Change order number increment or default order number?

[winedog]

Hi,

 

So it looks like OSC starts at order number 1 and then just increments numerically after each order is created.

 

Where can I change the starting order number or the way in which orders increment?

 

Is there a way to force it to a larger number so that it's not immediately obvious how many orders have been processed on a brand new store?

[♥geoffreywalton]

The answer is in the knowledgebase

 

http://www.oscommerce.info/kb/osCommerce

[winedog]

Thank you!

 

Answer was here

 

http://www.oscommerce.info/kb/osCommerce/G...s_and_Tricks/31

[knifeman]

I have installed scrambled order number on my other shops. What would be nice is if you could just force the number to increment by say 6 instead of by 1 every time a new order is placed. Then once your store is moving along, you could back that number down. Of course this would not work for those counting their orders, but it would for lots of others.

 

Tim

[♥ecartz]

What would be nice is if you could just force the number to increment by say 6 instead of by 1 every time a new order is placed.

That's possible, but apparently in MySQL, it is a server wide setting (affects all tables on all databases): auto_increment_increment.

 

You can also manually set the order ID when you insert into the orders table. I forget if you have to turn off auto incrementing on the column first. Might be subject to an odd race condition it two people place orders at the same time.