
Use a CSV file when products in a sale need different prices, for example 1,499 to 999 and 2,299 to 1,599, or when the sale covers more products than you can pick one by one. The file lists variants by Variant ID or SKU, with their sale prices if you have them. When the sale ends, every price and compare at price returns to its value before the sale.
Open Sales and click Create sale.
Under How to change prices, choose CSV file upload.
In the CSV file card, click Export variants.
When the export finishes, click Download CSV.
The file lists every variant of your products that aren't archived, with the columns Variant ID, Variant Name, Variant SKU, Variant Price and Variant Compare At Price. Delete the rows that shouldn't be in the sale and type the sale prices in Variant Price.
An export stays available for an hour, or until a task or sale changes prices. After that, export again so the file starts from your current prices.
You can also use your own file, such as one from another price app or Shopify's product export, as long as it has the columns below.
A Variant ID or SKU column. A row with a variant ID changes that variant only. A row without one changes every variant with exactly that SKU.
To set sale prices, a Variant Price (or Price) column with a price on every row.
To set the crossed-out price, a Variant Compare At Price (or Compare at price) column. A blank cell removes the compare at price during the sale.
Up to 20,000 rows and 2 MB, saved as .csv, or as tab-separated .txt or .tsv.
Prices are in your store currency and are used as typed, without rounding. Both 1,499 and 1.499,00 work. Other columns, such as market price columns, are ignored.
If Excel shows a variant ID like 4.35503E+13, it has rounded the number and the row can't be matched. Write the ID as ID43550274814031, the way the exported file does.
Drop the file on the CSV file card, or click Upload CSV file.
Check the card. It shows how many variants the file has and whether it has prices. If some rows can't be used, a banner lists them with the row number and the reason. Fix those rows and click Replace file.
Check Price and Compare at price below the file. With a price column, Price switches to Set prices from the file. With a compare at column, Compare at price switches to Set compare at prices from the file. Without one, Set to old price (discount) shows the price before the sale as the crossed-out price.
Set the Schedule and any other options.
Click Preview changes to check every new price before anything changes, then start or schedule the sale.
If your file has only variant IDs or SKUs, the sale uses the usual price rules for every variant in the file. For example, keep Decrease under Price and enter 20 to take 20% off.
After the sale prepares, its page lists the rows of the file that aren't in the sale. Common reasons:
No variant has that exact SKU. SKUs are case-sensitive, and Excel can remove leading zeros.
The variant was deleted or recreated, which gives it a new variant ID.
The product is archived, or Exclude leaves the variant out, for example a sold-out variant or a gift card.
Another active sale already discounts the variant.
A sale from a CSV file changes product prices only, not market prices. CSV files are available for sales, not tasks.
The file can't be changed after the sale starts. To use a different file, disable the sale, wait for prices to restore, then duplicate it and upload the new file.
A large file takes longer to prepare on a store with many products.
On the Free plan, the usual product limit applies.
For the rest of the sale settings, see create and schedule a sale. To check prices before they change, see preview price changes. To end a sale early, follow restore prices after a task or sale.