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
In the top menu, click Inventory, then Item Price Lists.
To export only some items, filter the list first, for example by vendor or category.
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.
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
In the top menu, click Import / Exports, then New Import.
Choose Update Existing.
In Select Template, choose Item Price Lists.
Click Choose File, pick your CSV, and click Import.
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.
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.


