Can I edit the cost on old orders for accurate reporting?

[thefourthplace]

Somehow an import that I did resulted in the cost of several items multiplied a thousandfold. This means I have a handful of orders with cost that makes cost/profit reporting useles.

Is there any way for me to edit the cost on old orders, or update reports to use the current cost?

[CloudlabSam]

Shopify captures the cost at the time of order - this way you have accurate historical data as your costs change. So I don't think there is a way to change this. Have you tried making another edit to the order (like the note or adding a tag) to see if that makes it capture the new item cost?

[BetterReports-K]

Hi @thefourthplace,

Keanna here from the Better Reports support team. I would recommend our app Better Reports for this!

Our reports always use the current variant cost to determine cost of goods sold so would reflect the correct cost in all sales reports. For variants that have been deleted since they were sold, cost of goods sold is assumed to be equal to net sales. This can be customized based on your preferred method of handling variants where cost is unknown.

In addition to custom reporting capabilities, Better Reports offers more than 60 built-in reports that cover your most common reporting needs including sales, current inventory, refunds, payouts, and more. Our reports can even be scheduled to send at a set frequency to your email or Google Drive!

I encourage you to install Better Reports and start your free 14-day trial and I'll be happy to walk you through the built-in reports that include COGS.

[thefourthplace]

Thanks for the offer, but this is something that shows up a lot in the basic analytics. Being able to pay for a third party app isn't a solution I am interested in.