Change next order ID value

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;