Price Adjustment - Round Up - Deduct 0.01
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;
Change next order ID value
If you've just opened a new store, you may not want customers to see low order ID's.
Detect HTTPS mode in Smarty