---
title: "Set a price for each product with a CSV file"
description: "Upload a file of variants and sale prices, or a list of variants to discount, and run it as a scheduled sale."
url: https://price-editor-help.platmart.io/en/articles/25-set-a-price-for-each-product-with-a-csv-file
collection: "Sales"
updated: 2026-11-17
language: en
---

# Set a price for each product with a CSV file

Upload a file of variants and sale prices, or a list of variants to discount, and run it as a scheduled sale.

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.

## Get a file with your current prices

1.  Open **Sales** and click **Create sale**.
    
2.  Under **How to change prices**, choose **CSV file upload**.
    
3.  In the **CSV file** card, click **Export variants**.
    
4.  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.

## What the file needs

-   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.

## Upload the file and create the sale

1.  Drop the file on the **CSV file** card, or click **Upload CSV file**.
    
2.  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**.
    
3.  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.
    
4.  Set the **Schedule** and any other options.
    
5.  Click **Preview changes** to check every new price before anything changes, then start or schedule the sale.
    

## Discount a list of variants instead

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.

## Check rows that didn't match

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.
    

## Good to know

-   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](https://price-editor-help.platmart.io/en/articles/19-create-and-schedule-a-sale.md). To check prices before they change, see [preview price changes](https://price-editor-help.platmart.io/en/articles/24-preview-price-changes.md). To end a sale early, follow [restore prices after a task or sale](https://price-editor-help.platmart.io/en/articles/3-restore-prices-after-a-task-or-sale.md).
