Excluding a product or category from best selling list

[Ajeh]

Let's say you want to toss out all products in categories_id 42 ...

That would now use the master_categories_id 42 in the products table so you should be able to use:

$best_sellers_query = "select distinct p.products_id, pd.products_name, p.products_ordered
                             from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd
                             where p.products_status = '1'
                             and p.products_ordered > 0
                             and p.products_id = pd.products_id
                             and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
                             and p.master_categories_id != 42
                             order by p.products_ordered desc, pd.products_name
                             limit " . MAX_DISPLAY_BESTSELLERS; 

Note: this assumes all products that should not display use the same Category and that Category is "owns" these Products which would reflect that in that the master_categories_id of all of these Products would be the same ...

In this example:

                             and p.master_categories_id != 42 

this is the key to the block ...

[AnitaLanter]

THANK YOU SO MUCH!!!! That's exactly what i needed!

[Ajeh]

Glad that this code worked for you ... thanks for the update!

[srturner47]

Is there a way to exclude certain product categories from the 'All Products' list?

I noticed this on this thread:

and p.master_categories_id != 42

which would work perfectly if I could figure out how to apply it to all products instead of best sellers...

Thanks for the help!!! :)

[Ajeh]

The SELECT statement for All Products is in the:
/includes/modules/pages/products_all/header_php.php

You can customize it in there ...

NOTE: this is not an override file so be sure to save both the original and your changes ...

[srturner47]

Thanks so much! That worked like a charm! :)

[MeltDown]

I would like to exclude my Sold Gallery category from displaying in Featured Products. in featured_products.php would I just add:

and p.master_categories_id != 8 

to get:

if ( (($manufacturers_id > 0 && $_GET['filter_id'] == 0) || $_GET['music_genre_id'] > 0 || $_GET['record_company_id'] > 0) || (!isset($new_products_category_id) || $new_products_category_id == '0') ) {

  $featured_products_query = "select distinct p.products_id, p.products_image, pd.products_name, p.master_categories_id

                           from (" . TABLE_PRODUCTS . " p

                           left join " . TABLE_FEATURED . " f on p.products_id = f.products_id

                           left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id )

                           where p.products_id = f.products_id

                           and p.products_id = pd.products_id

                           and p.products_status = 1 and f.status = 1

                           and p.master_categories_id != 8
                           and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'"; 

Thanks!

[sweetikins]

Let's say you want to toss out all products in categories_id 42 ...

That would now use the master_categories_id 42 in the products table so you should be able to use:

$best_sellers_query = "select distinct p.products_id, pd.products_name, p.products_ordered
                             from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd
                             where p.products_status = '1'
                             and p.products_ordered > 0
                             and p.products_id = pd.products_id
                             and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
                             and p.master_categories_id != 42
                             order by p.products_ordered desc, pd.products_name
                             limit " . MAX_DISPLAY_BESTSELLERS; 

Note: this assumes all products that should not display use the same Category and that Category is "owns" these Products which would reflect that in that the master_categories_id of all of these Products would be the same ...

In this example:

                             and p.master_categories_id != 42 

this is the key to the block ...

Hiya, i was wondering if it is possible to exclude certain products for the bestsellers list? there is 10 of them and they are in different catagories. They where givin as freebies for 3 days before going up for sale and so there for they have taken up all the space on the bestsellers box

[Ajeh]

Let's say you didn't want products_id 199 and 26 to show in the Best sellers sidebox ...

You could customize the best_sellers.php sidebox module with something like:

    if (isset($current_category_id) && ($current_category_id > 0)) {
      $best_sellers_query = "select distinct p.products_id, pd.products_name, p.products_ordered
                             from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, "
                                    . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c
                             where (p.products_status = '1'
                             and p.products_ordered > 0
                             and p.products_id = pd.products_id
                             and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
                             and p.products_id = p2c.products_id
                             and p2c.categories_id = c.categories_id
                             and '" . (int)$current_category_id . "' in (c.categories_id, c.parent_id))
and p.products_id not in (199, 26)" . "

                             order by p.products_ordered desc, pd.products_name
                             limit " . MAX_DISPLAY_BESTSELLERS;

      $best_sellers = $db->Execute($best_sellers_query);

    } else {
      $best_sellers_query = "select distinct p.products_id, pd.products_name, p.products_ordered
                             from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd
                             where (p.products_status = '1'
                             and p.products_ordered > 0
                             and p.products_id = pd.products_id
                             and pd.language_id = '" . (int)$_SESSION['languages_id'] . "')
and p.products_id not in (199, 26)" . "

                             order by p.products_ordered desc, pd.products_name
                             limit " . MAX_DISPLAY_BESTSELLERS;

      $best_sellers = $db->Execute($best_sellers_query);
    }

[sweetikins]

Thank you so much for the reply, i will give it a go and post back with a result xoxo