Delete Global Customers

Apr 15, 2009 1 Replies

Hi - I'm running HQ with 2 stores - My Global customers are all organised according to account type. I want to delete several of these account types (not bothered about history etc) is there an easy way to do this which will be translated to each store? Or could I do SQL in each database?



I cant use the worksheet which filters by last active as i want to select them on the basis of their account type...


you could issue a worksheet 51 sql command to the stores:

delete from customer where accounttypeid in (1,2,3...)

"Philip Gass" wrote:

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required