- This topic has 4 replies, 3 voices, and was last updated 10 years, 6 months ago by .
Viewing 5 posts - 1 through 5 (of 5 total)
Viewing 5 posts - 1 through 5 (of 5 total)
- You must be logged in to reply to this topic.
Support site for Tips and Tricks HQ premium products
by
Tips and Tricks HQ Support Portal › Forums › WP eStore Forum › WP eStore General Questions › Making a price for a category ?
Tagged: group price, group pricing
Hi there…
My product are the same Price, and I need too control the Price only one place
so that I dont half too correct 4000 products to chance the Price
How can I do that ?
Love your support
Love eStore…
Well, one (quick and dirty) way is to go into phpMyAdmin and try…
update wp_eStore_tblset price = '99.99';
This will change the price for ALL of your products.
P.S. Don’t forget to add the correct table prefix to: wp_eStore_tbl
Hey
That was a nasty one, can you be more specific please
where in my sql admin lets say i want to raise my price with 5
how to do that ?
Sorry, I thought you wanted to change all 4,000 prices
What you’d do is add a condition to the SQL command…
update wp_eStore_tblset price = ‘99.99’ where <condition>;
You’d have to learn SQL in order to specify the <condition> under which the price is changed.
Teaching you SQL is beyond the scope of this forum, but there are several good resources available on the Internet. This one is specific to the “where” condition clause:
http://www.w3schools.com/sql/sql_where.asp
Here is the official documentation for phpMyAdmin:
http://docs.phpmyadmin.net/en/latest/
But unless you’re really confident about your ability to speak SQL, anything less than 20 products probably should be done through the Manage Products interface.
The following video tutorial on PHPMyAdmin can be helpful when doing this kind of stuff: