SELECT meta_key, meta_value FROM wp_postmeta WHERE meta_key = "_wpsc_price" SET meta_value = meta_value * 2.0 ORDER BY meta_value
this is all i got so far but still not working, i am just about over it all and this is the last major thing left before i can open up again.
I have taken the CSV file and updated my site with products and everything is sitting there quite nice, but the prices are sitting at wholesale and so i need to update 5000 products with a x2 multiplier so i can make money off my sales otherwise there is no point in doing this.
Currant version 188.8.131.52 WP e-Commerce
any help would be much appreciated with a SQL update code for the plugin.
- The topic ‘[Plugin: WP e-Commerce] Unable to mass update prices’ is closed to new replies.