Update cost prices across multiple products using direct values, target margins, or markup percentages. Useful for recalculating costs after supplier price changes or setting margin targets.Documentation Index
Fetch the complete documentation index at: https://docs.wisepim.com/llms.txt
Use this file to discover all available pages before exploring further.
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.