My attempts at creating a category with PHP fails while flat_categories are enabled in the system. Reference here.

So, I want to create a new category in Magento 2 using SQL. How would I do that?

  • As Magento used Eav structure for categories. So using a single SQL query category create not possible – Amit Bera Oct 1 '19 at 8:02
  • Yeah I know I can't be done with a single query. I am fine with multiple queries. – Shankar Thyagarajan Oct 1 '19 at 11:53

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.