This is the advice for importing a John Sands 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

  1. Click the attached file and the file will download.
DO NOT OPEN THE FILE. This usually goes into the Downloads folder.

Importing a Supplier Stock File

  1. From the main screen of Retailer, go to 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.
    Click HERE to learn more about adding a new supplier.
  3. Press the [Tab] key on your keyboard.
  4. If you get a message saying Stock file does not exist, click OK.
    Then, click on Desktop (or find the file) on the left. Select the John Sands May 2024.csv file and click Open.

    If you don't get that message, go to step 5.
  5. In the Stock File Setup screen, click Cancel.
    If the screen below does not appear, click on the arrow next to Tools and click on Change Stock File Settings.

  6. Enter the settings as per the image below.

  7. Once the settings have been entered, click Save and then Close.
  8. Back in the Import Supplier Stock File screen:
    • Select a Department you wish the stock items to be assigned to.
    • Select a Category you wish the stock items to be assigned to.
    • Enter your Category Mark-up %.
  9. In the Instructions section, tick all the tick-boxes unless you have specific information that you want to maintain. Click HERE for more information about the options.


    WARNING: JOHN SANDS has specified categories for the stock items in the file. If you do not want your category structure to be overwritten/changed, untick the Category options here.
  10. Click on Import.
  11. Then, click on Desktop (or find the file) on the left.
  12. Select  John Sands May 2024.csv  and click Open.
  13. A message will appear asking you to confirm the import. Check the file name and click Yes to confirm.