Global pricing change...Is this possible??
- igavemybest
- Captain (CAPT)
- Posts: 388
- Joined: Sun Apr 06, 2008 5:47 pm
Global pricing change...Is this possible??
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?
Re: Global pricing change...Is this possible??
I havce used ODBC to connect to the pricing table before to make changes.
Re: Global pricing change...Is this possible??
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.
- jmestep
- AbleCommerce Angel
- Posts: 8164
- Joined: Sun Feb 29, 2004 8:04 pm
- Location: Dayton, OH
- Contact:
Re: Global pricing change...Is this possible??
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
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