Zen Cart Logo
Forums / General Questions / Can i delete all my customers?

Can i delete all my customers?

Locked

Views: 3,068

Results 1 to 10 of 10
This thread is locked. New replies are disabled.
28 Oct 2009, 8:49 PM
#1
touchclothing avatar

touchclothing

Totally Zenned

Join Date:
Jul 2005
Location:
Brooklyn NY
Posts:
498
Plugin Contributions:
0

Can i delete all my customers?

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.

28 Oct 2009, 10:30 PM
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
177

Re: Can i delete all my customers?

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

28 Oct 2009, 10:42 PM
#3
touchclothing avatar

touchclothing

Totally Zenned

Join Date:
Jul 2005
Location:
Brooklyn NY
Posts:
498
Plugin Contributions:
0

Re: Can i delete all my customers?

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

28 Oct 2009, 11:20 PM
#4
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
177

Re: Can i delete all my customers?

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

29 Oct 2009, 3:12 AM
#5
touchclothing avatar

touchclothing

Totally Zenned

Join Date:
Jul 2005
Location:
Brooklyn NY
Posts:
498
Plugin Contributions:
0

Re: Can i delete all my customers?

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

29 Oct 2009, 3:15 AM
#6
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
177

Re: Can i delete all my customers?

touchclothing:

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.

29 Oct 2009, 3:24 AM
#7
touchclothing avatar

touchclothing

Totally Zenned

Join Date:
Jul 2005
Location:
Brooklyn NY
Posts:
498
Plugin Contributions:
0

Re: Can i delete all my customers?

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

29 Oct 2009, 3:45 AM
#8
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
177

Re: Can i delete all my customers?

****** 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.

29 Oct 2009, 4:16 AM
#9
touchclothing avatar

touchclothing

Totally Zenned

Join Date:
Jul 2005
Location:
Brooklyn NY
Posts:
498
Plugin Contributions:
0

Re: Can i delete all my customers?

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

29 Oct 2009, 5:11 AM
#10
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
177

Re: Can i delete all my customers?

Doesn't affect products or categories or attributes.