changing price of multiple products simultaneously

hi.

i have hundreds of items for sale, all at the same price.

how can i change the price of every product i have at once from $9 to $9.50?

thanks, matt.

Backup your database before attempting this ...

Providing your products_price is presently set at 9.00 and you want to change this to 9.50 you can enter this in the Tools ... Insert SQL Patches ...

UPDATE products SET products_price=9.50 where products_price=9.00;

Again, backup before attempting this change ...

hi.

thanks for that.

BUT... i need to change the price details of all stock using the admin site options, NOT html.

i forgot to add this before.

thanks, matt.

Could you explain a bit better what it is you are trying to do ... I am a tad slow at times ...

ok, thanks.

i have hundreds of different items in a variety of categories.

each item is different, but the prices are all the same = $9.

i want to change the price of every item to $9.50 in one overall change - i don't want to go through and change the price of each item individually.

i want to do this via the options in the admin section, not using html.

matt.

The command I gave you addresses the products table itself and effects all Products where the products_price is currently set to 9.00 and will change them all at one time to 9.50 ...

NOTE: you should then run the Tools ... Store Manager ...

Update ALL Products Price Sorter
to be able to sort by displayed prices: Update

sorry, i don't know what that means.

i am new to this (started using it this week) - can u give me the detailed way to get to the option in the admin page.

i can't do any html commands as i don't know html.

thanks, matt.

In your Zen Cart Admin ...

You have a menubar ... one of the titles reads: Tools

Under Tools there is a menu choice for: Insert SQL Patches

This is a section of code made to allow you to issue a command that changes the data in the database ...

You need to change all of the products_price settings in the products table of your database ...

To do this, you want to make a backup of your database ...

This can be done via phpMyAdmin that should be located in your web site control panel ...

Or, by getting the Backup MySQL add-on in the Downloads located at the top of your screen ...

The command that I gave you to paste into the Insert SQL Patch page:

UPDATE products SET products_price=9.50 where products_price=9.00;  

Is designed to change all Products that currently have the products_price of 9.00 to the products_price of 9.50 all in one command ...

Then in the Tools ... Store Manager ... is an option to globally update the products_price_sorter ... so that the pricing works and sorts as if you had manually made all of these changes ... this is accomplished running the second setting that I gave you:

Update ALL Products Price Sorter
to be able to sort by displayed prices: Update

I don't know what HTML has to do with any of this, but I think that is just a confusion on terms ...

You have a database and that database contains the tables with the records of information about each product ...

You want to update all of those records related to existing products with 9.00 prices in one fell swoop vs one by one ...

That is what these two command run through your Zen Cart Admin are meant to do ...