Bulk Category Insert to DB

  • Trying to insert categories in bulk using direct DB insert. Inserted into 'category' table and 'category_translations' table with id and parent_id relations correctly inserted. I am facing two issues.

    #1 in the Admin interface categories, they do not show up in the right hierarchy [ parent-child tree], editing a category and moving on the parent category selection do not show up all the available categories, instead they show a few categories.
    Is this something to do with '_lft' and '_rgt' columns? if so what is the logic to generate it?

    #2 url_path --> is there a way to disable automatic generation of this while performing a bulk insert Via DB because despite the given value it is updated from elsewhere [ using triggers I guess ]?

    Please give me an overview on how I can externally insert categories into bagisto db directly as in future we would like to have a category & product sync service created where we can dynamically add categories and products directly to db. But for now let's start with categories.

    Thank you

Log in to reply