Products hidden after re-index

[XWEB4U]

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

[JoshBR]

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

[idlea]

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.

[idlea]

to make this searchable, magento2 products not showing on front end.

[idlea]

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.

[idlea]

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.

[idlea]

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

[Ashish Kacha]

I resolved this issue after completely clearing all products (truncating MYSQL) I did the following two steps

1. 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

2. 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