Missing COGS Is Not Zero COGS

Revenue is easy to see.

Product cost is often messier.

A SKU may be missing from the cost table. A new shipment may have a different landed cost. Historical cost may have been overwritten. A variation may not map correctly. A spreadsheet lookup can fail. A profitability dashboard may receive a blank.

Then a dangerous shortcut appears:

If cost is missing, use zero so the calculation can continue.

The spreadsheet works. The dashboard fills in. The margin looks fantastic.

The answer is wrong.

1. Missing cost and zero cost are different facts

A true zero cost can exist in special cases, but it should be an explicit business fact.

A missing cost means you do not currently know what cost to assign.

Those states need different treatment:

• COGS = $0: the business explicitly says the product cost is zero.
• COGS missing: no reliable cost is available for this sale or SKU.

If your system cannot distinguish them, every missing cost can silently become fake profit.

2. See what a false zero does to profit

Imagine a marketplace order with:

• Revenue: $40
• Marketplace and fulfillment fees: $12
• Advertising allocated to the order: $5
• Actual product cost: $14

True contribution after those costs:

$40 − $12 − $5 − $14 = $9.

Now suppose the product-cost lookup fails and the model substitutes $0:

$40 − $12 − $5 − $0 = $23.

The sale did not become more profitable. The model lost a cost and reported the missing data as margin.

3. False profit spreads into other decisions

Bad COGS does not stay inside a profitability report.

It can change:

• PPC targets: break-even ACoS and affordable CPC appear higher than they should.
• Pricing: a SKU can look safe to discount even when the real margin is thin.
• Reimbursement economics: the value of an inventory loss can be misstated.
• Channel comparison: one marketplace can appear more profitable because its cost mapping is incomplete.
• SKU ranking: products with missing cost can rise to the top of “most profitable” lists.
• automation: rules based on margin can take actions from corrupted inputs.

This is why data quality is part of profitability, not a separate cleanup task.

4. Give missing COGS its own state

When cost is missing, do not hide it.

You can mark the row or transaction with states such as:

• cost confirmed;
• cost missing;
• cost mapping uncertain;
• historical cost unavailable;
• cost estimated — review required.

Then decide what your reports are allowed to do with each state.

For example, a dashboard can show revenue and fees while flagging profit as unknown because product cost is missing. A ranking report can exclude incomplete SKUs from “highest margin” until the cost is resolved. A PPC calculator can refuse to produce a profitability target from a missing cost.

An incomplete answer that tells the truth is more useful than a precise answer built on a false zero.

5. Historical profit needs historical cost

Even when you have COGS today, historical profit can still be wrong if you overwrite old cost.

Suppose a SKU cost $8 per unit from January through June. A new supplier shipment raises cost to $11 in July.

If your profitability system stores only “current cost = $11” and applies that cost to every past sale, January profit is rewritten using July economics.

The reverse can also happen: an old $8 cost remains attached to new $11 inventory and makes current margin look too high.

A stronger model uses effective-dated cost: the cost value that was in effect for the relevant period or inventory basis.

A simple cost history can include:

• SKU;
• cost amount;
• effective start date;
• effective end date where applicable;
• source;
• confidence/status;

The exact accounting method can vary. The operating principle is that historical analysis should not casually rewrite history with today's cost.

6. Keep product cost separate from other costs

COGS is important, but it is not the whole profit model.

Depending on the decision, you may also need marketplace referral fees, fulfillment fees, storage, inbound/prep cost, shipping, advertising, refunds, discounts, or other variable expenses.

Keep those cost categories visible instead of packing everything into one unexplained “cost” number.

That lets you answer better questions:

• Is margin weak because the product itself is expensive?
• Are fulfillment fees the problem?
• Is PPC consuming the remaining contribution?
• Did returns erase the expected profit?
• Is one marketplace structurally more expensive for this SKU?

Example: one SKU looks like a winner because its cost is missing

A seller reviews 300 SKUs and sorts by contribution margin.

SKU A shows 58% contribution. SKU B shows 31%. SKU C shows 27%.

The team plans to increase ads on SKU A.

But SKU A's product-cost lookup failed. The calculation used $0 COGS.

After the correct $16 cost is restored, SKU A's contribution falls to 18%.

The original ranking was not merely inaccurate. It pointed the next advertising dollar toward the wrong product.

A simple COST_MISSING flag would have prevented SKU A from entering the profitability ranking in the first place.

7. Build a cost completeness view

Before trusting a marketplace profitability report, ask how much of the underlying sales volume has reliable cost.

Useful checks include:

• SKUs with missing cost;
• sales dollars tied to missing cost;
• units tied to uncertain mappings;
• cost records without an effective date;
• products whose cost changed recently;
• profitability rows using estimates rather than confirmed cost.

This turns “our report has some blanks” into an operational data-quality queue.

Using this manually or with AI at scale

You can manage product-cost completeness manually with a cost table, effective dates, and a missing-cost exception list.

For larger catalogs, browser AI such as ChatGPT or Claude can help compare SKU lists, find unmatched cost records, summarize changes, and prepare a review queue. It can also help explain why a margin changed when the underlying cost history is supplied.

AI should not invent COGS. If a source value is missing, the correct first answer is “cost missing,” followed by the work needed to resolve it.

Choose the right next resource

If your main problem is understanding true marketplace profit across products and channels, the Marketplace Profitability Toolkit is the core operating resource for bringing revenue, product cost, fees, fulfillment, ads, refunds, and data quality into one decision model.

If the immediate decision is advertising, the Profitability-Aware PPC Calculator can translate confirmed product economics into break-even ACoS and CPC guardrails.

For the foundation, read Marketplace Revenue Is Not Marketplace Profit, or explore Marketplace Profitability.

Operating note: Cost-accounting methods vary by business. Use a consistent method appropriate to your accounting and operational needs, and involve a qualified accounting professional where formal financial reporting requires it.

Put this into practice

If you are diagnosing one profitability question, use this guide and the related articles first. For recurring product- and channel-level profitability work, use the Marketplace Profitability Toolkit. If that profit view also needs to drive Amazon advertising decisions, use the Seller Profitability Bundle. Browse the full Marketplace Profitability resource family.

Related operator guides

• Why historical marketplace profit needs effective-dated product cost
• Turn profitability insights into an operating review routine

Nyansa Hub — Playbooks for Smarter Ecommerce. Built for sellers and operators managing multiple marketplaces, large catalogs, and recurring ecommerce operations.