Recover Cart Sales

[simplebaby]

So when I run this as a CRON job, I get this:

 

<table border="0" width="100%" cellspacing="0" cellpadding="2">

</table>

<table border="0" width="100%" cellspacing="0" cellpadding="2">

<tr class="dataTableHeadingRow" colspan="8">

<td class="dataTableHeadingRow" colspan="8"><form name="" action="http://www.simplebaby.com/xxx/recover_cart_sales.php?SID" method="post"></td>

</tr>

<tr class="dataTableHeadingRow">

<td class="dataTableHeadingContent" align="left" colspan="2" width="10%" nowrap>CONTACTED</td>

<td class="dataTableHeadingContent" align="left" colspan="1" width="15%" nowrap>DATE</td>

<td class="dataTableHeadingContent" align="left" colspan="1" width="30%" nowrap>CUSTOMER NAME</td>

<td class="dataTableHeadingContent" align="left" colspan="2" width="30%" nowrap>E-MAIL</td>

<td class="dataTableHeadingContent" align="left" colspan="2" width="15%" nowrap>PHONE</td>

</tr>

<tr class="dataTableHeadingRow">

<td class="dataTableHeadingContent" align="left" colspan="2" width="10%" nowrap> </td>

<td class="dataTableHeadingContent" align="left" colspan="1" width="15%" nowrap>ITEM</td>

<td class="dataTableHeadingContent" align="left" colspan="2" width="55%" nowrap>DESCRIPTION</td>

<td class="dataTableHeadingContent" align="center" colspan="1" width="5%" nowrap>QTY</td>

<td class="dataTableHeadingContent" align="right" colspan="1" width="5%" nowrap>PRICE</td>

<td class="dataTableHeadingContent" align="right" colspan="1" width="10%" nowrap>TOTAL</td>

</tr>

<tr bgcolor="FF9F9F">

<td class="dataTableContent" align="center" width="1%"><input type="checkbox" name="custid[]" value="418"></td>

<td class="dataTableContent" align="left" width="9%" nowrap><b>09/11/2013</b></td>

<td class="dataTableContent" align="left" width="15%" nowrap>09/10/2013</td>

<td class="dataTableContent" align="left" width="30%" nowrap><a href="http://www.simplebaby.com/xxx/customers.php?search=Johnson&SID">Rachel Johnson</a></td>

<td class="dataTableContent" align="left" colspan="2" width="30%" nowrap><a href="http://www.simplebaby.com/xxx/mail.php?selected_box=tools&customer=pxxx[email protected]&SID">proxxx[email protected]</a></td>

<td class="dataTableContent" align="left" colspan="2" width="15%" nowrap>850-791-8377</td>

</tr>

<tr class="dataTableRow">

<td class="dataTableContent" align="left" valign="top" colspan="2" width="12%" nowrap> </td>

<td class="dataTableContent" align="left" valign="top" width="13%" nowrap> </td>

<td class="dataTableContent" align="left" valign="top" colspan="2" width="55%" nowrap><a href="http://www.simplebaby.com/xxx4/categories.php?action=new_product_preview&read=only&pID=1065&origin=recover_cart_sales.php?page=&SID"><b>Eco Sprout Detergent - Sandalwood Vanilla 48oz</b></a></td>

<td class="dataTableContent" align="center" valign="top" width="5%" nowrap>1</td>

<td class="dataTableContent" align="right" valign="top" width="5%" nowrap>$13.95</td>

<td class="dataTableContent" align="right" valign="top" width="10%" nowrap>$13.95</td>

</tr>

<tr>

<td class="dataTableContent" align="right" colspan="8"><b>Cart Total: </b>$13.95</td>

</tr>

<tr>

<td class="dataTableContent" align="right" colspan="6"><a href="http://www.simplebaby.com/xxx/recover_cart_sales.php?action=delete&customer_id=418&tdate=30&sdate=1&SID"><img src="includes/languages/english/images/buttons/button_delete.gif" border="0" alt="Delete" title=" Delete "></a></td>

</tr>

<tr bgcolor="FF9F9F">

<td class="dataTableContent" align="center" width="1%"><input type="checkbox" name="custid[]" value="4"></td>

<td class="dataTableContent" align="left" width="9%" nowrap><b>09/04/2013</b></td>

<td class="dataTableContent" align="left" width="15%" nowrap>08/25/2013</td>

<td class="dataTableContent" align="left" width="30%" nowrap><a href="http://www.simplebaby.com/xxx/customers.php?search=Karr&SID"><font color=0000FF><b>Rachel Karr</b></font></a></td>

<td class="dataTableContent" align="left" colspan="2" width="30%" nowrap><a href="http://www.simplebaby.com/xxx/mail.php?selected_box=tools&customer=rxxx@hotmail.com&SID">rxxx@hotmail.com</a></td>

<td class="dataTableContent" align="left" colspan="2" width="15%" nowrap>817-483-6024</td>

</tr>

<tr class="dataTableRow">

<td class="dataTableContent" align="left" valign="top" colspan="2" width="12%" nowrap> </td>

<td class="dataTableContent" align="left" valign="top" width="13%" nowrap> </td>

<td class="dataTableContent" align="left" valign="top" colspan="2" width="55%" nowrap><a href="http://www.simplebaby.com/xxx/categories.php?action=new_product_preview&read=only&pID=1680&origin=recover_cart_sales.php?page=&SID"><b>Smoobee Blue Sky Magic No Cry Brush</b></a></td>

<td class="dataTableContent" align="center" valign="top" width="5%" nowrap>1</td>

<td class="dataTableContent" align="right" valign="top" width="5%" nowrap>$19.95</td>

<td class="dataTableContent" align="right" valign="top" width="10%" nowrap>$19.95</td>

</tr>

<tr>

<td class="dataTableContent" align="right" colspan="8"><b>Cart Total: </b>$19.95</td>

</tr>

<tr>

<td class="dataTableContent" align="right" colspan="6"><a href="http://www.simplebaby.com/xxx/recover_cart_sales.php?action=delete&customer_id=4&tdate=30&sdate=1&SID"><img src="includes/languages/english/images/buttons/button_delete.gif" border="0" alt="Delete" title=" Delete "></a></td>

</tr>

<tr>

<td class="dataTableContent" align="right" colspan="8"><hr align=right width=55><b>Grand Total: </b>$33.90</td>

</tr>

<tr>

<td colspan="8"><input type="submit" name="submit_button" value="Send E-mail"></td>

</tr>

<tr>

<td class="infoBoxContent"></form></td>

</tr>

</table>

<table border="0" width="100%" cellspacing="0" cellpadding="2">

</table>

<table border="0" width="100%" cellspacing="0" cellpadding="2">

<tr class="dataTableHeadingRow">

<td class="dataTableHeadingContent" align="left" colspan="1" width="15%" nowrap>CUSTOMER NAME</td>

<td class="dataTableHeadingContent" align="left" colspan="1" width="30%" nowrap> </td>

<td class="dataTableHeadingContent" align="left" colspan="1" width="25%" nowrap> </td>

<td class="dataTableHeadingContent" align="left" colspan="1" width="10%" nowrap> </td>

<td class="dataTableHeadingContent" align="left" colspan="1" width="10%" nowrap> </td>

<td class="dataTableHeadingContent" align="left" colspan="1" width="10%" nowrap> </td>

</tr>

<tr class="dataTableHeadingRow">

<td class="dataTableHeadingContent" align="left" colspan="1" width="15%" nowrap>ITEM</td>

<td class="dataTableHeadingContent" align="left" colspan="2" width="55%" nowrap>DESCRIPTION</td>

<td class="dataTableHeadingContent" align="center" colspan="1" width="10%" nowrap>QTY</td>

<td class="dataTableHeadingContent" align="right" colspan="1" width="10%" nowrap>PRICE</td>

<td class="dataTableHeadingContent" align="right" colspan="1" width="10%" nowrap>TOTAL</td>

</tr>

<tr>

<td class="dataTableContent" align="right" colspan="8"><b>Cart Total: </b>$0.00</td>

</tr>

<tr>

<td align="right" colspan="6"><a href="http://www.simplebaby.com/xxxx/recover_cart_sales.php?action=delete&customer_id=&tdate=30&sdate=1&SID"><img src="includes/languages/english/images/buttons/button_delete.gif" border="0" alt="Delete" title=" Delete "></a></td>

</tr>

<tr>

<td align="center" colspan="6"><a href="recover_cart_sales.php">[Click Here To Return]</a></td>

</tr>

</table>

 

Am I missing something that would make the admin email fully HTML formatted? The one that goes to the customer works just fine.

Edited September 19, 2013 by simplebaby

[dreaminggates]

Does anyone have a fix for this? I'm using v.3.1 and getting these errors at the top of the recover part page in Admin:

 

Warning: mysql_num_rows() expects parameter 1 to be resource, object given in /home/...admin/recover_cart_sales.php on line 348

 

Warning: mysql_num_rows() expects parameter 1 to be resource, object given in /home/.../admin/recover_cart_sales.php on line 391

 

Warning: mysql_num_rows() expects parameter 1 to be resource, object given in /home/.../admin/recover_cart_sales.php on line 413

[Guest]

I have seo url 5 installed, and I was wondering if there's a way to get the link in the emails to use the seo url instead of the basic oscommerce url?

[redrum]

Regarding how long time after the visit the email should be sent;
How can I change it to look back for a specific amount of hours, instead of days?

[brian_cee]

Has anyone figured out how to get Unsold Carts to record product attributes?

[misantropo]

On 11/14/2013 at 11:46 AM, dreaminggates said:

Does anyone have a fix for this? I'm using v.3.1 and getting these errors at the top of the recover part page in Admin:

 

Warning: mysql_num_rows() expects parameter 1 to be resource, object given in /home/...admin/recover_cart_sales.php on line 348

 

Warning: mysql_num_rows() expects parameter 1 to be resource, object given in /home/.../admin/recover_cart_sales.php on line 391

 

Warning: mysql_num_rows() expects parameter 1 to be resource, object given in /home/.../admin/recover_cart_sales.php on line 413

I think mysqli_num_row.... solve that

did some run recovery cart sales in php 7? i cant send emails

[♥raiwa]

It would be better to use the built in function:
tep_db_num_rows()

[misantropo]

1 hour ago, raiwa said:

It would be better to use the built in function:
tep_db_num_rows()

👌

[misantropo]

About my question.

I can't work recover cart sales with php 7.

It looks good, without errors, but don't send emails, return with same customers without notify

Edited December 24, 2019 by misantropo