Skip to main content

How to get custom attribute value with product id of enableenabled product with SQL query in Magento 2  ?

I am using

SELECT entity_id,value FROM catalog_product_entity_varchar WHERE attribute_id = 150

But it gives me all data iI want these data only forto enable products.

Any help is appreciated.

How to get custom attribute value with product id of enable product with SQL query in Magento 2  ?

I am using

SELECT entity_id,value FROM catalog_product_entity_varchar WHERE attribute_id = 150

But it gives me all data i want these data only for enable products.

Any help is appreciated.

How to get custom attribute value with product id of enabled product with SQL query in Magento 2?

I am using

SELECT entity_id,value FROM catalog_product_entity_varchar WHERE attribute_id = 150

But it gives me all data I want these data only to enable products.

Any help is appreciated.

Source Link
Prits
  • 623
  • 8
  • 50

How to get custom attribute value with product id of enable product with SQL query in Magento 2?

How to get custom attribute value with product id of enable product with SQL query in Magento 2 ?

I am using

SELECT entity_id,value FROM catalog_product_entity_varchar WHERE attribute_id = 150

But it gives me all data i want these data only for enable products.

Any help is appreciated.