Extremely weird database/order discrepancy problem...

[beley]

We had a customer call this week who received their order and was upset that we sent them the wrong product. They ordered a sandal and we sent a diabetic shoe... pretty big discrepancy.

The order in ShopSite, which also downloaded to our StoneEdge order manager, was for the diabetic shoe, so at first we thought she just made a mistake... until she forwarded us her receipt.

Below is the text of her email receipt and a screenshot of the order page in Shopsite (sensitive info removed)

Thank you for your business!

Order Number: 11922

Billing Address:
-----------------
Mrs. asdfasdf asdf asdf

address here
sssss, aa 131313
United States
999-444-4444
abcdef@charter.net

The shipping address is the same as the above address

Comments / More Information


Ordering Instructions




Qty Name SKU Each Subtotal
------------------------------------------------------------------------
1 Columbia Aquatooth - Mud 17 M COL-BM4215-Mud17M $74.95
$74.95
------------------------------------------------------------------------
Subtotal $74.95
Shipping: UPS Ground $9.85
Tax Total $0.00
Grand Total $84.80

Payment type: Visa

Please come again!
Store URL: http://www.2bigfeet.com/index.php


This store is powered by ShopSite web catalog software.

We've had several orders that we noticed preauthorized for a different amount than the order, so I'm thinking that this happened multiple times in the past week and we just haven't heard from those customers yet.

This is obviously a very expensive and serious problem. Was this a problem with ShopSite? We just upgraded to 9.0.3 from 9.0.2 -- could that have caused it?

[Jim]

You need to contact ShopSite directly. I doubt that anyone on the forum would have any idea on something like this.

[topher]

I certainly would be interested in the answer, so if you don't mind, please post here.

[beley]

Jim, I just emailed Loren. I posted because I know you guys frequent the forums and also in case anyone else has this kind of issue in the future, they can see what the problem is/was and may help them.

I've emailed Loren and will follow-up later this morning.

We've just found another order that came through messed up, and the incorrect product was the same SKU as the one above (boxer dogs)... definitely something going on ...

[topher]

bump - what was the outcome?

Thanks!