- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Products hidden after re-index
Hi
I am using Magento 2.1
I have an issue that after i re-index products get hidden. I do have a work around but this is not good. Let me explain how I reproduce error then what i do to fix.
1. Upload via emagic 7000 products
2. I notice as the products are been loaded that the front end is looking good
3. After upload products automatically indexed (or i run index command)
4. Products are hidden from front end
( i.e
1 page should have 1,500 products but now only shows 500
another page should have 6,000 products but now only shows 500
and a page showing all records with 7,500 now only shows 500)
I can fix this by doing the following
1. run this sql query to disable all products
UPDATE catalog_product_entity_int SET value =0 WHERE attribute_id =94
2. run re-index command
php bin/magento indexer:reindex
3. run sql query to enable all products
UPDATE catalog_product_entity_int SET value =1 WHERE attribute_id =94
4. run re-index command
php bin/magento indexer:reindex
5. run this command (twice)
php bin/magento cron:run
php bin/magento cron:run
then all products display again. but if i run re-index again I have to repeat steps i to 5 to get working again which is not very good.
I also notice that the below 2 commands cause the issue, all other index commands run seperatly cause no problems
php bin/magento indexer:reindex catalog_category_product
php bin/magento indexer:reindex catalog_product_category
How can I fix this permanently? any ideas
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Products hidden after re-index
Hi, did you solve this? I have a similar issue.
I have 83 products in my catalogue but only 60 are showing.
http://misfitshapes.com/surfboards/art.html
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Products hidden after re-index
Hey, did you fix this problem, I have an intermittent problem after update to Magento ver. 2.1.6
I thought I had fixed my altering the configurable attribute but must have been coincidental.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Products hidden after re-index
to make this searchable, magento2 products not showing on front end.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Products hidden after re-index
Hey, did you fix this problem, I have an intermittent problem after update to Magento ver. 2.1.6 I thought I had fixed my altering the configurable attribute but must have been coincidental.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Products hidden after re-index
fixed
re Magento2 products not showing front end
Hi I had a similar problem. Using collar size as an attribute I used for example 16 16.5 17 and so on.
I recalled that when using 1.7 I could not use " for inches I used in instead.
Changing the collar size in simple products fixed it and the product then appeared on the front end.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Products hidden after re-index
FIXED BY NOT USING THE DOT AND USING FOR EXAMPLE (161/2 in) INSTEAD OF 16.5 NO BRACKETS OF COURSE.
There are some characters that cannot be used in manage label/label options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Products hidden after re-index
I resolved this issue after completely clearing all products (truncating MYSQL) I did the following two steps
Followed the details in the below link to truncate all tables that to delete all data ready for re-import. Obviously get a back up of your data to re-import first
Checked mysql and truncated all tables in mysql beginning with 'catalog_' EXCEPT catalog_product_link_type
3.logeed in as ssh and ran the following commands cd public_html php -f bin/magento indexer:reindex