[Plugin: eShop] Quantity control doesn't work with simultaneous orders

There are a number of possible reasons for this:

The customer did complete the transaction (via echeck, which took a few days to clear). Paypal did contact eShop immediately (eShop said it was a failed payment, which it wasn’t).

There appears to be a fourth possibility that eShop doesn’t properly process Paypal eCheck payments if it’s not an instant payment.

The IPN from Paypal is below, which shows that it notified eShop and was successfully paid:

mc_gross: 10.00
protection_eligibility: Partially Eligible - INR Only
address_status: unconfirmed
item_number1: 2012 : Men s Large
payer_id: [DELETED FOR POSTING]
tax: 0.00
address_street: [DELETED FOR POSTING]
payment_date: 09:51:33 May 16, 2012 PDT
payment_status: <strong>Completed</strong>
charset: windows-1252
address_zip: 67203
mc_shipping: 0.00
mc_handling: 0.00
first_name: [DELETED FOR POSTING]
mc_fee: 0.52
address_country_code: US
address_name: [DELETED FOR POSTING]
notify_version: 3.4
echeck_time_processed: 16:55:41 May 21, 2012 PDT
custom: [DELETED FOR POSTING]
payer_status: verified
business: [DELETED FOR POSTING]
address_country: United States
num_cart_items: 1
mc_handling1: 0.00
address_city: Wichita
verify_sign: [DELETED FOR POSTING]
payer_email: [DELETED FOR POSTING]
mc_shipping1: 0.00
tax1: 0.00
txn_id: 27751510V9152191S
payment_type: echeck
last_name: [DELETED FOR POSTING]
address_state: KS
item_name1: [DELETED FOR POSTING]
receiver_email: [DELETED FOR POSTING]
payment_fee: 0.52
quantity1: 1
receiver_id: [DELETED FOR POSTING]
txn_type: cart
mc_gross_1: 10.00
mc_currency: USD
residence_country: US
transaction_subject: [DELETED FOR POSTING]
payment_gross: 10.00
ipn_track_id: [DELETED FOR POSTING]

Unfortunately this payment, like several others, went through after we were sold out of stock, because eShop allowed the stock to be purchased even though there were pending orders for the same items.

The only way I can see to avoid the stock quantity problem in the future is to tell eShop that we have 5-10% fewer items than we actually have. Otherwise we’ll have to keep refunding customers their payments, which is a pain for us and leaves us with unhappy customers.

And that is exactly what we recommend.

It would be awesome to see stock control that works, rather than having to not be able to sell everything you might want to sell. Just sayin’… 🙂

In a perfect world, when someone adds an item to their shopping cart (limited quantity items only), the number of available stock would be reduced by what is in the shopping cart. If the order is not completed in a certain amount of time (30 minutes? 60 minutes? 24 hours?), the shopping cart would be emptied and items returned to available stock.

It should be easy enough to respond to the IPN saying that it is not a valid transaction if it has passed a set expiration time. (But maybe the incorrectly handled eCheck IPNs indicate there is already mishandling of IPNs??)

On the other hand, if there isn’t enough demand for accurate handling of transactions, then it would just be nice if the features description (“Basic Stock Control”) was a little more honest (e.g.: “Partially-working Basic Stock Control”)

I think you must not have read my posts. The problem isn’t PayPal, the problem is when PayPal sends the successful IPN, eShop can’t handle it properly.

An IPN that reports payment_status: Completed should never cause eShop to report Paypal IPN -A Failed Payment Ref:XXXX

People are relying on eShop for financial transactions. If eShop refuses to acknowledge problems that clearly exist, then people should know that eShop doesn’t care about the integrity of transactions.

This is why I clicked the “Support” tab and started asking questions… for support.

PayPal is working fine. eShop is not. Can you help me find out why? Or do you just want to mark the post “resolved” again without acknowledging there’s a problem that may be putting “100,00 users” at risk?

Can you please tell me how an eShop transaction is successfully processed through PayPal, but eShop then says the transaction is “failed”?

I’ve provided copious amounts of detail. Please advise.

I’m not trying to be an ass.. I’m trying to solve a problem that is NOT resolved.

http://quirm.net/wiki/eshop/troubleshooting/invalid-failed-payments/

This refers to a merchant gateway reporting an invalid or failed payment, which is not my problem. (Please note in above posts, Paypal reports SUCCESS.)

http://quirm.net/wiki/eshop/troubleshooting/transaction-remains-pending/

This refers to transactions that remain pending. This is not my problem. (Please note above posts, after Paypal reports success eShop moves the transactions to Failed.)

Your merchant gateway cannot contact eShop…

I believe PayPal contacted eShop fine, but maybe you can help me understand what happened with this particular order…

The order was entered through eShop on 16-May @ 16:50. One minute later the first notification came through and said:

An instant payment notification was received

from [buyer.email] on 05/16/2012 at 4:51 PM

Details:
http://the.website/wp-admin/admin.php?page=eshop-orders.php&view=31&eshop
The transaction was not completed successfully. eShop could not validate the order.The transaction was not completed successfully at Paypal. The pending reason for this is echeck

Paypal did process the payment, and the echeck took 4 days to clear. (I was concerned about it being marked as Failed instead of Pending, but I didn’t touch the order just in case..) When the payment cleared, PayPal appears to have initiated an IPN, and eShop sent the following notification:

An instant payment notification was received

from [buyer.email] on 05/21/2012 at 11:55 PM

Details:
http://the.website/wp-admin/admin.php?page=eshop-orders.php&view=31&eshop
The transaction was not completed successfully. eShop could not validate the order.

My guess would be that eShop couldn’t validate the order because it was marked as failed when the eCheck first went through. But I don’t know the back-end process and I’m sure there are other possibilities..

What is the expected behavior from eShop when a PayPal IPN reports “payment_status: Pending”, as in the first notification?