search

uWebshop / -INACTIVE-uWebshop-Core

[INACTIVE] The source of the uWebshop E-Commerce module for Umbraco
MIT License
12 stars 14 forks source link

Order lost in the database, ids get scrambled in the payment providers. #64

Open gardarthorsteins opened 9 years ago

gardarthorsteins commented 9 years ago

Hi,

I'm having the strangest problem.

We have had 2 orders get lost in the last month.

This seems to happen this way :

  1. User adds product/s to basket
  2. Chooses to pay with paypal
  3. Goes to Paypal site but cancels.
  4. User repeats these steps one more time.
  5. User chooses another payment provider (creditcard)
  6. Payment is successfull but the order is not updated to ready to dispatched.

In steps 1,2,3 the user get ID for the order and when he cancels the ID is changed to a new one.

when the user does this the second time he suddenly gets 2 new ids somehow. the new ID he gets is not created in the database but is somehow used in step 5 and 6.

So when the payment provider is trying to update the order in step 6 it cannot find it.

Here is complete logging of this :

First time trying to pay with paypal

ERROR uWebshop.Umbraco6.UmbracoLoggingService - [Thread 52] PayPal - CreatePaymentRequest Hit INFO Umbraco.Extensions.Events.Order - OrderInfo_OrderStatusChanged Hit: 01af66f3-e3ac-441b-908a-cf5983728773 status:WaitingForPayment AfterStatus:WaitingForPayment INFO Umbraco.Extensions.Events.Order - OrderInfo_OrderStatusChanged Hit: 01af66f3-e3ac-441b-908a-cf5983728773 status:Confirmed AfterStatus:WaitingForPayment INFO Umbraco.Extensions.Events.Order - OrderInfo_OrderStatusChanged Hit: fee85935-2e8a-4d98-9d23-769147bf10fa status:Incomplete AfterStatus:Incomplete

Second time trying to pay with paypal

ERROR uWebshop.Umbraco6.UmbracoLoggingService - [Thread 54] PayPal - CreatePaymentRequest Hit INFO Umbraco.Extensions.Events.Order - OrderInfo_OrderStatusChanged Hit: fee85935-2e8a-4d98-9d23-769147bf10fa status:WaitingForPayment AfterStatus:WaitingForPayment INFO Umbraco.Extensions.Events.Order - OrderInfo_OrderStatusChanged Hit: fee85935-2e8a-4d98-9d23-769147bf10fa status:Confirmed AfterStatus:WaitingForPayment

These next 2 lines I dont understand. these IDS are not in the database.

INFO Umbraco.Extensions.Events.Order - OrderInfo_OrderStatusChanged Hit: 224af69c-d38d-45b4-8c10-45bcdf8074ae status:Incomplete AfterStatus:Incomplete INFO Umbraco.Extensions.Events.Order - OrderInfo_OrderStatusChanged Hit: 8e2bc3ea-f612-484c-9848-436ab97231fc status:Incomplete AfterStatus:Incomplete

User successfully pays with credit card (you can see it uses the ID 8e2bc... that does not exist in the database. the only order I see has the ID fee85935..... and the status is waiting for payment):

ERROR uWebshop.Umbraco6.UmbracoLoggingService - [Thread 75] Borgun API Payment Provider - CreatePaymentRequest Start INFO Umbraco.Extensions.Events.Order - OrderInfo_OrderStatusChanged Hit: 8e2bc3ea-f612-484c-9848-436ab97231fc status:WaitingForPayment AfterStatus:WaitingForPayment ERROR uWebshop.Umbraco6.UmbracoLoggingService - [Thread 75] BorgunPaymentResponseHandler Hit ERROR uWebshop.Umbraco6.UmbracoLoggingService - [Thread 75] BorgunPaymentResponseHandler orderInfo.UniqueOrderId: 8e2bc3ea-f612-484c-9848-436ab97231fc Amount:22900 ChargedAmount:229

I have tried to replicate this with no success.

Hope this is clear enough :)

Any ideas on what could be happening here would be good.

Best regards. Garðar