Interspire Product Knowledge Base

Sometimes when you are a new store owner it makes the most sense to appear as if you've been around a little longer than you really have.

Sending a customer an order number of 2 can be a little scary. So if you would like to change your order numbers for your new store so that it looks like you've been in business longer than you have, here is the solution.

Assuming your database prefix is isc_, then you would run the following SQL statement (in the SQL tab) using phpMyAdmin (or any other database management program):

ALTER TABLE isc_orders AUTO_INCREMENT = 1000;

If you don't have a database prefix, then it would look like this:

ALTER TABLE orders AUTO_INCREMENT = 1000;

That statement will increase your order numbers by 1,000.