Forums / Managing Customers and Orders / Deleting Customers & Orders

Deleting Customers & Orders

Locked

Views: 1,715

Results 1 to 3 of 3
This thread is locked. New replies are disabled.
5 Nov 2007, 12:05 AM
#1
esugrue avatar

esugrue

Zen Follower

Join Date:
Jun 2004
Posts:
182
Plugin Contributions:
0

Deleting Customers & Orders

Hi!

I am creating a duplicate store for a customer and have copied the original store (still operating) to another server successfully :yes:

Is there a way to bulk delete the original orders/customers from the new install? I guess it would be messing with MySql tables maybe but I'm unsure which ones to edit etc?

After deleting all customers/orders is it possible to reset the order count to 1 again?

Thanks
Ernie

5 Nov 2007, 5:15 AM
#2
wolfsz avatar

wolfsz

Zen Follower

Join Date:
Mar 2006
Location:
Australia
Posts:
286
Plugin Contributions:
3

Re: Deleting Customers & Orders

Hi there
It would be best to transfer all tables bar all customer and orders tables, if you have already transferred all tables then you will need to empty all tables called zen_customers_* and zen_orders_* plus the customers and orders tables them selves and the zen_address_book table

Wolf Skafte-Zauss
http://e-commerce-pros.com
Tools for E-commerce Professionals

5 Nov 2007, 10:17 AM
#3
esugrue avatar

esugrue

Zen Follower

Join Date:
Jun 2004
Posts:
182
Plugin Contributions:
0

Re: Deleting Customers & Orders

Hi!

Excellent, thank you just what I wanted!

Ernie