|
support
Administrator
4679 Posts |
 Posted - September 16 2019 : 15:41:34
|
Dear Alex,
It seems you need to update the sql query for dynamic group to exclude a specific customer from group. For this you may follow the steps below.
1) Login to your VPCart admin and go to ''Customers > Customers Groups'' from top menu.
2) Locate which Dynamic group you want, and click the EDIT button.
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:
* from customers
Say you want to remove a customer with contactid 2, then update the query as follows.
select * from customers where contactid <> 2
For more details please refer our help guide.
https://helpnotes.vpcart.com/userguide900/index.html#!Documents/removecustomersfromastaticordynamicgroup.htm
Please give a try and let us know if you need further assistance.
Thank you,
VPCart Customer Care Team
www.vpcart.com
|
 |
|
All Forums
Remove a customer from dynamic group
New Topic
Printer Friendly
Topic 
TrustGuard - PCI Security Scanner
