Why Shopify’s cost per item can mislead your margin reports

The report says the sofa made a 60% margin. The last shipment’s paperwork says otherwise. In this illustrative sale, Shopify’s Cost per item still holds $2,000, while the received landed cost is $2,800. On a $5,000 sale, that changes the margin from 60% to 44%. Both calculations are correct; only one uses the cost of the piece that arrived.

Shopify stores one cost per variant. Keep that figure connected to the actual goods and purchasing charges, and the report becomes more useful. OrderPilot can publish a weighted average of finalized costed stock to Shopify, giving staff a path from the receipt to the reporting figure.

Know what the Shopify field can represent

Shopify describes Cost per item as a single static field per variant that does not change simply because a PO or transfer is received. Its inventory guidance directs merchants to additional costing tools for weighted-average costing or automatic landed-cost allocation. Shopify, Track inventory costs and reconcile received stock.

The product and variant profit reports also depend on cost information recorded when the goods were sold. Missing costs can exclude sales from those reports. A sales total and a profit-report sales total can therefore differ for a reason unrelated to demand. Shopify, Profit reports.

Check the purchase price, landed charges, and configuration

A stale purchase price is the first problem to look for. The vendor may have raised the cost while the product field still carries an earlier amount. Compare the actual purchase record with the field used for reporting before judging whether a discount was affordable.

Bring freight and duty into the same review. The landed-cost guide explains the charges that belong with the goods. Trace each charge through the store’s accounting process so it enters the item cost and reports once.

Put the two configurations side by side and bring out the swatches. Cream and oatmeal may look like the same color until someone opens the fabric books. The selected weave, grade, and finish belong on the record that identifies the actual piece.

A premium fabric and standard weave can share a sofa name while carrying different costs. Match the cost to that full specification. The configuration-specific stock and cost guide follows the exact stocked piece.

Calculate the effect before making a pricing decision

Using the opening example, margin is gross profit divided by the sale value. Taxes, selling fees, and store overhead are excluded from this illustration; the result is merchandise gross margin, not net profit.

The cost difference takes $800 out of the example’s gross profit. Find the cost used by the report before setting a discount or commission from its margin. If freight is still waiting to be allocated, finish that costing job first and bring the settled figure into the decision.

Publish final costs through OrderPilot

OrderPilot publishes the weighted average of costed stock once its supporting costs are final. A newly created stocked variant first receives the PO unit cost, followed by the finalized average when ready. Finalizing the receipt’s charges gives Shopify a maintained cost for subsequent sales.

Shopify receives the weighted average even when the store uses FIFO or LIFO inside OrderPilot. Those methods can value the next unit out differently from the average stock held. The costing-method comparison follows that difference through a worked example.

Decide how manual Shopify cost edits should be handled

By default, OrderPilot flags and pauses a cost update when Shopify’s current value differs from the app’s last published figure. The setting can allow overwriting instead. Choose how the store wants manual edits handled, then give the costing team responsibility for resolving flagged differences.

The PO list shows cost-sync progress and any problems, with retry where available. Use the reason to choose the next action: finalize the charges, resolve a manual-value conflict, or retry a failed update. Staff can follow the result back to the published Shopify figure.

Separate future reporting from past corrections

A cost update helps future sales; historical profit reports retain the cost recorded at the earlier sale. Review past discrepancies against the actual receipts and accounting records, and handle those corrections through the bookkeeping process. Shopify, Profit reports.

For products purchased outside OrderPilot’s costed receipts, maintain the Shopify cost through a separate, assigned process. The native Shopify capability guide and purchasing guide help map which system supplies each product’s purchasing and cost record.

Next, review the landed cost of one received furniture order, then compare the finalized figure with the cost Shopify is using.

Sources

1. Migrating from Stocky to Shopify inventory management, Track inventory costs and reconcile received stock — Shopify Help Center
2. Profit reports — Shopify Help Center