With the Pro App, you can now perform bulk updates of prices using a CSV (Comma Separated Values) file. This process is useful when you have a list of products you want to update and can be done using either an SKU, or product handle, or variant ID.
How does it work?
1. Go to Pro Dashboard -> Create a task -> Select All Products in a CSV.
2. Upload a CSV file with either of the below data. The first row of the CSV should have one of the following headers and it is mandatory:
- handle
- SKU
- variant ID
3. Map the columns and click submit.
4. Once done, click Next. The app will read the products according to the CSV file and show the count. If a certain SKU, handle, or variant ID is not found in your store, it will be skipped.
5. Configure the pricing rule as per your requirement.
Note:
1. Don't use special characters, symbols, or spaces, because these can cause problems when searching for products in Shopify by SKU and other computer programs, such as spreadsheet software. You can find the guidelines here.
Here is a sample CSV:
