Page 1 of 1

Global pricing change...Is this possible??

Posted: Sun Dec 27, 2009 12:35 pm
by igavemybest
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??

Posted: Mon Dec 28, 2009 9:08 am
by kastnerd
I havce used ODBC to connect to the pricing table before to make changes.

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

Posted: Tue Dec 29, 2009 1:54 am
by mazhar
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.

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

Posted: Tue Dec 29, 2009 8:07 am
by jmestep
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.