Email to admin for recovered carts not sent

Hi,

I have tried to replicate the issue at our end. But unfortunately I am unable to reproduce the same. I am able to receive recovery email once I had placed an order from abandoned cart reminder email. Please check the screenshot: https://www.screencast.com/t/wzZeLwfhAFo

I had gone through the code and we found an issue with the “wp_” prefix when we are sending a recovery email to Admin.

So, could you please change the below code in line number 1390 to 1398 in the “woocommerce-ac.php” file? The file will be present in the plugin’s core “woocommerce-abandoned-cart” folder.

function wcal_check_order_is_recovered( $wcal_order_id ) {
global $wpdb;
$wcal_recover_order_query = “SELECT recovered_cart FROM `
” . $wpdb->prefix .
“ac_abandoned_cart_history_liteWHERErecovered_cart` = %d”;
$wcal_recover_order_query_result = $wpdb->get_results( $wpdb->prepare(
$wcal_recover_order_query, $wcal_order_id ) );
if( count( $wcal_recover_order_query_result ) > 0 ) {
return true;
}
return false;
}

If still if you face the same issue then kindly drop your email drop us an email on “support at tychesoftwares dot freshdesk dot com” where we can more communicate on it and give the fix for this.

Regards,
Chetna Bhutka

Hello, @chetnapatel

I’m trying to change the code you have shared, but when I go my code app to do it, I don’t know if it will be fine. Could you please check this screenshot?

https://i65.tinypic.com/28bxkk5.jpg

Hi,

Thank you for sharing the screenshot with us.

The code which you have added is quite wrong. As you have not added quote for table name. I am attaching the screenshot for your reference. You would need to do some changes on your website.

Please see the screenshot of it: https://www.screencast.com/t/FG9egSfL5Vif

If you do not comfortable to make the changes then kindly drop your email on our ticketing system (support at tychesoftwares dot freshdesk dot com ). So, I can provide you the plugin file.

Regards,
Chetna Bhutka