COGS is missing
Okiela hypothesis
Without product cost, no tool can compute real profit. It can only show revenue and gross sales.
In real life: A dashboard shows "profit" but it never had your cost per unit, so the number is really just revenue minus fees.
Shopify / DTCShopeeTikTok ShopLazadaExcel / Manual
Data you need
- requiredCost per SKU. Landed unit cost (product + inbound freight).
- requiredSKU list. To map each cost to a product.
Formula
Gross Profit
Net Revenue - COGSCOGS is the first real cost layer. Without it, profit is undefined, not zero.
Key insight
- A profit number computed without COGS overstates profit on every order.
- When COGS is missing, an honest tool says "cannot determine", not a guess.
Action checklist
- 1List landed cost for your top 10 SKUs · easy · 30 min
They usually cover most of revenue. - 2Use a category benchmark for the long tail · easy · 15 min
Label it estimated until you confirm. - 3Replace estimates with real costs as you confirm them · medium · ongoing
Profit confidence rises as coverage grows.
Money impact · Improve clarity
Turns an unreliable profit number into a verifiable one. Clarity is the prerequisite for every other money decision.
Common mistakes
- Trusting a profit figure that was never given a cost.
- Using last purchase price instead of weighted cost.
How Okiela helps
COGS coverage + estimated/verified labelslive
Okiela labels profit Estimated until real COGS is matched, then Verified.
Trust & sources
- Okiela hypothesisDeterministic consequence of the profit formula
Last reviewed 2026-06-22 · Confidence 5/5