send abandoned car emails on multiste

  • Hi,

    I was looking at cron jobs on my multisite and I noticed that the send_abandoned_cart_emails function that is hooked to the abandoned_cart_cron_hook tries to query {dbprefix}_{siteprefix}_users table from the database, while it should query {dbprefix}_users table, because the users table is a global table on multisite.
    I suggest in file /wp-content/plugins/mailjet-for-wordpress/src/includes/SettingsPages/WooCommerceSettings.php line 649 (send_abandoned_cart_emails function), you change the line:

    LEFT JOIN ' . $wpdb->prefix . 'users AS wpuser ON cart.user_id = wpuser.id

    to:

    LEFT JOIN ' . $wpdb->base_prefix . 'users AS wpuser ON cart.user_id = wpuser.id

    Please let me know if it is OK.

    Thank you

  • The topic ‘send abandoned car emails on multiste’ is closed to new replies.