Customizing ProductCart - Change customer default pricing

Print Page | Close Window

Change customer default pricing

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=395
Printed Date: 05-May-2024 at 5:08am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Change customer default pricing

Posted By: Inkyfinger
Subject: Change customer default pricing
Date Posted: 17-August-2006 at 5:26pm

Does anybody know of a way to change the customer default from retail to wholesale when they register? I want my customers to be able to register to see the wholesale pricing without my intervention. I'm using V2.76.

Replies:

Posted By: sawan
Date Posted: 18-August-2006 at 12:38am

I too would like to know this, anyone to help!

-------------
Sawan S Ruparel

Posted By: netprofits
Date Posted: 18-August-2006 at 7:23am

You would need to modify the page that saves new customers during registration (SaveNewCust.asp) to set the CustomerType to Wholesale Customer.

Are you allowing people to purchase and checkout using retail pricing? And only those who pre-register get wholesale pricing? If you want everyone to get your wholesale pricing, then you'll also need to modify the routine for when new customers checkout to set them to wholesale customers. This may be more involved because you need to have their shopping cart calculate new prices based on the wholesale amounts.

You should determine if you will charge sales tax to wholesale customers. Most likely you will as it sounds like these are not really wholesale customers. Check the option under the View/Edit Tax Options for "Tax Wholesale Customers".

-------------
NetProfits Internet Consulting

Certified ProductCart Developer

http://www.nicwebdesign.com" rel="nofollow - Our Site

Posted By: Inkyfinger
Date Posted: 18-August-2006 at 1:02pm

Thanks Netprofits, you were right. Just needed to change the customerType variable from "0" to "1".

For anybody else interested, copy this code and replace same paragraph in savenewCust.asp.

query="INSERT INTO customers (name, lastName, customerCompany, phone, email, address, zip, state, stateCode, city, CountryCode,[password], customerType,IDRefer,CI1,CI2,address2,RecvNews) VALUES ('" &replace(pName,"'","''")& "','" &replace(pLastName,"'","''")& "','" &replace(pCustomerCompany,"'","''")& "','" &pPhone& "','" &pEmail& "','" &replace(pAddress,"'","''") & "','" &pZip& "','" &replace(pState,"'","''")& "','" &pStateCode& "','" &replace(pCity,"'","''")& "','" &pCountryCode& "','" &pEncryptedPassword& "',1," & IDRefer & ",'" & replace(CI1,"'","''") & "','" & replace(CI2,"'","''") & "','" &replace(pAddress2,"'","''") & "'," & CRecvNews & ")"
set rs=Server.CreateObject("ADODB.Recordset")
set rs=connTemp.execute(query)