Abandoned Carts‎ > ‎Configuration‎ > ‎

Troubleshooting Guide

There are a few common issues when people try to use this module. I will detail every one and how to fix them.

  • The Abandoned Cart need you have the CRON correctly configured and pointing to your Magento root folder like we explain here.
  • You have to fill ALL the fields in our settings page (System -> Configuration -> Ebizmarts Abandoned Cart) read more here.

If you want to force sending emails before the time you have set up (the minimum it's 1 hour) you can install the AOE Scheduler extension (download here)

Then you have to edit the values in the database. You should have access to a MySql browser like PhpMyAdmin.

If you have an abandoned cart you can check for your email. like this query below:

select * from sales_flat_quote where customer_email = 'myemail@domain.com';

PhpMyAdmin


Then you should edit the value updated_at to the date that correspond with your configuration settings.

Example: I set up the abandoned cart module to send an email one hour after my client leave the cart and the date now is 20:37 of 2013-06-18.
So I should edit the value to 2013-06-18 19:37:00 (to edit click the pens image above)

Keep in mind if you are not on the first email, that the configured days are from the moment when the cart was originally abandoned so you need to rest the days of previous emails configurations.

Example: I set the first email for 1 hour and the second for 1 day and the date now is 20:37 of 2013-06-18.
So the value I should set on updated_at field is some time after 21:37 of 2013-06-17 (23 hours after last update) because the last time this field was updated was one hour after the cart was abandoned.

Another values you should also check are the ebizmarts_abandonedcart_counter (Has to be lower than the Max number of emails to send option)
And check that the is_active value be 1 this means that it's an abandoned cart and was not converted into an order. In this situation the is_active value will be 0 and the Abandoned Cart email won't be sent.

Once this is done you can run the ebizmarts_abandoned_cart CRON process with the AOL Scheduler extension.

Go to System -> Scheduler -> Schedule Configuration
Find the ebizmarts_abandoned_cart process check it and choose the "Run Now" option from the Actions dropdown and click "Submit" like it's shown below:

AOL Scheduler


If you have any problem or doubt doing this please post in our forum and we will reply asap



SQL ERROR: Column not found 1054 'sales_flat_order.ebizmarts_abandonedcart_flag' in 'where clause'

This could be caused by a failure during MageMonkey install.
Please back everything up (files and database), and take a look at this post:

http://ebizmarts.com/forums/topics/view/6339


Verify your Abandoned Cart Templates assigned in database

In case you need to check that your Transactional Email Templates for the Abandoned Cart module are correctly assigned, you can execute this query into your database to double check that:

SELECT * FROM core_config_data WHERE path LIKE '%abandonedcart/general/template%';

You'll be able to check "scope", "scope_id", "value" to ensure that they're assigned correctly.





I can't see Abandoned Cart Templates

To solve this you should create new templates at System -> Transactional Emails.
Here are the default emails for abandoned cart.

First Abandoned Cart Mail


<body style="background:#F6F6F6; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:12px; margin:0; padding:0;">
<div style="background:#F6F6F6; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:12px; margin:0; padding:0;">
    <table cellspacing="0" cellpadding="0" border="0" width="100%">
        <tr>
            <td align="center" valign="top" style="padding:20px 0 20px 0">
                <table bgcolor="#FFFFFF" cellspacing="0" cellpadding="10" border="0" width="650" style="border:1px solid #E0E0E0;">
                    <!-- [ header starts here] -->
                    <tr>
                        <td valign="top"><a href="{{store url=""}}"><img src="{{var logo_url}}" alt="{{var logo_alt}}" style="margin-bottom:10px;" border="0"/></a></td>
                    </tr>
                    <!-- [ middle starts here] -->
                    <tr>
                        <td valign="top">
                            <h1 style="font-size:22px; font-weight:normal; line-height:22px; margin:0 0 11px 0;"">Hello, {{htmlescape var=$name}}</h1>
                            <p style="font-size:12px; line-height:16px; margin:0;">
                                You have an abandoned cart at {{var store.getFrontendName()}}.
                                We would be glad to help you feel comfortable with our checkout process. if you are having technical issues contact us at <a href="mailto:{{config path='trans_email/ident_support/email'}}" style="color:#1E7EC8;">{{config path='trans_email/ident_support/email'}}</a> or call us at <span class="nobr">{{config path='general/store_information/phone'}}</span> Monday - Friday, 8am - 5pm PST.
                                <br>You can access your cart <a href="{{var url}}" style="color:#1E7EC8;">here</a>.
                                {{depend couponcode}}
                                <br>You can use this coupon code <b>{{var couponcode}}</b>
                                {{/depend}}
                                {{depend discount}}
                                and obtain a discount of {{var discount}} only until {{var todate}}
                                {{/depend}}
                            </p>
                    </tr>
                    <tr>
                        <td>
                            {{block type='ebizmarts_abandonedcart/email_order_items' area='frontend' template='ebizmarts_abandonedcart/email/order/items.phtml' quote=$quote}}
                        </td>
                    </tr>
                    <tr>
                        <td bgcolor="#EAEAEA" align="center" style="background:#EAEAEA; text-align:center;"><center><p style="font-size:12px; margin:0;">Thank you, <strong>{{var store.getFrontendName()}}</strong></p></center></td>
                    </tr>
                    <tr>
                        <td>You can unsubscribe from this email clicking <a href="{{var unsubscribeurl}}" style="color:#1E7EC8;">here</a>.</td>
                    </tr>
                </table>
            </td>
        </tr>
    </table>
</div>
</body>


Second Abandoned Cart Mail


<body style="background:#F6F6F6; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:12px; margin:0; padding:0;">
<div style="background:#F6F6F6; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:12px; margin:0; padding:0;">
    <table cellspacing="0" cellpadding="0" border="0" width="100%">
        <tr>
            <td align="center" valign="top" style="padding:20px 0 20px 0">
                <table bgcolor="#FFFFFF" cellspacing="0" cellpadding="10" border="0" width="650" style="border:1px solid #E0E0E0;">
                    <!-- [ header starts here] -->
                    <tr>
                        <td valign="top"><a href="{{store url=""}}"><img src="{{var logo_url}}" alt="{{var logo_alt}}" style="margin-bottom:10px;" border="0"/></a></td>
                    </tr>
                    <!-- [ middle starts here] -->
                    <tr>
                        <td valign="top">
                            <h1 style="font-size:22px; font-weight:normal; line-height:22px; margin:0 0 11px 0;"">Hello, {{htmlescape var=$name}}</h1>
                            <p style="font-size:12px; line-height:16px; margin:0;">
                                You have an abandoned cart at {{var store.getFrontendName()}}.
                                Please remember our stock is not unlimited, it is recommended to take advantage of this great opportunity to get your desired products in the comfort of your home.
                                <br>You can access your cart <a href="{{var url}}" style="color:#1E7EC8;">here</a>.
                                {{depend couponcode}}
                                <br>You can use this coupon code <b>{{var couponcode}}</b>
                                {{/depend}}
                                {{depend discount}}
                                and obtain a discount of {{var discount}} only until {{var todate}}
                                {{/depend}}
                                <br>If you have any questions about your order please contact us at <a href="mailto:{{config path='trans_email/ident_support/email'}}" style="color:#1E7EC8;">{{config path='trans_email/ident_support/email'}}</a> or call us at <span class="nobr">{{config path='general/store_information/phone'}}</span> Monday - Friday, 8am - 5pm PST.
                            </p>
                    </tr>
                    <tr>
                        <td>
                            {{block type='ebizmarts_abandonedcart/email_order_items' area='frontend' template='ebizmarts_abandonedcart/email/order/items.phtml' quote=$quote}}
                        </td>
                    </tr>
                    <tr>
                        <td bgcolor="#EAEAEA" align="center" style="background:#EAEAEA; text-align:center;"><center><p style="font-size:12px; margin:0;">Thank you, <strong>{{var store.getFrontendName()}}</strong></p></center></td>
                    </tr>
                    <tr>
                        <td>You can unsubscribe from this email clicking <a href="{{var unsubscribeurl}}" style="color:#1E7EC8;">here</a>.</td>
                    </tr>
                </table>
            </td>
        </tr>
    </table>
</div>
</body>

Third Abandoned Cart Mail


<body style="background:#F6F6F6; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:12px; margin:0; padding:0;">
<div style="background:#F6F6F6; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:12px; margin:0; padding:0;">
    <table cellspacing="0" cellpadding="0" border="0" width="100%">
        <tr>
            <td align="center" valign="top" style="padding:20px 0 20px 0">
                <table bgcolor="#FFFFFF" cellspacing="0" cellpadding="10" border="0" width="650" style="border:1px solid #E0E0E0;">
                    <!-- [ header starts here] -->
                    <tr>
                        <td valign="top"><a href="{{store url=""}}"><img src="{{var logo_url}}" alt="{{var logo_alt}}" style="margin-bottom:10px;" border="0"/></a></td>
                    </tr>
                    <!-- [ middle starts here] -->
                    <tr>
                        <td valign="top">
                            <h1 style="font-size:22px; font-weight:normal; line-height:22px; margin:0 0 11px 0;"">Hello, {{htmlescape var=$name}}</h1>
                            <p style="font-size:12px; line-height:16px; margin:0;">
                                You have an abandoned cart at {{var store.getFrontendName()}}.
                                {{depend couponcode}}
                                <br>You were chosen to receive a coupon which can be used with this code <b>{{var couponcode}}</b>
                                {{/depend}}
                                {{depend discount}}
                                and obtain a discount of {{var discount}} only until {{var todate}}
                                {{/depend}}
                                <br>You can access your cart <a href="{{var url}}" style="color:#1E7EC8;">here</a>.
                                <br>If you have any questions about your order please contact us at <a href="mailto:{{config path='trans_email/ident_support/email'}}" style="color:#1E7EC8;">{{config path='trans_email/ident_support/email'}}</a> or call us at <span class="nobr">{{config path='general/store_information/phone'}}</span> Monday - Friday, 8am - 5pm PST.
                            </p>
                    </tr>
                    <tr>
                        <td>
                            {{block type='ebizmarts_abandonedcart/email_order_items' area='frontend' template='ebizmarts_abandonedcart/email/order/items.phtml' quote=$quote}}
                        </td>
                    </tr>
                    <tr>
                        <td bgcolor="#EAEAEA" align="center" style="background:#EAEAEA; text-align:center;"><center><p style="font-size:12px; margin:0;">Thank you, <strong>{{var store.getFrontendName()}}</strong></p></center></td>
                    </tr>
                    <tr>
                        <td>You can unsubscribe from this email clicking <a href="{{var unsubscribeurl}}" style="color:#1E7EC8;">here</a>.</td>
                    </tr>
                </table>
            </td>
        </tr>
    </table>
</div>
</body>