Restrict new customer registration

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   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.

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
BrianRoden Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 07-September-2007 Status: Offline Points: 0	Post Options Post Reply Quote BrianRoden Report Post Thanks(0) Quote Reply Topic: Restrict new customer registration 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.

Greg Dinger Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238	Post Options Post Reply Quote Greg Dinger Report Post Thanks(0) Quote Reply 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.

Hamish Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group Joined: 12-October-2006 Location: United Kingdom Status: Offline Points: 56	Post Options Post Reply Quote Hamish Report Post Thanks(0) Quote Reply Posted: 12-January-2009 at 12:13pm
	Hi Brian, See the following page on the WIKI :- 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
	Editing ProductCart Code? See WIKI Guidelines for Editing ProductCart's ASP Source Code

katharina Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 25-October-2005 Location: United States Status: Offline Points: 0	Post Options Post Reply Quote katharina Report Post Thanks(0) Quote Reply 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 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

intour Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 30-June-2006 Location: United Kingdom Status: Offline Points: 0	Post Options Post Reply Quote intour Report Post Thanks(0) Quote Reply 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 Edited by intour - 20-January-2009 at 4:16am

macleather Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 23-June-2008 Location: Los Angeles Status: Offline Points: 3	Post Options Post Reply Quote macleather Report Post Thanks(0) Quote Reply Posted: 21-January-2009 at 4:13pm
	Katherina, I'm also seeing the same as Nigel. Firefox 3.0 Alan

katharina Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 25-October-2005 Location: United States Status: Offline Points: 0	Post Options Post Reply Quote katharina Report Post Thanks(0) Quote Reply 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

macleather Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 23-June-2008 Location: Los Angeles Status: Offline Points: 3	Post Options Post Reply Quote macleather Report Post Thanks(0) Quote Reply Posted: 21-January-2009 at 6:36pm
	Hi Katharina, Here is what I'm seeing. http://www.mcpcustomleather.com/images/germancorner.jpg Don't know if that's what you intended. Alan

katharina Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 25-October-2005 Location: United States Status: Offline Points: 0	Post Options Post Reply Quote katharina Report Post Thanks(0) Quote Reply 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

macleather Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 23-June-2008 Location: Los Angeles Status: Offline Points: 3	Post Options Post Reply Quote macleather Report Post Thanks(0) Quote Reply 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 Scroll down to Screen Resolution. Alan