Skip to Content
This question has been flagged
csvimporting data from excel fileodoo10.0
1 Reply
9256 Views
Avatar
Silviaa

I created products with demo data. I need to use this created product to the another table, so i gave the "product_id/id" as "External ID" in the csv file. while import the csv file it shows an error like "No matching record found for external id 'demo_addon.demo_product_5' in field 'Product' at row 2".

My import data:

         product_id/id
         demo_addon.demo_product_5
         demo_addon.demo_product_6
         demo_addon.demo_product_7

can anyone guide me to resolve this issue. 

Avatar
Discard
Avatar
Levenez Morgan
Best Answer

hi product_id this field maтy2one or other field with the ratio of the corresponding id should be with the table referenced to the example

 "product.product_product_7"
or
"product.product_product_7_product_template"
Avatar
Discard
Silviaa
Author

I used like as you mentioned, but it still shows this error "No matching record found for external id 'product.product_product_5' in field 'Product' at row 2"

Levenez Morgan

so in your database there is no object with this id, the number in external_id corresponds to the id in the table of the database postgresSQL check whether there is such an object in the corresponding database table

Related Posts Replies Views Activity
Import csv file with related field other than id, external id, name
import csv importing data from excel file
Avatar
Avatar
Avatar
Avatar
4
Nov 24
8901
[Odoo 10.0] Hide Pro-Forma Invoices to Employees in the Accounting Module
csv account.invoice odoo10.0
Avatar
0
Aug 17
2417
Differ context on test import and real import Solved
import csv importing data from excel file odoo11
Avatar
1
Oct 20
3868
security /groups structure and explanation with example Solved
security csv groups odoo10.0
Avatar
Avatar
1
Aug 18
13255
TypeError: error.data.arguments is undefined
csv typeerror odoo8.0 importing data from excel file
Avatar
0
Jan 17
4140