BV Commerce Forum
»
BV Commerce Support
»
General Support
»
BVC - Issue with Extremely Large number of products in a single category
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: "Kim (Kman)"  Could always add some Ajax to check inventory on a per item basis if you wanted. That wouldn't work if you don't want to display out-of-stock products on the site. I guess the easiest thing would be to check the inventory status on the product page, which I'm guessing it already does. |
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012 |
|
|
|
|
|
Rank: Member
Joined: 11/3/2009(UTC)
Posts: 17
|
|
|
|
|
|
|
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)
|
Tim from Engineer Supply found a bug in the bvc_Product_ByCategory_s procedure that I posted that caused inactive products to be displayed. The procedure has been updated to fix this bug so if you downloaded this previously, please re-download the file from my original post and run the update. Thanks, and sorry for any problems it may have caused you guys. |
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012 |
|
|
|
|
|
Rank: Member
Joined: 11/3/2009(UTC)
Posts: 17
|
Hi Guys,
I'm experiencing this issue again with category having 100k+ products. Is there anything we could do about it and what is the maximum product number that can be assigned to the category?
|
|
|
|
|
|
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)
|
romanuum,
If you're already using the modified stored procedures that I posted, I'm not sure there is much more that can be done. Having 100,000 products in a single category seems a little excessive. How can a user even find a product? |
Aaron Sherrick
BV Commerce
Toll-free 888-665-8637 - Int'l +1 717-220-0012 |
|
|
|
|
|
Rank: Member
Joined: 11/3/2009(UTC)
Posts: 17
|
Hi Aaron,
I see what you mean, and agree.
Anyway thanks ;-)
|
|
|
|
|
|
Rank: Member
Joined: 4/10/2009(UTC)
Posts: 120
Location: Mechanicsville, VA
Thanks: 3 times
Was thanked: 1 time(s) in 1 post(s)
|
Hey gang,
I tested Aaron's modification on 5.7.3, seems to work fine. This helped me out a lot. Thanks Aaron! |
Tim
|
|
|
|
|
|
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.