Mass updating product prices or qty

Here is how you can do price (and inventory qty) update:

- Export all products using Export Products menu
- Open file in Excel and change prices in PRICE column
- Remove all extra columns from this file and leave only 2:

PRODUCTCODE, PRICE

* in case of inventory qty update, change and keep AVAIL column, so you have file with 2 columns:

PRODUCTCODE, AVAIL

- Save this file in CSV format

In Stores control panel
- make backup of your database in DB Backup/Restore
- Go to Update inventory
- Select Update "PRICE" or "QTY"
- Browse for your file
- Click [Update]