Price Adjustment - Round Up - Deduct 0.01
Category: X-Cart Snippets
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;