Updating Your Inventory Through Excel (Product numbers, Vendors, Price, etc.)

You can update many inventory items swiftly by updating their information through excel. This guide will show you how to export your inventory to excel, and then edit the information and import it back into your AmberPOS system.

 

1. Login to AmberPOS and access the Inventory menu.

 

2. Select the inventory tab, and then Refresh at the bottom. 

inventory_load_list.JPG

 

3. A window prompt will appear asking you to add items without history. Select Yes or No based on whether you want to include them. 

window_prompt_for_add_all.JPG

 

4. Select the Copy ListView to ClipBoard option to copy the Listview of your entire list of SKUs to a clipboard. This will be pasted into your Excel document. 

export_sku_list_with_entire_inventory_listed.JPG

 

5. Open your excel, and right click on the first cell in the first row and column. Select the Paste option to paste your copied clipboard. 

paste_listview.JPG

 

6. You can update any of the columns. In this example, product numbers are being added that previously did not exist. 

adding_product_number_to_updating_items.JPG

 

7. Once your changes for updating are complete, go to File in the top right corner of the screen and select Save to save your excel file.

1.PNG

 

8. Open AmberPOS and Login again.

 

9. Access the Inventory Menu, then select Import Skus under the Skus tab.

2.PNG

 

6. Select Import Skus list

3.PNG

 

7. Select your saved excel file in the location that you previously saved it in. 

 

8. Overview of the next window:

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. A notepad will open with the result of your import.

 

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

 

 

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk