Interspire Product Knowledge Base

Would you like to...

Print this page Print this page

Email this page Email this page

Post a comment Post a comment

Subscribe me

Add to favorites Add to favorites

Remove Highlighting Remove Highlighting

Edit this Article

Export to PDF

User Opinions (8 votes)

62% thumbs up 37% thumbs down

How would you rate this answer?



Thank you for rating this answer.

How do I change the starting value of my order numbers ?

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.

Related Articles

No related articles were found.

Attachments

No attachments were found.

Powered by Interspire Knowledge Manager - World's #1 Best Selling FAQ and Knowledge Base Software