devshb
Senior Member
United Kingdom
1904 Posts |
Posted - February 13 2013 : 05:28:04
|
If it's a straight-forward case of changing all the product prices, then that can be done by executing a command in sql, eg:
update products set cprice=cprice*1.1 where cprice is not null
(to increase all prices by 10%)
and/or:
update products set retailprice=retailprice*1.1 where retailprice is not null
you might also find this very useful: Bulk Product Updater for VPASP - BYZ089: http://www.bigyellowkey.com/bulk-product-updater-for-vpasp-from-bigyellowzone-byz089.asp
as it lets you do things like increase/decrease prices by percentages or amounts for certain categories or other searches etc, and it also lets you see what the proposed changes will be and which products they'll hit via a test run.
One thing you need to be careful about is that if you increase your prices by 10%, and then want to reduce them again later, then decreasing them by 10% will NOT give you the correct result as that 10% will be 10% of the new price, not the original price. For this reason it's often useful to set your "base" product price up in, say, price2 so that you can always draw from that base price for your calculations.
eg: update products set price2=cprice update products set price3=retailprice
so that you've got an easy-to-reference/use backup of the prices prior to change.
Simon Barnaby Developer [email protected] www.BigYellowZone.com www.BigYellowKey.com Follow us on Twitter: http://twitter.com/bigyellowzone Web Design, Online Marketing and VPASP addons |
|
|