Making a price for a category ?

[Tekstoglyd]

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…

[wzp]

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

[Tekstoglyd]

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 ?

[wzp]

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.

[admin]

The following video tutorial on PHPMyAdmin can be helpful when doing this kind of stuff:

http://www.tipsandtricks-hq.com/how-to-easily-import-or-export-any-of-your-wordpress-database-content-using-phpmyadmin-3415

[Author]

Posts