0

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)

enter image description here

Has anyone had this since the new update?

  • You have no Product Salable Quantity. – Dhaduk Mitesh Jan 23 at 11:59
  • Other products that work dont have this – Gaz Smith Jan 23 at 12:45
  • Have you face this problem in configurable products only? – Dhaduk Mitesh Jan 23 at 12:46
  • yeah just them products so far – Gaz Smith Jan 23 at 12:49
  • @DhadukMitesh Just to test saleble is there any way to edit this hard like in a table so i can test if that is the issue? – Gaz Smith Jan 23 at 12:53
3

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.

| improve this answer | |
  • Hi this worked for me, do you know why this happened? and how i can prevent it from happening again? – Gaz Smith Jan 23 at 13:44

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.