Bulk Price Increase Calculator
Upload your product CSV file, increase all prices by percentage or set a target margin, toggle VAT handling, and download the updated file instantly. All calculations run in your browser.
| Upload CSV (SKU,Price,Cost) | |
|---|---|
| Mode | |
| Value (%) | |
| VAT Included? |
How to Increase All Prices by Percentage (Bulk)
If you want to increase all prices by percentage, the spreadsheet logic is simple:
New Price = Old Price × (1 + Increase ÷ 100)
For example, increasing £20 by 10% becomes £22. This calculator applies that formula across every row in your uploaded file.
Target Margin Formula
If you need to protect profit instead of applying a flat percentage, use margin mode:
New Price = Cost ÷ (1 − Margin ÷ 100)
This ensures every product hits your required margin, regardless of its starting price.
VAT Handling Explained
If your selling prices include VAT, enable the VAT toggle. The calculator removes VAT first, performs the increase or margin calculation on net price, then reapplies VAT. This avoids distorted margin calculations.
For UK sellers on marketplaces like Etsy Profit Calculator (UK) or Amazon FBA Fee Calculator, this distinction matters.
When to Use a Bulk Price Increase
- Supplier cost increases
- Rising marketplace fees
- Inflation adjustments
- Margin recovery campaigns
If you are unsure how price changes affect profit, read the How to Price Products for Profit guide before applying changes store-wide.
Frequently Asked Questions
How do I bulk increase prices in Excel?
You can use a formula like =A2*(1+10%) and drag down. This calculator automates that process without manual editing.
What is a good margin for ecommerce?
Many ecommerce sellers target 30-60% gross margin depending on niche and fees.
Will increasing prices reduce sales?
It can. Monitor conversion rate and profit per order, not just revenue.
Is this bulk price increase calculator secure?
Yes. Files are processed entirely in your browser.