What is the purpose of table spy_product_search_attribute_map?
Is anyone using spy_product_search_attribute_map
and can explain to me the benefit of that table? Docs saying it maps product attributes to their corresponding search keys. I would like to understand it and how we could use it.
Some background: We had some attributes in that table and were wondering why we have duplicate string-facets on some products.
Answers
-
fsmeier Senior Software Engineer & Developer Enablement Advocate Sprykee Posts: 1,052 ⚖️ - Guardians (admin)
Heyhey,
sorry for the late reply but it took some time to gather some information.It enables the ability to make a product searchable based on its attributes without needing code modifications. It functions seamlessly in conjunction with 'spy_product_attribute_key'.
- Not all attributes are included to search preferences by default if you search through product data.
- You need to re-publish all entities after this manipulation. There is somewhere a button in Back Office /product-search/search-preferences
- The benefit: Admin can manage it by him/herself without a developer.
Does this help?
All the best,
Florian
2 -
Hey @fsmeier ,
thanks, I finally understood and also made some tests on my local env. This table is used to map an attribute to for example the full_text_boosted field. With that it is possible to search for these attribute values and find related products. It can be configured (as you said) in the backend at /product-search/search-preferences. Thanks.
1
Categories
- All Categories
- 42 Getting Started & Guidelines
- 7 Getting Started in the Community
- 8 Additional Resources
- 7 Community Ideas and Feedback
- 68 Spryker News
- 890 Developer Corner
- 753 Spryker Development
- 83 Spryker Dev Environment
- 360 Spryker Releases
- 3 Oryx frontend framework
- 34 Propel ORM
- 68 Community Projects
- 3 Community Ideation Board
- 30 Hackathon
- 3 PHP Bridge
- 6 Gacela Project
- 22 Job Opportunities
- 3.2K 📜 Slack Archives
- 116 Academy
- 5 Business Users
- 370 Docker
- 551 Slack General
- 2K Help
- 75 Knowledge Sharing
- 6 Random Stuff
- 4 Code Testing
- 32 Product & Business Questions
- 68 Spryker Safari Questions
- 50 Random