VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

VP-ASP Shopping Cart Customer Forum

Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 VPCart Forum
 General help me questions
 Global price change by percentage
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

bwalz
VP-ASP New User

USA
82 Posts

Posted - February 12 2013 :  17:33:17  Show Profile  Visit bwalz's Homepage  Reply with Quote
Is it possible to change prices on all products globally by percent? the prices will need to change occasionally across the board.

Also, if running two sites on one database can the prices be different using the same products from the same database on the different sites? This would need to be done by percentage as well.

devshb
Senior Member

United Kingdom
1898 Posts

Posted - February 13 2013 :  05:28:04  Show Profile  Visit devshb's Homepage  Reply with Quote
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
Go to Top of Page

bwalz
VP-ASP New User

USA
82 Posts

Posted - February 14 2013 :  07:02:35  Show Profile  Visit bwalz's Homepage  Reply with Quote
Thank you Simon for your response.

The addon you have definitely will work for me in one case but I also need to run two sites off one database using the same products but different pricing. Can this addon help to do that?
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000