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.

Share

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

Let's say you want the next order ID to be 5000, apply this SQL patch...

ALTER TABLE xcart_orders AUTO_INCREMENT = 5000;

Note, in later v4.6.x versions, you can do this from tools > maintenance.

You can use the same method for other tables, changing x to whatever value you want...

ALTER TABLE xcart_categories AUTO_INCREMENT = x;
ALTER TABLE xcart_products AUTO_INCREMENT = x;
ALTER TABLE xcart_manufacturers AUTO_INCREMENT = x;
ALTER TABLE xcart_extra_fields AUTO_INCREMENT = x;
ALTER TABLE xcart_pages AUTO_INCREMENT = x;
: *
: *
: *
Type the characters you see in the picture:
Captcha

*
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...

Detect HTTPS mode in PHP

Detect HTTPS mode in PHP

Detect HTTPS mode in PHP

More...