Price Adjustment - Round Up - Deduct 0.01

Category: X-Cart Snippets
Added:
Enter Price $
SKU SKU82112221
Quantity

SQL patch to adjust price, round up to nearest, then deduct a cent or penny etc.

It's useful if you want to convert prices to an alternative currency.

Database backup recommended !

In Admin > Patch/Upgrade apply this SQL patch...

UPDATE xcart_pricing SET price = ROUND(price * 1.57192, 0) - 0.01;
The website uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy.
More Information