Importing a SKU-list into AmberPOS with Excel

1. Download the Excel template file here.

 

2. Open the Excel file.

excel_sku.JPG

 

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,4CategoryName: The Category 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

 

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")

 

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

1.PNG

 

4. Open AmberPOS and Login.

 

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

2.PNG

 

6. Select Import SKUs list

3.PNG

 

7. Select SKUImportTemplate

4.PNG

 

8. Overview:

match_the_skulist_columns.JPG

     Step 1: Ensure that the fields on the left match the fields on the right identically.

     Step 2: Select OK to proceed with the import.

 

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

5.PNG

 

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.

roll_back_changes.JPG

 

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.

importSKUQOH2.jpg

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.

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk