Maybe this is by design, but while I am able to set a value for Customers.CustomerGroupId (such as 1), I am not able to remove members from that group by clearing out that value, such as setting it to Null.
Code: Select all
UPDATE Customers SET Customers.CustomerGroupId = Null WHERE BC_Customers.Email='[email protected]';
So I found I can set the Group to 0 and does work.
Code: Select all
UPDATE Customers SET Customers.CustomerGroupId = 0 WHERE BC_Customers.Email='[email protected]';