Importing 0 Quantity into Inventory Count

Preparing Your File

With your file your file that you want to import, make sure it has the following:

  1. Only 2 columns
    1. First column should be for your SKU/Item-codes
    2. Second column should be your quantity
  2. First row's quantity should be 1
  3. All other row's quantity should be 0
  4. File format should be .csv when you save the file.

    File should look like this:
    mceclip0.png

 

Importing File into AmberPOS

  1. For this, we will have to go to the Inventory Count section of Amber.
    mceclip1.png

  2. Click on the Generate New Snapshot button, and it will bring up the Generate New Inventory Count Snapshot window.

  3. 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. 

  4. It will pop up with a box saying it generated a number of items, just hit OK here

  5. 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.
    mceclip2.png

  6. Make sure your batch is selected, and then choose the Scanner/File button at the bottom
    mceclip3.png

  7. Select Load List From File, and look for your CSV file you made earlier
    mceclip5.png

  8. 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
    mceclip8.png

  9. Double check to see if there are any issues with your import, by clicking on the ErrorMessage column twice
    mceclip6.png

  10. If there are any, select the item, click on the Edit button, and scan in the correct code / set the quantity properly.
  11. Once it looks good, click on the View / Apply Results tab at the top, and Apply Variance in the bottom right.

 

 

0 Comments

Please sign in to leave a comment.
Powered by Zendesk