Developer forum

Forum » Ecommerce - Standard features » Missing Order

Missing Order

E-mail notifications
Marek Miesiac
Reply
Posted on 01/12/2012 21:33:53

Hi there,

has anyone experienced missing order in Dynamicweb? We have DW 19.2.0.4 and from time to time customer gets a product, goes through payment gateway and payment is being successfully made, while on Dynamicweb that particular order is missing. It's really annoying because we have no way of identifying the customer - having no personal details.

Do you know if I can recall/pull directly say from SQL db that order - if so how? And also is there any way of finding it in the system, other than simply going through the orders list - which simply the one I'm looking for is not there...

Please advise if anyone knows what to do in this scenario.

Many thanks in advance,

Marek


Replies

 
Imar Spaanjaars Dynamicweb Employee
Imar Spaanjaars
Posted on 02/12/2012 12:16:55
Reply

Hi there,

 

I don't know why your order isn't visible but if it exists in the database, you should be able to retrieve it with this query from the database:

 

SELECT        * FROM            EcomOrders INNER JOIN
                         EcomOrderLines ON EcomOrders.OrderID = EcomOrderLines.OrderLineOrderID
WHERE        (EcomOrders.OrderID = N'YourOrderId')

 

Hope this helps,

 

Imar

 

You must be logged in to post in the forum