Finished Testing, Ready to Move to Production

[Toot4fun]

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

[DrByte]

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

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

[Toot4fun]

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

[otakushark]

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

[CybaGirl]

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.

[DrByte]

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

[CybaGirl]

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