How can I retroactively apply correct costs to past orders?

[SB9Shop]

when I first setup my store I had not correctly added my costs per item

I realised my mistake and corrected that a week or so after my store was taking orders etc.

Now, on the costs of goods sold and profit reports,  the items prior to when I made my change are still incorrect.  How to I retroactively apply the costs to items on the orders prior to my fix?  I need a cost on date fix or something?

[BetterReports-K]

Hi @SB9Shop,

Keanna here from the Better Reports support team.

Shopify's built-in reporting will always use the cost at the time of sale for their cost of goods / gross margin calculations. They will not update the costs associated with historical sales based on the current variant cost.

If you'd like to see historical sales cost and profit data calculated based on your current variant costs, I recommend using our app Better Reports. All gross margin / cost of goods sold calculations in our reporting rely on current variant cost (even for sales which occurred before cost was recorded). We can also create custom reports based on your specific needs.

In addition to custom reporting capabilities, Better Reports offers more than 80 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 answer any additional questions.