Menu
Search has stopped working for complete and partial SKUs on a site I am in the process of developing, this functionality has previously worked.
Diffing an older .SQL for the site when this worked I can't see any changes to core_config_data that would effect the site in this way.
Search is set to combined and like. SKUs are still searchable from the advanced search page.
Does anyone have any idea what tables that I should should be looking at for changes effecting search behavior? My hunch is that there is some backend change causing this.
693
Magento can handle several hundred thousand product SKUs without any major performance tuning requirements. There really is no limit to the number of SKUs Magento can hold.
In order to assign all products to the website please, go to your Magento 2 Admin panel > Catalog > Product and Select All products. Then, choose Update attributes in the Actions select box. Afterwards, move to the Product Information > Websites and in the Add Product to Websites section, choose the website you need.
Does anyone have any idea what tables that I should should be looking at for changes effecting search behaviour?
Yep, it's catalogsearch_fulltext. Magento fills this table during partial and full reindex of "Catalog Search" index.
BTW, I think the problem is in the attribute's settings. Go to Admin Panel -> Catalog -> Attributes -> Manage attributes -> (chose SKU attribute) -> Use in Quick Search -> Value should be "Yes"
94
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
