Info
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 barcodes associated with it. Retailer can import ONIX XML files if the supplier uses them. Below are the steps on how to do this.

Save The Stock File

You will generally receive the stock file from the supplier or Tower Systems as an attachment through e-mail. This file needs to be in an .xml format.

  1. Access your e-mail account.
  2. Open the e-mail message that contains the attachment or stock file.
  3. Save the stock file to a easy to access location such as the Desktop. This can usually be done by right-clicking on the attachment and selecting  Save  or  Save As .
Alert
After saving the file, open the file by right-clicking on it, and select Edit. A line has to be removed from the file for this to work. Remove the following line and save:
<!DOCTYPE ONIXMessage SYSTEM "http://www.editeur.org/onix/2.1/reference/onix-international.dtd">

Import the Stock File

  1. From the main screen of Retailer, click on Utilities -> Import/Export Files -> Import Supplier Stock File.
  2. Select the required supplier. 
    If the supplier is not in the list, press the [Insert] key on your keyboard to add the supplier.
    Info
    Click HERE to learn more about adding a new supplier.
  3. Press the [Tab] key on your keyboard.
  4. In the box to the right side of the supplier box, click and select Onix XML Format Stockfile.
  5. If you get a message saying Stock file does not exist, click OK.
    Then, click on     Desktop on the left. Select the file that you saved earlier and click Open.
  6. Select the Default Department and Default Category. This is where the stock items will be allocated to if a department or category was not specified in the stock file.
  7. Enter the Category Markup. This is used to calculate the Cost/Retail Price if only one of the two is specified in the import template (If the import template specifies both, then this percentage is ignored).
  8. Tick the required options under the Instructions section. In general, tick all the available tick-boxes to use the information from the stock file. However, if there are certain types of information that you want to retain from your data, untick the corresponding tick-boxes.
    9. Info
    Click HERE for a breakdown of all options in the Instructions section.
    Notes
    The import process requires that Barcode, Description and at least one price for each product is in the file.
  9. Click on Import.
  10. Navigate to the location of your stock file, select the stock file and click Open.
  11. The import file will contain the name of the supplier as they have specified it. If this doesn't match the supplier name you have selected, you will be prompted to import the file under their specified name.
  12. Click Yes to do the import. Clicking No will stop the import. You may need to merge or delete any duplicate supplier names after this.
    13. Info
    For information on how to merge suppliers, click HERE.
  13. Once the import process is complete, you have the option of viewing a Stock Listing Report. Click Yes  to access the report options or click No to finish the process.