Delete Global Customers

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

Reply to
Philip Gass
Loading thread data ...

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

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

"Philip Gass" wrote:

Reply to
Matt Hurst

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.