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.
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%.
Click on Stock tab on the left, then Data Importer
You will now see the window shown below.
On the spreadsheet, highlight all of the products and it's data to be imported. Then right click and press copy.
Back in the Supplier Data Importer Window, Click Paste from Clipboard.
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.
If you have any additional questions about the above guide, please contact our Support Team on either 03303 800 142 or [email protected].
If you're a new customer and interested in joining Premier EPOS please click here for more information and to book your free demo.
Last updated