Using ProductCart - Restrict new customer registration

Print Page | Close Window

Restrict new customer registration

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Using ProductCart
Forum Description: Running your store with ProductCart
URL: https://forum.productcart.com/forum_posts.asp?TID=2337
Printed Date: 26-February-2025 at 11:37pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Restrict new customer registration

Posted By: BrianRoden
Subject: Restrict new customer registration
Date Posted: 12-January-2009 at 10:01am

We are using ProductCart for a wholesale-only B-to-B ordering site. A few consumers have found our site and registered themselve to place an order.

1) Can we make it where ProductCart will not allow site visitors to create their own accounts?

2) When we imported our existing customer list from our in-house system, everyone got created as a retail customer. What is the proper database field/value to set using a SQL update query so I can change them all to wholesale, and then make it so only wholesale customers can place orders?

Thanks.

Replies:

Posted By: Greg Dinger
Date Posted: 12-January-2009 at 10:47am

Hi Brian,

In the customer table, customerType (data type int) must contain a 1 to indicate a wholesaler.

-------------
GreyBeard Design Group

Certified ProductCart Developer

Web Design/Development/Hosting

http://tinyurl.com/5c8t4t" rel="nofollow - Add-Ons & Custom Code |

Posted By: Hamish
Date Posted: 12-January-2009 at 12:13pm

Hi Brian,
See the following page on the WIKI :- http://wiki.earlyimpact.com/developers/dealer_only_store -
http://wiki.earlyimpact.com/developers/dealer_only_store
Please check whether you wish to use Customer Groups or Wholesale (or both) by referring to a different WIKI page : http://wiki.earlyimpact.com/productcart/customer-type -
http://wiki.earlyimpact.com/productcart/customer-type

-------------
Editing ProductCart Code?

See http://wiki.earlyimpact.com/developers/editcode" rel="nofollow - WIKI Guidelines for Editing ProductCart's ASP Source Code

Posted By: katharina
Date Posted: 12-January-2009 at 2:07pm

Hi, just wanted to let you know how we do it. We do have retail and wholesale, but you can use this method to set it up the way you need it. Create a page with wholesale information and sign up information. We require wholesalers to print/fill out that page, fax it and proof of business to us. Then we manually set up a wholesale account, and email them back. You can leave the signup (My Account) intact, but make sure that it states wholesale pricing will only be available to approved customers, after providing business proof. This also means that they will not see wholesale pricing until the process has been completed. Take a look at http://www.germanplaza.com - www.germanplaza.com Wholesale signup is near the end of the page. I suppose you leave it all automatic, but I prefer some form to proof and approval by us.
Katharina

Posted By: intour
Date Posted: 20-January-2009 at 4:16am

Hi Katherina,

I had a look at your germanplaza.com store and it looks a bit strange in my monitor. The main part of the website is left justified and appears with the content but it also loads a blank page to the right?

Just thought I'd mention it.

Nigel

Posted By: macleather
Date Posted: 21-January-2009 at 4:13pm

Katherina,

I'm also seeing the same as Nigel. Firefox 3.0

Alan

Posted By: katharina
Date Posted: 21-January-2009 at 5:22pm

I've looked at it with IE and Firefox and don't seem to see it. The page is left aligned and set to a width of 800, and the background image starts over again at that point. Perhaps it appears strange like that.
Katharina

Posted By: macleather
Date Posted: 21-January-2009 at 6:36pm

Hi Katharina,

Here is what I'm seeing. http://www.mcpcustomleather.com/images/germancorner.jpg - http://www.mcpcustomleather.com/images/germancorner.jpg

Don't know if that's what you intended.

Alan

Posted By: katharina
Date Posted: 21-January-2009 at 6:45pm

You must have a monster of a screen! What resolution are you using? I did set up the site for 800 pixel width for those that have smaller monitors, or those that still use the AOL interface to look at sites. You will be surprised how many of them do! This means, that others that use higher resolution, will see blank spaces on the right hand side. I know it looks funny on those screens, but it does work for those with lower resolutions. I actually run on a low resolution with my large monitor, but that is because of my eye sight getting worse. Age gets you eventually. LOL I'm considering upgrading the site to 1024 pixel width. Perhaps with the next upgrade of PC.
Katharina

Posted By: macleather
Date Posted: 21-January-2009 at 7:13pm

Yes, I use a high resolution (and strong reading glasses LOL). Mine is set at 1440x900. When I set it down to 1280x720 your site looked fine in IE but still had the white space in FF.

If you're interested, here is a link to screen resolution stats. http://www.w3schools.com/browsers/browsers_display.asp - http://www.w3schools.com/browsers/browsers_display.asp Scroll down to Screen Resolution.

Alan

Posted By: katharina
Date Posted: 22-January-2009 at 7:03pm

Thanks for the link. I was already thinking of going up to 1024 pixel screen width. I will do that with the next PC upgrade. I don't worry about the white space at this point either. The site is working well, so it is more a cosmetic thing.
Katharina