Remove customers from a Static or Dynamic Group

 

If you want to remove a customer from a Static group, you can follow these:

1) Login to your VPCart admin: Customers > Customers Groups.

2) Locate which Static group you want, and click the icon in the Action column, like the screenshot below:

A screenshot of a cell phone

Description automatically generated

3) Then in the next screen of the customer list, you should see a list of checkboxes on the right, simply UNTICK which customer you want to remove from the group as shown in the screenshot below:

A screenshot of a cell phone

Description automatically generated

4) Click Add Selected Record button.


If you want to remove a customer from a Dynamic group, you can follow these:

1) Login to your VPCart admin: Customers > Customers Groups.

2) Locate which Dynamic group you want, and click the EDIT button.
Screenshot:
A screenshot of a cell phone

Description automatically generated

3) Then in the next screen, locate the "SQL Query " big text box.
You will need to alter the existing SQL query there to exclude the customer ids you want.

For example, if your current SQL is eg:
select * from customers

A screenshot of a cell phone

Description automatically generated

And you want to exclude two customer id 9 and 10, then you need to alter SQL to eg:
select * from customers where contactid <> 9 and contactid <> 10

A screenshot of a cell phone

Description automatically generated

NOTE: You can add more contact ids you want to exclude from the dynamic group.

4) Click Update record.

5) Click Back To Groups.

6) Click the Refresh icon in the column "Action" for the dynamic group you edited before.
Screenshot:
A screenshot of a cell phone

Description automatically generated

7) After the refresh, in this example, you should see the correct numbers of the customers in the dynamic group. In my example above, before removing it was 21 customers in the dynamic group.
After altering the SQL to exclude two customers, the numbers showing 19 members.
Screenshot:
A screenshot of a social media post

Description automatically generated