I just finished testing my Zen Cart install and am ready to move to production. I've reset everything that I can in my admin section, but would like to reset my order numbers. I had changed them to start at 1000001, but found that a number this big doesn't display well on my site. So, since I don't mind losing all of my test customer/order data, I thought this would be a good time to do this. My question is really two:
1.) If I want to set my order number to one that is lower than it was, it is as simple as a ALTER TABLE orders AUTO_INCREMENT = [number here]
2.) What's the best way to get rid of all my test data (hits, views, customers, orders, etc) but still keep my settings, categories, products, etc.?
Thank you!!



