Does Updating Cost per Item Fix Past Shopify Orders?

The freight invoice finally arrived, so you did the sensible thing.

You worked out what the stock had really cost once the forwarder and the customs broker were paid, opened the product, and put the proper number into Cost per item. It had been sitting at the supplier price since the container landed. Now it is right.

Then you opened last month's profit report to see the corrected margin, and nothing had moved.

This surprises people because the field looks like a property of the product, and product properties feel current. It behaves more like a reading taken off a meter: what matters is the number that was showing when the sale went through.

Does updating Cost per item change past orders?

It does not, and Shopify says so directly. Its documentation on the profit reports repeats the same condition throughout:

“Profit is reported only for products and variants that had cost recorded at the time they were sold.”

That is the whole mechanic in one sentence. At the time they were sold is doing the work. The cost is captured onto the order when the order happens, and the report reads what was captured, not what the field says today. (Shopify Help Center, profit reports, as of September 2026.)

So the edit you just made is not wasted. It is simply pointed forward. Orders from today onward will carry the corrected figure, and the further back you look, the more the report is describing a version of your costs you no longer believe.

Before and after the edit, on orders already shipped

Round numbers, so the arithmetic can be checked. Nothing here describes a real store.

You receive 500 units. The supplier invoice is $10.00 a unit, so you type $10.00 into Cost per item. In April you sell 200 of them. In May the forwarder bills $1,500 of freight and the customs broker bills $500 of duty on that same shipment, which is $2,000 across 500 units, or $4.00 a unit. The true landed cost was $14.00 all along.

You update the field to $14.00. Here is what happens to one of those April orders.

Only one row changed, and it is the row that does not feed the report. April is still $800 better than it was, on paper, forever. Do that across a year of shipments and the gap is not a rounding difference on one product, it is the difference between the margin you think you run and the one you actually run.

What if the field was empty when the order shipped?

Then it is worse than a wrong number, because the order does not get a wrong cost. It gets no cost, and it drops out of the report entirely. Shopify is explicit about this too:

“If orders are missing from this report, then it's likely that these variants don't have cost information.”

This is the version that catches people out, because a missing order does not look like an error. The report still renders, the totals still add up, and the margin it shows on the products it does cover can look perfectly healthy. What it is not telling you is how much of your trading it left out.

Filling the field in afterwards does not bring those orders back. They were never given a cost to record, and there is no second pass.

Why does Shopify work this way?

Because the alternative is worse, and it is worth saying so plainly rather than treating this as a defect.

If the reports read the current field instead, every report you had ever run would change the moment anyone edited a product. A margin you showed your accountant in April would be a different number in September, with nothing recording why. Closed periods would quietly move. A snapshot taken at the time of the sale is the more honest of the two designs, and it is the one that lets a report stay true to the day it was run.

The limitation is not the snapshot. It is that the snapshot is only ever as good as the cost you happened to have typed by then, and for anyone importing goods, the real cost is not knowable on the day the stock sells. The forwarder bills weeks after the container lands. The broker bills after that. You were always going to be typing that number late.

So how do you restate a month you have already sold?

Not by editing a field, because a field has no memory of what it used to say. You restate a period the way accounts have always been restated: by recalculating the cost of what sold, comparing it to what was posted, and posting the difference as a correction that names the period it belongs to.

That needs the cost to live somewhere that can be recalculated after the fact, and that is the real difference between a cost field and a cost ledger. A field holds one number and overwrites it. A ledger holds a dated cost for every receipt of stock, so when the freight invoice turns up six weeks late it can be landed into the receipt it belongs to and the sales drawn from that receipt can be costed again.

This is what Landara does with the movements Shopify already reports. Shopify stays the system of record for what sold and when. Landara keeps the cost side: a dated FIFO layer per receipt with freight and duty landed into it, drawn down oldest first as orders ship. Because the period is recalculated rather than stored, a late invoice produces a correction you can read and post, not a silent edit.

It is worth being clear about what that does and does not fix. It does not rewrite Shopify's own profit report, which will go on showing what it recorded at the time. It gives you a second set of numbers that can be restated, which is the set your accountant needs at month end.

And if none of this applies to you, that is a real answer too. If you buy domestically at a stable price, pay no freight worth allocating, and your Cost per item has been right since the day you typed it, the snapshot is doing its job and there is nothing here to fix.

Frequently asked questions