Filter by product options
Posted: Wed Jul 17, 2013 2:21 am
by Paulius
Hi, I'd like to know if it is possible to filter products by their options, for example if there is a computer with an option to choose its processor from [i3, i5, i7..] is there any way to make this product appear in results page if i make one of those queries: processor=i3, processor=i5 or processor=i7, or should I create three product for each processor type?
Re: Filter by product options
Posted: Thu Jul 18, 2013 4:19 am
by Paulius
OR maybe its possible to create a field for product option, something like:
Code: Select all
INSERT INTO BLC_FIELD (FIELD_ID, ENTITY_TYPE, PROPERTY_NAME, ABBREVIATION, SEARCHABLE, FACET_FIELD_TYPE) VALUES (12, 'PRODUCT', 'productOptions.processor', 'processor', FALSE, 's');?
Also I'd like to ask what is represented by PROPERTY_NAME in BLC_FIELD table? Is it possible to extend my product with new method, which combines productAttributes and productOptions into one structure and then create FIELD with PROPERTY_NAME='combineAttributesWithOptions()' or should it be a new @Column field?