Bulk Increase Product Prices

Increase variant prices for many products at once by a fixed amount or percentage using CSV/Excel and DataEase.

Steps:

1. Plan the change

Decide on a percentage or a fixed amount and your rounding rule (e.g., round to 2 decimals, end with .99). 

2. Export Products with Variants

In DataEase create a New Export → Products. Include at least: product id, handle, variantId, variantSKU, variantPrice (optionally compareAtPrice, title). Apply filters (by tag, vendor, collection, status) to target only the products you want. 

3. Compute new prices in Excel/Sheets

Add a column for the new price: • +10%: newPrice = ROUND(variantPrice1.10, 2) • +2.00: newPrice = ROUND(variantPrice+2, 2) • +10% and end with .99: newPrice = ROUND(variantPrice1.10, 0) - 0.01

4. Prepare the import file

Keep only the needed columns (variantId or variantSKU, variantPrice, Variant Command). Copy your newPrice values into the variantPrice column. Set Variant Command = UPDATE for rows you want to change. If you also want to set compareAtPrice to the old price, copy the old variantPrice into compareAtPrice.

5. Import and validate

In DataEase create a New Import, upload the file, map columns (Variant ID or SKU → variant, Price → variantPrice, Command → Variant Command), and run Validation. Download the validation file and check the “Validation Status” column; fix any issues.

6. Run the import

After completion, download the result file and spot-check products in the admin/storefront.

Tips

• Prefer matching by Variant ID; use SKU only if it is unique and consistent. 
• Prices are entered in your store’s base currency. If you use Markets with fixed prices per market, adjust those separately.
• Keep two decimal places for currency values. 

Minimal CSV (example)

References

• Shopify Variants: export/import steps, commands, and fields.