Send Email Order to multiple buyers.

Hi Jason,

I have a site that basically allows members to sell items. A shopper can purchase items from multiple people at one time and checkout once.

I need to have the order receipt go to each seller. I have a foreign key setup in the cart columns that could link to the seller's account.

My question is how do I pull that email address on the confirm page? This of course would need to happen after the PayPal transaction is approved.

thx
Eric

You will need some hand coding to accomplish this.

you need to loop through the cart contents to return the IDs of the items purchased, convert the list of ID's to a comma separated list. For example:

<?php

while (!$eCart1->EOF())      {

    $cartItemsArr[] = $eCart1->DisplayInfo("ID");

  $eCart1->MoveNext();

}

$eCart1->MoveFirst();

$cartItems = implode(", ", $cartItemsArr);

?>

then use $cartItems in a recordset to return the email addresses that relate to the Ids


for example:

SELECT * FROM table WHERE ID IN($cartItems)

you c an use that recordset in the receipt mail.

if you need help accomplishing this, we can help in a premiere support appointment.

Thanks Jason! I will give it a try first.

Should the snippet of code go before the Universal Email code block?

thx
Eric

that snippet of code will need to be before the recordset and before the UE code block.

it is only an example though, and will need to be modified depending on your cart object name.

Thanks Jason!!

Jason,

I have not tested this yet by making a purchase, but I wanted to run this by you.

I have the code in place:
<?php
while (!$eCart1->EOF()) {
$cartItemsArr[] = $eCart1->DisplayInfo("cartClosetID");
$eCart1->MoveNext();
}
$eCart1->MoveFirst();
$cartItems = implode(", ", $cartItemsArr);
?>

The cart object is the default eCart1.

For the recordset I have:

mysql_select_db($database_connBLUR, $connBLUR);
$query_rsItemsCart = "SELECT * FROM closet WHERE closetID IN($cartItems)";
$rsItemsCart = mysql_query($query_rsItemsCart, $connBLUR) or die(mysql_error());
$row_rsItemsCart = mysql_fetch_assoc($rsItemsCart);
$totalRows_rsItemsCart = mysql_num_rows($rsItemsCart);

Does thi slook correct?

thx
Eric

yes, that looks correct

Hi Jason,

I did a test and I did not get any errors, but the email did not come thru for the sellers. I did get an order confirmation to the buyer.

Is there code I can add to the page to see what is taking place?

If we need to do this as a premier support session then go ahead and set that up please.

thx
Eric

If you add the following code to the payment success page, it will show all the session contents, this will include information about each email it tried to send and the status:

<?php @session_start; var_dump($_SESSION); ?>

if you want us to look into it in a premiere support incident, you will need to visit the support landing page to sign up for a premiere support session.

Hi Jason,

I did a support ticket with Ray and he got the setup and working.
Now PayPal has an issue with the client using Pro/Direct Payment so we have to go to PayPal Standard.

With PayPal Standard can we still accomplish this?
I would just need to move that code to the new confirm page, correct?

thx
Eric