Why does Shopify show zero cost or leave orders out?
- Cost is fixed at order time. Earlier orders keep the old cost, or none.
- Each variant needs its own cost. A cost on the medium doesn’t carry to the large.
- Missing costs display as $0 in Shopify’s reports.
- Profit reports skip items with no cost. Their net sales can be lower than your sales reports show.
- An import can wipe costs. A blank Cost per item cell in an overwrite import replaces the saved cost with a blank.
- Gift cards never carry a cost.
How do you find the variants with no cost?
- Open the variant sales report. Go to Analytics > Reports, open Total sales by product variant and set your date range.
- Add the missing-cost data. Edit the report’s columns to add the metric Net sales without cost recorded, or the dimension Cost is recorded.
- Export it. Click Export, choose CSV, and sort by the new column.
- Check the rest of the catalog. Go to Products, click Export, choose All products and the CSV file for Excel, Numbers, or another spreadsheet program, then click Export products. Filter Cost per item for blanks.
Sales reports show product details as they were at the time of the order, so a variant whose SKU changed can appear on two rows.
How do you fill in costs on every variant safely?
For a few dozen variants, go to Products, tick the products, click Bulk edit, add Cost per item under Columns, type the costs and click Save.
For hundreds of variants, use a product CSV:
- Export all products and keep an untouched copy as your backup.
- Keep only URL handle, Title, the Option name and value columns, SKU and Cost per item. A column left out keeps its saved value; a blank cell in an included column overwrites it.
- Keep the option columns. Shopify warns that without Option1 name and Option1 value, “a new default variant is created and existing variants are deleted.”
- Leave the rows in the exported order. Shopify cautions that a sorted file can separate variants from their products and overwrite them with bad data that can’t be recovered.
- Enter each cost as a plain number, such as 9.99, with no currency symbol.
- Test three or four products first. Select them, export Products you have selected, edit and import before the full file.
- Import. Go to Products, click Import, click Add file, select Overwrite products with matching handles, click Upload and continue, review, then click Import products. A file can’t exceed 15 MB.
- Check it worked. Confirm a few products still have every variant. After a week, Net sales without cost recorded should be zero.
Shopify’s example of cost per item is the price you paid the manufacturer, excluding taxes, shipping or other costs. Agree with your accountant whether freight and duty go in. The same CSV rules apply to bulk editing Shopify prices.
How do you rebuild cost of goods sold for past orders?
Shopify’s profit reports page points to your accounting system or a manual calculation:
- Export units sold by variant, one month at a time, from Total sales by product variant. Net quantity is items sold minus items returned.
- Build a cost table by SKU from supplier invoices or your bills in QuickBooks. When a cost changed, give each price its own date range.
- Map old SKUs to current ones, so renamed variants land on one row.
- Multiply and add up: net quantity times unit cost, per SKU, per month.
- Check which orders are in. Shopify’s sales reports include pending, unpaid and canceled orders, and leave out test orders.
Example, in dollars, for one month:
| SKU | Net quantity | Unit cost | COGS |
|---|---|---|---|
| TEE-BLK-M | 120 | 6.50 | 780.00 |
| TEE-BLK-L | 95 | 6.50 | 617.50 |
| MUG-12OZ | 60 | 3.20 | 192.00 |
| Total | 1,589.50 |
The gap to the cost in Gross profit by product variant for that month is cost Shopify never recorded, or recorded at an old price.
Why doesn’t Shopify’s cost of goods sold match QuickBooks Online?
| Cause | What happens | How to check |
|---|---|---|
| Sales post to a default item | Intuit’s connector uses “Shopify Sales Item” when Product Tracking is off or no match is found, and QuickBooks debits COGS only when inventory items are sold on invoices or sales receipts | Open a few synced sales receipts and look at the item on each line |
| Different costing | QuickBooks Online costs inventory by FIFO or moving average cost from your purchases; Shopify uses the cost typed on the variant | Compare unit costs for your 10 best sellers |
| Freight and duty | Shopify’s example excludes them; your bills may add them to item cost | Ask your bookkeeper how landed costs are booked |
| Orders that never synced | Missing sales mean missing COGS in QuickBooks | Follow the steps for Shopify orders not syncing to QuickBooks Online |
Set the Cost of Goods Sold line from the QuickBooks Profit and Loss report beside your rebuilt total and Shopify’s figure. Your accountant decides whether past months need a correcting entry. For fees, labels and returns on top of product cost, see your real Shopify margin after fees and shipping.
What are your options?
| Option | What you get | Watch for |
|---|---|---|
| Do it yourself | The CSV fill-in and a monthly rebuild sheet | Hours each month |
| Buy a tool | A profit app that keeps cost history by date | What it does with orders placed before you installed it |
| Hire a freelancer | An ecommerce bookkeeper who reconciles COGS monthly | Whether the cost table stays with you |
| Bring in an outside team (Reports & answers) | Past COGS rebuilt and a margin report that keeps costs current | Written notes on where each cost comes from |
FAQ
Can I update the cost on past Shopify orders? Shopify’s help says a changed cost isn’t applied to orders created before the change. Rebuild past months outside Shopify.
Where is the cost of goods sold report in Shopify? Go to Analytics > Reports, filter Category to Profit Margin, and open Gross profit by product or Gross profit by product variant.
Why are net sales lower in the profit report than in the sales report? Profit reports count only products that had a cost recorded when they sold. Adding the missing costs fixes it for new orders.
Does the Shopify connector post COGS to QuickBooks Online? Intuit says COGS is debited only when inventory items are sold on invoices or sales receipts. Check whether synced sales use your items or the default Shopify Sales Item.
Sources
- Adding cost per item to products, Shopify Help Center,
- Profit reports, Shopify Help Center,
- Analytics data points (fields) reference, Shopify Help Center,
- Sales reports, Shopify Help Center,
- Using CSV files to import and export products, Shopify Help Center,
- Exporting products, Shopify Help Center,
- Importing products, Shopify Help Center,
- Inventory assets and Cost of Goods Sold tracking, Intuit QuickBooks,
- Inventory valuation methods for cost accounting, Intuit QuickBooks,
- Connect Shopify to QuickBooks Online, Intuit QuickBooks,