Finished Testing, Ready to Move to Production

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!!

1. Truncate all of these tables:```
   address_book
   customers
   customers_info
   email_archive
   products_notifications
   customers_basket
   customers_basket_attributes
   files_uploaded
   orders
   orders_products
   orders_products_attributes
   orders_products_download
   orders_status_history
   orders_total
   paypal
   paypal_payment_status_history
   paypal_session
   paypal_testing
   admin_activity_log
   authorizenet
   banners_history
   counter
   counter_history
   coupon_email_track
   coupon_redeem_track
   email_archive
   coupon_gv_customer
   coupon_gv_queue

That's just what I was looking for. Thanks!!

Is it okay to use phpMyAdmin to just delete the records?

DrByte:

2. Reset the products_viewed column to 0 in the products_description table.

Can someone please tell me where I can find this file and how do I reset this file to 0?

Thanks.

Admin->Tools->Store Manager ... there are some counter reset options there.

Thanks for your reply and letting me know DrByte very much appreciated :).