How To Bulk Edit Price On Shopify Without Needing An App
If you’re a website manager and are wondering whether it’s possible to bulk edit price on Shopify, we’re happy to inform you that it absolutely is and we’re here to explain how you can do it quickly and easily.
Below you will find a step-by-step guide on how to bulk edit price on Shopify using CSV files. Being able to bulk-edit prices will undoubtedly save you a great deal of time, especially during those times when you wish to apply promotional prices to a collection of products in a sale period. Simply follow the stages below and see for yourselves just how simple it is!
- Log into the admin dashboard of your Shopify site
- In the left menu, select ‘Products’
- Search and select the products you wish to edit by typing in the search box, and selecting them by ticking the adjacent check box
- Once you have selected all of the products that you wish to amend, click ‘Export’
- In the window that appears, ensure that you check the option that says ‘Selected: # products’ (# = the number of products that you have selected). Ensure that the option is check which says ‘CSV for Excel, Number, or other spreadsheet programs’. Then click ‘Export Products.
A .csv file should then be automatically generated and downloaded into your standard destination folder. Open this document and check that it lists all of the products that you expected it to. Then SAVE the .csv document – ensuring that you name it as something which allows you to easily identify it as listing your products in their original state, prior to the changes which you are about to make. This is the document that you will use to reinstate them as their current versions.
- Then, create another save of the document – naming it as something which allows you to easily identify it as the ‘sale’, or ‘promo’ version, or anything which conveys the actions which you are taking. Once you have created this save, you are then safe to continue with the next points of action.
- Once saved, scroll RIGHT until you see the columns named ‘Variant Price’ and ‘Variant Compare At Price
- These 2 columns denote the actual sale price to the customer (Variant Price) and any figure which the item’s actual sale price can be compared to (Variant Compare At Price) – previous sale price, RRP, etc.
To make changes to these, simply overwrite figures in each column – it may be that you move all of the current ‘Variant Price’ values to the ‘Variant Compare At Price’ column, then add new sale prices to the ‘Variant Price’ column. Whatever fits the actions that you wish to take on your site, be sure to place the value which you intend to sell your items in the ‘Variant Price’ column. Note: there doesn’t need to be a value in the ‘Variant Compare At Price’ column. Once you have completed your amendments, click save (Ensuring again that you are saving to the version you are using as your promo/sale etc. version, NOT the original version.)
- Return to your Shopify dashboard and now click ‘Import’
- In the appearing window, simply click in the box which says ‘Add File’, and select your amended .csv file. Then ensure that the box which says ‘Overwrite any current products that have the same handle. Existing values will be used for any missing columns’ is checked. This ensures that all of the price amendments which you made in the .csv are applied to the products within it. Once the file is added, click ‘Upload and continue’.
- After a few moments, your products will all be updated. Go to the front end of your website to ensure that everything displays correctly.
- Once your promotion has ended, or if you wish to return your products to their original state, repeat points 11-13 – only this time, add the original .csv file which you downloaded prior to making the amendments.
And that’s just about it! A task which could potentially render you laptop-bound for hours, or even days, could now be completed in record time. Not only that, you have a firm back up already in place ready for the occasional slip up and when the promotional period ends.
We really hope that you found this useful – if you have any further queries on finding other ways to streamline your eCommerce business, get in touch and we’d be more than happy to help.