Bulk Price Editor

How This Tool Works

Start by exporting your products from Shopify as a CSV (Products, Export, All Products, CSV). Upload that file here. The tool reads the CSV, identifies the Variant Price and Variant Compare At Price columns, and applies your chosen pricing rule to every row that has a price value.

For percentage and fixed-amount adjustments, the tool modifies the Variant Price column directly. The “Set compare-at price” option is designed for running sales: it moves the current price to the Compare At Price column (creating the strikethrough effect) and sets the new Variant Price to the discounted amount. This makes your entire catalog appear to be on sale.

The rounding option applies after the price calculation. Choose X.99 for charm pricing (the most common choice in ecommerce), X.95 for a slightly different approach, or X.00 for clean whole-dollar prices. The preview table shows both the old and new prices so you can verify the results before downloading.

All processing happens entirely in your browser using JavaScript. Your CSV file is never uploaded to any server, which means your product data, pricing information, and business details remain completely private. The modified CSV is generated as a local Blob and downloaded directly to your computer.

Step-by-Step Guide to Bulk Price Editing

1. Export your products from Shopify. Navigate to Products in your Shopify admin, click Export, select “All products” or a specific collection, choose “CSV for Excel, Numbers, or other spreadsheet programs,” and click Export. The file will download or be emailed to you depending on the catalog size.
2. Save a backup copy. Before making any changes, duplicate the exported CSV file and store the backup in a safe location. This is your rollback insurance if anything goes wrong during the import process.
3. Upload the CSV to this tool. Click the file upload button above and select your Shopify product CSV. The tool will read the file and prepare it for processing.
4. Select your pricing action. Choose from percentage increase, percentage decrease, fixed amount addition, fixed amount subtraction, or the compare-at price option for sales. Enter the corresponding amount or discount percentage.
5. Choose a rounding option. Select X.99 for psychological pricing, X.95 for a slightly different approach, X.00 for whole dollars, or no rounding if you want exact mathematical results.
6. Preview your changes. Click “Preview Price Changes” to see a side-by-side comparison table showing the original and new prices for each variant. Review the first 30 entries to ensure the changes look correct.
7. Download the modified CSV. Once satisfied with the preview, click “Download Modified CSV” to save the updated file to your computer.
8. Import back into Shopify. Go to Products, click Import, upload the modified CSV, and check the “Overwrite existing products with matching handles” option. Click Import to apply the changes.

Real-World Pricing Scenarios

Scenario 1: Annual Supplier Cost Increase

A home goods store receives notice from their primary supplier that wholesale costs are increasing by 12%. The store owner needs to pass this increase to customers while maintaining their profit margins. Using the percentage increase action with a 12% adjustment and X.99 rounding, the entire catalog of 340 products is repriced in under a minute. Without bulk editing, this change would have taken an estimated 6-8 hours of manual work in the Shopify admin.

Scenario 2: Black Friday Site-Wide Sale

A fashion retailer wants to run a 25% off site-wide Black Friday sale with visible strikethrough pricing on every product. Using the “Set compare-at price” option with a 25% discount, the tool moves every current price to the Compare At column and sets the new price to 75% of the original. After the sale, the original CSV backup is re-imported to restore normal pricing. The entire setup takes less than 5 minutes for a catalog of 1,200 variants.

Scenario 3: Currency Adjustment for International Expansion

A US-based store expanding to a Canadian audience decides to add $3.00 to every product to account for currency conversion overhead on lower-tier items, while keeping prices psychologically appealing. Using the fixed-add action with $3.00 and X.95 rounding, all prices are adjusted consistently. This approach avoids the uneven results that percentage-based adjustments can produce on items at different price points.

Pricing Strategies Compared

Different pricing strategies serve different business goals. The table below compares the most common approaches and when each one is most effective for Shopify stores.

Why This Matters for Your Shopify Store

Price consistency across your catalog builds customer trust and simplifies operations. When you decide on a 15% price increase, every product should reflect that change uniformly. Manual editing inevitably leads to missed products, rounding errors, and inconsistencies that confuse customers and create support tickets. Studies show that pricing inconsistencies within a product category can reduce customer trust by up to 22% and increase cart abandonment rates.

Bulk pricing also enables more sophisticated promotional strategies. You can set up a store-wide sale by adding compare-at prices to every product in minutes, then reverse the changes just as quickly when the sale ends. This flexibility allows you to run time-limited promotions without the anxiety of manually reverting hundreds of prices afterward.

From a competitive standpoint, the ability to react quickly to market changes is a significant advantage. If a major competitor drops prices on Black Friday, you can respond within minutes rather than hours. If raw material costs spike, you can protect your margins the same day you learn about the increase rather than spending a week updating prices product by product.

Common Mistakes to Avoid

• Not keeping a backup of the original CSV. This is the most common and most costly mistake. Without a backup, there is no quick way to revert bulk changes. Always save the original export before processing.
• Applying percentage changes without rounding. A 15% increase on $24.99 produces $28.7385. Without rounding, your storefront displays awkward prices like $28.74, which look unprofessional and erode customer confidence.
• Forgetting to remove compare-at prices after a sale. Products permanently showing a “sale” price lose credibility. Customers become suspicious of perpetual markdowns, and in some jurisdictions like the EU and UK, displaying a compare-at price that was never the actual selling price can violate consumer protection laws.
• Using the wrong CSV format. Shopify exports two CSV types: “CSV for Excel” and “Plain CSV.” This tool works with both, but make sure you re-import using the same format Shopify expects. Using a third-party CSV editor that alters the encoding can corrupt special characters in product titles and descriptions.
• Applying changes to the wrong collection. If you only want to adjust prices for one collection, export only that collection from Shopify. Processing a full catalog export when you only intended to change one category leads to unintended changes across your store.
• Running percentage decreases that push prices below cost. A 30% decrease might sound reasonable, but if your margins are only 35%, you are now selling some products at a loss after transaction fees and shipping. Always calculate your break-even price before applying large discounts.
• Not testing with a small batch first. Before processing your entire 5,000-product catalog, export a single collection of 10-20 products, process it, import it, and verify the results on your live storefront. This catches formatting issues, rounding surprises, and import errors before they affect your whole catalog.

When to Use This Tool

Different business situations call for different pricing actions. Use the table below to identify the right approach for your specific scenario.

Tips and Best Practices

• Always keep a backup of your original CSV. Before importing the modified file, save the original export from Shopify. If anything goes wrong with the price changes, you can re-import the original to restore all prices instantly.
• Test with a small export first. Export a single collection or a few products, run them through the tool, and import the result to verify the changes look correct on your storefront before processing your entire catalog.
• Use charm pricing (X.99) for consumer products. Research consistently shows that prices ending in .99 convert better than round numbers for most consumer goods. A study published in the Journal of Consumer Research found that charm pricing increased sales by 8% on average compared to round-number pricing.
• Remove compare-at prices after sales end. If you used the “Set compare-at price” feature for a promotion, remember to clear those values after the sale. Products showing a permanent “sale” price lose credibility and may violate advertising regulations in some jurisdictions.
• Consider rounding after percentage changes. A 15% increase on $24.99 gives $28.7385. Without rounding, your products will have awkward prices. Always select a rounding option when applying percentage-based changes.
• Schedule price changes during low-traffic hours. If you are running a large catalog update, import the modified CSV during your store’s lowest traffic period (typically 2-5 AM in your primary market). This minimizes the chance of a customer seeing partially updated prices during the import process.
• Document every pricing change. Keep a log of what changes you made, when, and why. This is invaluable for analyzing the impact of pricing decisions on revenue and helps you make better pricing decisions in the future.

Related Tools

• Bulk Price Editor – Edit prices directly within a visual interface without CSV exports.
• Profit Margin Calculator – Calculate your margins before and after price adjustments to ensure profitability.
• CSV Validator – Validate your Shopify product CSV file structure before importing to catch formatting errors.