Asset Intelligence and Management

Asset Intelligence and Management

EZOfficeInventory Blogs Item Imports Asset Tracking Software

Importing Items into EZOfficeInventory – Asset Tracking Software

Importing items into EZOfficeInventory
Share:

Asset tracking software needs to be able to process thousands of business assets quickly and efficiently. Importing items into EZOfficeInventory is extremely straightforward with our nifty import wizard. You can instantly add or update all items – including assets, asset stock, and inventory – by setting up a CSV file and mapping the columns onto existing ones. This guide will take you through the basics of item imports, and provide you with some helpful tips to ensure seamless imports each time!

Before you start, it would be helpful to go through this quick guide on importing basics.

1. Custom Fields

If the columns shown while mapping don’t cater to all your asset management needs, you can map onto tailor-made columns through custom fields. The process for setting up custom fields is outlined here. Below, we’ve set up some custom fields for tracking project numbers, usage type, and inspection dates:

Add custom field (1)

With custom fields all set up, you can start the basic process for importing items. We’ve outlined the steps for importing assets, but remember that you can import asset stock and inventory the same way.

2. Adding Assets

First, set up a CSV with columns pertaining to different asset attributes. The following columns will be present for mapping assets later by default:

equipment management software

You might want to add details for fields not present above. This is where your custom fields come into play. Simply add columns for them, so your CSV looks something like this:

Asset Tracking Software

Next, go to ‘Items’ on the left navigation bar. Follow the pathway: Assets → Import Assets → Add New Assets.  

Add new asset (1)

Upload your CSV file, as shown below. Click on ‘Choose file’ and select ‘Upload and Proceed’.

Choose file

You can now start mapping! Choose the relevant option from the dropdown, or skip a column if you have nothing to map it to. You can always scroll back and edit a previous column.

Mapping columns

The highlighted checkboxes below give you a few options. If you have a header row describing the column type, the first checkbox will allow you to ignore it in the import.

Additionally, if you’ve associated an asset to a location, group, subgroup, or vendor that doesn’t exist yet, you can ask the system to create these in one go during the new import.

If not present, create

After you’re done mapping the columns, you can press the ‘Proceed’ button for a preview of what your assets will look like, as shown below:

Preview and import

Click the ‘Import’ button, and you’re done!

2.1 Errors in importing assets

In case there are any errors or failed rows during your Import, you will be notified about this at Step 3. Here you have the option to download the all the errors in a CSV file. You can then easily access all the errors on a single screen without having to switch between windows on the app. Once you have resolved the errors you will be able to take actions on your imported Assets.

The system will display all your new imports under the ‘Imported Assets’ filter, so you can take mass action on them immediately. This can be done from the ‘Actions’ button:

Assets successfully created

3. Adding Asset Stock

The process for adding Asset Stock is the same as above. To start, go to Items →  Asset Stock → Import Asset Stock → Add New Asset Stock. Below, you can see the asset stock fields that will be available for you to map to:

Note that the ‘Inspection’ and ‘Project Number’ fields are custom fields created for the purpose of this guide.

4. Adding Inventory

To add Inventory, go to Items →  Inventory → Import Inventory → Add New Inventory. You can see that the fields available for mapping inventory are slightly different, with some notable inclusions such as fields for Low Stock Thresholds and Prices for adding and removing stock.

Import inventory

If you provide details on the quantity to be added to stock, the Stock Price column must be mapped.

Also note that stock cannot be added or removed through imports. You can only set up the initial stock through an Add Import.

5. Updating Items

Items can be updated just as you would add them. For this, go to Items →  Assets → Import Assets → Update Existing Assets. 

For example, if you want to update the vendor of a particular item, you can add a new vendor or edit the existing one in the Excel sheet. Upload the edited sheet containing the updated vendor information. Now map the AIN and vendor column in EZOfficeInventory to update the item details. To edit an item(s), you need to map the AIN and and the column(s) you wish to edit. Your item will be updated to show the updated information without impacting the existing information in the system. 

Please note that if you try to update assets through the ‘Add New Assets’ button, you would be creating duplicates rather than updating asset values!

6. Mass Check-ins and Checkouts

You can also instantly update asset check-ins and checkouts using a CSV file. For this, go to Items →  Assets → Import Assets → Check-in Assets or Checkout Assets. The columns available for mapping here are outlined below:

Asset Tracking Sofwtare

And as easy as that, you can add new items, update items, or change the check-in/checkout status of Assets using our asset tracking software.

7. Bulk Import Templates

Note that only 1000 records or a 10mb file can be imported at one time. If you want to do excel imports multiple times, you may want to create a Mapping Template from Items →  Assets → Import from Excel Sheet → Add New Assets → New Import Template:

New import template

Here, you can choose what columns you’d like to map to later, and use this template repeatedly to speed up multiple imports. This is what your mapping options will look like:

Done new template - Decription

Click ‘Create Bulk Import Template’, and you’ll receive a confirmation about the columns you’ve chosen. You can also Edit and Delete these templates.

Edit and Delete

You can choose one of these templates when you do a new import. Here’s what this should look like:

Import template

Have feedback about our equipment tracking software?

EZOfficeInventory is the leading asset tracking software used by SMBs all over the globe. 

For more assistance, drop us an email at support@ezo.io.

Was this helpful?

Thanks for your feedback!

Achieve Higher Asset Control with EZOfficeInventory

Cloud-based asset management software that helps minimize costs with efficient asset organization and tracking.
Index

Personalized Demo For You

Please share your details below & let our Product Specialist get back to you

Talk to Us

Need help getting started or have questions? Get in touch with one of our product specialists!