Many2Many importing multiple rows (values) into one field - is this possible at all?

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Accounting
Inventory
PoS
Project management
MRP

Take the tour

All Posts People Badges

Tags (View all)

odoo v14 accounting v15 odoo16features

About this forum

Help

Many2Many importing multiple rows (values) into one field - is this possible at all?

import many2many importing products rows

1 Reply

6569 Views

Krys.Raj

Hello guys,

Is the importing of multiple values into one many2many field possible with standard importing tool provided by Odoo? With other relational field had no problem, but many2many makes me pulling my hair.

If that is possible, how to do it?.. I have imported products. Now try import alternative products. But not possible with the bulk row importing. Below the situation: trying to import alternative products via "Alternative Products / External ID" field identification. Seems it lack more dimensions like it was for example with attributes "Attributes / Attribute / External ID".

Any sollution for many2many without rebuilding the sheet? I do assume that using names separeted with commas would help, but i got 10 000 products guys.. It does not seem wise.

Any help would be appreciated.

Jornald

Did you write the script or something?
I face same problem

Jagdish Panchal

Best Answer

Hello

You have to separate by commas.

Suppose your field product_ids many2many field in Attribute, in file column header add product_ids/id add values of record separate by commas.

Krys.Raj

Author

Is there a way to export many2many field with comma seperated before I write a script or custom module to do this? :) Do not want to waste unnecessarily my time :)

Thanks in advance for the answer.

Krys.Raj

Author

Thanks for the answer, just wanted some confirmation of experienced guy.. you were right only this way was possible. Manage to do this.. but there should be something checkbox enablin exporting certain field in comma separated multiple values.

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

Create an account today to enjoy exclusive features and engage with our awesome community!

Related Posts	Replies	Views
Errors when importing the import-compatible-export import importing	1 Nov 24	111
Is there a list of all sales/products/ import fields? importing products	2 Sep 22	1364
import in vcard format import importing	4 Nov 18	6965
Updating imported products workflow... Solved import products	1 Mar 15	2529
Unable to import a class from sale package to stock package import importing	1 Mar 15	3337

This question has been flagged

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