VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

VP-ASP Shopping Cart Customer Forum

Home | Profile | Register | Active Topics | Members | Search | FAQ
Save Password
Forgot your Password?

 All Forums
 VPCart Forum
 Comments about VP-ASP
 productgroup and customermatch
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

6 Posts

Posted - February 11 2005 :  13:40:25  Show Profile  Reply with Quote
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.


Edited by - jstablein on April 04 2006 15:38:25


4263 Posts

Posted - February 13 2005 :  19:44:16  Show Profile  Visit support's Homepage  Reply with Quote

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)"
sql=sql & " and customermatch is null"
end if
end if

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000