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.

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

• Common issues with Xero accounting link

  This advice looks at the most common issues or messages seen during accounting exports to Xero, and how to resolve them. Error Account number X missing When exporting, Retailer will check that all Xero codes have been setup. If you have added ...

• Common Stocktake Issues

  Stocktake was closed and cannot reopen/find it When in the Stocktake screen (Stock Maintenance -> Stocktake -> Stocktake), click on Open Existing Stocktake at the top. Select the stocktake from the drop-down menu. If this stocktake was previously ...

• Common Webstore Issues

  This advice is for anyone asking why the Tower Web Connect (TWC) link syncing to Shopify, Magento or WooCommerce (Wordpress) websites is not working. Before continuing, it is assumed that your link had been working previously and all initial setup ...

• Common EFTPOS Issues

  Please note that most EFTPOS processing issues are actually under the responsibility of the EFTPOS integration provider or the bank themselves as the Retailer software only sends the transaction data across and waits for the approved signal back from ...

• Common Problems with Subagents

  Remember: Subagent statements BEFORE subagent billing. Generate orders BEFORE arriving magazines. Most subagent issues are caused by performing these actions out of order. For help with common problems with magazine arrivals, click HERE The Total ...