- Posts: 45
- Thank you received: 0
Filter questions, multi-filtering, order + problem
14 years 10 months ago - 14 years 10 months ago #29349
by Karloz
Filter questions, multi-filtering, order + problem was created by Karloz
Hello, is it possible to have multi-filtering ?
Example:
I would like to have a music shop, it is possible that each music item belongs to more styles e.g. jazz, soul, rock
and i would like to make a filter with which will list all styles, be deletable and will be possible to combine that filters.
Please is that possible to make ?
Thank you very much,
Karloz
Example:
I would like to have a music shop, it is possible that each music item belongs to more styles e.g. jazz, soul, rock
and i would like to make a filter with which will list all styles, be deletable and will be possible to combine that filters.
Please is that possible to make ?
Thank you very much,
Karloz
Last edit: 14 years 10 months ago by Karloz.
Please Log in or Create an account to join the conversation.
14 years 10 months ago #29353
by Karloz
Replied by Karloz on topic Re: Filter question , Multi-filtering ? :-)
Maybe it will suite as filter for categories in this case
Please Log in or Create an account to join the conversation.
14 years 10 months ago #29365
by nicolas
Replied by nicolas on topic Re: Filter question , Multi-filtering ? :-)
Hi,
Yes, you can use categories for that. Then, add several categories for your products and you can create a filter ( multi select or not ) which will be based on the categories. so that the user can filter your products based on their categories. Please note that the creation of filters is only in the Business edition of HikaShop.
Yes, you can use categories for that. Then, add several categories for your products and you can create a filter ( multi select or not ) which will be based on the categories. so that the user can filter your products based on their categories. Please note that the creation of filters is only in the Business edition of HikaShop.
Please Log in or Create an account to join the conversation.
14 years 10 months ago - 14 years 10 months ago #29432
by Karloz
Replied by Karloz on topic Re: Filter question , Multi-filtering ? :-)
Ook great thanks i have it working now...
Last edit: 14 years 10 months ago by Karloz.
Please Log in or Create an account to join the conversation.
14 years 10 months ago #29441
by Karloz
Replied by Karloz on topic Re: Filter question , Multi-filtering ? :-)
I found out that if i'm on another page not the first one, the filter give back blank results.
Also please is it possible to sort manufacturer filter alphabetically ?
I found here on forum how to sort them via order, but in my case i have around 200 manufacturers, its madness
Also please is it possible to sort manufacturer filter alphabetically ?
I found here on forum how to sort them via order, but in my case i have around 200 manufacturers, its madness
Please Log in or Create an account to join the conversation.
14 years 10 months ago #29456
by nicolas
Replied by nicolas on topic Re: Filter question , Multi-filtering ? :-)
The filters give results based on the current category. If the current category does not contain any product which match the filters, you won't have any results.
It's possible. You can just change the code:
$query='SELECT a.* FROM '.hikashop_table('category').' AS a '.$left.' WHERE a.category_type="manufacturer" AND a.category_parent_id!
'1\' '.$optionElement.' ORDER BY a.category_ordering';
to:
$query='SELECT a.* FROM '.hikashop_table('category').' AS a '.$left.' WHERE a.category_type="manufacturer" AND a.category_parent_id!
'1\' '.$optionElement.' ORDER BY a.category_name ASC';
in the file administrator/components/com_hikashop/classes/filter.php
However, that modification will be removed when you update HikaShop. So for only 200 manufacturers, I would still recommend to change the ordering and be done with it...
It's possible. You can just change the code:
$query='SELECT a.* FROM '.hikashop_table('category').' AS a '.$left.' WHERE a.category_type="manufacturer" AND a.category_parent_id!
'1\' '.$optionElement.' ORDER BY a.category_ordering';to:
$query='SELECT a.* FROM '.hikashop_table('category').' AS a '.$left.' WHERE a.category_type="manufacturer" AND a.category_parent_id!
'1\' '.$optionElement.' ORDER BY a.category_name ASC';in the file administrator/components/com_hikashop/classes/filter.php
However, that modification will be removed when you update HikaShop. So for only 200 manufacturers, I would still recommend to change the ordering and be done with it...
Please Log in or Create an account to join the conversation.
11 years 5 months ago - 11 years 5 months ago #197405
by lionel75
Replied by lionel75 on topic Re: Filter question , Multi-filtering ? :-)
Hi
Does fitler base on multi custom field is supported now ? ( april 2015)
what is the logic for choose filter ( and so search ) base on category or custom field ?
Could we import csv file that have custom field value for a product ?
Does mass action support custom field ?
regard's
Does fitler base on multi custom field is supported now ? ( april 2015)
what is the logic for choose filter ( and so search ) base on category or custom field ?
Could we import csv file that have custom field value for a product ?
Does mass action support custom field ?
regard's
Last edit: 11 years 5 months ago by lionel75.
Please Log in or Create an account to join the conversation.
11 years 5 months ago #197479
by nicolas
Replied by nicolas on topic Re: Filter question , Multi-filtering ? :-)
Hi,
1. Filters based on different custom fields are not supported. Filters based on one multiple value custom fields are now supported.
2. If you already have categories setup like you want for your filter, then use the categories for your filter. Otherwise, use a custom field. It's more flexible and allows for more things to be done.
3. Yes, you can import the value of custom fields for the products. And likewise, when you export the products, you can see the columns relative to the custom product fields in the resulting CSV.
4. Yes, mass actions can work on custom product fields.
1. Filters based on different custom fields are not supported. Filters based on one multiple value custom fields are now supported.
2. If you already have categories setup like you want for your filter, then use the categories for your filter. Otherwise, use a custom field. It's more flexible and allows for more things to be done.
3. Yes, you can import the value of custom fields for the products. And likewise, when you export the products, you can see the columns relative to the custom product fields in the resulting CSV.
4. Yes, mass actions can work on custom product fields.
Please Log in or Create an account to join the conversation.
Time to create page: 0.219 seconds