How to track COGS in Shopify (and keep it accurate)
Cost of goods sold is the biggest input to Shopify profit. How to record COGS, handle price changes and find products with missing costs.
Cost of goods sold (COGS) is usually a store’s largest cost, and the one most often wrong. A product without a cost looks fully profitable, which quietly inflates every profit number.
Three ways to record COGS
- Shopify’s “Cost per item” on each product or variant. Simple, but it holds only the current cost.
- A spreadsheet of costs by SKU. Flexible, but disconnected from your orders.
- A profit app that reads Shopify’s costs, accepts imports and keeps history.
Costs change: use effective dates
Suppliers raise prices, freight costs move, and you switch manufacturers. If you overwrite the cost, your old months suddenly look less profitable than they were. Record each cost with the date it took effect, so every order uses the cost that applied when it was sold.
Measure coverage
Ask: what share of units sold in this period have a cost? If the answer is 93%, your profit is overstated by the margin on the other 7%. Track coverage every month and fix the best-selling uncosted products first.
Include landed costs
COGS should include what it took to get the product to your warehouse: duties, inbound freight and packaging you buy per unit. Leave outbound shipping to customers as a separate cost.
Keep it accurate automatically
Optifin’s Costs workspace reads Shopify’s cost per item, imports CSVs with a preview, keeps effective-dated history, and flags every product still missing a cost, so profit is never quietly inflated. See also: How to calculate true profit on Shopify.