Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
Hello Odoo, I created a product with attribute of [Service Type] and added variants to test our importing. I exported the file as is and only tried to import it and I received errors saying "no matching records" and other errors.
Can anyone help me understand where I went wrong?
To update prices, go to Variants and export / import from there.
Either Export all or select records from the List View
Tick the box "I want to update data"
Open the Excel file and amend prices:
Save the file
Go back to the List View and use the Import option:
You must select the External ID and the field(s) you are updating. Odoo should recognize the field names from the column headings in the Excel.
The most common error is not selecting the checkbox and so you don't have the External ID and Odoo thinks you are creating a new record.
That is what I did. Got all these errors
You shouldn't get errors if your file includes the External ID and the price (or whatever else you want to update). Don't include variant values or Name. Looking at the screenshot I can't see the External ID so Odoo will be trying to create a new variant.
Hi Ammar,
I think this video can help you:
Odoo 17 is a bit different from what i notice. There is only EXPORT all option.
Hi Ammar,
The video above introduces a custom module, so if you are a programmer you can download the module to review. I tested it in Odoo 17 and found version 17 of this module is still fine.
| 関連投稿 | 返信 | ビュー | 活動 | |
|---|---|---|---|---|
|
0
2月 24
|
1540 | ||
|
2
11月 24
|
1676 | ||
|
1
11月 24
|
2193 | ||
|
0
8月 24
|
1235 | ||
|
1
6月 24
|
1676 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
What do you want to achieve? Copy a product with variants? Add variants to a product?
I created the variants in the system and wanted to adjust the prices instead of adjusting them one by one. So I exported the excel file, changed the amounts and tried importing it back. Received these errors. Even If I do not make any changes to the exported file, I get the same errors.