Customers placing orders without any products

For general questions and discussions specific to the AbleCommerce 7.0 Asp.Net product.
Post Reply
Robbie@FireFold
Commodore (COMO)
Commodore (COMO)
Posts: 433
Joined: Wed May 28, 2008 9:42 am
Location: Concord, NC
Contact:

Customers placing orders without any products

Post by Robbie@FireFold » Mon Oct 13, 2008 11:34 pm

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.
Robbie Hodge
General Manager
Robbie@FireFold.com
http://www.FireFold.com

User avatar
Shopping Cart Admin
AbleCommerce Admin
AbleCommerce Admin
Posts: 3055
Joined: Mon Dec 01, 2003 8:41 pm
Location: Vancouver, WA
Contact:

Re: Customers placing orders without any products

Post by Shopping Cart Admin » Mon Oct 13, 2008 11:51 pm

Hello Robbie,

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

Shopping Cart Guru
AbleCommerce.com
Follow us on Facebook

User avatar
compunerdy
Admiral (ADM)
Admiral (ADM)
Posts: 1283
Joined: Sun Nov 18, 2007 3:55 pm

Re: Customers placing orders without any products

Post by compunerdy » Mon Oct 13, 2008 11:53 pm

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.

Robbie@FireFold
Commodore (COMO)
Commodore (COMO)
Posts: 433
Joined: Wed May 28, 2008 9:42 am
Location: Concord, NC
Contact:

Re: Customers placing orders without any products

Post by Robbie@FireFold » Tue Oct 14, 2008 12:00 am

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.
Robbie Hodge
General Manager
Robbie@FireFold.com
http://www.FireFold.com

User avatar
Shopping Cart Admin
AbleCommerce Admin
AbleCommerce Admin
Posts: 3055
Joined: Mon Dec 01, 2003 8:41 pm
Location: Vancouver, WA
Contact:

Re: Customers placing orders without any products

Post by Shopping Cart Admin » Tue Oct 14, 2008 12:13 am

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 your support

Shopping Cart Guru
AbleCommerce.com
Follow us on Facebook

Robbie@FireFold
Commodore (COMO)
Commodore (COMO)
Posts: 433
Joined: Wed May 28, 2008 9:42 am
Location: Concord, NC
Contact:

Re: Customers placing orders without any products

Post by Robbie@FireFold » Tue Oct 14, 2008 12:21 am

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.
Robbie Hodge
General Manager
Robbie@FireFold.com
http://www.FireFold.com

User avatar
AbleMods
Master Yoda
Master Yoda
Posts: 5170
Joined: Wed Sep 26, 2007 5:47 am
Location: Fort Myers, Florida USA

Re: Customers placing orders without any products

Post by AbleMods » Tue Oct 14, 2008 6:46 am

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.
Joe Payne
AbleCommerce Custom Programming and Modules http://www.AbleMods.com/
AbleCommerce Hosting http://www.AbleModsHosting.com/
Precise Fishing and Hunting Time Tables http://www.Solunar.com

Post Reply