Merchgain – Profit & Margin Reports for WooCommerce

WooCommerce tells you what you sold. It does not tell you what you earned.

Since WooCommerce 10.3 the cost of goods sold lives in the core product editor, and every order
records the cost at the moment of sale. Merchgain reads that field and answers the question the
sales report cannot: how much of this revenue is actually yours. It is a WooCommerce profit report
built on data your store already has – no import, no second place to keep costs.

It only reads. No product, no price, no order, no cost value is ever written back to your store.

What you get

• Summary cards – revenue, cost of goods, gross profit and margin for the period you pick.
• Profit per product – sortable, searchable, paginated.
• Profit per category – the same sales grouped by product category. A product that sits
  in several categories counts in each of them, so category totals can add up to more than
  the summary – the screen and the CSV file both say so.
• Missing cost warning – how many products have no cost recorded, with links straight to
  the products, and how much of your revenue that leaves uncovered.
• CSV export – the current view, exactly as you see it on screen. Very large reports are
  capped at 20,000 rows and the file says so on its last line, so a short file is never a
  silent one – and a category export that adds up to more than the summary says why.
• Foreign currency warning – orders in a currency other than your store currency are named
  and left out, instead of being quietly added into one wrong total.

What makes it different

• CSV export in the free version. Not behind an upgrade.
• The missing cost warning is a feature, not an upsell. You see coverage next to every
  number, so you always know how much of the report rests on real data.
• Works without WooCommerce Analytics. Merchgain runs its own queries against the order
  tables, so it does not require the Analytics module to be enabled.
• Nothing leaves your server. No account, no external service, no telemetry, no calls home.
  The report is calculated on your hosting and stays there.

How the numbers are calculated

This is a cost of goods sold report, so every number below rests on the cost recorded at the
moment of sale – not on a current price list.

Revenue is the net line total of sold items after discounts, excluding tax and shipping. Refunds
count as negative amounts in the period they were issued, not in the period of the original sale.
Orders counted by default: completed, processing and refunded.

Margin is profit divided by revenue – not markup on cost. A product bought for 60 and sold for
100 has a 40% margin here. That single distinction is what separates a profit margin report from
a sales report.

Profit and margin are calculated only on items whose cost is known. An item with no cost recorded
still counts towards revenue, but it is never treated as if it had cost zero – the report says so
instead of quietly inflating your margin.

Documentation and answers: https://merchgain.com/

From the makers of Merchlint.