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;