Importing a SKU-list into AmberPOS with Excel

1. Download the Excel template file HERE


2. Open the Excel file.



Overview of Excel fields for SKU:                                         Make sure that the cells contain only values, no formulas.

SKU: Numerical or alphanumerical format and is a placeholder for inventory that is setup in a sequential counting manner. (example: 1005, 1006, 1007, 1008 or abc001, abc002, abc003, etc) max char. 15

Description: The description of the SKU. (example: Levies 501 Jeans) max char. 500 (all characters will import)

ProductNumber: The product number associated with the item, or vendor product number. Or in the clothing industry, this would be considered a style number. (example: 52363) max char. 51

GroupName: The group for which the SKU belongs to. (example: Bottomwear) max char. 50

UnitName: If it is a partial quantity, the UnitName designates what unit of measurement it will be. (example: Grams) max char. 5

Vendor: The vendor associated with the SKU in AmberPOS. (example: ClotheManu Inc) max char. 50

Brand: The brand associated with the SKU in AmberPOS. (example: Levies) max char. 100

Department: The department to be designated for the SKU in AmberPOS (example: Clothing) syntax for sub department: Clothing->Pants.  (max 25 char per department name or max char. 50 total)

Season: If there is a season associated with the SKU. (example: Summer)

PriceIncludeTax: Does the price of the SKU include tax already applied to it? (example: "Y" which means Yes or "N" which means No)

Taxable1: Where Tax 1 is applied or not. (example: "Y" which means Yes or "N" which means No)

Taxable2: Where Tax 2 is applied or not. (example: "Y" which means Yes or "N" which means No)

Taxable3: Where Tax 3 is applied or not. (example: "Y" which means Yes or "N" which means No)

PartialQty: Associated with an item that is not sold as a whole number, such as a steak that is sold by it's weight in grams. (example: "Y" which means Yes or "N" which means No)

Dim1,2,3,4GroupName: The Group name(s) of your SKU dimensions. (example: size, colour, length, etc) max char. 50

Dim1,2,3,4Alias: The alias of the dimension (example: L)

Dim1,2,3,4Description: The description of the dimension (example: Large)

ListCost: The price of the SKU purchased from the vendor. (example: 30)

Price: The retail default price of a SKU that is sold to a customer. (example: 50)

Active: Whether the SKU is active and avallable for sale in AmberPOS. (example: "Y" which means Yes or "N" which means No)

PackageQty: For individual items, package quantity will be 1, but if you have a packaged item such as a 6-pack of Soda, then the package quantity will be higher. (example: 6)

PackageUnitName: The name of the package unit type used to hold multiple items. (example: box, case, etc)

MinPrice: Import the minimum value that the SKU's price cannot sell lower than (example: 9.99)

Deposit: Designate whether there is a deposit fee for the SKU. **Note: You must enable the 011 switch titled "Enable Bottle Deposit" for this to function**

Recycle: Designate whether there is a recycle fee for the SKU. **Note: You must enable the 011 switch titled "Enable Bottle Deposit" for this to function**

SkuType: Designate the type of SKU that you are importing.

        SkuType 0: Normal

        SkuType 1: Basket

        SkuType 2: QOH=0

        SkuType 3: Rental

UPCLookup: Used to store UPC, EAN GTIN, ASIN, MPN, ISBN numbers or any other number you want to use as an alternate lookup number for your product.

QOH: Import the quantity on hand of the SKU (example: 6)

The remaining columns are for attribute import. Replace Attribute 1,2,3,4 with your own desired attributes. Example is given below that is also in template:

**Example for Attribute 1** Disclaimer: Attribute disclaimer message that is displayed for SKU (example: "No returns for personal garments")

GPCostPercent: Gross Profit Cost Percentage

Weight: The Weight of your item (Primarily used for web based items)

Width: The Width of your item (Primarily used for web based items)

Height: The Height of your item (Primarily used for web based items)

Depth: The Depth of your item (Primarily used for web based items)

BinNumber: Bin number or location number of your item.

Attribute 1-5: Attributes are optional and will only show up after you create a new custom attribute prior to importing your data. To create attributes click Here for the article.


3. Go to File in the top right corner of the screen and select Save to save your excel file.



4. Open AmberPOS and Login.


5. Access the Inventory Menu, then select Import SKUs under the SKUs tab.



6. Select Import SKUs list



7. Select SKU_Import_Template.xlsx file and press OK



8. Overview:



    Step 1: Match up each of the AmberPOS fields on the left to the Excel columns on the right or press the Match By Name Button to match the AmberPOS field name to your column name in Excel.

     Step 2: Select OK to proceed with the import.



9. Notepad will open with the result of the import.



Warnings indicate notification that values don't exist though they will be created upon import.  Errors indicate conflict with data in the import file and isn't formatted correctly.


10. If you want to revert the import changes you made, select Import SKUs again by first accessing the Inventory Menu, then select Roll Back Last SKU Import in the drop down menu that appears.



11. If you included quantity on hand in the excel file there will be a batch automatically created in Inventory Count which you can use to update the QOH for you new SKUs. This will generate a selective snapshot of only your new SKUs and will not affect your existing inventory.


Step 1: Navigate to the Inventory Count tab.

Step 2: Ensure your SKU and QOH information is correct. 

Step 3: Select View Variance >>.


12. To finish updating your quantity on hand you need to Apply Variance.


Please sign in to leave a comment.
Powered by Zendesk