Price Adjustment - Round Up - Deduct 0.01

Price Adjustment - Round Up - Deduct 0.01

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

Share

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;
: *
: *
: *
Type the characters you see in the picture:
Captcha

*
Change next order ID value

Change next order ID value

If you've just opened a new store, you may not want customers to see low order ID's.

Protect company emails from spambots

Protect company emails from spambots

This will encode your company email addresses...

Detect HTTPS mode in Smarty

Detect HTTPS mode in Smarty

If you get a security alert when in secure mode, it's usually due to offsite elements such as SSL certificate seals, images and javascript that are not secure, in which case you can fix with this code...

More...