RE: Authorize.net Error

This message was sent from: General Support
http://forums.oscommerce.com/viewtopic.php?p=228032#228032
----------------------------------------------------------------

One of my clients is having the same problem.

Goes thru to authorize.net and is charged, but doesn't show up in the cart.

They told me today they've gotten a few today that are showing up in the cart, but not making it to authorize.net.

They're not happy about orders getting charged, and not know what the customer purchased!

I've had this problem for a couple of weeks now - intermittently.  To address this, I've written a chunk of code that will:

Take the customers name, the date and the dollar amount charged to authorize.net

It then goes thru the customers_basket and other relevant tables and rebuilds the last set of items that person put in their cart and didn't follow thru on to purchase.

It assumes that only one person with that name, on that date, put items in their cart and DIDN'T purchase them for roughly that amount.

There is no way to determine what address the order would have gone to, which does have sales tax implications.

It also forces you to 'guess' what level of shipping was used based on the difference in items charges versus what was charged.  So, if $100 was charged to the card, and their estimated cart contents was $90 and no sales tax applies to any of their address book values - it's reasonably safe to assume that they selected shipping charges that amount to $10 - probably some form of ground shipping, etc.

While just a band aid and rather coarsely done on my part - it does allow the customer to have some idea of what the heck happened to the order.

  If anyone wants this let me know via this forum.  This is basically stand alone code, I haven't done anything to tie this into the oscommerce interface.  All you should have to change is the mysql access info.