How to import Product Categories tree structure?

Question

In the Inventory app, does anyone know how to import Product Categories so as to preserve parent/child relationships.
Relations of depth 1, I can do.  For example, if I want to make two new categories (Metals, Plastics) as children of the default "All" category, I can import the following spreadsheet:
*id*
*name*
*child_id/name*
product.product_category_all
All
Metals

Plastics
But I can't for the life of me figure out how to import fields of depth greater than 1.
For example, if I wanted the f

Luc Bernard · Answer

Is there still no 1-step import solution for this? I need to import 250 categories up to 5 levels deep.

Anusha · Answer

Hi,
Please refer this  sheet [1]     https://ibb.co/QF0SqLQ [2]

[1] https://ibb.co/2FYFBJ5
[2] https://ibb.co/QF0SqLQ

Answer

Anyone know how this can be done with a single import step, using a single spreadsheet?

Control the external ID yourself, then you can import all of your categories, both parent/child category.
For example,
External ID Parent External ID Product Category Name
M0
Metals
M1 M0 Aluminium
M2 M0 Stainless Steel   Hope this help :)

mike@rehabtronics.com · Answer

The only workaround way I can figure is to:
Ensure that the Product Categories "All / Metals" and "All / Plastics" already exists in the Odoo database (see instructions in original post).
Select the "All / Metals" Product Category in Odoo, and click "Action -> Export"
Select "Update data (import-compatible export)" radio button, then export the "External ID" field.
Repeat 2-3) for the "All / Plastics" category
Copy and paste the External IDs into the following new spreadsheet, which can be impor

id	child_id/name
(paste "All / Metals" External ID here)	Aluminium
	Stainless Steel
(paste "All / Plastics" External ID here)	Nylon
	PVC

Related Posts	Odgovori	Prikazi
How to Import Products with a 3-Level Classification Hierarchy: Product Category, Classification , and Sub-Category? import importing productcategory colum	1 avg. 25	113
Importing Physical Inventories with Serial Numbers stock import inventory serial_number importing	2 mar. 15	7329
Errors when importing the import-compatible-export import importing	1 nov. 24	1561
opening stock import inventory	1 apr. 25	1791
Receipt Transfer import record issue import inventory	3 okt. 23	2760

This question has been flagged

Enjoying the discussion? Don't just read, join in!

id	name	child_id/name
product.product_category_all	All	Metals
		Plastics

External ID	Parent External ID	Product Category Name
M0		Metals
M1	M0	Aluminium
M2	M0	Stainless Steel