Integrating Constant Contact into PayPal checkout

I'm trying to reintegrate a call to Constant Contact if the "add me to your newsletter" checkbox is selected during checkout. I had it working in the previous version that was local checkout, so I have all the Constant Contact routines to put on the checkout success page. I just need to trigger that if the checkbox is selected. How do I check (or store and check) a cookie or session variable since I'm going to PayPal and back?

This is the code I have for my newsletter checkbox:

<input name="emailList" type="checkbox" id="emailList" value="1" >
        <label for="emailList" class="sublabel">Please add me to your email list.</label>

Just save the checkbox value into the session using the posted checkbox form field as the trigger. That will only save it when it is checked and you can check the session variable value on the paypal confirm page.

What server behavior do I use to save the session and on which page do I put it?

You could use the "Set Session Value" server behavior in the cookies section and set it on the confirm_cart.php page.

Getting closer. I can't see a way to use the posted checkbox form as the trigger. My options are: any form post, before page load, eCart is empty/not empty. Could I use before page load? And further - what value do I specify?

If you add the checkout form to the bindings for the confirm_cart page from the bindings panel first, then you can use the lightning bolt to set the trigger to the form element.

Come to think of it since you are using the latest version of eCart the entire checkout form is automatically saved in the persistent form, so you can just reference it from the pp_confirm page already from the persisted value.

Not working yet. I think it might be because the session variables I'm using to get the info for Constant Contact (first & last name, email) are using the eCart 5 syntax instead of eCart 6. This is what I now have:

$theEmail = ((isset($_SESSION["eCartCheckoutForm_email"]))?$_SESSION["eCartCheckoutForm_email"]:"");
	$theFirstName = "";
	$theLastName = ((isset($_SESSION["eCartCheckoutForm_firstname"]))?$_SESSION["eCartCheckoutForm_firstname"]:"")." ".((isset($_SESSION["eCartCheckoutForm_lastname"]))?$_SESSION["eCartCheckoutForm_lastname"]:"");

I'm not sure of the workflow and couldn't find where sessions are set. I've attached my checkout, confirm, confirm_cart, and pp_confirm pages for your review.

You should be able to refer to whether the email checkbox was checked or not with:
WA_getSavedFormValue("CheckoutWizard_Sharp_Default","emailList");

and then the email address would be:
WA_getSavedFormValue("CheckoutWizard_Sharp_Default","Email_Address")

and the name would be:
WA_getSavedFormValue("CheckoutWizard_Sharp_Default","First_Name")
WA_getSavedFormValue("CheckoutWizard_Sharp_Default","Last_Name")

So your code might look like:

<?php

if (WA_getSavedFormValue("CheckoutWizard_Sharp_Default","emailList")) {

    $theEmail = WA_getSavedFormValue("CheckoutWizard_Sharp_Default","Email_Address");

    $theFirstName = WA_getSavedFormValue("CheckoutWizard_Sharp_Default","First_Name");

    $theLastName = WA_getSavedFormValue("CheckoutWizard_Sharp_Default","Last_Name");

    $theFullName = $theFirstName . " " . $theLastName;

   // constant contact code here

}

?>

After applying those changes, I now get the message "Column 'email_list' cannot be null" on the pp_confirm page. The email is being stored in the database in the Customers table. I've attached that page.

Any ideas on what's going wrong?

I'll contact you for a premier support ticket to look into what is going on and get it fixed.