[AccessD] OT: Affiliate Program

Rocky:

Are you using "classic" PayPal or PayPal Payments Pro? If you're using
classic, then this is a bit of a problem, since not everyone clicks on the
"return to store" button to return to your site (you could have the handling
code on your landing page). 

Do you generate an order or customer record before going to PayPal? If so,
then you could update the record before they go to PayPal. 

Have you checked out other payment gateways such as Authorize.Net? I've seen
some resellers advertise them at 25/month + trans fees ... Their advantage
is that your customer stays on your site. PayPal Pro Payments is similar in
price and capabilities, but is much harder to implement AND they have an
extemely strict validation routine, which occassionally reject valid CC's
because of problems with the address (str instead of Street for example). 

Let me know if you have any questions.

Larry Mrazek
LCM Research, Inc.
www.lcm-res.com
lmrazek at lcm-res.com
ph. 314-432-5886
fx. 314-432-3304

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin -
Beach Access Software
Sent: Friday, February 10, 2006 9:44 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] OT: Affiliate Program

Larry:

We use PayPal for ordering.  When they click on the Order Button they go to
the paypal page where they may or may not complete the order.  Does this
make the cookie approach problematical?

TIA

Rocky


Lawrence Mrazek wrote:
> Hi Rocky:
>
> If she is constructing the links, could she add a query string to the 
> URL
> (EX: http://www.thesleepadvisor.com/index.asp?AffiliateID=1)? 
> Depending on your server model, then you could add code to 
> automatically detect the query string and log it to a database/session 
> variable/cookie (using server side code). Then on a successful order, 
> your system looks for the db value/session variable/cookie and adds it to
the order record.
>
> Hope this helps. 
>
> Larry Mrazek
> LCM Research, Inc.
> www.lcm-res.com
> lmrazek at lcm-res.com
> ph. 314-432-5886
> fx. 314-432-3304
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky 
> Smolin - Beach Access Software
> Sent: Friday, February 10, 2006 12:54 AM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] OT: Affiliate Program
>
> Dear List:
>
> I have a web site where we are selling The Sleep Advisor 
> (www.thesleepadvisor.com).  Someone with an alternative health site 
> has proposed to promote The Sleep Advisor on her site and send folks 
> to our site. She asks if we have an affiliate program.  Which we ain't.
>
> I looked into it a bit and it doesn't look trivial. Basically we need 
> a way to know if someone visiting our site and buying The Sleep 
> Advisor originated from her site.  We're hosted by Affinity and have 
> Urchin statistics but I don't see anything there that would be helpful
right off.
>
> Does anyone know a slick, quick way to do this?
>
> MTIA
>
> Rocky
>
> --
> Rocky Smolin
> Beach Access Software
> 858-259-4334
> www.e-z-mrp.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
>
>   

--
Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com