This article provides solutions for the Adobe Commerce issue where your catalog data is not synchronized correctly when using the Live Search extension.
Your catalog data is not synchronized correctly, or a new product was added but is not appearing in search results.
Steps to reproduce
Or
Expected result
Actual result
Exported catalog cannot be verified and/or connection is not established because the API key has changed.
There are several things you might do to try and fix the catalog syncing issues.
Once you configure and connect, it can take over 8 hours for the index in ES (Elasticsearch) to be created and search results to be returned (same timeframe is also true for delta updates as of now, but will be improved in the future).
If your product data is not synced correctly for a specific SKU, do the following:
Use the following SQL query and verify that you have the data you expect in the feed_data
column. Also, make a note of the modified_at
timestamp.
select * from catalog_data_exporter_products where sku = '<your_sku>' and store_view_code = '<your_ store_view_code>';
If you do not see the correct data, try to reindex using the following command and rerun the SQL query in step 1 to verify the data:
bin/magento indexer:reindex catalog_data_exporter_products
If you still do not see the correct data, create a Support ticket.
If you see the correct data in catalog_data_exporter_products
, use the following SQL query to check the timestamp of the last export. It should be after the modified_at
timestamp:
select * from flag where flag_code = 'products-feed-version';
If the timestamp is older, you can either wait for the next cron run or trigger it yourself using the following command:
bin/magento cron:run --group=saas_data_exporter
Wait for <>
time (time for incremental updates). If you still do not see your data, create a Support ticket.
If your product attribute data isn’t synced correctly for a specific attribute code, do the following:
Use the following SQL query and verify that you have the data you expect in the feed_data
column. Also, make a note of the modified_at
timestamp.
select * from catalog_data_exporter_product_attributes where json_extract(feed_data, '$.attributeCode') = '<your_attribute_code>' and sto1re_view_code = '<your_ store_view_code>';
If you do not see the correct data, use the following command to reindex and then rerun the SQL query in step 1 to verify the data.
bin/magento indexer:reindex catalog_data_exporter_product_attributes
If you still do not see the correct data, create a Support ticket.
If you see the correct data in catalog_data_exporter_product_attributes
:
Use the following SQL query to check the timestamp of the last export. It should be after the modified_at
timestamp.
select * from flag where flag_code = 'product-attributes-feed-version';
If the timestamp is older, you can either wait for the next cron run or trigger it yourself using the following command:
bin/magento cron:run --group=saas_data_exporter
Wait for 15-20 minutes (time for incremental updates). If you still do not see your data, please create a Support ticket.
(Known issue) If you have changed your API configuration, which results in a change in your Data Space ID and find that your catalog changes are no longer syncing, run the following commands:
bin/magento saas:resync --feed products
bin/magento saas:resync --feed productattributes
See Onboard Live Search in our user documentation.