bulk price change on zen

[carisma]

Right what i need to know,  is there any way of changing the prices of items on zen without having to do them one at a time with the price manager,

 I have just on 3000 items on site and am sure our loverly rulers will put up VAT in the budget.  I myself am not VAT registered but i have to pay it so if it goes up my prices will have to go up to suit.

I know i will probably have to do it one at a time but it's worth asking just in case.

Thanks

Mike.

[gordym75]

Mike,

Go to catalog > quick updates and the wee box at the top called value or rate can be used to update the products that are currently on screen. You can change the amount of products on screen by altering the max lines per page on he top left of the screen but dont go to the max amount of 320. It crashes on me when I do that.

[evil_grrrl666]

Assuming you're going to increase all your prices by the same percentage you could do it with an SQL query (tools > install sql patches) but before attempting such a thing ALWAYS do a back up of the database in case it gets messed up

the code should look something like this:

UPDATE products SET products_price = products_price * 1.1;

(multiplying by 1.1 would be a price increase of 10%. if you're trying to increase the price by a different percentage, amend this number before inputting the code! and if you're not sure what you're doing, have some extra nerdy person check out the code before trying this)

[carisma]

Thanks gordy, Laura

Gordy don't hase the quick update on the site i need it on but on the other so will be grabbing setter i think,

Laura yours is a great idea but needs someone braver than me to attempt when i see all that red writing i always back off.

thank you both anyway.

[evil_grrrl666]

OK how about this - if you have easypopulate installed on your site, and microsoft excel or some other spreadsheet software on your pc you could:
(DO A FULL BACKUP OF YOUR DATABASE FIRST)

1) download the easypopulate model/price/qty file
2) open it in microsoft excel
3) copy the column "v_products_price" and insert after the original one
4) in the first row, (assuming "v_products_price" is column E) type "=E2*1.10" (without the quotes. whereby 1.10 again is a price increase of 10%, amend if necessary)
5) copy that code, select all the fields in your new column and paste
6) save the file (as .txt, don't change to excel), close it and open it again (that converts the formula you just inserted into actual figures which zencart will understand)
7) delete the original "v_products_price" column, keeping only the one with the new increased prices
upload file in easypopulate (if need be get easypopulate to split the file up, 3000 products will probably cause it to time out before it's done updating all of them)

[carisma]

Thanks Laura

 I have had the quick update added and tried it it's great and easy i can cope with doing a couple of hundred at a time much better than one at a time.

Afraid my brain can't take in all the techy stuff but i really appreciate you help.

Mike.