Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2007
    Posts
    3
    Plugin Contributions
    0

    Default filter specific categories using Category/Manufacturer Filter

    Hello, i am having little problem with displaying subcategories. I maintain a website that sells rugs. Basically each item belongs to a some kind of an brand, and also some kind of descriptive category such as floral or traditional. So, when I enter the item it goes into one of these descriptive categories such as floral, and also has brand name identification. The problem is inside the brands there are collections. So i made a category called brand names and inside i made sub categories that has all the brand names and inside in it i made categories with the name of collections. After that, i linked those items that already inside descriptive categories such as floral to belonging collection category. Now, when certain manufacture is selected on the website Category/Manufacturer Filter filters the entire categories and descriptive and collections categories comes out mixed. Therefore, is there anyway to redirect Category/Manufacturer Filter to filter specific category in Categories/Products (i mean only brand names category), instead of filtering all categories. Or is there any other addons can do that?

  2. #2
    Join Date
    May 2009
    Posts
    6
    Plugin Contributions
    0

    help question Re: filter specific categories using Category/Manufacturer Filter

    I sort of have the same question.

    Is it possible to prevent having duplicate categories show up in the Manufacturer page filters when using linked products?

  3. #3
    Join Date
    Aug 2007
    Location
    Gijón, Asturias, Spain
    Posts
    2,571
    Plugin Contributions
    30

    Default Re: filter specific categories using Category/Manufacturer Filter

    Hi,
    I would like to fix this too.

    To clarify:
    after selecting a manufacturer from the manufacturer sidebox, the product listing has a sort-by-category filter.

    Instead of just showing the product subcategories within the manufacturer category (I have manufacturer as a master category), this drop-down includes all categories that some of the products are linked into.

    As I have single products that are linked into many other categories like
    Suzuki-DL650-All Years,
    Suzuki-DL1000-All Years etc…

    I will have a huge drop down list composed of repetitions of “All Years”.

    So, how to limit the form options to subcategories of that chosen manufacturer?

    I think this listing is generated in \includes\index_filters\default_filter.php but its way beyond me to dissect this.
    I imagine this will need to be cloned and edited to be specifically used in this drop-down form.

    Is this possible or should I just switch off the filter!

    Regards
    Steve

  4. #4
    Join Date
    Aug 2007
    Location
    Gijón, Asturias, Spain
    Posts
    2,571
    Plugin Contributions
    30

    Default Re: filter specific categories using Category/Manufacturer Filter

    well, I have come back to this and I am sure that in
    \includes\index_filters\default_filter.php
    this is the query that populates the drop down.

    I have manufacturers as a master category.

    My question is, what do I need to put (a verbal description will do, not tested code!) to return only the subcategories belonging to that manufacturer in question but NOT any linked categories?

    PHP Code:
    // optional Product List Filter
      
    if (PRODUCT_LIST_FILTER 0) {
        if (isset(
    $_GET['manufacturers_id']) && $_GET['manufacturers_id'] != '') {
          
    $filterlist_sql "select distinct c.categories_id as id, cd.categories_name as name
          from " 
    TABLE_PRODUCTS " p, " .
          
    TABLE_PRODUCTS_TO_CATEGORIES " p2c, " .
          
    TABLE_CATEGORIES " c, " .
          
    TABLE_CATEGORIES_DESCRIPTION " cd
          where p.products_status = 1
            and p.products_id = p2c.products_id
            and p2c.categories_id = c.categories_id
            and p2c.categories_id = cd.categories_id
            and cd.language_id = '" 
    . (int)$_SESSION['languages_id'] . "'
            and p.manufacturers_id = '" 
    . (int)$_GET['manufacturers_id'] . "'
          order by cd.categories_name"
    ;
        } 
    thanks
    Steve

  5. #5
    Join Date
    Dec 2011
    Posts
    6
    Plugin Contributions
    0

    Default Re: filter specific categories using Category/Manufacturer Filter

    Have you found the answer to this yet?

 

 

Similar Threads

  1. Filter by Category in Manufacturer´s page
    By ppsoyal in forum Basic Configuration
    Replies: 15
    Last Post: 29 Jan 2011, 02:58 PM
  2. Manufacturer/Category Filter
    By rbarbour in forum Setting Up Categories, Products, Attributes
    Replies: 1
    Last Post: 19 Aug 2010, 06:10 AM
  3. Filter by attributes -- exactly like the manufacturer filter
    By Goldlion in forum Setting Up Categories, Products, Attributes
    Replies: 6
    Last Post: 16 Jan 2010, 03:59 PM
  4. Filter category by manufacturer...
    By Scott_C in forum Templates, Stylesheets, Page Layout
    Replies: 0
    Last Post: 19 Dec 2009, 05:11 AM
  5. Category / Manufacturer filter not switching on
    By angeli in forum Upgrading from 1.3.x to 1.3.9
    Replies: 4
    Last Post: 28 Aug 2007, 04:10 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR