Jump to content
Met00

Recover Cart Sales

Recommended Posts

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=pxxxty@gmail.com&SID">proxxxy@gmail.com</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 by simplebaby

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×