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 Log in or register to post a comment. PN Posted: Sep 15, 2011 Comments Auto-increment field 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; Log in or register to post a comment. Thank you rfay. It works PN on September 16, 2011 Thank you rfay. It works great! Log in or register to post a comment.