How to change the average cost of a product

You can reset a product's average cost to match its supply price. This will fix your Cost of Goods Sold (COGS) going forward, but it will not retroactively fix previous reports. 

We recommend doing this when your store is closed so that your inventory levels are not affected by this process. 

To adjust a product's average cost, you need to export it from Retail POS. Then you can add the inventory back using a stock order. This will recalculate the average cost for each product. 

  Important

You must repeat the steps below for each outlet in your store in order to correct the average cost for a product.

If an outlet is missed, the average cost will not be corrected.

Part one

  1. Navigate to Catalog > Products.
  2. Use the filters to locate the product(s) you want to adjust. Click the checkbox in the left column to select the product(s).
  3. Click Export list... and select CSV format.
    Select-Catalog-Products.png
  4. Save two copies of this file. The first will be used as a working file and the second will be reserved as a backup.
  5. Once this is done, navigate to Inventory Inventory counts.
  6. Click on Add inventory count.
  7. Enter a name into the Count name field and choose an outlet.
  8. Scroll down and select Partial count.
  9. Scroll down to Filter products and add the products you want to adjust.
  10. Click Start count.Adjust-count.png
  11. Refresh the page until the total number of products in the count matches the number of products you want to adjust.

  12. Do not click Count. Click Review.
  13. Click Complete. This will revert your inventory to zero for the selected products. Then, click Submit.

    Complete-stock-take.png

Part two

Create a stock order CSV file using your exported product list.

  1. On your computer, locate and open the product list you exported at part one.
  2. Delete all columns except "sku", "handle", "supply price", and "inventory_outletname".

    average_cost-delete-items.png

  3. Rename the "inventory_outletname" column as "quantity".

    rename-column-average-cost.png

  4. Check that the supply price for the products are correct.
  5. Save the file.

Part three

Order and receive the inventory you had back into Retail POS using the above purchase order.

Important: Large purchase orders will take longer to load.

  1. Navigate to InventoryStock control > Order stock.
  2. Enter "Fixing average cost" in the Order number or Note field.

    edit-order-number-or-note.png

  3. Click Import via CSV and select the stock order CSV file you created in part two.
  4. Click Save at the top of the page.

    click-import-csv-click-save.png

  5. Retail POS will save your purchase order. Now, click Receive.
  6. Scroll to the bottom of the page and enter the correct inventory count for each item.

    Click-receive-order.png

  7. Click Receive and then click Receive order.

Your inventory will be added back to Retail POS and the average cost will reset to match the supply price of the product.

Additional information

What is average cost?

How to format your CSV file using Open Office

How to order and receive stock in Retail POS (X-Series)

 

Did this answer your question?
Have more questions? Contact us so that we can help you out.