Rank: Member
Joined: 1/10/2005(UTC)
Posts: 714
Thanks: 14 times
Was thanked: 1 time(s) in 1 post(s)
|
Does the top products report show products from orders that are marked as complete, or all products regardless of order status?
|
|
|
|
|
|
Rank: Administration
Joined: 4/2/2004(UTC) Posts: 2,393 ![United States]( "United States") Location: Hummelstown, PA Thanks: 6 times
Was thanked: 163 time(s) in 158 post(s)
|
Originally Posted by: sternyy  Does the top products report show products from orders that are marked as complete, or all products regardless of order status? All products regardless of order status. |
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012 |
|
|
|
|
|
Rank: Member
Joined: 1/10/2005(UTC)
Posts: 714
Thanks: 14 times
Was thanked: 1 time(s) in 1 post(s)
|
Is that the same for the sales reports (By Manufacturer, Date, Coupon, Product Type).
|
|
|
|
|
|
Rank: Member
Joined: 4/29/2010(UTC)
Posts: 256
Thanks: 4 times
Was thanked: 11 time(s) in 10 post(s)
|
The sales reports also report orders regardless of status.
|
 1 user thanked Steve95 for this useful post.
|
|
|
|
Rank: Member
Joined: 1/10/2005(UTC)
Posts: 714
Thanks: 14 times
Was thanked: 1 time(s) in 1 post(s)
|
Yup I found that in the stored procedures. Thinking about updating it with a checkbox for orders marked as paid and all orders.
|
|
|
|
|
|
Rank: Member
Joined: 4/29/2010(UTC)
Posts: 256
Thanks: 4 times
Was thanked: 11 time(s) in 10 post(s)
|
Just be careful about changing the bvc_Order_ByCriteria_s stored procedure this is used elsewhere and will cause issues within the store/admin section.
Instead add the highlighted code to the Daily Sales Report FillList function, or alternatively populate a drop downlist with Orders.OrderPaymentStatus options and use it’s selected index
Sub FillList(ByVal d As Date)
msg.ClearMessage()
Try
TotalSub = 0
TotalShip = 0
TotalHandling = 0
TotalTax = 0
TotalGrand = 0
Dim c As New Orders.OrderSearchCriteria
c.StartDate = Me.DatePicker.SelectedDate
c.EndDate = Me.DatePicker.SelectedDate.AddDays(1)
c.PaymentStatus = Orders.OrderPaymentStatus.Paid
Dim dtOrders As Collection(Of Orders.Order) = Orders.Order.FindByCriteria(c)
dgList.DataSource = dtOrders
dgList.DataBind()
lblResponse.Text = dtOrders.Count & " Orders Found"
Catch Ex As Exception
msg.ShowException(Ex)
End Try
End Sub
|
|
|
|
|
|
Rank: Administration
Joined: 4/2/2004(UTC) Posts: 2,393 ![United States]( "United States") Location: Hummelstown, PA Thanks: 6 times
Was thanked: 163 time(s) in 158 post(s)
|
Originally Posted by: Steve95 c.PaymentStatus = Orders.OrderPaymentStatus.Paid This line of code is already there; it's just commented out. All you need to do is remove the comment. |
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012 |
|
|
|
|
|
Rank: Member
Joined: 1/10/2005(UTC)
Posts: 714
Thanks: 14 times
Was thanked: 1 time(s) in 1 post(s)
|
Yup. The only one I touch is in the Manufacturer_TopSellers SP. Comment and remove the comment when needed.
|
|
|
|
|
|
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.