• Toll-free  888-665-8637
  • International  +1 717-220-0012
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

jacobk
#1 Posted : Friday, July 6, 2012 4:33:00 PM(UTC)
jacobk

Rank: Member

Joined: 6/13/2012(UTC)
Posts: 16

Thanks: 2 times
We have a strange bug coming up after a recent upgrade to 5.8. We've a few cases where a customer places an order and pays for it, then system generates a new order email (with an order number) and sends it out to the various email addresses.

However, it never seems to get promoted from a shopping cart to an order, even after the payment. It isn't visible in the order manager, but the next new order number is one higher than the 'missing' order. We can view the 'missing' orders by going to the Reports -> Shopping Carts, and it is showing the status as "Shopping Cart / Paid / Unshipped". This is an intermittent issue, we've seen two of these over the last week, but other orders are coming through fine.

Any idea how to fix this? This is affecting our ERP integration because these never get exported as orders.

This is using the BV PlugNPay payment module, if that makes a difference.
jacobk
#2 Posted : Saturday, July 7, 2012 2:12:45 PM(UTC)
jacobk

Rank: Member

Joined: 6/13/2012(UTC)
Posts: 16

Thanks: 2 times
Any help here? We just had another email alert for an order number that is not showing up in the order manager, still staying as a cart. This seems like a significant bug that is really impacting business with 5.8. We never had this problem with 5.3.2 before we upgraded.
Aaron
#3 Posted : Tuesday, July 10, 2012 7:50:21 AM(UTC)
Aaron

Rank: Administration

Joined: 4/2/2004(UTC)
Posts: 2,381
United States
Location: Hummelstown, PA

Thanks: 6 times
Was thanked: 163 time(s) in 158 post(s)
It's possible that one of the workflow steps in your "Process New Order" workflow is failing. This can result in an order that appears to be placed from the customer standpoint but really isn't (just like you describe).
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012
jacobk
#4 Posted : Tuesday, July 10, 2012 10:28:24 AM(UTC)
jacobk

Rank: Member

Joined: 6/13/2012(UTC)
Posts: 16

Thanks: 2 times
Aaron, thanks for the comment. I was leaning towards workflow / order task issues as well, but it was difficult to diagnose since it was intermittent without any error information in the audit log. As it turns out, it sounds like it was a problem with a corrupt dll left over from the upgrade that wasn't mentioned in the upgrade file changes document. Hopefully it's resolved now.
jacobk
#5 Posted : Wednesday, July 11, 2012 12:27:33 PM(UTC)
jacobk

Rank: Member

Joined: 6/13/2012(UTC)
Posts: 16

Thanks: 2 times
Ah, looks like I spoke too soon, had two more "missing" orders yesterday. Very frustrating.

Based on the email CC steps in our workflow, it looks like this is failing in either "Update List Items" or "Update Order", leaning towards the latter.
Kman
#6 Posted : Wednesday, July 11, 2012 12:48:59 PM(UTC)
Kman

Rank: Member

Joined: 11/25/2003(UTC)
Posts: 370

Nothing in the error log at all? Can you look at server logs?
Regards,
Kim(Kman) Rossey
www.toocoolwebs.com
BVSoftware - MerchantTribe Programming/Design, Database Programming and Business Applications
[email protected]
Aaron
#7 Posted : Wednesday, July 11, 2012 1:03:19 PM(UTC)
Aaron

Rank: Administration

Joined: 4/2/2004(UTC)
Posts: 2,381
United States
Location: Hummelstown, PA

Thanks: 6 times
Was thanked: 163 time(s) in 158 post(s)
Here's what I would do:
1. Install a fresh copy of BV and compare the "Process New Order" workflow against the one on your site to make sure that everything is the same (i.e. all of the same workflow steps and their ordering)
2. Double-check any custom code you may have written
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012
jacobk
#8 Posted : Thursday, July 12, 2012 3:41:03 PM(UTC)
jacobk

Rank: Member

Joined: 6/13/2012(UTC)
Posts: 16

Thanks: 2 times
Kim, I'm not seeing any errors in the audit log, just a "Payment / Charge" notification around the time of the missing orders.

It's hosted with Resposio, so I don't have access to the server logs, but they say that nothing has shown up in the error logs.

Aaron, thanks, good troubleshooting tips. The workflow is identical to the stock copy, and we don't have any custom code for the checkout / new order process.
Kman
#9 Posted : Thursday, July 12, 2012 4:49:16 PM(UTC)
Kman

Rank: Member

Joined: 11/25/2003(UTC)
Posts: 370

Hmm, hard to figure an error such as this would not bubble up and get recorded in the site error log or IIS log. That does not put you in a good position. With this going on the only way I see resolving it is investigation debugging the site and stepping through the process. That and comparing the sites files and workflows to a new install of 5.8 to possibly find a difference. Unfortunately the process here is time consuming and expensive. Is there anything that these problem orders have in common like products ordered, browser used etc. I would study the orders that had issues and see if there is anything that jumps out.

Good luck, tough one.
Regards,
Kim(Kman) Rossey
www.toocoolwebs.com
BVSoftware - MerchantTribe Programming/Design, Database Programming and Business Applications
[email protected]
Matt@9BallDesign
#10 Posted : Thursday, July 12, 2012 9:50:23 PM(UTC)
Matt@9BallDesign

Rank: Member

Joined: 12/23/2003(UTC)
Posts: 909

Just a chime in as I would approach it like kman mentioned.

Are the orders not being recorded as orders using a third party checkout (Paypal, google wallet, echeck, etc.) as opposed to standard processor?
Matt Martell


http://www.9balldesign.com - Web, Print, Graphic


http://www.martellhardware.com/ - Decorative & Builder's Hardware

------------------------------------------------
jacobk
#11 Posted : Tuesday, July 17, 2012 5:47:36 PM(UTC)
jacobk

Rank: Member

Joined: 6/13/2012(UTC)
Posts: 16

Thanks: 2 times
After a lot of testing from us and our hosting company, including a fresh install of 5.8, the problem has been narrowed down to products with product options or choices. They seem to be slowing the checkout process to a crawl.

It looks like it's a bug in BVC 5.8. Our hosting company (a BVCommerce partner) has passed detailed information about it on to the BVCommerce developers.

Our clients' daily web sales have dropped to nearly nothing since the upgrade.
Kman
#12 Posted : Tuesday, July 17, 2012 8:28:35 PM(UTC)
Kman

Rank: Member

Joined: 11/25/2003(UTC)
Posts: 370

Sorry to hear about the drop in sales. Will be interested to read more on your findings. I do currently have active clients using 5.8 with product choices and this issue has never occurred. If possible to share your future findings please do. I would like to see what your host reported but any info that helps prevent this issue or speed up checkout would be great.
Regards,
Kim(Kman) Rossey
www.toocoolwebs.com
BVSoftware - MerchantTribe Programming/Design, Database Programming and Business Applications
[email protected]
Aaron
#13 Posted : Wednesday, July 18, 2012 10:50:49 AM(UTC)
Aaron

Rank: Administration

Joined: 4/2/2004(UTC)
Posts: 2,381
United States
Location: Hummelstown, PA

Thanks: 6 times
Was thanked: 163 time(s) in 158 post(s)
Ditto. I'm curious to hear what this bug is.
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012
Aaron
#14 Posted : Thursday, October 25, 2012 2:21:12 PM(UTC)
Aaron

Rank: Administration

Joined: 4/2/2004(UTC)
Posts: 2,381
United States
Location: Hummelstown, PA

Thanks: 6 times
Was thanked: 163 time(s) in 158 post(s)
Did anything ever come of this? Was a bug ever confirmed?
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012
Marcus
#15 Posted : Saturday, November 3, 2012 8:29:43 AM(UTC)
Marcus

Rank: Member

Joined: 11/5/2003(UTC)
Posts: 1,786

We never confirmed any bug having to do with options/choices in BV 5.8.
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

©2024 Develisys. All rights reserved.
  • Toll-free  888-665-8637
  • International  +1 717-220-0012