Hi I have been trying from past two days to import products from csv file to new database in openerp and whenever i try I get this error : ValueError: No such external ID currently defined in the system: __export__.product_product. I tried importing with compatible fields only and then added all the required fields, then i exported almost a dozen of product.product csv file successfully but on importing it gives the above mentioned error. Please help anyone asap. Really urgent.
External ID Active Can be Rent Can be Sold Category Category/ID Category/Name Company/ID Cost Price Costing Method Default Unit Of Measure Default Unit Of Measure/Name Inventory Valuation Measure Type Name Name Net weight Procurement Method Product Type Product Template/Category Product Template/Category/Name Product Template/Cost Price Product Template/Costing Method Product Template/Default Unit Of Measure Product Template/Default Unit Of Measure/Name Product Template/Default Unit Of Measure/UoM Type Product Template/ID Product Template/Measure Type Product Template/Name Product Template/Procurement Method Product Template/Product Type Product Template/Supply method Public Price Purchase Unit of Measure Quantity Available Quantity On Hand Reference Sale Price Status Supply method Track Incoming Lots Track Manufacturing Lots Track Outgoing Lots UOM -> UOS Coeff Variant Price Extra Variant Price Margin Variants Warranty (months) product_tmpl_id/id product:1cb06470-015b-11e2-b87f-f46d04dd7c3a.product_product-3gAfy02Z8ozx TRUE FALSE TRUE __export__.product_category_456 456 Adhesive 1 1 Standard Price product.product_uom_kgm kg Real Time (automated) fixed Tile Fixer (Bag) Faros Tile Fixer (Bag) Faros Make to Stock Consumable __export__.product_category_456 Adhesive 1 Standard Price product.product_uom_kgm kg reference 2414 fixed Tile Fixer (Bag) Faros Make to Stock Consumable Buy 285 product.product_uom_kgm 992 993 Adhesive 285 Normal Buy FALSE FALSE FALSE 1 1
product:1cb06470-015b-11e2-b87f-f46d04dd7c3a.product_product-L7JnbHDTHG7w TRUE FALSE TRUE __export__.product_category_456 456 Adhesive 1 1 Standard Price product.product_uom_kgm kg Real Time (automated) fixed Tile Grout Tile Grout Make to Stock Consumable __export__.product_category_456 Adhesive 1 Standard Price product.product_uom_kgm kg reference 2410 fixed Tile Grout Make to Stock Consumable Buy 50 product.product_uom_kgm 996 997 Adhesive 50 Normal Buy FALSE FALSE FALSE 1 1
product:1cb06470-015b-11e2-b87f-f46d04dd7c3a.product_product-GpgPnbs6Hrbq TRUE FALSE TRUE __export__.product_category_632 632 1.800 Kg 1 1 Standard Price product.product_uom_unit PCE Real Time (automated) fixed Araldite 1.800 Kg Araldite 1.800 Kg Make to Stock Consumable __export__.product_category_632 1.800 Kg 1 Standard Price product.product_uom_unit PCE reference 976 fixed Araldite 1.800 Kg Make to Stock Consumable Buy 935 product.product_uom_unit 998 999 Adhesive / Araldite / 1.800 Kg 935 Normal Buy FALSE FALSE FALSE 1 1
product:1cb06470-015b-11e2-b87f-f46d04dd7c3a.product_product-f1qsZMi1l1YF TRUE FALSE TRUE __export__.product_category_638 638 13 Gm 1 1 Standard Price product.product_uom_unit PCE Real Time (automated) fixed Araldite 13 Gm Araldite 13 Gm Make to Stock Consumable __export__.product_category_638 13 Gm 1 Standard Price product.product_uom_unit PCE reference 982 fixed Araldite 13 Gm Make to Stock Consumable Buy 32 product.product_uom_unit 995 1000 Adhesive / Araldite / 13 Gm 32 Normal Buy FALSE FALSE FALSE 1 1
product:1cb06470-015b-11e2-b87f-f46d04dd7c3a.product_product-Xonkk2ryllgU TRUE FALSE TRUE __export__.product_category_635 635 180 Gm 1 1 Standard Price product.product_uom_unit PCE Real Time (automated) fixed Araldite 180 Gm Araldite 180 Gm Make to Stock Consumable __export__.product_category_635 180 Gm 1 Standard Price product.product_uom_unit PCE reference 979 fixed Araldite 180 Gm Make to Stock Consumable Buy 232 product.product_uom_unit 995 1000 Adhesive / Araldite / 180 Gm 232 Normal Buy FALSE FALSE FALSE 1 1
product:1cb06470-015b-11e2-b87f-f46d04dd7c3a.product_product-aI_hDM8o4GdA TRUE FALSE TRUE __export__.product_category_631 631 3.600 Kg 1 1 Standard Price product.product_uom_unit PCE Real Time (automated) fixed Araldite 3.600 Kg Araldite 3.600 Kg Make to Stock Consumable __export__.product_category_631 3.600 Kg 1 Standard Price product.product_uom_unit PCE reference 975 fixed Araldite 3.600 Kg Make to Stock Consumable Buy 1645 product.product_uom_unit 998 1000 Adhesive / Araldite / 3.600 Kg 1645 Normal Buy FALSE FALSE FALSE 1 1
product:1cb06470-015b-11e2-b87f-f46d04dd7c3a.product_product-Yhd665PMzLe2 TRUE FALSE TRUE __export__.product_category_637 637 36 Gm 1 1 Standard Price product.product_uom_unit PCE Real Time (automated) fixed Araldite 36 Gm Araldite 36 Gm Make to Stock Consumable __export__.product_category_637 36 Gm 1 Standard Price product.product_uom_unit PCE reference 981 fixed Araldite 36 Gm Make to Stock Consumable Buy 82 product.product_uom_unit 983 989 Adhesive / Araldite / 36 Gm 82 Normal Buy FALSE FALSE FALSE 1 1
product:1cb06470-015b-11e2-b87f-f46d04dd7c3a.product_product-vALnw9xNbBt4 TRUE FALSE TRUE __export__.product_category_634 634 450 Gm 1 1 Standard Price product.product_uom_unit PCE Real Time (automated) fixed Araldite 450 Gm Araldite 450 Gm Make to Stock Consumable __export__.product_category_634 450 Gm 1 Standard Price product.product_uom_unit PCE reference 978 fixed Araldite 450 Gm Make to Stock Consumable Buy 495 product.product_uom_unit 999 1000 Adhesive / Araldite / 450 Gm 495 Normal Buy FALSE FALSE FALSE 1 1
__export__.product_product_977 TRUE FALSE TRUE __export__.product_category_633 633 700 Gm 1 1 Standard Price product.product_uom_unit PCE Real Time (automated) fixed Araldite 700 Gm Araldite 700 Gm Make to Stock Consumable __export__.product_category_633 700 Gm 1 Standard Price product.product_uom_unit PCE reference 977 fixed Araldite 700 Gm Make to Stock Consumable Buy 580 product.product_uom_unit 1000 1000 Adhesive / Araldite / 700 Gm 580 Normal Buy FALSE FALSE FALSE 1 1
__export__.product_product_980 TRUE FALSE TRUE __export__.product_category_636 636 90 Gm 1 1 Standard Price product.product_uom_unit PCE Real Time (automated) fixed Araldite 90 Gm Araldite 90 Gm Make to Stock Consumable __export__.product_category_636 90 Gm 1 Standard Price product.product_uom_unit PCE reference 980 fixed Araldite 90 Gm Make to Stock Consumable Buy 140 product.product_uom_unit 1000 1000 Adhesive / Araldite / 90 Gm 140 Normal Buy FALSE FALSE FALSE 1 1
product:1cb06470-015b-11e2-b87f-f46d04dd7c3a.product_product-ooTaaKYZHO0L TRUE FALSE TRUE __export__.product_category_567 567 1 Kg 1 1 Standard Price product.product_uom_unit PCE Real Time (automated) fixed DDL DDL Make to Stock Consumable __export__.product_category_567 1 Kg 1 Standard Price product.product_uom_unit PCE reference 933 fixed DDL Make to Stock Consumable Buy 62 product.product_uom_unit 999 1000 Adhesive / DDL / 1 Kg 62 Normal Buy FALSE FALSE FALSE 1 1
__export__.product_product_1001 TRUE FALSE TRUE __export__.product_category_654 654 Duckorning 1 1 Standard Price product.product_uom_unit PCE Real Time (automated) fixed Silicon Black 789 Silicon Black 789 Make to Stock Consumable __export__.product_category_654 Duckorning 1 Standard Price product.product_uom_unit PCE reference 1001 fixed Silicon Black 789 Make to Stock Consumable Buy 158 product.product_uom_unit 1000 1000 Adhesive / Duckorning 158 Normal Buy FALSE FALSE FALSE 1 1
product:1cb06470-015b-11e2-b87f-f46d04dd7c3a.product_product-o6nW0AffN1AR TRUE FALSE TRUE __export__.product_category_640 640 20 Gm 1 1 Standard Price product.product_uom_unit PCE Real Time (automated) fixed Fevi Quick 20 Gm Fevi Quick 20 Gm Make to Stock Consumable __export__.product_category_640 20 Gm 1 Standard Price product.product_uom_unit PCE reference 983 fixed Fevi Quick 20 Gm Make to Stock Consumable Buy 85 product.product_uom_unit 999 999 Adhesive / Fevi Quick / 20 Gm 85 Normal Buy FALSE FALSE FALSE 1 1
product:1cb06470-015b-11e2-b87f-f46d04dd7c3a.product_product-j3N5hBDvqYPw TRUE FALSE TRUE __export__.product_category_474 474 1 Kg 1 1 Standard Price product.product_uom_unit PCE Real Time (automated) fixed Fevicol Marine Fevicol Marine Make to Stock Consumable __export__.product_category_474 1 Kg 1 Standard Price product.product_uom_unit PCE reference 849 fixed Fevicol Marine Make to Stock Consumable Buy 190 product.product_uom_unit 999 1000 Adhesive / Fevicol Marine / 1 Kg 190 Normal Buy FALSE FALSE FALSE 1 1
product:1cb06470-015b-11e2-b87f-f46d04dd7c3a.product_product-uYChCNMImNAw TRUE FALSE TRUE __export__.product_category_471 471 10 Kg 1 1 Standard Price product.product_uom_unit PCE Real Time (automated) fixed Fevicol Marine Fevicol Marine Make to Stock Consumable __export__.product_category_471 10 Kg 1 Standard Price product.product_uom_unit PCE reference 846 fixed Fevicol Marine Make to Stock Consumable Buy 1700 product.product_uom_unit 995 995 Adhesive / Fevicol Marine / 10 Kg 1700 Normal Buy FALSE FALSE FALSE 1 1
__export__.product_product_848 TRUE FALSE TRUE __export__.product_category_473 473 2 Kg 1 1 Standard Price product.product_uom_unit PCE Real Time (automated) fixed Fevicol Marine Fevicol Marine Make to Stock Consumable __export__.product_category_473 2 Kg 1 Standard Price product.product_uom_unit PCE reference 848 fixed Fevicol Marine Make to Stock Consumable Buy 370 product.product_uom_unit 1000 1000 Adhesive / Fevicol Marine / 2 Kg 370 Normal Buy FALSE FALSE FALSE 1 1
__export__.product_product_845 TRUE FALSE TRUE __export__.product_category_470 470 20 Kg 1 1 Standard Price product.product_uom_unit PCE Real Time (automated) fixed Fevicol Marine Fevicol Marine Make to Stock Consumable __export__.product_category_470 20 Kg 1 Standard Price product.product_uom_unit PCE reference 845 fixed Fevicol Marine Make to Stock Consumable Buy 3340 product.product_uom_unit 1000 1000 Adhesive / Fevicol Marine / 20 Kg 3340 Normal Buy FALSE FALSE FALSE 1 1
__export__.product_product_844 TRUE FALSE TRUE __export__.product_category_469 469 30 Kg 1 1 Standard Price product.product_uom_unit PCE Real Time (automated) fixed fevicol Marine fevicol Marine Make to Stock Consumable __export__.product_category_469 30 Kg 1 Standard Price product.product_uom_unit PCE reference 844 fixed fevicol Marine Make to Stock Consumable Buy 4970 product.product_uom_unit 1000 1000 Adhesive / Fevicol Marine / 30 Kg 4970 Normal Buy FALSE FALSE FALSE 1 1
__export__.product_product_847 TRUE FALSE TRUE __export__.product_category_472 472 5 Kg 1 1 Standard Price product.product_uom_unit PCE Real Time (automated) fixed Fevicol Marine Fevicol Marine Make to Stock Consumable __export__.product_category_472 5 Kg 1 Standard Price product.product_uom_unit PCE reference 847 fixed Fevicol Marine Make to Stock Consumable Buy 880 product.product_uom_unit 1000 1000 Adhesive / Fevicol Marine / 5 Kg 880 Normal Buy FALSE FALSE FALSE 1 1
I get the same type of error when i tried importing partners. Though I imported partners successfully but there also I did not get the total receivable and payable amounts.
Post your CSV file. It is not possible to guess what you are doing from your description.
I get this everytime I try to import my products! is there a way to get out of it? ValueError: No record found for __export__.product_category_456, already imported my product_category and uom. Even I tried with fresh databases with a restore but all i get is the above error.
I don't know how do I attached my csv here. Let me know and I retry again. The above formatted text is my csv data.
Use http://www.zippyshare.com/ - post both your Product Categories and Products CSV files.
Do anyone know if we can import partners with their total receivables?
http://www38.zippyshare.com/v/26109410/file.html http://www38.zippyshare.com/v/16768720/file.html
Your product_category.csv file imported fine for me. You should not be importing product_tmpl_id/id for products - templates are automatically created for your products. Try importing your product without that column
Then it gives error: product_tmpl_id/id not selected!
Sorry - import BLANK values in this field.
I am now able to import products successfully but one issue is there, that the "quantity available" and "quantity on hand" are not getting imported while my csv do contain these two fields.
The quantity of products cannot be imported this way. These fields are 'functional' fields which means OpenERP gets their values from other information and you cannot supply values for them. You need to import and process an inventory, or import and process incoming shipments - to get stock of products. Check out the other questions on this help forum related to importing inventory.