AbleCommerce Shopping Cart Software

Anyone experience this?

I had a customer place an order w/o anything in his cart.

Error log shows:

Cannot insert the value NULL into column 'TotalCharges', table 'FireFold.dbo.ac_Orders'; column does not allow nulls. UPDATE fails. The statement has been terminated.

Hello Robbie,

likely it's directly accessing the checkout pages, with nothing in the basket. Something we likely could catch however.

I have seen this when 2 people are trying to buy the same item at the same time and its the last one in inventory. You need to check also because it wont show a payment went through on AC even though it did on paypal.

No inventory is active on our site at this time. I'll keep watching to see if more occur.

With 300+ customers checking out a day you learn stuff quite quickly it seems. Customers always manage to find that 'black hole' or fall into it on accident.

Hello Robbie,

We have ton's of users and find new stuff (issues) every day. We try hard not to enforce (limiting) business rules in our software, but attempt to make things work in harmony regardless of the choices. Doesn't always work, but it makes us versatile. Sometimes it's a bug, sometimes it's a 'logic call' where the feature isn't working as you want but IS working. I don't think this is the case this time, this is just an comment on the side . Either way if it can be reproduced we can fix it or let you know why we did it that way.

Thanks for the response Mike.

You guys do a great job at what you said. I can't imagine what goes into developing such a well rounded software such as Able. I tested 50-100 carts over a month or two period with no luck. Found Able thru a Google search - got the demo and saw the forum. Pretty quickly it was obvious that this was for FireFold.

I've seen it happen when PayPal erroniously sends multiple IPN notifications to your site.

The clue I saw was that you would have 1 or more $ 0 orders in your order summary immediately following an order paid via PayPal.