Preparing Your File
With your file your file that you want to import, make sure it has the following:
- Only 2 columns
- First column should be for your SKU/Item-codes
- Second column should be your quantity
- First row's quantity should be 1
- All other row's quantity should be 0
- File format should be .csv when you save the file.
File should look like this:
Importing File into AmberPOS
- For this, we will have to go to the Inventory Count section of Amber.
- Click on the Generate New Snapshot button, and it will bring up the Generate New Inventory Count Snapshot window.
- Choose the appropriate snapshot type, and then hit Generate New Snapshot at the bottom.
- Complete Snapshot will assume that you're counting everything.
Anything not counted is set to 0
- Selective Snapshot is similar to a Complete Snapshot, but lets you query the product you are counting.
Anything not counted is set to 0
- Spot Snapshot (Recommended) will only make changes to the products counted. - It will pop up with a box saying it generated a number of items, just hit OK here
- You now need to create a Inventory count batch, so put any number in the Batch Number box on the left, and hit create batch.
- Make sure your batch is selected, and then choose the Scanner/File button at the bottom
- Select Load List From File, and look for your CSV file you made earlier
- Change the quantity of the first item from 1 to 0 by checking the Quick Edit checkbox.
Click on 1 in the Count Qty column, and change it from 1 to 0 - Double check to see if there are any issues with your import, by clicking on the ErrorMessage column twice
- If there are any, select the item, click on the Edit button, and scan in the correct code / set the quantity properly.
- Once it looks good, click on the View / Apply Results tab at the top, and Apply Variance in the bottom right.
0 Comments