We found a rotten pickle.
We have a webshop, with a PIM, where products are imported from AX into PIM. The products are under seperate companies in AX so in the PIM we have 2 warehouses that the products get split into, then the client adds some info to his products and publishes them to Ecommerce groups which are also split between two seperate shops.
The problem is during the import process, when we select Deactivate missing products and designate a SHOP on the Dynamicweb destination provider, the provider adds this clause to the SQL query:
Meaning that if the product exists in a warehouse in PIM, and an Ecommerce shop, it won't get deactivated.
Is this something that could be changed or is it to prevent products getting accidentally deactivated that exist in multiple shops on the frontend?