Pandora invoices can be imported into Retailer electronically saving hours of data entry work. Electronic invoicing means that all of the stock you’ve received in an invoice can be imported into Retailer without having to be added manually. You can download your invoices from the Pandora website. 

Before importing the invoice into Retailer, the file must be saved from your email program onto your computer. Locate the attached CSV file, right-click on the file and save it to an easy to find location on your computer, like the desktop or downloads folder.

Once saved, DO NOT open the file under any circumstance. This can corrupt any barcodes or supplier stock code information.

Supplier Settings

  1. From the main screen of Retailer, open Suppliers and Departments (Stock Maintenance -> Suppliers & Departments).
  2. Click on the Suppliers tab.
  3. Click on the magnifying glass at the bottom. If Pandora exists as a supplier, select it and press OK. If not, click Add and enter the details.
  4. In the Details tab, select your Pandora Imports department in the field When adding stock, the default department for this supplier is. Press Save then Close.

Configuring the Invoice File Template

  1. Open Invoice Arrivals.
  2. Click on Open Invoice (located on the top right of the screen).
  3. Navigate to the invoice file you saved earlier and double-click on it.
  4. You may be prompted to select the Supplier that this invoice is from. If so, continue to Step 9. If you’re not prompted, skip to Step 14.
  5. Select Pandora from the list, then click Tools -> Change Template File Settings.
  6. You may be asked to select the supplier again from a list. If Pandora is not there, click Cancel. If it is there, select it and click OK.
  7. You will be shown the File Settings screen for Pandora. See the image below for the correct settings. Enter the Validation Settings (bottom of the screen) first then complete the rest of the file settings.
  8. Click Save then Close.


Importing and Arriving the Invoice

  1. Back in the Import Supplier Invoice File screen, click on Import.
  2. The screen will flash and you can then click on Close.
  3. The Select Invoices to Import screen will appear.
  4. Click on the invoice to import and:
    • Click on View to see a preview of the invoice to check the information. 
    • Click on Delete to remove the invoice.
    • Click on OK to begin arriving the invoice.