How to Guide - Import Supplier Data

A guide on how to bulk import new product information into EPOS

Open the supplier data in a spreadsheet program, ready for the data import.

A Supplier Data File Open in the Spreadsheet Software

Please ensure the VAT is set to the correct VAT percentage without the % symbol. e.g. 20 for 20% VAT

Shown in the picture there are examples of the VAT rate for each products which are all VAT rated at 20%.

New Main Menu

Click on Stock tab on the left, then Data Importer

Old Main Menu

Click on Stock tab at the top, then Supplier Data Importer

Main Menu - Stock Tab

You will now see the window shown below.

Initial Screen when the Supplier Data Importer Window is Opened

On the spreadsheet, highlight all of the products and it's data to be imported. Then right click and press copy.

The Products and Details has been Highlighted.

Back in the Supplier Data Importer Window, Click Paste from Clipboard.

Supplier Data Importer Window with the Product Information

Then map the column number to a column name, as shown in the picture.

You can move the slider to “OFF” position, to skip the column during the import.

Example: Column 0 – Supplier Code, Column 1 – Name of Item, Column 2 – Barcode, etc.

Click onto 'Step 2 Process/Import'. Choose your supplier in the 'Select Destination Supplier'. Example: Supplier 1.

If the product is barcoded then you can keep the 'Import Based on Barcode' default selection, otherwise use the drop down to choose an appropriate option.

Update the import options on the right hand side as necessary.

Click on Preview Changes to check the data being imported is correct.

If the import looks correct then, click on 'Commence Import' to import the data.