DragonflyCMS Projects > Storez > Paypal problem > Community Forums > Phoenix Netology
Forum Index > eCommerce > Storez

Paypal problem Reply to topic

On making an order everything goes through properly right up until the paypal part. When I click on the paypal link I'm sent to a page which displays "This invoice has already been paid. For more information, please contact the merchant."

This is with all customers who are purchasing items even though they aren't logged into paypal at the time. No paypal payment has been received at our merchant end.

Please enter your server specs in your user profile! 😢

I have fixed this problem by using a previous version. The version I was using was the current beta 9.1.2.1 beta3 which reports as beta2 on my modules although I downloaded it and tried again the problem was still present.

I'm not sure of what version I have but it has fixed my problem.

Please enter your server specs in your user profile! 😢

This is strange I managed to make one order then I went to test again and again I'm unable to order and the message says that the invoice has already been paid.

Please enter your server specs in your user profile! 😢

hmm, I'm a bit out of touch with Storez lately but that suggests that somehow a new invoice number isn't being generated for the next order.

I haven't encountered that problem in extensive testing Confused

• Donations & Audit for DragonflyCMS •

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):

Phoenix wrote
hmm, I'm a bit out of touch with Storez lately but that suggests that somehow a new invoice number isn't being generated for the next order.

I haven't encountered that problem in extensive testing Confused


On admin side they are coming through:

admin.php?op=Storez&mode=CartOrderView&orderID=15
admin.php?op=Storez&mode=CartOrderView&orderID=16
admin.php?op=Storez&mode=CartOrderView&orderID=17

User side:
Storez/orders/op=viewReceipt/orderID=15.html
Storez/orders/op=viewReceipt/orderID=16.html
Storez/orders/op=viewReceipt/orderID=17.html

The problem appears to be paypal creating the same link for every order if that makes sense?

Please enter your server specs in your user profile! 😢

As I recall, Storez actually provides the invoice number to PayPal - sounds like something in your system has gotten out of sequence, perhaps some edited files.

I'll have a look when I get a chance. The MwA issue has taken a chunk of my time atm Sad

• Donations & Audit for DragonflyCMS •

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):

Phoenix wrote
As I recall, Storez actually provides the invoice number to PayPal - sounds like something in your system has gotten out of sequence, perhaps some edited files.

I'll have a look when I get a chance. The MwA issue has taken a chunk of my time atm Sad


I haven't changed anything apart from the store image, the only thing I did was to add products.

In regards to the MwA its very disappointing as a user I hope someone can continue especially with the forumspro project.

Please enter your server specs in your user profile! 😢

hmm, the mismatch will be in your database.

There is probably some un-processed invoice that has thrown the system out of whack - I could understand it happening if the database had been edited directly.

The invoice paypal receives and checks against is based on the orderID in table cms_cart_orders - the reason you have the error is because PayPal has already received an order with an orderID lower than one it has already received. It is coded to do that check to help prevent paypal fraud.

The simplest fix for now is check the last known invoice number accepted by PayPal (orderID is the number after the #) and check that against the auto-increment value for the table cms_cart_orders - using phpmyadmin, I would increase that value to a number above the value indicated on the invoice.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):

All the orders are currently test orders from me, last night I was able to pay for one order after this problem started, after I paid for the order I posted here it was fixed (this is when I posted about uploading a previous version) I then tried another test order only for the problem to arise again. I'll completely empty out the cms_cart_orders and see how it goes.

Please enter your server specs in your user profile! 😢

Completely emptied the cms_cart_orders and tried to make an order, I received the error even though the system now thinks none have ever been made.

Please enter your server specs in your user profile! 😢

This is really starting to annoy me, I completely trashed the entire module, re uploaded the beta3 and still I have the same problem. 😢 On my very first order.

Please enter your server specs in your user profile! 😢

Really, it's more a PayPal issue than anything else.

Are you using confirmed account details in PayPal?

Have you tried changing your PayPal invoice options?

Are you actually using the PayPal sandbox?

• Donations & Audit for DragonflyCMS •

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):

Yes I have been using this account for 5 years with paypal.
I haven't looked at paypals invoice options I'll try that.
Not using sandbox just normal procedure.

Please enter your server specs in your user profile! 😢

Nothing I do works.

Its strange that it works properly at first and now just decided to be temperamental.

Please enter your server specs in your user profile! 😢

Good news, I think???

After trying many things I have just managed to create the issue - in my case, by generating an order, then cancelling it. Still more work to do to see if that was just a fluke after countless tests, and what needs to happen to eliminate it.

• Donations & Audit for DragonflyCMS •

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):

All times are Australia/Adelaide


Jump to:

Terms of Use : Phoenix Netology : © 2004 - 2021
Interactive software released under GNU GPL, Code Credits, Privacy Policy