VirtueMart Forum

VirtueMart 2 + 3 => General Questions => Topic started by: wicko on April 06, 2021, 11:57:01 am

Title: System keeps sending email notifications
Post by: wicko on April 06, 2021, 11:57:01 am
Our site keeps sending email notifications for orders. This started a few dayts ago.
Site running:
Joomla 3.9.25
Virtuemart 3.8.8

Latest update was.
FOF 4

orders appear to be set to confirmed.

Why has this suddenly started to send confirmation emails all the time? How can I fix it to only send once?

David
Title: Re: System keeps sending email notifications
Post by: pinochico on April 06, 2021, 12:11:04 pm
Who know? :)

After basic instalation we send only one.
Title: Re: System keeps sending email notifications
Post by: jenkinhill on April 06, 2021, 12:17:41 pm
What payment plugin?
Title: Re: System keeps sending email notifications
Post by: wicko on April 06, 2021, 12:25:17 pm
We are just using the PayPal standard plugin.
V3.8.8
We do also use CMSmart One Page Checkout which is also up to date.

PHP 7.3

Not sure where else to look.

David
Title: Re: System keeps sending email notifications
Post by: Jörgen on April 06, 2021, 12:50:52 pm
Paypay is using new IP addresses, have You updated Your IPN check to use these new addresses. PayPal has sent several emails informing about this. Look here:
https://www.paypal-status.com/history/eventdetails/31029 (https://www.paypal-status.com/history/eventdetails/31029)

Jörgen @ Kreativ Fotografi
Title: Re: System keeps sending email notifications
Post by: wicko on April 06, 2021, 13:10:08 pm
Hi Jörgen
PayPal Standard doesn't use API details. These are only used for PayPay Pro and Express Checkout which we are not using.
Your PayPal link didn't open

David
Title: Re: System keeps sending email notifications
Post by: Jörgen on April 06, 2021, 13:27:22 pm
Quote
Your PayPal link didn't open

The link works for me. Just tested.
Quote
PayPal Standard doesn't use API details

I never talked about API details. Check out the link.

Jörgen @ Kreativ Fotografi
Title: Re: System keeps sending email notifications
Post by: wicko on April 06, 2021, 13:44:41 pm
Hi Jörgen
Thanks
Link did finally open. Was just taking a long time.
Still not sure what changes I need to make here. I do use Akeeba Admin Tools on the site but it is not blocking any IPs as this is mainly due to just admin access. There are restrictions for access certain directories from the front end but but these are just inbound and not restricting any IPs.
Dates mentioned on the page look about right for the time things started to appear. Perhaps this is part of the big PayPal changes as they are loosing eBay.

regards

David
Title: Re: System keeps sending email notifications
Post by: Jörgen on April 06, 2021, 13:52:58 pm
Paypal sends confirmation emails via IPN and these emails emanate from these IP addresses. If the IP address is not accepted by Your Paypal payment method, they will resend these emails.
There is a setting for turning off the IP check, not anything I would do I like the extra bit of security. There is in the VM 3.8 a setting to add new IP's for this check. Otherwise update, the new IP's have AFAIK been added to the PayPal payment option in the latest test release.

Jörgen
Title: Re: System keeps sending email notifications
Post by: wicko on April 06, 2021, 14:04:25 pm
Thanks Jörgen

ok got it.
See the field extra IPs for IPN check
I have added all the new IPs, separated by a comma. Hopefully that might help.
Thanks for pointing that out.

regards

David
Title: Re: System keeps sending email notifications
Post by: Jörgen on April 06, 2021, 14:06:16 pm
Will keep my fingers crossed.

Jörgen @ Kreativ Fotografi
Title: Re: System keeps sending email notifications
Post by: wicko on April 09, 2021, 09:20:49 am
No joy with these changes as still getting multiple notification emails and anoying customers. Odd that this suddenly started. Might have to look into alternative payment provider.

David
Title: Re: System keeps sending email notifications
Post by: Jörgen on April 09, 2021, 09:27:55 am
I am not defending PayPal in any way, but my experience för over 10 years is that standard PayPal for VM works like a charm.

Do You have any changes in Your server setup, blocking of IP's, CDN or something else that has been updated lately ?

Jörgen

Title: Re: System keeps sending email notifications
Post by: wicko on April 09, 2021, 09:39:53 am
I agree that Standard PayPal has worked a charm for many years. No changes made to the server. However I di use Akeeba Admin Tools t create a secure htaccess so if the incoming directory has changed then this would be blocked.
Otherwise not new changes to the server and only regular updates to Joomla core and other plugins as usual.
David
Title: Re: System keeps sending email notifications
Post by: Jörgen on April 09, 2021, 10:02:38 am
OK, then the admin tools would be a good starting point :)

Jörgen
Title: Re: System keeps sending email notifications
Post by: wicko on April 09, 2021, 12:44:21 pm
I can see that the order status are definitely being set to confirmed so looks like the PayPal status is being returned ok. The issue is that Virtuemart keeps sening the customer notifications that their order has been received. Must be someting else that keeps updating the order status and then sending the customer notifications.
Title: Re: System keeps sending email notifications
Post by: Jörgen on April 09, 2021, 12:50:01 pm
How does the order status log look like. Are the notifications logged ? Order edit view.

I guess paypal gets a error reply on the update URL which leed to more replies. This seem to be leading to your provider filtering traffic to and from your site.

Jörgen
Title: Re: System keeps sending email notifications
Post by: wicko on April 09, 2021, 13:01:44 pm
Hi Jörgen

For instance I see one of the latest order staus updated reported here.

Thursday, 08 April 2021 18:04    No   Pending   
Thursday, 08 April 2021 18:09    Yes   Confirmed   Your payment for order A75V0139 has been confirmed by PayPal
Thursday, 08 April 2021 18:15    Yes   Confirmed   Your payment for order A75V0139 has been confirmed by PayPal
Thursday, 08 April 2021 18:21    Yes   Confirmed   Your payment for order A75V0139 has been confirmed by PayPal
Thursday, 08 April 2021 18:27    Yes   Confirmed   Your payment for order A75V0139 has been confirmed by PayPal
Thursday, 08 April 2021 18:32    Yes   Confirmed   Your payment for order A75V0139 has been confirmed by PayPal
Thursday, 08 April 2021 18:39    Yes   Confirmed   Your payment for order A75V0139 has been confirmed by PayPal
Thursday, 08 April 2021 18:47    Yes   Confirmed   Your payment for order A75V0139 has been confirmed by PayPal
Thursday, 08 April 2021 19:00    Yes   Confirmed   Your payment for order A75V0139 has been confirmed by PayPal
Thursday, 08 April 2021 19:22    Yes   Confirmed   Your payment for order A75V0139 has been confirmed by PayPal
Thursday, 08 April 2021 20:05    Yes   Confirmed   Your payment for order A75V0139 has been confirmed by PayPal
Thursday, 08 April 2021 21:53    Yes   Confirmed   Your payment for order A75V0139 has been confirmed by PayPal
Friday, 09 April 2021 00:44    Yes   Confirmed   Your payment for order A75V0139 has been confirmed by PayPal
Friday, 09 April 2021 06:26    Yes   Confirmed   Your payment for order A75V0139 has been confirmed by PayPal

When I look at the tarnsaction logs they all appear the same.

Checked the server error logs and see nothing there.

David
Title: Re: System keeps sending email notifications
Post by: Jörgen on April 09, 2021, 13:05:08 pm
The call from Paypal is clearly coming through. It is the return call that does not get sent from VM. Probably caught by some filtering in htaccess, mayby CDN or otherwise from your host. This is usually not a VM issue.

As long as PayPal deos not see a correct return value PayPal will continue to send updates.

Jörgen @ Kreativ Fotgrafi
Title: Re: System keeps sending email notifications
Post by: AH on April 09, 2021, 14:07:38 pm
Look into any plugins you have - shipping - payments - cmsmart

The base VM paypal system does not continually send an email on a confirmed payment
Title: Re: System keeps sending email notifications
Post by: wicko on April 09, 2021, 14:40:42 pm
I keep it fairly simple
Using the PayPal standard plugin VM Payment - PayPal
Shipping is the standard  VM Shipment - By weight, ZIP and countries
Only additional plugin used is CMSmart one page checkout which is hanfdles the checkout and not the email confirmations.

I do get the follow errors on the update page
Update: :Extension: Could not parse http://virtuemart.net/releases/vm3/plg_vmpayment_eway_update.xml
Update: :Extension: Could not parse http://virtuemart.net/releases/vm3/plg_vmcustom_download_simple_update.xml

regards

David
Title: Re: System keeps sending email notifications
Post by: AH on April 09, 2021, 15:38:49 pm
Glad you kept it simple

Quote
Only additional plugin used is CMSmart one page checkout which is handles the checkout and not the email confirmations.

David, what you think handles the triggering of an email - is not the same as what actually triggers an email.  It is quite possible for a plugin to generate a trigger that affects a payment method and causes such behaviour that you have seen.

The trigger -
Code: [Select]
function plgVmConfirmedOrder
Can be incorrectly called by other plugins and cause the behaviour that you are experiencing

The default VM paypal plugin is tested widely and we do not see your problem.
Title: Re: System keeps sending email notifications
Post by: wicko on April 09, 2021, 16:32:47 pm
The site runs on
PHP 7.3.27
Joomla 3.9.25
VM 3.8.8

I would have thought that a confirmation email is sent by the system when an order is updates. The repeat confirmations are only send for confirmed orders.

Will also connect with CMSmart to see if they have anything that would be causing this. I thik CMSmart have recently been taken over by Cloodo and they have issue with their own account area so could be related.

David
Title: Re: System keeps sending email notifications
Post by: pinochico on April 09, 2021, 17:56:52 pm
Check CMSmart one page checkout
can call payment plugins triggers repeteally

After change VM 3.2 to 3.4 we have to change our payment Gopay plugin - we have the same problem
But Paypal plugin is core VM, then only one extensions who call payment triggers can be OPC, I think
Or wrong setup Paypal

About this issues in my head is no more :)
Title: Re: System keeps sending email notifications
Post by: AH on April 10, 2021, 09:43:27 am
Pinochio

It is not a wrong setup in PayPal - nothing changed there.

Title: Re: System keeps sending email notifications
Post by: wicko on April 19, 2021, 12:02:05 pm
Still no real joy with this. Not heard back from CMSmart regarding the One Page checkout.
It is odd as some orders get more notifications than others.
I will disable One Page checkout and use the Virtuemart default to see if this resovede the issue.

David
Title: Re: System keeps sending email notifications
Post by: wicko on May 05, 2021, 19:06:05 pm
I have had an updated list of IPNs from PayPal but this still has not fixed the issue.

This was the list:
66.211.170.66, 173.0.81.1, 173.0.81.0/24, 173.0.81.33, 173.0.81.65, 173.0.81.140, 64.4.240.0/21, 64.4.248.0/22, 66.211.168.0/22, 173.0.80.0/20, 91.243.72.0/23

having checked the paypal.1.log.php and see the following error
2021-05-01 16:52:19 ERROR validateIpnContent: Invalid IPN validation: NO ANSWER FROM PAYPAL
Title: Re: System keeps sending email notifications
Post by: GJC Web Design on May 05, 2021, 19:45:57 pm
ips like 64.4.240.0/21 are a range so if your inputting them this is a shed load of ip addresses ...    2048 in this case

I have switched off the IPN check on my clients sites till a better solution is found
Title: Re: System keeps sending email notifications
Post by: wicko on May 06, 2021, 12:06:37 pm
Ok so here is an update.

I have gone into PayPal and turned off IPN notifications. Then made a few test orders and I am still getting multiple notifications. I got 5 notifications as a customer within the first 5 minutes.

So when I then refunded the payments from PayPal I started to get multiple refund notifications from the site also. But I didn't update anything on the site so it must still be getting notificatiojs from PayPal even though I have turned it off. This is crazy.

Think we will be removing PayPal very soon and switching to another payment gateway.
Title: Re: System keeps sending email notifications
Post by: AH on May 06, 2021, 16:37:25 pm
From what I can tell

You cannot turn off IPN notifications via PayPal

It always sends the as VM sends the relevant URL for IPN responses
Title: Re: System keeps sending email notifications
Post by: GJC Web Design on May 06, 2021, 19:37:21 pm
Quote
You cannot turn off IPN notifications via PayPal
-> correct

Quote
I have switched off the IPN check on my clients sites till a better solution is found
-> turn off the IPN check in the VM Paypal plugin .. not Paypal
Title: Re: System keeps sending email notifications
Post by: wicko on May 07, 2021, 10:50:45 am
Yep set check to No in the VM PayPal plugin and also turned off in PayPal. But still getting regular confirmation emails.

What appears to be happening is when I created a test order on the site it sent an email to confirm. But then when the order was refunder via PayPal it then sent a Refund confirmation. Then for some reason it then send a confirmed email again and then a refund. If in some kind of loop.

I made 3 test orders yesterday and got over 90 notifications and they are still going but slowing down.

Title: Re: System keeps sending email notifications
Post by: Jörgen on May 07, 2021, 11:50:52 am
Sticking out my head right now, but I think you have to test without the CMSSmart checkout. It is a delicate plugin interaction that could give trouble if Your plugin does not make correct actions when called. All plugins are called and if some plugins take that call when it is adressed to someone else there will be trouble.

Otherwise there is some HTACCESS setting or setting doen by the host that blocks the return call to PalPal.

Jörgen @ Kreativ Fotografi
Title: Re: System keeps sending email notifications
Post by: wicko on May 07, 2021, 12:02:12 pm
I have full control over the htaccess. I use Akeeba Admin tools.
I have added
Code: [Select]
components/com_virtuemart/notify_preorder.php
components/com_virtuemart/notify.php
the the exceptions.

originally it had
Code: [Select]
administrator/components/com_virtuemart/notify.phpLets see if that make any difference
Title: Re: System keeps sending email notifications
Post by: AH on May 07, 2021, 16:42:07 pm
Quote
Look into any plugins you have - shipping - payments - cmsmart

The base VM paypal system does not continually send an email on a confirmed payment

April 9th and still we have no progress