I Sell a Lot, Keep Little: Will an E-commerce Consultant Sit Down and Do the Math?
The orders come in — the notification sound proves it all day. The team packs, ships, answers, restocks. Revenue looks respectable. And at month’s end you open the account and meet the same quiet insult: where is the profit? You sell plenty and keep little, and nobody at any meeting can tell you why.
Here is the uncomfortable comfort: the money isn’t vanishing mysteriously. It is leaving through named, findable doors — fees, shipping, returns, ads, discounts — and it leaves per order, which is exactly where nobody looks. Totals hide what rows confess.
This guide shows the profit session: how an e-commerce consultant sits down with you and builds the number your store has never had — profit per order, per product — and what decisions fall out of it.
Revenue Without Profit: Where Does the Money Leak?
Between “sold for X” and “kept Y” runs a corridor of doors. Four of them do most of the taking.
The doors:
The Profit Session: How Is the Math Built With You?
One working session, your records on the table, the consultant’s method driving. Four steps.
The steps:
Where Do the Fix-Ups Start?
Rows written, tribes sorted — now the corrections, cheapest first.
The corrections:
Which Product Gets Which Treatment?
The tribes dictate; sentiment abstains. Four treatments.
The treatments:
Monthly Rhythm: How Does the Table Stay Alive?
A dead spreadsheet is last year’s truth. Four habits keep it breathing.
The habits:
The Meeting Test and the Profit X-Ray
BU BÖLÜMÜN ÖZETİ
- “Will you actually sit down and do the math with us?”
- “What if raising prices loses us orders?”
- “How do you handle our marketplace channels?”
- “If we start small, what do we get?”
Close with the door-specific test. Four questions:
And the sound of good answers:
“Will you actually sit down and do the math with us?”
The door’s title question — ask it verbatim. Good answer: yes, one session, your records, twenty rows, verdicts on paper. Deflections toward “growth strategy” or “conversion optimization” before rows exist are packages circling; the row is the diagnosis, and you know the rule about diagnosis.
“What if raising prices loses us orders?”
Good answer, calmly: some orders deserve losing — the ones that paid you to work. The row shows which; the market then votes on honest prices, and the vote usually surprises pleasantly. A consultant promising repricing with zero order loss is selling weather again; you’re buying climate.
“How do you handle our marketplace channels?”
Good answer: same method, separate rows — each channel’s fee identity makes the same product a different business per venue, and the rows decide what sells where. The full marketplace treatment lives in its own guide; the two tables share a method and split the venues.
“If we start small, what do we get?”
The profit X-ray: your top sellers rowed in one session, tribes named, first corrections listed — fixed fee, table yours, freedom after. Bring last month’s sales export and your purchase costs to a preliminary assessment, and pair this read with the e-commerce consulting page. Kin topics: the patch-cost guide and the export guide.
Field Notes
· The session’s recurring shock: the store’s proudest bestseller rowing out underwater once returns and ad share land — and a quiet mid-catalog product revealed as the real breadwinner.
· Freeloader desponsorship is the fastest fix in the book: same week, visible in the ad account and the till simultaneously.
· Stores that adopt the campaign sentence report the strangest cultural shift: marketing and finance reading the same line, agreeing for the first time.
Quick Glossary
The row: One product’s full truth: real price minus every per-unit cost and share.
Three tribes: Earners, break-evens, freeloaders — plus the written-role showcase.
Campaign sentence: Orders up X, per-order down Y, net Z — written before the next campaign.
Quick Summary
· Money leaks per order through named doors; rows make the doors visible and totals stop lying.
· One session rows the top twenty, sorts the tribes, and the corrections write themselves — cheapest first.
· Three headlines monthly: profit per order, return rate, campaign net; the table and its habit stay yours.
Next Step
Row one product tonight — your bestseller, honestly, every share included. Whatever the remainder says, bring the row to a preliminary assessment; the X-ray starts from your first line, and first lines are usually the loudest.
Frequently Asked Questions
Our costs change weekly with exchange rates. Won’t the rows be instantly stale?
Volatile costs make rows more necessary, not less: the row template recalculates in minutes once built, and the trigger habit — cost event, row rewrite — is designed exactly for moving inputs. Stores in volatile-cost trades typically keep a currency column and reread monthly at minimum. Stale rows beat no rows the way an old map beats darkness; fresh rows are just a habit away.
We sell hundreds of SKUs. Is rowing everything realistic?
Rowing everything by hand isn’t the method: twenty rows by hand build understanding, then the template scales by pattern — products sharing cost structures inherit row logic, and exports do the arithmetic. The long tail usually sorts fast because its tribes are extreme. The manual session is the education; the spreadsheet is the factory. Hundreds of SKUs is a formatting task, not a barrier.
Is this the same as what our accountant already does?
Complementary, not identical: accounting answers whether the business made money, legally and in total; the rows answer which product, order and channel made it, operationally and per unit. Accountants themselves usually welcome the table — it explains their totals. The healthy loop runs both directions: rows feed cleaner questions to accounting, accounting sanity-checks the rows’ honesty.
Sık Sorulan Sorular
Because each is small and none arrives as one bill: a fee here, a shipping label there, a free-return, a discount code. Individually forgettable, per-order they compound — and monthly totals blur them into “costs.” The leak survives on the difference between visible-in-total and felt-per-order; the row is the cure.
Outbound shipping spent, return shipping spent, handling time spent — and sometimes the product comes back unsellable. A product with a high return rate can headline your bestseller list and bleed on its row. Return rate is a per-product property, not a store-wide weather condition; treating it store-wide is how bleeders hide.
On nothing — which means on everything, evenly, which is false: ads sell specific products, and their cost belongs on those rows. Unassigned ad spend is the most common reason a “profitable” product turns out to be sponsored. The Ads guide’s rule arrives here in row form: undistributed spend is an unanswerable profit question.
The sale price itself: a row calculated at list price lies whenever the product mostly sells discounted. Campaign periods need their own reading — order counts up, per-order profit down is a trade, acceptable only when chosen knowingly. Celebrated blindly, campaigns are how busy months become poor ones.
Your real numbers: sales exports, purchase costs, shipping tariffs, fee statements, return records, ad spend. No estimates where records exist; estimates flagged where they don’t. The session’s first product is honesty — the store meeting its own paperwork, often for the first time.
One line, in order: average real sale price, minus purchase cost, fee, shipping, packaging, per-unit return share, per-unit ad share, per-unit discount share. The remainder is the row’s verdict. The arithmetic is deliberately schoolbook — the discipline is in the shares, and the consultant’s craft is calculating them fairly.
Because volume concentrates: your top sellers usually carry most of the story, and twenty rows fit one honest session. The long tail follows later, faster, by pattern. Sessions that try to row the whole catalog day one produce fatigue instead of verdicts; twenty verdicts change behavior this week.
Sorted by remainder: earners (fund everything), break-evens (work for free), freeloaders (charge you for the privilege). Plus the honest fourth from the marketplace guide — the deliberate showcase product, kept for traffic with its role written down. Unwritten showcase and freeloader are indistinguishable; the writing is the difference.
Each underwater row gets repriced from its own costs upward — including a shipping presentation rethink: free-shipping thresholds set by math, not mood; heavy products priced with their freight told honestly. Repricing scares owners and rarely scares customers; the row supplies the courage the market usually rewards.
Per product, by cause: wrong size expectations get size guidance, color surprises get truer photos, fragile arrivals get packaging fixes. Expectation repair is the cheapest profit work in e-commerce — a paragraph and a photo against a double-taxed shipment. The best return policy is the return that never starts.
To the earners, with each product’s row updated by its assigned spend so the move stays honest month over month. Freeloaders lose their sponsorship first — often the single largest same-week profit jump a store sees. The rule you know by heart now: proven rows get fuel, unproven rows get trials.
Pairing earners with natural companions, threshold nudges set at row-safe levels, bundles whose combined row still earns. Basket work multiplies everything upstream — same visitors, same ad spend, better remainder per checkout. It comes last on purpose: bundling freeloaders just industrializes the leak.
Protection and fuel: stock priority, ad priority, review care, and a monthly glance at their rows so success doesn’t quietly erode — costs drift, fees change, the row must breathe. Earners neglected are how next year’s flat store gets built. Feed what feeds you is the whole doctrine.
Often, with one lever each: a small reprice, a cheaper box, a shipping rethink — chosen from the row’s own worst line. One lever, one month, reread. Break-evens are the optimization playground precisely because they’re one fix from either tribe; the row names the fix.
After its levers fail or when no lever exists: structural rows — bought too dear, shipped too heavy, returned too often — don’t negotiate. Delisting feels like defeat and reads like a raise; the work it frees is the invisible bonus. Exceptions require a written role, showcase or gateway, with a review date.
You — from evidence, at the monthly table, one tribe review per session. The consultant referees the math and resists the two classic sentimentalities: the founder’s-favorite freeloader and the fear of raising a price that’s been wrong for years. Rows have no feelings; that is their entire value.
Any cost event: supplier change, fee update, carrier tariff, campaign entry. Row maintenance is minutes when done on trigger, archaeology when done annually. The official commerce framework and its obligations — tracked at eticaret.gov.tr — moves too, and moves are row events by definition.
Profit per order, return rate, campaign-period net. Revenue attends as context, never as headline — the series’ oldest demotion. Three numbers fit on anything and survive any meeting; dashboards are where headlines go to hide.
Every campaign closes with one sentence: orders up X, per-order down Y, net Z — written before the next campaign is planned. The sentence converts campaign culture from adrenaline to arithmetic. Stores that write it start declining some campaigns, which is the sentence working.
By design, quickly: the session builds the table, two or three monthly readings transfer the ritual, then quarterly check-ins reading your rows’ honesty. The table is the deliverable and it is yours in every sense — file, method and habit. Dependency was never on the menu at any door of this series.