Can i delete all my customers?

[touchclothing]

I copied my shop over and the data base but is there away that I can delete all my customers? And is there away that I can set my order number. I don't want my order number to start at 1 I want it to start at 5000.

[DrByte]

What do you mean by "copied my shop over"?

[touchclothing]

I meant to say that I restarted my site I had it down for awhile and I am selling something new.

[DrByte]

So, you're wanting to purge all customers, addresses, orders, products, everything?

[touchclothing]

yes i would like to start fresh and is there any way i can choose my start number for my order numbers?

[DrByte]

yes i would like to start fresh and is there any way i can choose my start number for my order numbers?

Yes: Admin->Tools->Store Manager->Change Starting Order Number.

[touchclothing]

how do i clean everything out like the customers and orders?

[DrByte]

******** USE EXTREME CAUTION WHEN DOING THIS!!!!! *******
Doing this WILL DELETE *ALL* customer and order data from your database.

Go to Admin->Tools->Install SQL Patch and paste the following in the box and click Send.

truncate table customers;
truncate table address_book;
truncate table customers_info;
truncate table group_pricing;
truncate table orders;
truncate table orders_products;
truncate table orders_status_history;
truncate table orders_products_attributes;
truncate table orders_products_download;
truncate table orders_total;
truncate table admin_activity_log;
truncate table authorizenet;
truncate table banners_history;
truncate table counter;
truncate table counter_history;
truncate table coupon_email_track;
truncate table coupon_gv_customer;
truncate table coupon_gv_queue;
truncate table coupon_redeem_track;
truncate table coupon_restrict;
truncate table customers_basket;
truncate table customers_basket_attributes;
truncate table db_cache;
truncate table email_archive;
truncate table files_uploaded;
truncate table paypal;
truncate table paypal_payment_status_history;
truncate table paypal_session;
truncate table sessions;
truncate table upgrade_exceptions;
truncate table whos_online;

And this too if you used the linkpoint payment module:

truncate table linkpoint_api;

But, given that you're starting a new store, and by the sound of it, likely also new products, a clean new install might be a better idea.

[touchclothing]

will this effect the products that i have uploded? becuase i just want to clear the orders and customers.

[DrByte]

Doesn't affect products or categories or attributes.