How to change the average cost of a product

Objective

You can reset a products' average cost to match its supply price. This will fix your cost of goods (COGS) going forward, but will not retroactively fix previous reports. 

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

Setup

  • Vend for Mac or PC
  • Open Office/Excel

Steps

Overview: You will be removing the inventory of the products you are adjusting the average cost of. Then you will add the inventory back in using a Stock Order which will recalculate the average cost for each product. 

  Important

You will need to repeat the below steps 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 Products -> Products
  2. Use the filters to locate the product you wish to fix the average cost for and select it in the check column
  3. Click Export List and select CSV format
  4. Save two copies of this file; one as a working file and another as a backup
  5. Once this is done, navigate to Products -> Stock Control -> Inventory Count
  6. Click on Add Inventory Count
  7. Give the count a name and choose an outlet
  8. Click on Partial Count
  9. Scroll down to Filter Products and add the products you need to fix the average cost for
  10. Click Start Count 
  11. Refresh the page until the total number of products in the count match the amount of products you are wanting to reset.

    AvgCost1.gif

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

    avgcot2.gif

Part two

Create a stock order CSV file using one of the exported files you saved earlier.

  1. Open the backup CSV file you saved earlier.
  2. Delete all columns except 'sku', 'handle', 'supply price', and 'inventory_outletname' 

    avgcost3.gif
  3. Rename 'inventory_outletname' to 'quantity'

    avgcost4.gif
  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 Vend using the above purchase order.

Important: With large Purchase Orders it will take longer to load.

  1. Navigate to Products -> Stock Control -> Order Stock
  2. Type in "fixing average cost" as the Order Number or as a Note
  3. Click Import via CSV and select the stock order CSV file you created in part two
  4. Click Save
  5. Click Send Order
  6. In the pop-up window enter your email address and click Send
  7. Click Receive
  8. Click Mark All Received
  9. Wait for this to update the Stock Order
  10. Click Save and Receive

ezgif.com-optimize.gif

The inventory for your products will be added back into your store and the average cost will be 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 Vend

 

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