Global pricing change...Is this possible??

For general questions and discussions specific to the AbleCommerce 7.0 Asp.Net product.
Post Reply
User avatar
igavemybest
Captain (CAPT)
Captain (CAPT)
Posts: 388
Joined: Sun Apr 06, 2008 5:47 pm

Global pricing change...Is this possible??

Post by igavemybest » Sun Dec 27, 2009 12:35 pm

Is there a way to globally change pricing? I know the price of every product is stored into the database, but lets say we wanted to increase all prices by 10%, what would be the best way to go about that? The only two options we see now are either a database query to change all pricing, or a proxy handler of some kind. Any suggestions?

kastnerd
Commodore (COMO)
Commodore (COMO)
Posts: 474
Joined: Wed Oct 22, 2008 9:17 am

Re: Global pricing change...Is this possible??

Post by kastnerd » Mon Dec 28, 2009 9:08 am

I havce used ODBC to connect to the pricing table before to make changes.

User avatar
mazhar
Master Yoda
Master Yoda
Posts: 5084
Joined: Wed Jul 09, 2008 8:21 am
Contact:

Re: Global pricing change...Is this possible??

Post by mazhar » Tue Dec 29, 2009 1:54 am

If you want to update actual price of products then I think you would need the query. The only thing where this possible via configurations is the case where merchants wants some GST on their products and they want price to be tax inclusive. For example you can create a tax with amount 10% and turn on tax setting of showing product prices tax inclusive.

User avatar
jmestep
AbleCommerce Angel
Posts: 8164
Joined: Sun Feb 29, 2004 8:04 pm
Location: Dayton, OH
Contact:

Re: Global pricing change...Is this possible??

Post by jmestep » Tue Dec 29, 2009 8:07 am

Don't forget to round to two decimal places. That's what I hadn't done in some code and it ended up with orders showing as not paid.
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx

Post Reply