| Author |
 Topic  |
|
|
kendiala
VP-CART New User
57 Posts |
 Posted - July 02 2014 : 12:05:23
|
I''m using customer groups to display wholesale prices to customers who are logged in and belong to the Wholesale group. That seems to be working great.
But I also have products that should only display to Wholesale customers, so I need to exclude customers who are casually browsing the site. Since those customers aren''t logged in, they''re not in a customer group so I can''t specifically exclude them. How do I go about doing that?
This page is a good example:
http://www.sunroseonline.com/shopdisplayproducts.asp?id=26&cat=Wild+Crafted+Essential+Oils
If you look at the dropdown for products on that size, you''ll see larger sizes that have no prices. I need to exclude those products unless you''re logged in as a Wholesale customer.
Any ideas? |
|
|
serjtankian
VP-CART Super User
Armenia
378 Posts |
Posted - July 02 2014 : 12:22:31
|
try this
first, you need to create all your customer automatically added to a normal customer group
second, create wholesales customer group and add your wholesales customer group manually
*serj* |
 |
|
|
kendiala
VP-CART New User
57 Posts |
Posted - July 02 2014 : 12:29:41
|
Thanks, that helps. So I need to make a Retail group that''s dynamic and the wholesale group is static.
I''m having a hard time figuring out what the SQL query would be to use for the dynamic Retail group. Any suggestions for that? |
|
|
|
kendiala
VP-CART New User
57 Posts |
Posted - July 02 2014 : 12:36:10
|
| I''m having a hard time visualizing this. If the customer isn''t in the database because they haven''t ordered anything or registered, how can they be in a customer group? |
|
|
|
serjtankian
VP-CART Super User
Armenia
378 Posts |
Posted - July 03 2014 : 10:55:11
|
for a new customer or unregistered customer they will automatically grouped as a regular customer
*serj* |
|
|
|
carfin
VP-CART Expert
United Kingdom
948 Posts |
Posted - July 03 2014 : 11:01:09
|
For each product record you can choose who has access. In your case the products to be excluded would be Access Level = Registered Customers only
Regards,
Carrol
www.deanston-electrical.co.uk |
|
|
|
serjtankian
VP-CART Super User
Armenia
378 Posts |
Posted - July 03 2014 : 11:08:55
|
Hi Carol,
could i ask you, can we do this also with product feature ? as i don''t see any access level option with product feature
*serj* |
|
|
|
carfin
VP-CART Expert
United Kingdom
948 Posts |
Posted - July 03 2014 : 11:31:15
|
Hi Serj,
no I don''t think features can be hidden from certain groups, but inventory products can.
Regards,
Carrol
www.deanston-electrical.co.uk |
|
|
|
serjtankian
VP-CART Super User
Armenia
378 Posts |
Posted - July 03 2014 : 11:42:45
|
OK thanks, so i think it would need customisation of the code
*serj* |
|
|
|
kendiala
VP-CART New User
57 Posts |
Posted - July 03 2014 : 11:50:16
|
Thanks for the replies. Unfortunately, registered customers only won''t work because there are customers who will be registered who aren''t wholesale, so they need to be excluded as well.
The official response is that the functionality I need isn''t native and needs to be customized. This is disappointing, because I have it working exactly as I want it to work in version 6.5. It''s disappointing that version 7 took a step backwards in functionality. |
|
|
|
serjtankian
VP-CART Super User
Armenia
378 Posts |
Posted - July 04 2014 : 06:50:35
|
hm.. strange actually, vpasp have that feature wirh 6.5 but don''t have with 7.00 version.
*serj* |
|
|
|
carfin
VP-CART Expert
United Kingdom
948 Posts |
Posted - July 04 2014 : 09:00:26
|
Ok I have tested this on our site and it does work because we use groups and exclusions regularly.
Create your customer group called Wholesale as a static group which you add customers to manually after they register.
For any product record that you want only the wholesale customers to see you set the Access Level as follows
Check the radio button for Customer Groups
In the first dropdown list of groups to be Included choose your Wholesale group only
In the second dropdown list of groups you should see a list of 2 items: None and Wholesale (unless you have already set up other groups) Do not choose None or Wholesale.
Save the record and test.
I tested this on our site by signing in as a normal registered customer and I searched for the product but could not see it
I logged out so that I was a browsing unregistered customer in a new browser and then tried to find the product but it was hidden
I then opened a new browser window, logged in as a wholesale customer and the product appeared in a search. So it DOES work. Let me know how you get on.
Regards,
Carrol
www.deanston-electrical.co.uk |
Edited by - carfin on July 04 2014 09:01:20 |
|
|
|
kendiala
VP-CART New User
57 Posts |
Posted - July 07 2014 : 11:52:50
|
Thank you, Carrol! What you said to do does work with a normal product. I was only testing it with a subproduct that shows up in a dropdown list for a parent product. That didn''t work.
After going back and forth a little so we were all on the same page about what I needed to do, support made the following edit:
----------------------------
I have modified your file shopproductinventory.asp and added new code as below :
Line 35 :
strsql = strsql & GenerateCustomerMatchSQL ("customermatch","excustomermatch","loggedin","and")
------------------------------
That solved the problem. It turned out to not need to be a customization, just a little correction to the existing code.
Thanks for your help!
~~kim |
|
|
|
carfin
VP-CART Expert
United Kingdom
948 Posts |
Posted - July 08 2014 : 03:42:51
|
Glad you''ve got it sorted. I didn''t realise you were using inventory products. I thought the dropdown list was for product features
Regards,
Carrol
www.deanston-electrical.co.uk |
|
|
| |
Topic |
|
All Forums
Excluding Customer With No Group
New Topic
Printer Friendly
TrustGuard - PCI Security Scanner
