One of our customer service reps got a call from a customer. The customer had created a cart, but called to complete the order. The CSR found the cart, and edited the order, manually calculated the shipping by adding the items to a different cart herself, since the shipping cost isn't calculated on the fly through Order Manager, then processed the order for payment by credit card. In processing the payment, she added an order number in the text box. She then manually processed the various notification emails. We immediately received the credit card confirmation, but never received an order confirmation. The credit card was charged but the order is absent from both the Shopping Carts report and the Order Manager page. In the database, I can see in the order table the row with the cart, but it has no order number and is still "In Process". I don't want to manually edit the database, but I want to figure out where the order went and get it in the right state so we can import it to accounting. In adding the order number, she skipped a couple of numbers in sequence, so I'm also wondering what will happen when the same order number comes up in the normal sequence.


What is your advice on how to clean up the data, and also how to avoid this happening the next time? I'm not sure this is a bug or a "feature". Seems like the moral of the story is never edit a shopping cart, no?



TIA

A related thread:

http://forums.bvcommerce...lt.aspx?f=78&m=57114


Like Joe said, a new order, from scratch, is called for to get the cleanest order possible. "Shopping Cart" sn't meant to become an order in admin. It's a hassle trying to resurect a botched up order here as in other places. Any interuption in the 'normal' flow of an order isn't handled very well.

Marcus said in the thread above, fiddleing with the workflows might help, but I'm hoping for a better cure in BVC6's admin.