Common Supplier Stock File Importing Issues

Common Supplier Stock File Importing Issues

Here are a few common issues that customers can run into when they try to import a supplier stock file into Retailer.

Info
The first thing to confirm is that the file's barcodes are not corrupt and all the data is correct.

  1. Default settings are required to import stockfile - This error can occur if the there is a space at the beginning or end of either the supplier name, department name or category name. You can edit your supplier and department details through the Suppliers & Departments menu.
  2. Please Select a Markup for This Category - This message will appear if there is no number (or zero) in the Markup box. The markup percentage is needed in case the file is missing either the cost or retail price, and will be used to calculate the missing price upon importing the file. Set to 1% if you're not worried about this affecting Gross Profit. If the file contains both the cost and retail price, then this will not be used and the number will be irrelevant.
  3. File imports, but the items are not actually added - This can happen, with the loading bar going to 100% very quickly when importing, if the stock file has bad data. This could be in the beginning lines of the file, so it's best to trim out / remove any unnecessary lines (such as logos) in the beginning and end of the file. You should also glance through the stock lines in the file to make sure there is no corrupt information such as weird symbols.
    If the required fields for import are not selected/present in the file, the same problem can happen with no items actually imported. Required fields are the Barcode, Long Description/name, one of the prices (Cost or Retail).
  4. Incorrect barcode style for imported stock - Incorrect barcode style for imported stock - Creating stock using a supplier stock file bypasses the usual process with the Stock Wizard, so all imported stock made this way will have the default Desc/Barcode/Price barcode style. You will need to use the Stock Manager to bulk update the newly created items to your preferred barcode style for the imported items.
  5. 'Dictionary Invalidated' error - See HERE for instructions on how to fix this error.

Warning
Make sure to check that your settings are correctly referencing the information in the file, otherwise you can end up with descriptions written in barcode fields, or prices set to quantities.