Customers placing orders without any products
-
- Commodore (COMO)
- Posts: 433
- Joined: Wed May 28, 2008 9:42 am
- Location: Concord, NC
- Contact:
Customers placing orders without any products
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.
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.
- Shopping Cart Admin
- AbleCommerce Admin
- Posts: 3055
- Joined: Mon Dec 01, 2003 8:41 pm
- Location: Vancouver, WA
- Contact:
Re: Customers placing orders without any products
Hello Robbie,
likely it's directly accessing the checkout pages, with nothing in the basket. Something we likely could catch however.
likely it's directly accessing the checkout pages, with nothing in the basket. Something we likely could catch however.
- compunerdy
- Admiral (ADM)
- Posts: 1283
- Joined: Sun Nov 18, 2007 3:55 pm
Re: Customers placing orders without any products
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.
-
- Commodore (COMO)
- Posts: 433
- Joined: Wed May 28, 2008 9:42 am
- Location: Concord, NC
- Contact:
Re: Customers placing orders without any products
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.
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.
- Shopping Cart Admin
- AbleCommerce Admin
- Posts: 3055
- Joined: Mon Dec 01, 2003 8:41 pm
- Location: Vancouver, WA
- Contact:
Re: Customers placing orders without any products
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.
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

-
- Commodore (COMO)
- Posts: 433
- Joined: Wed May 28, 2008 9:42 am
- Location: Concord, NC
- Contact:
Re: Customers placing orders without any products
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.
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.
Re: Customers placing orders without any products
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.
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
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