Uncategorized

COGS Tracking for E-commerce: How to Know Your True Margins

COGS Tracking for E-commerce: How to Know Your True Margins

Most e-commerce brands know their gross revenue. Far fewer know their true gross margin — because tracking COGS (cost of goods sold) accurately requires accounting for the full landed cost of inventory, not just the supplier invoice price.

In our experience, brands that make pricing, product, and promotion decisions based on incomplete margin data consistently leave money on the table or inadvertently run promotions that lose money. This guide covers how to set up COGS tracking correctly and what most businesses miss.

What Should Be Included in COGS

COGS for e-commerce includes more than just the unit cost from your supplier. A complete COGS calculation includes:

  • Product cost (unit cost) — the price you pay your supplier per unit
  • Inbound freight — the cost to ship goods from supplier to your warehouse or 3PL, allocated per unit
  • Import duties and customs fees — duties paid to import goods, allocated per unit or shipment
  • Quality inspection fees — if you use a third-party inspector before goods ship
  • Receiving and prep fees at 3PL — some 3PLs charge per-unit receiving, labeling, or prep fees
  • Packaging cost — if you use custom branded packaging, the packaging cost per unit is a COGS component

The sum of these is your landed cost per unit. This is the number that should be in your IMS and accounting system as COGS — not just the supplier unit cost.

The Common COGS Mistake: Using Supplier Price as COGS

The most common error is recording only the supplier invoice price as COGS. If you pay $15/unit for a product and $2.50/unit in inbound freight and duties, your actual COGS is $17.50. Running margin calculations at $15 overstates your gross margin by 14 percentage points on a 50% gross margin product — a material distortion that leads to incorrect pricing and promotion decisions.

How to Build Landed Cost into Your IMS

Most modern inventory management systems support landed cost calculation:

Extensiv

Extensiv allows you to record the purchase order (supplier cost) and add landed cost components (freight, duties) that are allocated across units. The system then uses the full landed cost as the COGS value when calculating margin.

Cin7

Cin7 supports landed cost allocation at the purchase order level. You can enter freight costs for a shipment and allocate them across the SKUs in the PO by value, weight, or quantity. This updates the per-unit cost for each SKU received.

Shopify Native

Shopify’s inventory cost field (in the product variant settings) stores a cost per variant, which Shopify uses in its COGS reporting. This is a flat number — it doesn’t dynamically calculate landed cost from multiple components. Most brands past $500K benefit from managing COGS in their IMS rather than Shopify’s native cost field.

COGS by Channel: Knowing Which Channel Is Most Profitable

If you sell across multiple channels (Shopify DTC, Amazon, wholesale), your COGS by channel may differ. Fulfillment costs are often higher on Amazon (FBA fees) than DTC (3PL pick-and-pack). Wholesale orders have lower fulfillment cost per unit but often lower selling price.

Build channel-level contribution margin reporting — not just gross margin — by including:

  • Landed product COGS (same across channels)
  • Channel-specific fulfillment costs (3PL fees, FBA fees, or your own warehouse cost per order)
  • Channel-specific fees (Amazon referral fees, payment processing fees)
  • Channel-specific return rates and return processing cost

Many brands discover that their Amazon channel is significantly less profitable than their DTC channel once these costs are properly allocated — and that knowledge should drive decisions about which channel to invest in growing.

Connecting COGS to Your Accounting System

For COGS to flow correctly into your P&L, your IMS needs to sync with your accounting platform (QuickBooks, Xero, or Zoho Books). The integration method varies:

  • A2X — the most popular tool for reconciling Shopify and Amazon payouts into QuickBooks or Xero, including COGS mapping
  • Direct IMS-to-accounting integration — Cin7, Extensiv, and others have direct QuickBooks and Xero integrations that push COGS entries when inventory is sold
  • Zoho Books + Zoho Inventory — native integration within the Zoho ecosystem; inventory movements automatically create journal entries in Zoho Books

The goal: when a sale is recorded in Shopify, the COGS entry in your accounting system reflects the full landed cost of that unit — automatically, without manual journal entries.


Frequently Asked Questions

What is included in COGS for e-commerce?

Supplier unit cost, inbound freight per unit, import duties, quality inspection fees, 3PL receiving/prep fees, and branded packaging cost. Using only supplier price as COGS overstates gross margin — a common error that distorts pricing and promotion decisions.

What is landed cost and why does it matter?

Landed cost is the total cost to get a product from supplier to your warehouse — including freight, duties, inspection, and prep. It’s the true per-unit cost for margin calculations and pricing decisions. Businesses using only supplier price consistently make decisions based on overstated margins.

How do I track COGS in Shopify?

Shopify has a built-in cost per variant field for COGS reporting. Enter full landed cost (not just supplier price). For more robust COGS tracking with landed cost calculation across POs, use a dedicated IMS (Extensiv, Cin7) that syncs COGS into your accounting system via A2X or direct integration.

How is COGS different from cost of revenue?

COGS = direct product cost. Cost of Revenue is broader — may include fulfillment costs (pick-and-pack, outbound shipping). For contribution margin analysis, tracking COGS and fulfillment costs separately gives the most complete picture of channel and product profitability.


Get Your Margin Data Right

OpsStack helps e-commerce brands set up landed cost tracking, IMS-to-accounting integrations, and contribution margin reporting by channel and product. Talk to us about your COGS and margin visibility.

Scroll to Top