How to bulk create 27,000 wordpress categories?

Question

WordPress

Good afternoon!
Please tell me, I have a catalog tree of 27 thousand categories in txt format of this type:
Product catalog
-Repair and decoration
-Doors
---Interior doors
----BRAND
-----Yasin
-----Oka
- ----Prima Port
-----VERDA (Odintsovo)
.....
.....
.....
and so on.
How can I bulk import them into Wordpress? I tried many plugins like Quick Bulk Taxonomy Term Creator and others. I did everything on Denver, played with the php and mysql settings, nothing helps, everything hangs and crumbles, and it’s not an option to load parts in parts, since these plugins do not keep nesting the next part of the import. I saw they wrote that it is possible directly to the database as it is possible, but I did not find information on how exactly to do this.
Please tell me how to do this, I can’t believe that when creating directories they are added manually.

Answer 1

Well, a ready-made plugin is unlikely. I would "navigate" like this:
1. We write a script that parses a text file and builds an object with the required nesting levels
2. We study the structure of the category table in the database
3. We generate an sql file with queries from the object from step 1
4. We import into the database
Naturally on the test database, that's all))

Answer 2

BulkPress - something like this, only you have to replace the "-", I guess. But it's simple.
Directly in the database - look for a table with categories, see how it is organized, make the appropriate insert