Product margins in the product list
How the Cost and Margin columns in the WooCommerce product list are worked out, how variable products show ranges, and when they show a dash.
The columns
Products › All Products gets two columns straight after Price:
- Cost: the unit cost in your shop currency. For a variable product, the range of its variations’ costs, with “Some variations have no cost” when one is missing.
- Margin: the margin at the current price, as a range for variable products.
How the margin is worked out
Margin = (current price excluding tax − cost) ÷ current price excluding tax × 100
- The current price is what a customer pays today, so a product on sale shows its sale-price margin.
- Tax is taken out of the price first, whether you enter prices with or without tax.
- A dash means no cost is set, the price is zero, or the product is a grouped product.
- The margin ignores payment fees, packaging and shipping. It is a quick guide; order profit uses the price actually paid.
Hide the columns
Use Screen Options at the top of the product list to hide Cost or Margin for your own user. To remove them for everyone, untick Products list › Show Cost and Margin columns in Settings.
Did this answer the question? No — open a support request