Having used BVC5 SP2 for over 9 months in a live environment and now having a good volume of business, we have realised that we are losing a significant percentage of sales for reasons that we simply cannot diagnose.
We are seeing these problems by using SQL Management Studio to execute the following query
SELECT bvc_Order.OrderNumber,bvc_Order.TimeOfOrder,bvc_Order.IsPlaced,bvc_Order.PaymentStatus,bvc_Order.ShippingStatus,bvc_Order.StatusName,
CAST(bvc_LineItem.Quantity AS Int) As Qty,
CAST(bvc_LineItem.QuantityShipped AS Int) As QtyShipped,
CAST(bvc_LineItem.QuantityReturned AS Int) As QtyReturned,
bvc_LineItem.ProductName, bvc_LineItem.ProductSku, bvc_Order.UserEmail, bvc_Order.UserId
FROM bvc_Order INNER JOIN bvc_LineItem
ON bvc_Order.bvin = bvc_LineItem.OrderBvin
ORDER BY TimeOfOrder DESC
This is the only way (other than website log examination or analytics) to get a list of customers that reached the basket/checkout but never closed their sales.
Take a look at the attached image.
You can see that there are far too many sales reaching the basket but never closing. You can tell this from the lack of an OrderNumber being allocated and by IsPlaced being false. Also from payment status.
1. We would love to have access to this kind of info from the Admin UI of BVC.
2. Its hard to tell which lines are grouped together from the same user. Please can you add the "IP address" and/or "session#" to the database so that there's some easier way to do this. At the moment its impossible.
Of course finally, and most importantly, we have no idea why these sales don't complete. The percentages are too high. Any ideas welcome on how to understand this.
The site is
http://www.beauty2u.comrichtheo attached the following image(s):
b2u-sql1.jpg
(171kb) downloaded 59 time(s).You cannot view/download attachments. Try to login or register.