Skip to main content

Update prices in bulk from a file

Change hundreds of prices at once by exporting your price lists, editing them in Excel and importing the file.

Your vendor's annual increase just arrived, or you're repricing a whole category. Instead of typing each price, export your price lists to a spreadsheet, change the numbers, and import the file back.

​

Before you start

  • Use the export as your template. It already has the exact columns the import expects.

  • Prices are plain numbers, such as 6.40. No currency symbols or commas.

​

1. Export your prices

  1. In the top menu, click Inventory, then Item Price Lists.

  2. To export only some items, filter the list first, for example by vendor or category.

  3. Click Export, choose All results (or Current page), and click Export.

​

You'll get a CSV file with one row per item and unit, and one column per price list.

​

Exporting from Item Price Lists

​

2. Edit the file

Open it in Excel or Google Sheets and change the prices you need.

  • Change only the price cells. Keep every column, including the product name, SKU and UOM columns. That's how each row finds its item and unit.

  • Prices you don't change are imported unchanged.

  • Save it as CSV.

​

3. Import it

  1. In the top menu, click Import / Exports, then New Import.

  2. Choose Update Existing.

  3. In Select Template, choose Item Price Lists.

  4. Click Choose File, pick your CSV, and click Import.

​

Importing a price file

​

How to know it worked

The form clears once the file is processed. Open Inventory → Item Price Lists and check a few of the prices you changed.

​

If any rows couldn't be imported, a Failed Records table appears under the form, with the reason for each, such as an SKU that doesn't exist. Fix those rows and import just them again. Click Export Failed Records to get them as a file.

​

The Failed Records table after an import

​

Looking to create price lists, not prices?

The Import button on Settings → Price lists is a different import: it creates new price lists, not prices for items. To add a single price list, see Creating a New Price List.

​

Related articles

Did this answer your question?