Some products cant be added to cart since Magento2.3.3

Question

We have upgraded Magento2.3.3, some products are throwing the error :

Product that you are trying to add is not available.

I have looked online and saw something about a view called Inventory_stock_1, It exists already and I cannot figure out why my product wont add.

Here is an image of a list of products that wont add to cart (except the first one, that works)

Has anyone had this since the new update?

Answer 1

First, take a backup of the inventory_source_item table.

Now execute below SQL query in MySQL,

INSERT IGNORE INTO `inventory_source_item` (source_code, sku, quantity, status)
select 'default', sku, qty, stock_status from (`cataloginventory_stock_status` as `lg` join `catalog_product_entity` as `prd` on((`lg`.`product_id` = `prd`.`entity_id`)))

Execute the below command.

• php bin/magento indexer:reindex

• php bin/magento cache:flush

And check it.