Knowledgebase: X-cart
Mass updating product prices or qty
Posted by - NA - on 01 April 2005 10:03 AM
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]
(440 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).