Broadleaf Commerce Discussion Forums

I have setup the demo of Broadleaf-3.1 and have created a totally new database with 100+ categories and 2500+ products. I want to configure the Index and search for following fields :-

blc_category.NAME
blc_product.MANUFACTURE
blc_product.MODEL
blc_sku.NAME
blc_sku.LONG DESCRIPTION
Can someone tell me what is the entry that will go in :-

blc_field
blc_field_search_types
blc_search_facet
blc_cat_search_facet_xref and any other table.
I have gone through the document link and try inputting the values, but sadly nothing works.

manufacturer, facetFieldType: "s", searchableFieldTypes: { "s", "t" }
defaultSku.retailPrice, facetFieldType: "d"
defaultSku.name, facetField: "s", searchableFieldTypes: { "s", "t" }

But still it still doesn't return any value on search . Also, for products under the category the sorting based on Name or anything else is also not working.

I am new to this Solr thing and a detailed answer would help.

Thanks in advance.

Sumit

Did you also put true for the SEARCHABLE column in BLC_FIELD?

The fields that you've inserted there look right to me.

Also, when you say it "doesn't return any value on search" what do you mean by that? These entries control what is put in Solr that you can search on, not what is displayed on the page when you get search results. To customize that, you will need to modify the productListItem.html template.

This is fixed now. I was actually messed up between facet and other stuff. I have gone through a detailed tutorial on Solr and now put in the right values in DB

So, such is now working fine.