I've added products in the backend even a test one. But they will not show up no matter what we do.

We have already tried php bin/magento indexer:reindex in the SSH We have cleared the cache, It worked on the local build but once we pushed it up it just refused to work. All the products have been manually added.

Im pulling my hair out at the moment.

They are visible in backend, But not in frontend, I cant see them in the products menu.

Does anyone have any ideas what on earth is going on?

I've editing the following files: app\code\Modules\Catalog\etc\di.xml app\code\Modules\Catalog\Model\Indexer\Category\Product\Action\Full.php

As referenced in this stackoverflow link https://stackoverflow.com/questions/33927658/products-is-not-showing-up-on-magento2-subcategory#answer-44364827

We have also tried invalidating and then reindexing.

Any advice would be greatly appreciated.


We decided to see if we could view the product its self by going to its direct url and we got an inventory_stoc_1 Error

  • Checked visibility and status on both top level scope and individual store scope? Also how did you add products? Through manual add process via backend? Jun 12, 2019 at 10:59
  • @DominicXigen We Added manually in the back end, Then they got overwritten by upload Later on. Jun 12, 2019 at 11:05

1 Answer 1


Fixed! :)

Refrence this awnser: Error with integration test

We applied the following code into the SQL:

VIEW `inventory_stock_1` AS select
    distinct `legacy_stock_status`.`product_id` AS `product_id`,
    `legacy_stock_status`.`website_id` AS `website_id`,
    `legacy_stock_status`.`stock_id` AS `stock_id`,
    `legacy_stock_status`.`qty` AS `quantity`,
    `legacy_stock_status`.`stock_status` AS `is_salable`,
    `product`.`sku` AS `sku`
    ( `cataloginventory_stock_status` `legacy_stock_status`
join `catalog_product_entity` `product` on
        (( `legacy_stock_status`.`product_id` = `product`.`entity_id` )));

Thank you for any help. Problem is now solved.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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