Common Mistakes Check List - Import Inventory |
  
|
Common Mistakes Check List - Import Inventory |
|
To minimize mistakes commonly made when importing inventory, review these import settings.
SKU/Barcode cannot be scanned
If, after importing your inventory, you may not be able to use a scanner to sell the item because the barcode/SKU does not match. This is caused when the spreadsheet automatically ignores leading zeroes.
- make sure that SKUs which begin with a 0 still have the leading 0 in the import file. Many spreadsheets will often delete any leading zero's
Price/Cost were not imported
- make sure the price and cost import fields do not have any currency symbols ($) because the importer cannot read these characters
- make sure that under menu View: Costs the appropriate fields are are checked. Note: leave Unchecked "Imported Price Includes Tax" unless you know that this feature is to be turned on
Vendor Not Selected
- if you are importing inventory, save yourself a lot of time by also updating the Vendor Inventory List at the same time.
Skip First Record When Importing - if your data has field titles, this will exclude row 1 from making an inventory item.