Customizing ProductCart - displaying data bases on customer

Print Page | Close Window

displaying data bases on customer

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Customizing ProductCart
Forum Description: Exchange messages with other users that are customizing ProductCart.
URL: https://forum.productcart.com/forum_posts.asp?TID=139
Printed Date: 27-November-2024 at 12:53am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: displaying data bases on customer

Posted By: dwatch
Subject: displaying data bases on customer
Date Posted: 27-February-2006 at 11:23am

Trying to display certain data (pricing, etc) on the viewprd.asp base on the customer and the product.

here is what i have so far

if session("idcustomer")=1200 then

'display data here

end if

I need help adding in the and idproduct= or idcategory= part of it. Any input will be appreciated.

Replies:

Posted By: watercrazed
Date Posted: 02-March-2006 at 4:13am

I may be way off base but have you tried just pasting all of the the code for the display part of the form between your if and end if? I don't code but here is my guess.

if session("idcustomer")=1200 then

<-- start form-->

paste all of the form code here

end if

Really not sure where you put your end if but, that is a guess. Maybe someone that actually knows asp will try to answer.

-------------
John

http://www.ultimatewatermassage.com - massagers, heat therapy, buckwheat pillows and more

Posted By: dwatch
Date Posted: 02-March-2006 at 9:05am

That part of it works. I need to add the part about the product into this though.

Example would be if the customer is xyz company and the product is a sku: tt33, then display a certain price.

Posted By: watercrazed
Date Posted: 04-March-2006 at 4:38pm

I am not sure what you are asking,

Do you have a different pricing structure for each customer?
I think you would need a new price column in the database for each customer or customer class. Then replace standardprice variable pPrice=rs("price") with newprice variable name.

For another example look for the code where the cart displays wholesale price based on the customer class of wholesale.

-------------
John

http://www.ultimatewatermassage.com - massagers, heat therapy, buckwheat pillows and more

Posted By: dwatch
Date Posted: 04-March-2006 at 5:00pm

John,

Right, another field in the database would be useful. I can handle that part. the part I need help with is the exact coding that would state if the customer is xyz company and the product is a sku: tt33, then display that new price field.