CRE Loaded Community

Hi. I am using 6.4.1 B2B.

The 'Best Sellers' infobox scrolls products but not sub-products.

Most of our items are indeed sub-products (based on size, colour etc), so this is misleading for customers.

Does anybody know how to make all products, including sub-products show up on the list?

Thanks.

Paul (in Dubai)

Well sub products are real products just set inactive and assigned to a parent

Not only will they not show there, they will not show in site searches

to fix the first
open up includes/classes/box_best_sellers_scroll.php

here is where the database is queried to see whats items have been the best sellers

You can either just change (in two places)

to


That works.. but allows ALL product in stock/on/off/subs to be listed.. which will work for most.. but for those who have inactive products that have been bestsellers in the past, a product not found will likely return when clicked on

Let me know if you need something custom to hide inactives.. but show subs

Thank you Jason.

That has worked partially. The sub products are now scrolling fine, but the products themselves have now disappeared. Is there something I need to tweek to make all products (both products and sub products) appear?

Thanks a lot.

Paul (in Dubai)

Opps

just delete the lines

and the and below

so it starts as

Great Jason! That has fixed it.

Thank you very much.

Paul (in Dubai)

oh oh - I may have spoken too soon.

I notice now that new sub-product best seller items are being added to the scrolling list fine - but new best seller PRODUCTS are NOT being added to the scrolling list.

(I have looked at the code, but as a php beginner I can't figure it out.)

Thanks.

Paul (in Dubai)

make sure both places p.products_status = 0 is removed

Hi,

I have removed the 2 lines you mention, and now both products and sub-products are scrolling happily. You were right. There are some previous items I entered when making dummy purchases at testing stage, but I have reduced the maximum number of scrolling items to 3 and these older items will slowly get pushed down the list and disappear.

Jason, thank you very much for your help and time!

Paul (in Dubai)