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?
Results 1 to 3 of 3
Hybrid View
-
18 Jun 2009, 03:45 PM #1
Zen Follower
- Join Date
- Oct 2006
- Posts
- 225
- Plugin Contributions
- 0
SQL for changing all products' prices?
Visit my Decal website: DecalDepot.net
-
18 Jun 2009, 06:04 PM #2
Totally Zenned
- Join Date
- Mar 2008
- Location
- Cape Town & London (depends on the season)
- Posts
- 2,975
- Plugin Contributions
- 0
Re: SQL for changing all products' prices?
-
18 Jun 2009, 06:31 PM #3
Zen Follower
- Join Date
- Oct 2006
- Posts
- 225
- Plugin Contributions
- 0
Similar Threads
-
Changing shipping settings of all products using SQL
By bigstore in forum Customization from the AdminReplies: 2Last Post: 6 Feb 2012, 05:53 PM -
How to add discounted prices for an attributes on all products?
By haniffali in forum Discounts/Coupons, Gift Certificates, Newsletters, AdsReplies: 0Last Post: 19 Dec 2011, 11:10 PM -
problems with changing prices for group of products
By grudziu in forum Currencies & Sales Taxes, VAT, GST, etc.Replies: 2Last Post: 9 Mar 2009, 02:30 PM -
SQl Command to update all prices in bulk
By ksmglobal in forum Setting Up Categories, Products, AttributesReplies: 2Last Post: 3 Apr 2008, 03:34 PM -
SQL for Listing all Products with Stock Numbers
By crabacle in forum General QuestionsReplies: 2Last Post: 19 Jul 2007, 04:16 PM
