Editing Importing Inventory Items

Before importing, make sure you read [[Before Importing - About UID]]

To just update pricing for your inventory items see [[Update Inventory Pricing]]

Note: This guide is for importing your inventory item list.  If you want to import inventory stock levels see [[Import Stock]]

<br>
<br>'''Step 1: Prepare the inventory item import file'''
<br>1. Open Excel and create columns for the inventory items based off image below.
<br>[[File:InventoryImportTemplate.png]]
<br>
<br>'''Name''' = Item Name '''**'''If you are syncing the items to QuickBooks, the character limit for this field is 30. If not syncing to QB, the limit is 40'''**'''
<br>'''Number''' = Item Number
<br>'''Description''' = Item Description
<br>'''Cost''' = Cost
<br>'''Retail1''' = Price
<br>'''AddToCustEQ''' = If TRUE then box is checked, if FALSE not checked
<br>'''IsActive''' = If TRUE then box is checked, if FALSE not checked
<br>'''DefaultLocation''' = Default Location
<br>'''DefaultLocationUID''' = UID Associated with the location
<br>'''Serialized''' = If TRUE then box is checked, if FALSE not checked
<br>'''QBExport''' = Recommend 0 or False.  If TRUE then''' Export to QB''' box is checked and the item will sync to QB, if FALSE not checked
<br>'''QBInventory''' - OPTIONAL.  If TRUE then '''As Inventory Item''' will be checked and will go to QB as inventory item, if FALSE not checked and go to QB as non-inventory item
<br>
<br>2. Paste the inventory item name, number, description, cost & retail1 in the corresponding columns.
<br>3. Choose if you want the items to be added to customer equipment by default, make it serialized, and exported to quickbooks. 
<br>4. Put TRUE in IsActive column
<br>5. You will usually enter the default location as default. If you are using a different default location for the items, enter it there with the corresponding UID.
<br>6. Save the excel file to your desktop.
<br>
<br> '''Step 2: Add additional columns to import file if needed'''
<br>You may want to import in additional information for your inventory items such as default vendor, system type or group code. Below are some common columns you may want to add. You will need to export the UID out of SME to import into a drop down or associate the inventory item with another record, like vendor.
<br>[[File:AdditionalInventoryColumns.png]]
<br> Below is an example of part of an import file including the SMPSystem, ItemGroup, and Vendor along with their UID.
<br>[[File:FilledOutInventoryImportFile.png]]
<br>
<br> '''Step 3: Import a test'''
<br>As always when importing, import first a small sample of your whole spreadsheet including the column headers. Check your import before importing the whole spreadsheet.
<br>
<br>1. Copy the first few rows of your spreadsheet including the column header and paste into a new spreadsheet. Save to your desktop.
<br>2. Go to '''Utilities''' > '''Utilities''' > '''Import Data''' and click '''Run It.''' The Data Import window opens
<br>3. In the''' Source Filename''' field, browse for your test import file you saved in step1. (when browsing for your file, make sure you are search “All Files”)
<br>4. In the''' Destination table''' drop down, select Inventory
<br>5. You will see a preview of your spreadsheet in the grid
<br>6. Click '''Start'''.
<br>7. You will be asked if you want to backup your data. You should be regularly backing up your data, so usually people click No to skip the backup. 
<br>8. When the import is complete you can close the Data Import window and look in the Inventory module for the items you imported. Check all of the fields to make sure it imported fine.

<br>

<br>'''Step 4: Import the rest of spreadsheet'''
<br>If your test import worked fine, then you can import the rest of the inventory items. It is a good idea to break up your items into spreadsheets with around 1000 items. 
<br>
<br>1. Delete the items off your spreadsheet that you imported in your testing. If you don’t delete them, they will be imported again.
<br>2. Save your spreadsheet to your desktop.
<br>3. Go to '''Utilities''' > '''Utilities''' > '''Import Data''' and click '''Run It'''. The Data Import window opens
<br>4. In the '''Source Filename''' field, browse for your import file. (when browsing for your file, make sure you are search “All Files”)
<br>5. In the '''Destination table''' drop down, select Inventory
<br>6. You will see a preview of your spreadsheet in the grid
<br>7. Click '''Start'''.
<br>8. You will be asked if you want to backup your data. You should be regularly backing up your data, so usually people click No to skip the backup.
<br>9. When the import is complete you can close the Data Import window and look in the Inventory module for the items you imported.