SMS Alert Plugin Compatibility

Hey @cozyvision1 thanks for letting us know, this is an excellent news! ??
We will look into this and I guess will give it a closer look in the upcoming weeks as at the moment it’s quite busy ??
Stay safe!

@cozyvision1 is the plugin compatible with @streamlinestar CartBounty.

I have been using SMS Alert for my COD Verification and would like to sms for Abandoned Cart as well?

Looking forward.

@streamlinestar PLease note, i have installed your plugin as well.

Yes, SMS Alert works with Cartbounty.

However if you have any questions regarding SMS Alert, please feel free to ask us at our Forum

• This reply was modified 4 years, 7 months ago by Cozy Vision.

Hi @pratikpai21,

Thanks for your question however it seems like this question had to be asked in this forum (https://www.ads-software.com/support/plugin/sms-alert/) since we are not really able to help you in setting up SMS Alert plugin as we are not the team behind it’s development ??

Best wishes and stay safe! <3

I have installed the “CartBounty – Save and recover abandoned carts for WooCommerce”

But unable to get the abandoned cart email kindly help me with this concern.

I also have the SMS Alert plugin where they have provision to send sms of an abandoned cart, that also not work and when I have talked on the SMS alert support they told me that “CartBounty – Save and recover abandoned carts for WooCommerce” not working properly so this plugin integrated with the hook so it will work once

“CartBounty – Save and recover abandoned carts for WooCommerce” work so please do the need full.

Sanjay

• This reply was modified 4 years, 6 months ago by sanjayemmbros.

Hi @sanjayemmbros

Thanks for reaching out.
Our Free version, as stated in the description of our plugin, only saves abandoned cart data and presents it to you. If you would like to integrate with MailChimp or ActiveCampaign to send out automated emails, you should consider upgrading to our Pro version.

About the SMS alert plugin, unfortunately we are not familiar with it and the way it works. We haven’t changed or in any way modified our product to suit that plugin. Our official way of sending SMS messages is via ActiveCampaign or MailChimp.

Warm regards,
Nauris

Hi @nauriskolats,

I can understand that you might not have checked SMS Alert.

But we feel there is a small issue in the plugin, which other users might be facing.

Your Free version Plugin sends an email to admin for abandoned carts

We are using that same hook to trigger sms whenever abandoned cart email is sent to admin, which is working fine for many of our users.

But it did not worked for a few customers like @sanjayemmbros

We firstly asked them to raise it to you as the admin email was not getting triggered(which we feel is a part of your plugin), but unfortunately as the user did not got a satisfactory revert from here, we took it forward and peeped into your code.

In woo-save-abandoned-carts\admin\class-cartbounty-admin.php

line 533

you are using something like below

$rows_to_email = $wpdb->get_var(
"SELECT COUNT(id) FROM ". $table_name ."
WHERE mail_sent = 0 AND cart_contents != '' AND time < (NOW() - INTERVAL ". CARTBOUNTY_STILL_SHOPPING ." MINUTE)"
);

but as you know many users are on shared hosting and do not have access to server, so they can not change servers time zone(for my sql), but the website has a different timezone(wordpress).

In short we think mysql “NOW()” should be replaced by php date function, something like below

$timezone =  wp_timezone_string();
$datetime =  get_gmt_from_date('UTC'.$timezone);
		
$time_interval = date('Y-m-d H:i:s',strtotime('-'.CARTBOUNTY_STILL_SHOPPING.' Minutes',strtotime($datetime)));
		
// Retrieve from database rows that have not been e-mailed and are older than 60 minutes
$rows_to_email = $wpdb->get_var(
	"SELECT COUNT(id) FROM ". $table_name ."
	WHERE mail_sent = 0 AND cart_contents != '' AND time < '". $time_interval."'"
);

Do let us know if any issues.

• This reply was modified 4 years, 6 months ago by Cozy Vision.

Hi @cozyvision1

Thanks for your input.
Up until now our users have never been reporting issues with receiving email notifications due to server time zones however you have pointed out a valuable tip and we will surely look into it if this is something we could change.

Thank you!

Hey @cozyvision1
Thanks for your help and assistance with the time function!
We have changed all SQL NOW() functions into local time functions that will no longer rely on the server’s time.

Hopefully it solves some of the sync issues your clients are having as well.

Best,
Nauris