jstablein
Starting Member
6 Posts |
Posted - February 11 2005 : 13:40:25
|
After working with Support, it has been explained that--
----------Support excerpt--------------- Customers record: productgroup=wholsale Products record: customermatch=wholesale Categories table: customermatch=wholesale Shop Configuration: xproductmatchcustomer - Yes
The Logic
If a customer logs in and has something in the productgroup, that is all they will see. If they do not login they see all categories. -----------End Support excerpt----------
Thus in 5.5, products disappear from visitors who sign up for an account but are not on the matching product list. And for those who match, nothing changes when they login. Seems backwards to me.
I think it would be an improvement if the products showed up ONLY for matching customers. If I have a product for VIP shoppers, I don't want every anonymous visitor to see it.
I should be able to do it like this--
Customers record 1: productgroup=VIP Customers record 2: productgroup=Bartenders
Product 1 record: Product 2 record: customermatch=VIP,Bartenders Product 3 record: customermatch=VIP
Categories record: customermatch=VIP,Bartenders Shop Configuration: xproductmatchcustomer - Yes
Then my VIP customers would see Product 1, 2 and 3. Bartenders would see Product 1 and 2. Anonymous visitors would see only Product 1.
When I purchased VPASP 5.5, I thought it would work like this and I think this functionality would make the program exceptional.
Comments?
|
Edited by - jstablein on April 04 2006 15:38:25 |
|
support
Administrator
4679 Posts |
Posted - February 13 2005 : 19:44:16
|
Hi,
Sorry for any confusion, but this is slightly incorrect.
VP-ASP works in the way that you want, but only on shopdisplayproducts.asp, not shopdisplaycategories.asp
To make shopdisplaycategories.asp work in the same way as shopdisplayproducts.asp requires a modification to the SQL. Locate the following code in shopdisplaycategories.asp
if getconfig("xproductmatchcustomer")="Yes" then if GetSess("CustomerProductGroup")<>"" then sql=sql & " and customermatch='" & getsess("customerProductgroup") & "'" end if end if
Change it to the following
if getconfig("xproductmatchcustomer")="Yes" then if GetSess("CustomerProductGroup")<>"" then sql=sql & " and (customermatch like '%" & getsess("customerProductgroup") & "%'" sql=sql & " or customermatch is null)" else sql=sql & " and customermatch is null" end if end if
|
|
|