Discussions

How do I set the order number?

Hello,

How do I set the order number so that the first order begins at 1000?

Thanks,
Paul

Posted: Sep 15, 2011

Comments

rfay Randy Fay on September 15, 2011

The order_number is by default the same as the order_id, which is an autoincrement field.

At least in Mysql, you can issue this mysql command and I think it will do the trick.

ALTER TABLE commerce_order AUTO_INCREMENT 1000;