Month: May 2017

magento 2

check product status for configurable et simple

select ce.sku,ci.`attribute_id`,ci.value ,ci.store_id from catalog_product_entity as ce inner join catalog_product_entity_int as ci on ce.row_id=ci.row_id where ce.sku in ( '050-3923-MASTER', '050-3880-MASTER', '050-3899-MASTER', '050-3853-MASTER', '050-3914-MASTER', '056-4128-MASTER', '056-4173-MASTER', '056-4182-MASTER', '056-4207-MASTER', '056-4191-MASTER', '060-9069-MASTER', '060-9078-MASTER', '060-9087-MASTER', '060-9096-MASTER', '060-9041-MASTER') and ci.attribute_id=97 UNION all select ce.sku,ci.`attribute_id`,ci.value ,ci.store_id...