1

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?

9
  • You have no Product Salable Quantity. Jan 23, 2020 at 11:59
  • Other products that work dont have this
    – Gaz Smith
    Jan 23, 2020 at 12:45
  • Have you face this problem in configurable products only? Jan 23, 2020 at 12:46
  • yeah just them products so far
    – Gaz Smith
    Jan 23, 2020 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, 2020 at 12:53

1 Answer 1

5

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.

2
  • Hi this worked for me, do you know why this happened? and how i can prevent it from happening again?
    – Gaz Smith
    Jan 23, 2020 at 13:44
  • works for me as well I am adding product via rest API Dec 27, 2021 at 13:38

Your Answer

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

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