How to track product costs and profits in WooCommerce
WooCommerce can store cost of goods for products, variations, and orders, but its built-in COGS feature does not currently feed those figures into WooCommerce Analytics. For a small catalogue, use COGS and a spreadsheet; for margin reports and bulk editing, use a dedicated plugin.
- 01Choose your cost basis
- 02Enable built-in COGS
- 03Enter product and variation costs
- 04Check how orders record cost
- 05Calculate profit manually
- 06Use a plugin for faster reports
What you need
- A WooCommerce store with access to the WordPress admin area
- Your product or supplier costs
- A spreadsheet if you are using the manual reporting route
Choose your cost basis
Decide what the product cost means before entering figures. Use the direct cost of making or buying the item, and keep tax and customer shipping charges separate unless your accounting method deliberately treats them as part of the cost.
For products with changing supplier prices, decide whether you will update the catalogue cost regularly or keep the cost recorded on each order at the time it was placed. Mixing methods makes older profit figures difficult to explain.
Enable built-in COGS
In the WordPress admin area, go to WooCommerce > Settings > Advanced > Features, enable Cost of Goods Sold, and save the changes. WooCommerce then adds cost fields to the product editor and shows cost totals in order details.
This is the manual route and is suitable for a small catalogue. The important limitation is that the built-in COGS feature does not currently integrate with WooCommerce Analytics, so it stores the data but does not give you a complete profit dashboard.
Enter product and variation costs
Edit each simple product and enter its cost in the Cost of Goods field. For a variable product, enter a default cost and override it on individual variations where sizes, materials, suppliers, or fulfilment costs differ.
For a large catalogue, use the product list bulk editor or the standard product CSV import and export tools where available. Check the imported values before relying on the reports; a blank or zero cost will make an item appear more profitable than it is.
Check how orders record cost
WooCommerce records the product cost with the order item, and the order editor calculates the line cost from the unit cost multiplied by the quantity. Changing a product cost later does not rewrite the cost already recorded on existing orders.
That behaviour prevents a supplier price change from rewriting your historical margin. Be careful with any tool that offers to apply current costs to old orders: overriding historical costs can change previously reported profit.
Calculate profit manually
Use WooCommerce Analytics for sales, returns, coupons, taxes, and shipping, then export the relevant sales data and match it against your COGS figures in a spreadsheet. A simple gross-profit calculation is net product sales minus cost of goods sold.
Keep shipping, payment fees, advertising, refunds, payroll, and other overheads in separate columns if you want net profit rather than product gross profit. WooCommerce Analytics uses specific definitions for gross sales, net sales, returns, taxes, and shipping, so do not compare unlike totals.
Use a plugin for faster reports
If you need product and variation costs, margin reports, and bulk cost editing without maintaining a spreadsheet, use PixelYourSite WooCommerce Cost of Goods. Install its ZIP from Plugins > Add New > Upload Plugin, activate it, enter costs, and review the available profit reports.
The manual route is fine for a small, stable catalogue. The plugin route is faster when you have many variations, regularly change costs, or need profit analysis beyond WooCommerce's stored cost totals.
Let PixelYourSite WooCommerce Cost of Goods do it
Tracks COGS by product and variation with margin reports and bulk cost editing, for profit analysis beyond inventory counts.
Sources
- woocommerce.com /document/woocommerce-cost-of-goods-sold-cogs/
- woocommerce.com /document/cost-of-goods-sold/
- woocommerce.com /document/woocommerce-analytics/
Questions
- Does WooCommerce track product costs without a plugin?
- Yes, current WooCommerce includes a Cost of Goods Sold feature that stores costs for simple products, variations, and order items. However, the built-in feature does not currently integrate with WooCommerce Analytics, so it does not provide a complete profit report by itself. For a small catalogue, combine it with a spreadsheet; for automated margin reports, use a COGS plugin.
- What should I include in a WooCommerce product cost?
- Use the direct cost of producing or buying the product. Do not include tax or customer shipping charges in the product cost unless your accounting method specifically requires that treatment. Track shipping, payment fees, advertising, and overhead separately when you want to calculate net profit rather than gross product profit.
- Can each WooCommerce variation have a different cost?
- Yes, variable products can have a default cost inherited by their variations, and you can override that value for individual variations. Use separate costs when a variation has a different supplier price, material cost, packaging cost, or fulfilment expense. Leaving a variation at zero can make its margin look falsely high.
- Will changing a product cost change past WooCommerce profits?
- No, changing the product cost normally affects new orders while existing orders retain the cost recorded when they were created. This protects historical reporting when supplier prices change. Take care with any bulk action that applies current costs to previous orders, because overriding historical costs can change earlier profit figures.
- What is the fastest way to track WooCommerce profit?
- The fastest route is a dedicated cost-of-goods plugin that supports product and variation costs, bulk editing, and profit reports. PixelYourSite WooCommerce Cost of Goods fits this use case when you want margin analysis without exporting sales and matching costs manually in a spreadsheet.