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.

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, Description/name, one of the prices (Cost or Retail).

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.

• Related Articles

• Importing A Supplier Stock File

  We have a video guide on importing a supplier stock file into Retailer - ? Importing A Supplier Stockfile A supplier stock file or price/product list can be used to quickly and easily bulk import products into the Retailer software, which has ...

• Stock Screen - Changing Details on Stock Items

  All aspects of a stock item - its name, prices, barcode, quantity on hand, stock code etc. - can be changed at any time. This is done through the Stock Screen, which is one of the most important screens in Retailer and one you will see a lot. The ...

• Supplier Stock Listing

  The Supplier Stock Listing Report lists selected stock items by department, category and supplier as of when the report is run. It is most commonly used for the value of the stock in the store, however it can also be used in other ways like listing ...

• Stock File Import Options

  This article is to be used when importing a supplier stock file. Click HERE for full details. The following options will only be available to be ticked if the corresponding setting is turned on in the supplier settings. Generally only the first 4 ...

• Importing a Waterlyn Stock File

  This is the advice for importing a Waterlyn stock file. The stock file is embedded in this article. Do not try this with another stock file. The stock file included with this article has been tested. We know it works. Saving the Stock File Click the ...