Forums / Setting Up Categories, Products, Attributes / SQL for changing all products' prices?

SQL for changing all products' prices?

Locked

Results 1 to 3 of 3

This thread is locked. New replies are disabled.

18 Jun 2009, 2:45 PM

dinki

Zen Follower

Join Date:: Oct 2006
Posts:: 206
Plugin Contributions:: 0

SQL for changing all products' prices?

Hey guys. I'm wanting to run an SQL command to change the price on all items in my store. Right now, all items are priced at $3.99 and I would like to increase this to $4.99.

Can someone tell me how to form my SQL so I can do this all at once?

18 Jun 2009, 5:04 PM

fairestcape

Totally Zenned

Join Date:: Mar 2008
Location:: Cape Town & London (depends on the season)
Posts:: 2,957
Plugin Contributions:: 0

Re: SQL for changing all products' prices?

http://www.zen-cart.com/forum/showthread.php?t=110093

18 Jun 2009, 5:31 PM

dinki

Zen Follower

Join Date:: Oct 2006
Posts:: 206
Plugin Contributions:: 0

Re: SQL for changing all products' prices?

Perfect, thanks.