Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Order Number Reset


iantates

Recommended Posts

After testing my site I would like to set the site live.

 

I would also like to reset the order number back so that all new orders start from 1 not 37 as it is now.

 

I guess its changing a value in database but can't find it any where?

Link to comment
Share on other sites

Use phpmyadmin in the SQL Tab to reset the order_id.

 

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

 

Rather than starting at 1, I'd recommend starting at 1000 as the Tips and Tricks link above states. I would not want to be "order #1" on your new site. Also if you start at 1, you'll need to make sure that ALL of the entries for the first 37 orders in the DB are properly deleted.

 

HTH

Tom

Link to comment
Share on other sites

  • 2 weeks later...

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...