Importing Orders from CSV file

Importing Orders from CSV file

New to Retailer 3.3.1, you can now import orders from a CSV file into Orders Maintenance which can be printed or sent to suppliers, then be ready to be arrived into Retailer.
This is separate to arriving a CSV Invoice file.
Click HERE for steps to import a CSV file into Invoice Arrivals

Setup Import Source

Before importing an Order File, you will need to create a new Import Source in Retailer.
  1. From the Main Screen of Retailer, click Stock Maintenance -> Orders -> Orders Maintenance.
  2. Click 'Import Order' near the top left corner.
  3. Click the 'Setup Import Sources/Settings' tab.
  4. To add a new Source, click the Plus button in the bottom left corner.
  5. Select a Type.
    Standard - This source can supply orders for various suppliers.
    Supplier - This source will supply orders for the selected supplier only.
  6. In Description, Enter a Description or select a Supplier.
  7. Leave Format Setup as 'Generic'.
  8. Click the Green tick at the bottom to Save.

Setup Order CSV File Template settings

Before importing an Order CSV File, you need to setup the Order File Template settings in Retailer. This will help the system understand where the information in the file is (under which columns).
  1. From the Main Screen of Retailer, click Stock Maintenance -> Orders -> Orders Maintenance.
  2. Click 'Import Order' near the top left corner.
  3. Click the 'Manual Import' tab.
  4. Select an Import Source.
  5. Click 'Change Template File Settings'.
  6. Click the yellow folder icon next to 'Load Invoice File'.
  7. Select the Order CSV file you wish to import.
  8. Click Yes to confirm this is the Order file you wish to import.
  9. Set 'Lines in File Header' first then enter the other settings as required. The 'Lines in file Header' setting indicates how many lines of the file are just heading, not actual stock lines.
  10. Click Save and then Close.

Import Order CSV File

  1. From the Main Screen of Retailer, click Stock Maintenance -> Orders -> Orders Maintenance
  2. Click 'Import Order' near the top left corner.
  3. Click the 'Manual Import' tab.
  4. Select an Import Source.
  5. Click the Import button.
  6. Change the 'Files of Type' to 'CSV Order Files' then select the Order CSV file you wish to import.
When importing a file, if the Supplier name is not in the file, it will prompt whether to create a new supplier, or select an existing one from your system.
Clicking OK on the message will start the wizard for adding a new supplier to the system.
Clicking Cancel will bring up a screen to select from one of the existing suppliers in Retailer.


    • Related Articles

    • Importing Orders from Evergreen Connect

      New to Retailer 3.3.1, you can now integrate with Evergreen Connect to import your online orders into Orders Maintenance ready to be arrived into Retailer. There are 2 ways you can import orders from Evergreen Connect. The first is to manually ...

    • Importing / Arriving Electronic Invoices ( CSV )

      There are a number of electronic invoice formats that can be imported through Retailer, one of which are CSV files. These files can be sent by your supplier to your e-mail account. 1. Saving the CSV File Log into your e-mail account. Open the message ...

    • CSV Stocktake

      This advice sheet will step you through performing a stocktake using CSV files. Before performing a stocktake, click HERE for more information on the types of stocktakes that can be performed as well as the precautions that you need to take before ...

    • Importing a Customer File

      The Import Customer File utility can be used to import new customers. Existing Customers cannot be updated by this utility From the Main Screen of Retailer, click Utilities -> Import / Export Files -> Import Customer File In Customer File Type, enter ...

    • Importing Batch Payment file

      In Retailer 3.2, a feature was introduced that allowed you to make batch payments to customers. This can be done through the Batch Payment screen in Retailer. The file needs to be saved onto your computer first. This can be any CSV file with the ...