select userid from users where email = '#trim(form.email)#' select MAX(userID) as idmax from Users Insert Into Address (addressname, firstname, lastname, address1, city, state, province, type, postalcode) VALUES ('#variables.namer#', '#trim(form.firstname)#', '#trim(form.lastname)#', '#form.address#', '#form.city#', '#variables.stateVal#', '#trim(variables.province)#', 'bill', '#form.postalcode#') select max(addressid) as addressid from address where type = 'bill' and addressname = '#variables.namer#' and address1 = '#form.address#' and city = '#form.city#' Insert Into Address (addressname, firstname, lastname, address1, city, state, province, type, postalcode) VALUES ('#variables.namer#', '#trim(form.firstname)#', '#trim(form.lastname)#', '#form.address#', '#form.city#', '#variables.stateVal#', '#trim(variables.province)#', 'ship', '#form.postalcode#') select max(addressid) as addressid from address where type = 'ship' and addressname = '#variables.namer#' and address1 = '#form.address#' and city = '#form.city#' Insert Into Users (userID, type, dateadd, email, dayphone, billinglocationid, shippinglocation1id, notes, password, sendemail, firstname, lastname, AcceptedWholeSaleAgreement ,DateAcceptedWholesale) VALUES(#maxid.idmax# + 1, 'Retail', '#dateformat(now(),"m/d/yyyy")# #timeformat(now(),"h:mm tt")#', '#form.email#', '#form.telephone#', #getbill.addressid#, #getship.addressid#, 'User added via wholsale inquiry form.', 'tastycoco', 'N', '#trim(form.firstname)#', '#trim(form.lastname)#', 10 ,'#dateformat(now(),"m/d/yyyy")# #timeformat(now(),"h:mm tt")#') INSERT into [contact-customer] (userid, firstname, lastname,company, relationship, heat, groups, dateadded, sentbulk) VALUES (#maxid.idmax# + 1, '#form.firstname#', '#form.lastname#', '#form.businessnamer#', 'Prospect', 3, 'Wholesale Customers', '#dateformat(now(),"m/d/yyyy")#', 'No') This message is from a tropicaltraditions.com web site user: Name: #trim(form.firstname)# #trim(form.lastname)# Business: #form.businessnamer# Email: #form.email# Telephone: #form.telephone# Fax: #form.fax# Address: #form.address# City: #form.city# State/Province: #variables.stateVal##variables.province# Zip: #form.postalcode# Country: #form.country# Interested in these products: #form.products# Information about their business: #form.businessinfo# Accepted Agreement?: YesNo THIS PERSON WOULD LIKE TO BE CONTACTED ASAP ABOUT THIS INQUIRY Wholesale Inquiries
BannerLeft.gif (1312 bytes) Wholesale Inquiries
BannerBottom.gif (366 bytes)
NavLeft.gif (1500 bytes)
The email address or password you entered is incorrect. Please try again, or have us send you your password by email -- click the link below. If you are registered with us as a wholesale client,
please log in.

E-Mail
Password
Forgot Password?

Hello #trim( Gettype.firstname )# #trim( Gettype.lastname )#!

To contact the wholesale department, use the form below, or call us at 1-866-311-COCO (2626) ext. 893. Thank you!

If you are not #trim( Gettype.firstname )# #trim( Gettype.lastname )#, please click here.

Wholesale Inquiries

For wholesale or bulk order inquiries, please fill out the form below:

Please tell us what products
you are interested in:
If you are interested in quotes on wholesale prices, please tell us a little bit about your business and how you plan to distribute the products. Please include the location of your business:
First Name
Last Name
Business Name
Email
Telephone
Fax
Street Address
City
State (if in the US)
Province (if outisde the US)
Zip/Postal Code
Country (if outside the US)
WHOLESALER AGREEMENT
You must agree to the Tropical Traditions Wholesale Agreement to be considered and approved as a wholesale purchaser.
 I Agree  I Disagree
Privacy Policy: Tropical Traditions has a very strict anti-spam policy. Ourselves the frequent victim of SPAM, we never give out email addresses to advertisers or to anyone outside our organization, but only use email addresses for internal communication within Tropical Traditions.