|
I\\\\\\\\\\\\\\\’m looking for SQL or the API approach to do the following:
1) Get a collection of all Simple products with Inventory > 0
2) With the list of skus from Step 1, look up their Configurable and see if an Active Level 2 or greater Category is NOT assigned
Example of a product assigned to a
Product:100-500 (config)
--------------100-500-XL-GRN (simple)
-------------------Stock: 10
Product/Categories:
---100-500 (config)
-------root /
------------Mens (category)
Find the Products that do not have a category assigned.
|
