Update costs and margins

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. Search for “Cost” or “Margins” or find it under Pricing & Discounts.
Choose an update mode
Pick how to calculate costs: direct update, target margin, or markup percentage.
Update modes
| Mode | What it does | Formula |
|---|---|---|
| Update cost prices | Set, increase, or decrease cost by a fixed amount or percentage | Direct value change |
| Set target margin | Works the cost back from the selling price to hit a margin | Cost = Price × (1 - Margin / 100) |
| Apply markup | Works the cost back from the selling price using a markup | 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: overwrite with an exact cost.
Options
| Option | What it does | Default |
|---|---|---|
| Only update products with existing prices | Skips products without a selling price | On |
| Round costs | Rounds to the nearest €0.01 | Off |
Markup and margin are not the same. A 50% markup on a €100 cost gives a €150 price. A 50% margin on a €150 price gives a €75 cost.
Tips
- Use Set target margin for consistent profitability. Set a 40% margin and costs are worked back from the selling price.
- Keep Only update products with existing prices on so you don’t set costs on products that aren’t priced yet.
Related
Change Price
Adjust selling prices by a percentage or fixed amount.
Set Special Price
Apply a sale price with an optional start and end date.
Apply Volume Discounts
Add tiered pricing based on quantity.
All Bulk Edits
Browse every bulk action available in WisePIM.


