Import prices from CSV

When prices come from a spreadsheet, import them instead of editing products one by one. Each imported row becomes a fixed-price override on the product with that SKU.

Before you start

• You need the Price Lists: Update permission to see Import.
• Prepare a .csv file with the columns SKU and Override Price. Download template in the dialog gives you a starter file. See the reference for the exact rules and limits.

Steps

1. Open the price list from Price Lists. The Products tab shows first.
2. Click Import. The Import Prices dialog opens.
3. Read How each row is handled if you are unsure what will be accepted.
4. Drag your file onto Drop a .csv here, or browse, or click browse and choose it. The file is checked as soon as it is selected and the dialog switches to the review.
5. Review the result. The file card shows the file name and row count, with Replace if you picked the wrong file. The counts tell you how many rows will import, were rejected and were skipped. Rejected rows are listed under Not imported with their Row, SKU and Reason; click a column header to sort them, or click Download report to save them as rejected-rows.csv.
6. Click Import 2 prices (the button counts the rows that will be written; it is disabled when there are none). The toast Imported 2 rows, 2 skipped appears and the dialog closes.
7. Check the table: each imported product shows its new FINAL PRICE, MARGIN % and LAST UPDATED.

Import prices from CSV1 / 8

1

1Open the price list. The Products tab shows first.

2

2Click Import.

3

3Each row is imported, rejected or skipped according to these rules.

4

4Drop your .csv on the dialog, or click browse and choose it.

5

5Check how many rows will import, were rejected or were skipped.

6

6Click the Import button. A toast confirms how many rows were imported.

7

7Each imported product shows its new final price and when it was updated.

8The imported products now carry their new final prices.

PreviousNextShow all steps

Watch this as a video (import prices from csv)

What happens next

The toast reads Imported 2 rows (with your count), with , 2 skipped added when some rows were rejected or skipped. Products that are not in the file are untouched, and there is no large-change confirmation on import. The dialog cannot be closed while the file is being checked or imported.

Caution

An import replaces whatever override a product already has, as the dialog’s footer says: Replaces any existing override, including margin and percent change. Export first if you want a record of the current prices.

Related

• Price Lists overview
• Filter the price table and export prices
• Price Lists reference