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

Notification

Icon
Error

TKatch
#1 Posted : Wednesday, January 23, 2013 3:24:33 PM(UTC)
TKatch

Rank: Member

Joined: 1/23/2013(UTC)
Posts: 267
Location: Joliet, IL

Thanks: 64 times
Not sure why yet, but a couple of orders lately get shipped but BV won't change the status to "Shipped". Most recently happened with order shipped via USPS Priority. Any ideas why this is happening?

Using v. 5.8.0.1015
Aaron
#2 Posted : Wednesday, January 23, 2013 7:59:38 PM(UTC)
Aaron

Rank: Administration

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

Thanks: 6 times
Was thanked: 163 time(s) in 158 post(s)
I'll need a little detail before we can troubleshoot something like this. If you can identify any patterns in the orders (e.g. same shipping carrier) that would help. Were you ever able to make the order show as 'shipped'? We will most likely need to look at your database to see what the underlying data looks like.
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012
TKatch
#3 Posted : Wednesday, January 23, 2013 11:41:49 PM(UTC)
TKatch

Rank: Member

Joined: 1/23/2013(UTC)
Posts: 267
Location: Joliet, IL

Thanks: 64 times
Okay, I just emailed you a list of orders with this issue, including the latest one 8844 via USPS Priority.
Aaron
#4 Posted : Friday, February 15, 2013 6:16:07 PM(UTC)
Aaron

Rank: Administration

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

Thanks: 6 times
Was thanked: 163 time(s) in 158 post(s)
Tom,

After reviewing this we've determined that this scenario occurs when one or more items in an order do not match a record in the product catalog. Specifically, when the bvc_LineItem.ProductId does not match bvc_Product.bvin. This occurs when a customer places an order and then that product is deleted from the catalog. In the case of your store, it was choice combination products that were not matching up. The SKUs match up but the ProductId/bvin values did not.
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012
Aaron
#5 Posted : Monday, February 18, 2013 10:54:24 AM(UTC)
Aaron

Rank: Administration

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

Thanks: 6 times
Was thanked: 163 time(s) in 158 post(s)
After further review we believe that we have a fix for the shipping status. The only scenario that the fix does handle is if the originally deleted product was set to be non-shipping. Unfortunately since the product was deleted it is not possible to know this.
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012
TKatch
#6 Posted : Thursday, February 28, 2013 1:09:20 AM(UTC)
TKatch

Rank: Member

Joined: 1/23/2013(UTC)
Posts: 267
Location: Joliet, IL

Thanks: 64 times
Thanks, Aaron. Seems to be working now.
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