How To Change All Prices On Your Shopify Website

Unfortunately, there are no settings in the back end that allow you apply discounts too all products in your store at once.

Without having to change the prices manually on every product through shopify (that would take so long especially if you have a large catalog) or purchasing apps to allow the change easily. 

We've found a FREE solution - 

  1. Log in as your store admin
  2. Click Products
  3. Click Export
  4. Select All products
  5. Export as: CSV for Excel, Numbers, or other spreadsheet programs
  6. Click Export Products
  7. Your browser will then download a products_export.csv file
  8. Open the .csv file
  9. Cut and paste all your current prices to Compare at Price field (or leave as they are)
  10. Change all your prices in the Variant Price to your new price
    1. If you're using Microsoft Excel, enter your new price in the field and move your cursor to the lower-right corner so that it turns into a plus sign (+) and drag the fill handle down and when you let go, the formula gets automatically filled to the other cells
  11. Save the .csv file once complete
  12. Go back to your Shopify store and click Import
  13. Choose the .csv you've just edited
  14. Tick Replace any current products that have the same handle. Existing values will be used for any missing columns
  15. Click Upload File
  16. You will see the updated changes.
  17. Click Start import
  18. All products will now be imported with new prices


If you don't have a Shopify store click here to start and take advantage of their 14 day trial.

Feel free to Contact us here if you need any assistance

ecommerce shopify webdesign website

Newer Post →

Leave a comment