Rank: Member
Joined: 4/4/2004(UTC)
Posts: 670
|
The top sellers that I am seeing on BVC5 sites has bugs. One of the most noticable is that you can go to a new site, add 9999 of an item to cart, and it will show up as a best seller, regardless if an order has ever even been placed for the item or not.
Scott Mech
|
|
|
|
|
|
Rank: Member
Joined: 3/3/2006(UTC)
Posts: 1,737
|
Now THAT'S inventive testing!!! |
Optimists invent airplanes,
Pessimists buy parachutes. |
|
|
|
|
|
Rank: Member
Joined: 2/21/2007(UTC)
Posts: 1,113
|
I think, however, Scott, that once you remove it from the cart -- or the cart expires -- that the item returns to its "rightful" place. I just tested it on our site and you are correct, adding it to cart immediately places it on top, but if you remove it from the cart, it takes it back off the list. But you are correct, the list should be based on actual purchases. |
|
|
|
|
|
|
Rank: Member
Joined: 8/17/2006(UTC)
Posts: 681
|
Hehe. Noticed this two days ago when someone wanted to check for a quote for 1000 products and that kicked the product in my Top Sellers :)
The fix is easy. Modify the [bvc_Product_ProductsOrderedCount_s] stored procedure and add an
IsPlaced = 1 in the inner select like this:
SELECT bvin FROM bvc_Order
WHERE
(TimeOfOrder >= @StartDate OR @StartDate IS NULL)
AND
(TimeOfOrder <= @EndDate OR @EndDate IS NULL)
AND IsPlaced = 1
Regards,
Corneliu. |
|
|
|
|
|
|
Rank: Member
Joined: 3/1/2006(UTC)
Posts: 1,142
|
Thanks, we have fixed this. |
Justin Etheredge
Senior Software Engineer
BVSoftware |
|
|
|
|
|
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.