Importing a John Sands Stock File

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 November 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 November 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.

• Related Articles

• John Sands (JS) EDI Settings

  Arrival Settings From the main screen of Retailer, click on Stock -> Suppliers & Departments. Click on the Suppliers tab. Click on the magnifying glass icon and double-click on John Sands. In the Details tab, set When adding stock, the default ...

• 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 ...

• Importing a BrownTrout Stock File

  This is the advice for importing a BrownTrout 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 ...

• 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 ...

• Importing a Henderson Greetings Stock File

  This is the advice for importing a Henderson Greetings 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 ...