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
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 VPCart Forum
 General help me questions
 customer type setup
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

casper
Starting Member

6 Posts

Posted - November 17 2009 :  13:11:36  Show Profile  Reply with Quote
I am trying to figure out how to setup the customer type pricing. So that when a customer logs into the site, he/she will see their pricing.
Is there a step by step outline of this procedure?

Thank you

creativechaos
VP-ASP New User

Australia
64 Posts

Posted - November 17 2009 :  20:36:19  Show Profile  Visit creativechaos's Homepage  Reply with Quote
Hi Casper,

Your best bet for this is to review the helpnote at http://helpnotes.vpasp.com/shopexd.asp?id=775

If you need clarification let us know where you are having difficulty and I'll try to help further.

Cheers,

Michael Dunkley
Creative Chaos
http://www.creativechaos.com.au
Go to Top of Page

casper
Starting Member

6 Posts

Posted - November 17 2009 :  20:55:26  Show Profile  Reply with Quote
Thank you Michael,
That is exactly what I was looking for.
Go to Top of Page

casper
Starting Member

6 Posts

Posted - November 17 2009 :  22:08:13  Show Profile  Reply with Quote
When changing xcustomerpriceidentifier from contacttypeid to any other value, I get this error at customer login.
ADODB.Recordset error '800a0cc1'

Item cannot be found in the collection corresponding to the requested name or ordinal.

/shop/shop$db.asp, line 1989
Looking at shop$db.asp line 1989
I see it is where the identifier is recognized.
what am i doing wrong?
any help would be appreciated.
Go to Top of Page

creativechaos
VP-ASP New User

Australia
64 Posts

Posted - November 17 2009 :  22:24:58  Show Profile  Visit creativechaos's Homepage  Reply with Quote
reply edited - see below

Edited by - creativechaos on November 17 2009 22:33:10
Go to Top of Page

creativechaos
VP-ASP New User

Australia
64 Posts

Posted - November 17 2009 :  22:32:07  Show Profile  Visit creativechaos's Homepage  Reply with Quote
Sorry,

My last post should have referred to the "Customers" table.

It should read:


You need to make sure that whatever you change "contacttypeid" to is a valid field name in the CUSTOMERS table.

To see the true field names in the CUSTOMERS table, when you edit a CUSTOMER you will see all of the fields in the CUSTOMERS table listed next to the actual database field name.

Try changing contacttypeid to something like CUSTOTHER1 to use that field instead where you will be able to enter references like "wholesale" or "retail" etc.

Cheers,

Michael Dunkley
Creative Chaos
http://www.creativechaos.com.au

Go to Top of Page

casper
Starting Member

6 Posts

Posted - November 17 2009 :  23:56:27  Show Profile  Reply with Quote
Hi Michael,
Thank you so much for the help. it is very much appreciated.
Changing contacttypeid to custother1 and setting custother1 in the customer field to wholesale...stopped the error.
However, when logged into a customer with wholesale placed in the field custother1 still shows the retail price.
configuration settings:
xcustomerpricefields - price2
xcustomerpriceidentifier - custother1
xcustomerpricetypes - wholesale
as I said contacttypeid in wholesale customer is set to wholesale
logging in under that customer i am seeing retail pricing.

Also, will I need to set all other customers to retail and add settings for that or will any customer without wholesale set in contacttypeid default to "cprice"?

Thank you again Michael,
Go to Top of Page

casper
Starting Member

6 Posts

Posted - November 17 2009 :  23:58:13  Show Profile  Reply with Quote
I meant will any customer without wholesale in the custother1 field see "cprice" by default?
Go to Top of Page

creativechaos
VP-ASP New User

Australia
64 Posts

Posted - November 18 2009 :  00:05:31  Show Profile  Visit creativechaos's Homepage  Reply with Quote
You didn't mention this one, so first thing to check is whether you have the configuration setting xcustomerprices set to YES?

Another thing to test is to log completely out of your admin, clear your cache and cookies from the browser and then log in as your wholesale customer. Sometimes the session variables can get mixed up if you are logged into the front and back ends at the same time.

If a customer is not flagged with anything in their custother1 field they will by default see the cprice value.

Cheers,

Michael Dunkley
Creative Chaos
http://www.creativechaos.com.au

Go to Top of Page

casper
Starting Member

6 Posts

Posted - November 18 2009 :  00:41:14  Show Profile  Reply with Quote
Worked beautifully. Clearing the cache did the trick.
Thank you again so very much for your time Michael.
I really appreciate your help.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000