Field guide · E-commerce brands · Shopify

Shopify cost of goods sold report missing costs: how to fix it

Shopify’s help says a changed cost per item “isn’t applied to orders that were created before the change,” so orders placed while a variant had no cost stay at zero cost of goods sold (COGS). Give every variant a cost, then rebuild past COGS from units sold by variant and check it against QuickBooks Online.

Published · Get the PDF

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?

  1. Open the variant sales report. Go to Analytics > Reports, open Total sales by product variant and set your date range.
  2. 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.
  3. Export it. Click Export, choose CSV, and sort by the new column.
  4. 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:

  1. Export all products and keep an untouched copy as your backup.
  2. 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.
  3. Keep the option columns. Shopify warns that without Option1 name and Option1 value, “a new default variant is created and existing variants are deleted.”
  4. 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.
  5. Enter each cost as a plain number, such as 9.99, with no currency symbol.
  6. Test three or four products first. Select them, export Products you have selected, edit and import before the full file.
  7. 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.
  8. 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:

  1. Export units sold by variant, one month at a time, from Total sales by product variant. Net quantity is items sold minus items returned.
  2. 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.
  3. Map old SKUs to current ones, so renamed variants land on one row.
  4. Multiply and add up: net quantity times unit cost, per SKU, per month.
  5. 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:

SKUNet quantityUnit costCOGS
TEE-BLK-M1206.50780.00
TEE-BLK-L956.50617.50
MUG-12OZ603.20192.00
Total1,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?

CauseWhat happensHow to check
Sales post to a default itemIntuit’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 receiptsOpen a few synced sales receipts and look at the item on each line
Different costingQuickBooks Online costs inventory by FIFO or moving average cost from your purchases; Shopify uses the cost typed on the variantCompare unit costs for your 10 best sellers
Freight and dutyShopify’s example excludes them; your bills may add them to item costAsk your bookkeeper how landed costs are booked
Orders that never syncedMissing sales mean missing COGS in QuickBooksFollow 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?

OptionWhat you getWatch for
Do it yourselfThe CSV fill-in and a monthly rebuild sheetHours each month
Buy a toolA profit app that keeps cost history by dateWhat it does with orders placed before you installed it
Hire a freelancerAn ecommerce bookkeeper who reconciles COGS monthlyWhether the cost table stays with you
Bring in an outside team (Reports & answers)Past COGS rebuilt and a margin report that keeps costs currentWritten 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

Have one problem in mind?

Walk us through it on a free 30-minute call. Within two business days you get a one-page note on what we’d fix first, yours to keep.

Walk us through one problemFree 30-minute call.