one small question

[tomliuwhite]

I've created a few new products in the catalog. Each item has a price of $10,000. This is not the real price. Is there another way of changing all the prices in the database? For example, if I want all the prices to change to $5,000, then I can make the change in seconds rather than go through the long, aggravating process of changing each one through the OSC Admin

[Jack_mcs]

Go into phpmyadmin and issue this command

update products set products_price=5000

 

Jack

[tomliuwhite]

Go into phpmyadmin and issue this command

update products set products_price=5000

 

Jack

Thanks, if i just want to change products whose price is 1000 to 5000, what should i do?

[sheldonlg]

Thanks, if i just want to change products whose price is 1000 to 5000, what should i do?

 

Add a WHERE clause. It would be something like

 

WHERE (products_price<=5000 AND products_price>=1000).

 

Shelly

[tomliuwhite]

Add a WHERE clause. It would be something like

 

WHERE (products_price<=5000 AND products_price>=1000).

 

Shelly

Thanks! But after i run "update products set products_price=5000" in phpmyadmin-> SQL, i got the below error:

Warning: Cannot modify header information - headers already sent by (output started at /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/header_meta_style.inc.php:27) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/common.lib.php on line 1154

 

what problem could it be?