Hello Odoo Community,
I am preparing to import a large list of products (around 300+) from a spreadsheet into Odoo, but I am facing a challenge with our product classification structure.
Our product data has a three-level hierarchy, which doesn't seem to map directly to Odoo's standard Product Category field. Here is an example of the structure:
- Product: Soft Drawn Copper Pipe 1/4"
- Level 1 (Product Category): Copper Pipe & Accessories
- Level 2 (Classification): Copper Pipe Coil
- Level 3 (Sub-Category): R410 Soft Drawn Copper Pipe Coil
I have a similar structure for other products, where the top-level classification remains the same, but the other two levels change. For example:
- Product: Hard Drawn Copper Pipe 3/8"
- Column 1 (Broadest Classification): Copper Pipe & Accessories
- Column 2 (Mid-Level Classification): Copper Pipe Length
- Column 3 (Most Specific Classification): Hard Drawn Copper Pipe
My Issue: Odoo's Product Category field appears to be a single field designed for the top-level classification (Copper Pipe & Accessories). I am trying to understand how to correctly import the other two classification levels for all my products.
My Questions:
- What is the recommended best practice in Odoo to handle this three-level classification?
- Should I be using a combination of Product Categories and Product Attributes? If so, could you please provide an example of how my import file (CSV/Excel) should be structured?
- Is this something that requires custom development or a specific module, or can it be handled with a standard Odoo import method?
Any guidance on how to structure the data and perform the import would be greatly appreciated. Thank you!
P.S here is a screenshot of the excel file
