Profit

Per-order profit visibility: the column that changes decisions

Most dropshippers know their monthly profit. They open the bank, look at the payout, subtract a rough idea of what they spent on AliExpress, and call it a number. That number is fine for paying yourself. It is useless for running the business.

The decisions that actually move the needle — which listings to push, which suppliers to drop, where to raise a price by 80p — happen at the level of a single order. And you cannot make those decisions if every row in your sheet just says "sold". You need a profit figure sitting on each line.

Why monthly profit hides everything that matters

A healthy-looking month is almost always a blend of winners subsidising losers. You have listings clearing £6 a unit and listings quietly losing 40p once you count the ad fee and the return. Averaged together they look like a thin, survivable margin. Broken out per order, they tell you exactly what to kill.

The problem is that the per-order number is genuinely hard to assemble by hand. To get real profit on one row you need four things lined up:

• Your true net eBay earnings — what actually landed in the payout after final value fees, not the sticker price.
• The AliExpress order amount you paid to source it (in the right currency).
• Any refund that clawed back part or all of the sale.
• Promoted Listings ad spend if the sale came through an ad.

The number most sellers get wrong: gross vs net

Here is where almost everyone trips. If you pull earnings from eBay's Order API, you get the gross price the buyer paid. Then you subtract a guessed fee — "about 13%" — and treat the result as revenue. That guess is wrong on nearly every order, because the real deduction depends on category, promoted-listing status, international fees, and adjustments.

If your profit column starts from a price the buyer saw rather than the money you actually received, it is not a profit column. It is a hopeful estimate that drifts further from reality the more orders you do.

The fix is to read earnings from eBay's Finances API instead. That endpoint reports the true net per transaction — fees already removed, the exact amount that hit your balance. We dig into this distinction in why your gross profit column is wrong, and it is the single biggest reason hand-built profit columns lie.

What changes the moment you can see it per row

Once real profit sits on every line, your behaviour shifts within a week. A few things that happen reliably:

1. You spot the silent losers. The listing that "sells well" but nets 30p, the supplier whose shipping cost crept up, the SKU that gets refunded twice as often as the rest.
2. You price with evidence. Instead of matching a competitor blindly, you can see which listings have the headroom to hold a higher price and which are already underwater.
3. You catch refund erosion. A delivered-then-refunded order can turn a +£5 row into a -£4 row. If your column does not subtract that, your "best month" was partly fiction.

How to build the column without losing your evenings

You can assemble this manually: open eBay, find the transaction, note the net, cross-reference AliExpress for the cost, check for a refund, drop it all into a formula. For ten orders, fine. For say 300 orders a month, it is an hour-plus daily of copy-paste that is stale the moment you finish.

This is the exact gap Fetch Order Tracking was built to close. It connects to your eBay account through the Finances API for true net earnings and to the AliExpress Dropshipping API for the source order amount, then writes both — plus refund state and tracking — straight into the Google Sheet you already own. The profit column stops being a project you maintain and becomes a number that is simply there, correct, on every row.

Because it captures the refund state alongside the cost, a delivered-then-refunded order shows up as the loss it really is rather than a phantom win. If you want the full reasoning on why automating this pays off fast, see why tracking automation pays for itself.

Per-order profit visibility is not a vanity metric. It is the difference between guessing which part of your business is working and knowing. Get the column right — start from net, subtract real cost, account for refunds — and you will make better calls every single day.

Ready to stop hand-building it? Try Fetch Order Tracking and let the right numbers land in your sheet automatically.

Frequently asked questions

Why is per-order profit better than just tracking my monthly profit?

Monthly profit averages your winners and losers into one number that looks survivable even when individual listings are losing money. Per-order profit shows you exactly which SKUs, suppliers, and prices are working so you can cut the silent losers and push the real winners. You simply cannot make those decisions from a single monthly figure.

Where do I get the true profit figure for each order?

Start from eBay's Finances API, which reports the real net that hit your payout after fees, rather than the Order API gross price minus a guessed percentage. Then subtract the AliExpress order cost and any refund. Fetch Order Tracking pulls the Finances API net earnings and the AE cost into your sheet so the figure is already correct on every row.

How do refunds affect my per-order profit column?

A delivered-then-refunded order can turn a positive row into a loss, so a profit column that ignores refunds overstates your earnings. You need to capture the refund state alongside the sale and cost. Because Fetch Order Tracking records refund state per order, those rows show up as the loss they really are rather than a phantom win.

Related guides

• Why your gross profit column is wrong (and what to use instead)
• Why eBay's Order API gives you the wrong earnings number
• Why tracking automation pays for itself in the first week

---