View Single Post
  #1  
Old 01-17-2013, 04:31 PM
  bullfrog's Avatar 
bullfrog bullfrog is offline
 

eXpert
  
Join Date: Oct 2004
Location: Oregon, USA
Posts: 366
 

Default X-Payments "Not Finished" status problems

Persistent "Not Finished" status is causing us problems.

If a customer clicks to checkout and gets to the payment page, X-Cart creates an order ID number with an initial status of "Not Finished". Ok so far.

If the customer does not complete the form, clicks to return to the store, or shuts down the browser, the orders stay "Not Finished" indefinitely. Not ok, because the "Not Finished" designation pulls stock out of inventory and it stays in limbo.

We have had customers with a last-in-stock item go to checkout, then go back to the store, then go to checkout again, creating two order ID numbers. A last-in-stock item that was in the cart for the earlier ID number is now not in the cart for the later ID number. Not good.

We started routinely marking "Not Finished" orders as "Failed" if they are older than 10-15 minutes to make the stock available again quicker. While doing this, we occasionally come upon a NF order that was actually charged. Damn.

We log most artificial order ID status changes. In the last 2500 orders, 40 were moved from Not Finished to Failed and stayed that way.

About 4-5 more were really charged. If we catch those quickly, they get marked 'Processed'. If not, we email the customer that the order was completed, but the notification system failed and ask if they still want the order. Awkward.

In 2 cases, customers placed orders that came in as 'Not Finished', but were charged 3 hours and 32 hours later when the customer came back to the store to place a new order after they thought the first order did not go thru. They get 2 paid almost identical orders. BAD.

This is all on a 4.5.0 store using X-Payments 1.0.4, then later 1.0.5, with Paypal Payflow Pro.

I would like to get a setting in X-Payments that will automatically convert an order from "Not Finished" to "Failed" if the customer leaves the payment page before placing a successful order, and prevent the card from every being charged for the previous order. Is this possible?

Image below is our worst case. Customer reaches the payment page with a new order and the "Not Finished" order from 32 hours earlier gets charged, followed 3 minutes later by a charge on the second order.

http://frogstore.com/oops.jpg
__________________
Bullfrog ~~~ X-Cart Gold v4.7.2 (2) v4.7.8. ⌠If the road is easy, you're likely going the wrong way.■ ― Terry Goodkind
Reply With Quote