Useful direct SQL queries for Magento 2 developers

February 14, 2018 Iyngaran Iyathurai 0

Select product default Attribute set id

  Select product Attribute Group Id by using attribute_group_code and Attribute Set ID

  Update attribute_group_id for product attribute

  Update sort_order for product attribute

  Delete a custom attribute using entity_type_id and attribute_code. Delete a custom attribute using entity_type_id and attribute_code.  For this example, I am going to delete a product attribute, which has  attribute_code as ‘iyn_product_option’. To delete a custom attribute, we need to […]