Snippet: Change next order ID value - SQL - X-Cart Snippets - X-Cart Mods

If you've just opened a new store, you probably don't 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;

You can use the same method for other tables, change 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;