Importing UPC codes with Excel

1. Download the template of the UPC import excel file here. 

 

2. The import template will look like the image shown below: Create a new excel file or remove and/or replace the example data with your own for import.

Column A: SKU number and the optional corresponding dimension alias.

Column B: Your desired UPC code to be associated with the SKU.

 upc_import_template_image.JPG

 

Two UPC's can be added to the same item with a semicolon like this 4123456789;4123456788

 

If you wish to clear UPC's you can use the format SKU,CLEAR for each item. But only imported UPC's will be cleared any AmberPOS generated UPC's will not be cleared.

SKU,UPC

1000,CLEAR

1001,CLEAR

1002,CLEAR

 

3. Login to AmberPOS and access the Inventory menu.

 

4. Select the Import SKUs option and then Import UPC from the drop down menu that appears.

 import_upc_selected.JPG

 

5. Select your excel file at it's location on your computer in the window that appears, and then in the following window match the fields on the right to those on the left such that they are identical. Then select OK.

 DimUPC.JPG

 

6. If your UPC import is successful, you should receive a message like in the image below depicting the corresponding number of successful SKUs imported.

 successful_upc_import.JPG

Related Articles: If you want to individually edit UPC's, see Adding a UPC to a SKU's Information.

0 Comments

Please sign in to leave a comment.
Powered by Zendesk