When you have to import a list of products, you may face a category structure as follow :

It means you have to manually create each category and to link it to the right parent. In case of large imports, here is a the tool that allows you to generate the CSV files to import a category structure. Each "simple" model that allows a parent ID is compatible : product categories, PoS categories, accounts groups, tags, etc.

1. Create this the following folder to your own Drive : 

2. Create a folder named "Output" in the same folder.

3. Open the GSheet and rename the sheet as the name of the model in which you will create the records (example : product_categories). This name will be used in the generated External ID. 

4. Paste your category structure, each column is a depth and each row has to contain the full path.

5. Launch the generation by clicking on the menu "Scripts > Categories Importer" 

6. Check the "Output", you will find a CSV file per level.

7. Import these CSV files in order.

8. Export the categories and map the lowest level with each associated record (example : products).

9. Import the records.

Tips :

- The srcipt automatically removes the duplicates.

- You can use "PoS & Product Categories Importer" to generate the same categories for products and PoS.