Author |
Topic |
|
casper
Starting Member
6 Posts |
Posted - November 17 2009 : 13:11:36
|
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-CART New User
Australia
64 Posts |
|
casper
Starting Member
6 Posts |
Posted - November 17 2009 : 20:55:26
|
Thank you Michael, That is exactly what I was looking for. |
|
|
casper
Starting Member
6 Posts |
Posted - November 17 2009 : 22:08:13
|
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. |
|
|
creativechaos
VP-CART New User
Australia
64 Posts |
Posted - November 17 2009 : 22:24:58
|
reply edited - see below |
Edited by - creativechaos on November 17 2009 22:33:10 |
|
|
creativechaos
VP-CART New User
Australia
64 Posts |
Posted - November 17 2009 : 22:32:07
|
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
|
|
|
casper
Starting Member
6 Posts |
Posted - November 17 2009 : 23:56:27
|
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, |
|
|
casper
Starting Member
6 Posts |
Posted - November 17 2009 : 23:58:13
|
I meant will any customer without wholesale in the custother1 field see "cprice" by default? |
|
|
creativechaos
VP-CART New User
Australia
64 Posts |
Posted - November 18 2009 : 00:05:31
|
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
|
|
|
casper
Starting Member
6 Posts |
Posted - November 18 2009 : 00:41:14
|
Worked beautifully. Clearing the cache did the trick. Thank you again so very much for your time Michael. I really appreciate your help.
|
|
|
|
Topic |
|