Skip to Content
Menu
This question has been flagged
1 Reply
5283 Views

after export product file , inserted several products with as much as details possible. After that, when import the CSV file All items validated except the external ID (the error is Missing required value for the field 'name'. This might be 'Name' in the current model, or a field of the same name in an o2m) even if it chosen ? the system generate number per each product in external ID so we need to know how the system generate it ? when add new item in CSV file how can we put it , based on what ?

Avatar
Discard
Best Answer
active;purchase_ok;sale_ok;product_tmpl_id/id ;product_tmpl_id/name;company_id/id;standard_price;cost_method;sale_delay;uom_id/id;property_stock_inventory/id;valuation;produce_delay;mes_type;name;property_stock_procurement/id;procure_method;type;property_stock_production/id;uom_po_id/id;default_code;list_price;supply_method;track_incoming;track_production;track_outgoing;uos_coeff;price_margin
True;True;True;;;base.main_company;40.0;Standard Price;7.0;product.product_uom_unit;stock.location_inventory;Periodical (manual);1.0;fixed;Your product name;stock.location_procurement;Make to Stock;Stockable Product;stock.location_production;product.product_uom_unit;Your_product_def_code;50.0;Buy;False;False;False;1.0;1.0

Just put this in a simple file. Save as something.csv Go to the Sale/Product Import >> choose the csv. Set the separator to ';' Set the product_tmpl_id column to product_tmpl_id if necessary. And just Execute. Must be read, under 6.1, if not you have a problem vith csv strucure, check by some table editor like excell, or Libre...

Avatar
Discard
Related Posts Replies Views Activity
2
May 25
646
2
Mar 24
2637
1
Feb 22
2048
5
Nov 21
12340
1
Mar 17
2989