How to add filter over products list ?

Hello

I am trying orocommerce 1.10, ubuntu 16, php 7, mysql

i managed to create some products attributes (for instance : color as a single select list, with some options as values yellow, red, etc …)

each time i am asked if i want to make this attribute visible (on search, on list …) i choose “yes”

i understood i had to update database schema in order to keep on going

i managed to add this attribute into the default product family list

it’s ok, i can select a value for this attribute each time i create a product

but, now, i’d want this select value to be display into the filters over a category’s list of products … how can i di that please ?

but i still have “sku”, “name” or “price” filters ….

i’d like to be able to filter by “color” (i am sure i have differents products with different values for this attribute)

can you help me please ?

thank you

Topic

[wgozdzickiParticipant]

Hello Simon,
This functionality, probably, will be added at following release. Now it’s possible to add it manually as a text filter.

In order to add text filter manually you have to:

1. Add values to indexation in WebsiteSearchProductIndexerListener, for example:

PHP

// Oro/Bundle/ProductBundle/EventListener/WebsiteSearchProductIndexerListener.php public function onWebsiteSearchIndex(IndexEntityEvent $event) { foreach ($products as $product) { // ... if ($product->getColor()) { $event->addField($product->getId(), 'color', $product->getColor()->getName()); }

1 2 3 4 5 6 7 8

// Oro/Bundle/ProductBundle/EventListener/WebsiteSearchProductIndexerListener.php public function onWebsiteSearchIndex(IndexEntityEvent $event) {     foreach ($products as $product) {         // ...         if ($product->getColor()) {             $event->addField($product->getId(), 'color', $product->getColor()->getName());         }

2. Modify datagrids.yml:

YAML

# Oro/Bundle/ProductBundle/Resources/config/oro/datagrids.yml frontend-product-search-grid: columns: # ... color: type: string data_name: color

1 2 3 4 5 6 7

# Oro/Bundle/ProductBundle/Resources/config/oro/datagrids.yml frontend-product-search-grid:     columns:         # ...         color:             type:      string             data_name: color

3. Modify website_search.yml:

YAML

# Oro/Bundle/ProductBundle/Resources/config/oro/website_search.yml Oro\Bundle\ProductBundle\Entity\Product: alias: oro_product_WEBSITE_ID fields: # ... - name: color type: text

1 2 3 4 5 6 7 8

# Oro/Bundle/ProductBundle/Resources/config/oro/website_search.yml Oro\Bundle\ProductBundle\Entity\Product:     alias: oro_product_WEBSITE_ID     fields:         # ...         -             name: color             type: text

To reindex values there is console command: https://github.com/orocommerce/orocommerce/blob/master/src/Oro/Bundle/WebsiteSearchBundle/Resources/doc/console_commands.md

Best regards

[yannick.simonParticipant]

Thank you wgozdzicki !
i’ll try asap ! ;-))))

[Author]

Replies