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