SKU unit economics: do the math before you write anything
AI for e-commerce · Lesson 1 / 22
Why this course opens with a calculator, not a prompt
The temptation looks like this: a hundred listings sell badly, so you rewrite the descriptions with a model and sales go up. In practice half of them sell badly not because of the text but because after every deduction the item earns about a dollar per sale, and more traffic only burns the ad budget faster. The first skill is breaking a single SKU into its parts and deciding whether anything there is worth optimising.
What goes into one item's unit economics
- Landed cost. Not the invoice price, but price including freight, duties and packaging per unit.
- Platform commission or payment processing. A percentage of the selling price, varying by category.
- Outbound and return shipping. The return leg is charged against every completed sale, not every return: if seven of ten orders are accepted, three return legs are spread across seven paid units.
- Storage. A rounding error for fast movers, a killer for an item that sits four months.
- Advertising. Ad spend as a share of revenue for this SKU, not the account average.
- Defects and damage. The share of a batch that never reaches a customer in sellable condition.
Then calculate margin after all deductions, in currency and in percent. Percentages compare positions; the absolute number tells you how many units a month justify handling the item at all.
Where the model helps
The model is not a source of numbers here, but a calculator that explains itself. Export the table and ask it to work through the rows.
Prompt: Below is a SKU table: landed cost, selling price, commission %, outbound and return shipping, acceptance rate, monthly storage, ad share. For each row calculate: margin after all deductions in currency, margin as a percentage, and the break-even selling price. Flag rows where margin is under 12% or under a fixed floor per unit. Do not invent missing figures — list what data is missing instead.
Cheat sheet
- SKU economics first, content and advertising second.
- Spread return shipping across accepted orders, not across returns.
- The model calculates and explains; you supply the numbers.
- Compare items by margin per unit of capital, not by percentage.