Average Cost of Goods stays at $0.00 on our Merchandise Sales Report after updating the merchandise

 If you add merchandise with a $0 cost, the average cost of goods may appear as $0.00 even after updating the merchandise with a higher cost. Also, you will see this number when you run the Merchandise Sales Report.
When you click Edit in the merchandise inventory, the cost there is only affecting new inventory. That option does not apply retroactively to inventory that was already added. When we update the cost by editing the merchandise, it will update the vendor price for any future shipment and the retail price for future sale of merchandise. It will not modify the average cost (as the cost has not been updated for the past shipments) until new items are added to inventory. Once a new item is added to inventory, the average cost will be modified accordingly and automatically.

To edit the cost of the current inventory:
  1. Open your merchandise item
  2. Click on the merchandise item and click Change Inventory
  3. Mark the Adjust quantity button and adjust the quantity down to 0 by entering a negative number.  Select or enter a reason, like data entry error
  4. Click Save
  5. Click Change inventory again
  6. Mark the Add inventory shipment button, enter the cost and appropriate quantity
  7. Click Save


 Altru Arts & Cultural

Was this article helpful?

Thanks for your feedback! Did this solve your issue?

Comments (optional):

Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):

Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.