I have imported more than 170000 configurable products, products are displayed properly in admin, but products are not displayed in front end. If I import only 30000 records at once, it will work fine.

I just tried php bin/magento indexer:reindex but not working. after reindexing catalogsearch_fulltext status shows Working is there any issue with this ?.



Follow my below suggestions for display products on the fronted.

The product should assign with correct website and category.

Product status must be enable.

Product visiblity must be Catalog Search.

Product stock status must be In Stock With Quantity.

Check it for configurable and simple product.

Run below commands

php bin/magento indexer:reindex

php bin/magento cache:clean

Delete browser cache.

  • Sorry still facing the same issue, while looking in to the "alp_indexer_state" table status for" catalogsearch_fulltext" is working, did this will cause for an error – Krishnakumar C Oct 18 '16 at 6:33
  • is flat catalog enable or disable in admin ? – Suresh Chikani Oct 18 '16 at 6:38
  • Use Flat Catalog Category and Use Flat Catalog Product shows "No " – Krishnakumar C Oct 18 '16 at 6:59
  • command "php bin/magento indexer:reindex" running without any error ? – Suresh Chikani Oct 18 '16 at 7:01
  • yes, but catalogsearch_fulltext" status shows "working" – Krishnakumar C Oct 18 '16 at 7:05

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.