Understanding Profitability in Listing Mirror

Understanding Profitability in Listing Mirror

Listing Mirror's profitability tools answer a single question in four different places: after the marketplace takes its cut and you pay for the goods, what do you actually keep?

To do that, Listing Mirror combines four numbers:

• Price — what the item sells for (plus buyer-paid shipping, on real orders)
• Marketplace fees — the exact fees the marketplace reported, or an estimate based on your own selling history
• Product cost — what the goods cost you, which you enter
• Overhead — packaging, labor, shipping and anything else you add, which you also enter

The first two, Listing Mirror already knows. The last two you have to tell it — and that is the single biggest factor in whether these numbers are useful to you.

Before you start: enter your costs

Everything below depends on your costs being in the system. On Manage Pricing and in Sales Reports, a product with no recorded cost shows a dash or an Add cost prompt in place of the figure — those two screens will not quietly treat your cost as zero and show you a 100% margin.

Orders behave the other way round, and it's worth knowing which is which. On View Orders and on the order itself, a missing cost is treated as zero and a profit figure is still shown, with an Add cost link next to it. The fees and overhead in that figure are real; nothing has been subtracted for the goods. Treat any order carrying that link as overstated until you fill the cost in.

Where to enter costs

Go to Pricing > Cost Settings. This page has two halves.

Note: Cost Settings requires the Billing permission. If you don't see it in the Pricing menu, ask your account administrator to grant it.

1. Product Costs (left side)

A searchable, paginated list of every product variant with a Cost field next to each one. Search by SKU, type your cost, and use the save banner at the bottom of the screen to save all your changes at once.

You can also add a cost in two other places without leaving what you're doing:

• On Manage Pricing, click the Add cost link inside any Profitability cell
• On an order, click Add cost in the item's profit box

2. Overhead Costs (right side)

Click Add to create a cost line. Each one has:

• Name — for example "Packaging", "Pick & pack labor", "Shipping"
• Amount
• Type — Per Order (charged once no matter how many units) or Per Unit (multiplied by quantity)
• Default shipping — see below

Default shipping tells Listing Mirror what to assume an order costs to ship when no real shipping cost has been recorded yet. If the order has an actual shipping cost from a fulfillment, that real figure is used and labeled Actual; otherwise your default is used and labeled Default. Only one cost line can be the default shipping cost — checking the box on one clears it on the others.

Overhead does not apply to marketplace-fulfilled orders

Overhead costs are applied to merchant-fulfilled (FBM) orders only. Orders fulfilled by the marketplace already have fulfillment baked into the fees they charge you, so adding your own packing and shipping costs on top would count the same money twice. Listing Mirror therefore applies zero overhead to orders fulfilled by:

• Amazon FBA
• Amazon Multi-Channel Fulfillment (MCF)
• Walmart Fulfillment Services (WFS)
• Walmart Multichannel Solutions (WMS)
• Wayfair CastleGate

Where marketplace fees come from

Once an order settles, the marketplace tells Listing Mirror exactly what it charged, and those exact fees are used. But settlement lags the sale by days — and on the Manage Pricing screen there is no order at all yet, only a price you're considering. For those cases Listing Mirror estimates the fee, and it always tells you which of three sources the estimate came from:

A few details worth knowing:

• Listing Mirror looks back over roughly the last 180 days of fees. Older history is ignored on purpose, because marketplaces change their fee schedules.
• A rate needs at least 3 sold items behind it before it's trusted. Below that, Listing Mirror falls to the next source down. The breakdown window tells you the sample size: "Based on 47 historical orders".
• Fee rates are calculated per store, not per marketplace. If you have two Amazon stores, their rates are kept separate — their category mixes and FBA/FBM splits are usually different, and blending them would smear both.
• Rates are recalculated at most once a day, so a brand-new store may show Marketplace Default for a short while after its first sales land.
• For stores selling in a currency other than USD, fees are converted using the same exchange rate as the order they came from, so the percentages are directly comparable.

Where you'll see profitability

1. Manage Pricing — before you sell (Beta)

Pricing > Manage Pricing shows a price column for each connected store. To add profitability, click Customize View and turn on Profitability (Beta) under the Pricing group. A Profitability column appears next to each visible marketplace price column, so you can compare the same SKU across channels side by side.

Each cell shows:

• Est Fees — the estimated marketplace fee plus your per-unit overhead
• Est Net — what you'd keep, and the margin as a percentage. Green for positive, red for negative.
• Add cost — shown instead of a net figure when the product has no cost recorded
• The ? icon — opens the full breakdown, line by line, with the fee source badge

Est Net = Price − estimated fees − cost per unit − per-unit overhead

This is a pre-order estimate for one unit of one item, so it includes your per-unit overhead only. Per-order costs and shipping are excluded here — they're charged once across a whole basket, and loading a full order's worth of them onto a single item would overstate its cost.

2. View Orders — a profit column on the grid

On Orders > View Orders, open the column chooser and add Profit — it sits in the Financials group, next to Order Total and Label Cost. Each row then shows that order's profit, green when positive and red when negative. Click the figure to open the same breakdown described below.

• A ~ in front of the amount (for example ~$14.20) means at least one item on the order is still on estimated fees. It disappears once the marketplace has reported them.
• There is no separate Margin column on this grid. Margin is shown per item on the order itself, and as a metric in Sales Reports.

3. Order Details — the real number, per item

Open any order and each item shows its own profit box, labeled one of two ways:

• Profit (Actual) — the marketplace has reported its fees for this item, so this is confirmed, not estimated
• Profit (Estimated) — fees haven't come through yet. The figure uses the estimate described above and updates itself once the marketplace reports.

Profit = (item price + buyer-paid shipping) − fees − (cost × quantity) − overhead

Click the ? icon for Profit Breakdown, which itemizes everything: revenue split into item price and buyer-paid shipping, fees (with a per-fee list when they're actual), cost per unit, shipping labeled Actual or Default, and each of your overhead lines.

One thing to watch: the summary line above the profit reads Fees: but totals everything being subtracted — marketplace fees, product cost and overhead together. The breakdown window separates them.

4. Sales Reports — profit across the whole business

In Reports > Sales Reports, tick Profit ($) and Margin (%) in the Metrics row. From there they behave like Revenue, Units Sold, Orders and Average Order Value — they appear as summary tiles, as columns in the table, on the chart, and in the CSV export.

Profit and Margin require the Billing permission. Without it the two metrics aren't in the picker at all, and saved reports built on them are hidden rather than offered and then refused.

Grouping, sorting, charting and export

• Group By and Then By take one dimension each — two at most. The built-in choices are Date, Channel, Store, SKU, Product, Brand, Category, Color, Size, State and Country, plus any custom product or variant attributes you use.
• Sort by clicking the Profit or Margin column header, to rank rows by what they earned rather than what they billed.
• Chart either metric by choosing it as the primary or secondary chart metric.
• Export writes the report to CSV with whichever metrics you selected. Note the export stops at 5,000 rows and the file gives no sign that it did, so narrow a longer report — a shorter date range, or a store filter — before reconciling against it.

Two shapes Profit and Margin can't take

Profit is served from the nightly sales rollup, which carries fees and costs but no customer address and no order IDs. Two combinations leave that table, and Listing Mirror refuses them with a message rather than returning a column of zeros:

• Grouping by State or Country.
• Selecting Orders or Average Order Value alongside Profit or Margin — unless SKU is one of your two groupings, the one case where both can be answered exactly at the same time.

Every other combination works. If you want profit by geography, the nearest available cut is by Channel or by Store.

The two ready-made reports

Both appear under Quick Reports in the sidebar, and both open on the last 30 days:

• Most Profitable Products — grouped by SKU and sorted by profit, highest first. SKU is deliberate: it's the one grouping where each row is confined to a single listing, so the cost behind each figure is that product's own rather than a blend.
• Margin by Channel — grouped by channel and sorted by margin, to show which marketplaces keep the most of each sale after their fees. Channel is the better first look for most sellers, because fee coverage across an account is usually far better than cost coverage.

Open either one, then change the date range, filters or grouping and save it as your own report.

How current is the data?

Sales Reports are built from a rollup that a nightly job maintains, so a report generally reflects sales through the end of yesterday. Today's orders won't be in it, and a very recent order can take a cycle to appear. For an up-to-the-minute view of a specific sale, use the order itself.

Profit = revenue − selling fees − product cost − per-unit overhead

Because a report can span thousands of orders at different stages of settlement, fees are handled in two parts: revenue whose fees have been reported is charged what it actually cost, and revenue still waiting on settlement is charged your store's historical rate. That's what stops the last few days of a report looking implausibly profitable.

Reading the coverage warnings

Sales Reports are explicit about how much of the number rests on data you've entered:

• "Add product costs" in place of the figure — no product costs are recorded for these sales at all, so nothing has been subtracted for what the goods cost. The number would be revenue minus fees, which isn't profit, so it isn't shown.
• "N units missing cost" in amber — some costs are recorded but not all, so profit and margin are overstated by the missing ones.
• Hover the ⓘ icon next to Profit or Margin for the full caveat, including what share of the revenue had fees reported versus estimated.

What Sales Report profit excludes

This figure is contribution margin: revenue less variable costs. It does not subtract advertising spend (Listing Mirror doesn't hold your ad data), per-order overhead, or shipping — the last two can't be attributed cleanly across a report grouped by product or by date.

Two consequences to expect:

• It will not tie out exactly to the Profit column on View Orders, which does include per-order overhead and shipping.
• It will read higher than the "Margin" column in tools like Helium 10 or Sellerboard, because those subtract PPC spend first.

Common questions

Why does profit show "--" or "Add cost"?

That product has no cost recorded. Add it in Pricing > Cost Settings, or click the Add cost link right there in the cell. On Manage Pricing and in Sales Reports, Listing Mirror shows the prompt instead of a figure rather than assuming your cost is zero, which would make every item look 100% profitable. On an order, the link appears beside a figure that hasn't had any goods cost subtracted — so there, the number is the one to distrust.

Why won't Sales Reports let me add Profit to this report?

Two report shapes can't carry it: grouping by State or Country, and selecting Orders or Average Order Value without SKU as one of your groupings. Profit comes from the nightly sales rollup, which holds no addresses and no order IDs, so those figures genuinely aren't available together. Change the grouping, or drop the conflicting metric, and Profit comes back.

Why is my CSV export shorter than the report on screen?

Exports stop at 5,000 rows and the file doesn't say so. Narrow the report — a shorter date range, fewer stores, or a coarser grouping — until the row count is under the cap.

Why does my fee estimate say "Marketplace Default"?

That store doesn't have enough recent sales history for Listing Mirror to calculate your real rate — it needs at least three sold items in the last 180 days. Keep selling and the badge will move up to Your Average, and then to Product History for your established SKUs.

Why is one item "Actual" and another "Estimated" on the same order?

Marketplaces report fees per item, and they don't all arrive together. Each item flips to Actual as its fees land — usually within a few days of the sale.

Why isn't my shipping overhead showing on FBA / WFS orders?

It's excluded on purpose. Marketplace-fulfilled orders already pay for fulfillment through the fees the marketplace charges you, so charging your own packing and shipping again would double-count it.

Why doesn't Sales Report profit match the View Orders profit column?

They're deliberately different scopes. View Orders profit includes per-order overhead and shipping for that specific order. Sales Report profit is contribution margin across many orders and excludes per-order overhead, shipping and advertising.

My margin looks too good. Is it wrong?

Almost always it means costs are missing. Check the coverage note under the Profit tile in Sales Reports, and remember that no profitability figure in Listing Mirror subtracts advertising spend.

Getting the most out of it

1. Enter product costs first. Nothing else works without them, and partial coverage produces optimistic numbers rather than obviously broken ones.
2. Add your overhead honestly — packaging, labels, pick-and-pack labor, and a default shipping cost. Small per-unit costs change the picture on low-priced items more than sellers expect.
3. Check the fee source badge before you act on an estimate. Product History is worth trusting; Marketplace Default is a placeholder.
4. Compare channels on Manage Pricing before you set a price, rather than discovering the margin after the order lands.
5. Use Most Profitable Products and Margin by Channel in Sales Reports for the monthly view, and the order-level figures when you're investigating a specific sale.