How to See Profit Margins in WooCommerce
WooCommerce will tell you how much revenue came in yesterday. It will not tell you how much of that revenue was actually profit. The built-in reports cover orders, products, categories, and customers, but none of them subtract the cost of goods from the sale price to show a margin. For a store owner who needs to understand which products make money and which ones just move volume, that gap is the difference between running a business and guessing at one.
The problem isn't that WooCommerce can't store cost data. Since version 10.3, every product has a "Cost of goods" field where you can enter what you paid for each item. The problem is that nothing in WooCommerce actually uses that data to calculate margins. The field exists, but the reports ignore it. Revenue goes up, costs stay invisible, and profit remains a number you figure out at the end of the quarter when the accountant calls.
There are three real ways to close this gap, and they differ significantly in how much of your time they consume and what you get back. This guide walks through each one honestly, including what each approach can and cannot do.
Option 1: Enter cost of goods manually and calculate margins yourself
How it works
WooCommerce has supported a "Cost of goods" field on every product since version 10.3. You open each product in the WordPress admin, scroll to the product data panel, and enter what you paid for that item. Once costs are saved, WooCommerce stores them at the order level when a sale happens, capturing the actual cost at the time of purchase rather than the current cost.
The catch is that WooCommerce doesn't do anything with this data in its reports. You have the raw numbers stored in the database, but there's no built-in margin report, no profit dashboard, and no way to see gross margin by product or category without exporting the data and doing the math yourself.
What you get
Accurate cost data captured at the point of sale, stored in your WooCommerce database. This is genuinely useful as a data foundation. If you sell physical goods with stable supplier costs, entering COGS once per product takes a few minutes and gives you the raw material for margin calculations.
What you don't get
Any kind of margin visibility inside WooCommerce itself. You'll need to export order data, match it with costs, and build your own calculations in a spreadsheet or another tool. Every time you want to check margins, you repeat that process.
Best for: store owners who want to start capturing cost data now, even if they don't have a reporting solution yet. Entering costs takes minutes, and the data is there whenever you're ready to use it.
Option 2: Export to a spreadsheet and build margin reports manually
How it works
WooCommerce lets you export order data as a CSV file. You download the export, open it in Google Sheets or Excel, and build formulas that subtract cost of goods from the sale price for each line item. With some pivot table work, you can calculate gross margin by product, by category, and over any time period you have data for.
This approach gives you complete control over the analysis. You can build exactly the reports you want, add custom calculations, and format everything to match how you think about your business. The trade-off is that every report is a manual process.
What you get
Full flexibility. You can calculate margin per product, per order, per category, per time period, or any combination. You can layer in additional costs like shipping, packaging, or discounts. If you're comfortable with spreadsheets, the ceiling on what you can analyze is high.
What you don't get
Anything automatic. Every time you want updated numbers, you export again, paste into the spreadsheet, and refresh your formulas. For a store doing a few dozen orders a week, this might take 30 minutes. For a store doing hundreds, it becomes a recurring time commitment that competes with everything else on your list. There's also no trending or visualization unless you build charts yourself, and no alerting if margins shift in a direction you'd want to know about.
Best for: store owners who are comfortable with spreadsheets, want full control over their analysis, and don't mind spending time each week on the export and calculation process.
Option 3: Use a dedicated analytics tool that calculates margins automatically
How it works
Several WooCommerce analytics tools exist that connect to your store and build dashboards from your data. Most of them focus on revenue, customers, and product performance. Very few of them actually pull cost of goods and calculate margins. Flumen Data Analytics is the only one in the current market that captures cost of goods at the time of each sale and shows true gross margins by product, by category, and over time, without requiring you to build anything yourself.
How Flumen handles it
You sign up, connect your WooCommerce store through a secure one-click link, and Flumen syncs your data including cost of goods for every product. A complete dashboard is built and reviewed by a live person before delivery, typically within 3 business days. The dashboard lives at a single dedicated URL, no plugin to install, no WordPress admin to navigate, no spreadsheet to maintain. You open one page and see revenue, costs, and margins side by side.
Cost of goods is captured at the time of each sale, not as a static average. That means if your supplier raises prices mid-month, the margins for orders before and after the change reflect what you actually paid. Dashboards show gross margin by product, by category, and as a trend over time, so you can see whether margins are improving, declining, or holding steady.
What you get
Automatic margin calculations updated nightly, presented in a reviewed dashboard alongside revenue, product performance, customer analytics, and inventory data. No manual work after the initial connection. The dashboard is designed to answer the questions store owners actually check daily: what sold, what was profitable, and how the business is trending.
What you don't get
Custom report builders or the ability to add your own formulas. Flumen delivers a carefully designed set of visualizations, not a blank canvas. If you need to layer in ad spend, shipping costs, or custom metrics beyond what the dashboard covers, you'll still need a spreadsheet for those specific calculations. There's also no customer segmentation or email automation. Flumen is focused on analytics, not marketing.
Best for: store owners who want margin visibility without the ongoing time investment of manual exports and spreadsheet work, and who value having their dashboards reviewed by a person before delivery.
See what a margin-aware dashboard looks like
This is a live Flumen dashboard built from real WooCommerce store data. Revenue, costs, and margins are calculated automatically from synced order data, with cost of goods captured at the time of each sale.
The bottom line
WooCommerce stores cost of goods data but doesn't use it in any report. That means every store owner who wants to see margins has to close the gap themselves, and the question is how much time and effort that should take.
If you just want to start capturing cost data, enter it in WooCommerce's built-in COGS field. It takes a few minutes per product and the data will be there when you need it.
If you want full control and don't mind the weekly time investment, export to a spreadsheet and build your own margin reports. The analysis can be as detailed as your spreadsheet skills allow.
If you want margins calculated automatically and presented in a reviewed dashboard without any ongoing manual work, Flumen handles that for $49 a month with a 10-day free trial.
The right choice depends on how much time you want to spend on reporting versus reading reports. All three options start with the same underlying data, they just differ in how much of the work is done for you.
If you're currently using Metorik and finding it's more than you need, see our comparison.
Start seeing your store's real margins
Signup Temporarily Unavailable$49/month after trial. Cancel anytime.