How to use it
Select products
Check the products you want to update, or use filters and select all matching results.
Open Bulk Edit and choose Update Cost/Margins
Click Bulk Edit, then search for “Cost” or “Margins” or find it under Pricing & Discounts.
Choose the update mode
Select how you want to calculate costs — direct update, target margin, or markup percentage.
Configuration options
Update modes
| Mode | Description | Formula |
|---|---|---|
| Update cost prices | Set, increase, or decrease cost by a fixed amount or percentage | Direct value change |
| Set target margin | Calculate cost from selling price to achieve a specific margin | Cost = Price × (1 - Margin / 100) |
| Apply markup | Calculate cost from selling price using a markup percentage | Cost = Price / (1 + Markup / 100) |
- Fixed — Set or adjust by a specific euro amount
- Percentage — Adjust by a percentage of the current cost
- Set Value — Override with an exact cost value
Options
| Option | Description | Default |
|---|---|---|
| Only update products with existing prices | Skip products that don’t have a selling price set | On |
| Round costs | Round to the nearest €0.01 | Off |
Tips
- Use Set target margin to ensure consistent profitability — e.g., set a 40% margin and costs will be calculated from the selling price.
- Markup and margin are different: a 50% markup on a €100 cost gives a €150 price, while a 50% margin on a €150 price gives a €75 cost.
- Enable Only update products with existing prices to avoid setting costs on products that haven’t been priced yet.