All Collections
Products and Product Categories
Products
How do I adjust the average cost if it is missing or incorrect?
How do I adjust the average cost if it is missing or incorrect?
Dimitris Athanasiadis avatar
Written by Dimitris Athanasiadis
Updated over a week ago

If you want to adjust the unit cost for just one product you need to follow these steps:

  1. Go to Products and Services > View Products - Services. Search for the SKU corresponding to the product you are looking for and click on it to open it up for editing.

  2. Click on the Quantity tab and there you should edit the Physical Count Quantity to be zero (0). When you click on the Save/Diskette icon:

    a new window will open and you have to click on Create Document:

    This will temporarily zero the quantity/stock for that SKU in the selected inventory location. If you have more than one inventory location, repeat this step to zero the quantity over all your inventory locations. Do keep a note of the quantity figures before zeroing them.

  3. The last step is to bring again the quantity to their previous values (before zeroing them in step 2). So, edit again the Physical Count Quantity and increase it to the correct value. After clicking on the save/diskette icon, another window will pop up - there you will fill in the preferred unit cost and click on Create Document:


To adjust the averaged unit cost for more than one product the process is this:

  1. Click INVENTORY > New Adjustment. Follow the instructions on the screen to download the XLS file. Save the file on your computer and keep a copy of it

  2. For only the products you want to update the unit cost for, set the stock to 0. You can remove the rows of the "good" products from the spreadsheet

  3. Save the file as CSV or Unicode TXT and upload this new version. This will zero the quantity of these products to the selected Inventory Location

  4. Repeat the process: click INVENTORY > New Adjustment. Download the XLS file again. Keep only the products you want to update the unit cost for. Set the correct quantity and the correct unit cost, save as CSV or Unicode TXT and upload this new version

Important: Keep in mind that if you have multiple warehouses, you need to zero the quantity in all your warehouses first. Then, import the correct physical quantity and the correct cost as per the instructions above.

Note: The above assumes that the product(s) for which you want to update the unit cost have non-zero stock. If the stock is zero, then, by design the unit cost is zero. It will be updated with your first bill (Purchase Bill/Receive On Consignment).

Or login to your account.

Did this answer your question?