I have a Magento 2.3.6 installation using multi inventory. I have the following setup: There many websites. Each website is assigned specific and unique stock. Also, each stock is assigned a unique source. As a result, there do not exist any common sources between websites (each source "feeds" one specific website).
The expected result is the following: The products are common between websites (global products) and when you browse a specific website, each product should read the stock that corresponds to current website. So, the same product could be available in website A because it reads stock from stock A, and unavailable in website B because it read stock B.
Actual result: In reality, it seems that magento fails to manage multiple sources in combination with many websites. When I browse a category page of a website and filter products, it seems that stocks are not taken into account.
Hint: I checked the records in cataloginventory_stock_item and cataloginventory_stock_status. In both tables the column 'website_id' is '0' for all records. I expected to see records from all websites. I have also logged mysql queries, as you see in the attached photo the website_id and stock_id correspond to we website 0, despite browser being in another website. I have attached some photos to help you understand. Has anyone ever faced the same problem? Any solution? Also, if anyone knows an extension that solves the problem it would be nice.
Thanks in advance