Odoo Help


Which value do I need to use for the field name if I am importing a sales quotation? OpenERP is demanding a name field to import a sales quotation

on 9/10/14, 4:05 PM 1,081 views

I like to export a sales quotation and modify the quantities. OpenERp is demanding valöue for name and suggesting to use "order reference" for the field name. I did it but despite that I got the error below

Missing required value for the field 'name'. This might be 'Order Reference' in the current model, or a field of the same name in an o2m.

On 9/11/14, 1:10 PM


thanks for the support. I exported a sales quotation - with all requiered field. Import works. But as soon ad to the import product quantity and id fields ERP asks for a name field. Strange. 

Previous import without product quantity and id fields works 


Ray Carnes

--Ray Carnes--
| 9 7 9
Keyport, United States
--Ray Carnes--

Senior ERP Analyst

OpenERP 6.1, 7.0; Odoo 8.0, 9.0, 10.0 and 11.0.

Completed Odoo Functional and Technical Training.

Functional Areas:

  • CRM/Sales

  • Inventory

  • Manufacturing

  • Accounting

  • Purchasing

Major Skills:

  • Business Process Reengineering

  • Efficiency Consulting

  • User Needs and GAP Analysis;

  • Functional and Technical Design;

  • Prototyping and Proof of Concepts;

  • Requirements Specifications;

  • Agile Implementation;

  • Data Migration;

  • Configuration & Customization (UI and code);

  • Integration - Odoo and non Odoo Applications and Services;

  • Training and Knowledge Transfer;

  • Go Live Support;

  • Helpdesk;

  • Version Upgrades and Migration.

  • Accounting Expert.

I have over 20 years of experience empowering and enabling users with enterprise information systems that make a real and measurable difference in their ability to proactively manage their businesses and organizations. 

I am a skilled Communicator and I only take the serious things seriously!

Ray Carnes
On 9/10/14, 6:58 PM

Export a Sales Quotation that is already created and see how it exports to learn the field names and which ones are required and optional.  You also need a 'name' for every line in the quote - do you have that information also?

(From the help on the Import page):

If you want to import sales order having several order lines; for each order line, you need to reserve a specific row in the CSV file. The first order line will be imported on the same row as the information relative to order. Any additional lines will need an addtional row that does not have any information in the fields relative to the order.

As an example, here is sample CSV file of some quotations you can import, based on demo data.

"Order Reference","Supplier","Destination","Pricelist","Order Lines / Product","Order Lines / Quantity"
"PO000020","ASUSTeK","Stock","Default Purchase Pricelist","ADPT",20
"PO000021","Axelor","Stock","Default Purchase Pricelist","CD",5


About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 9/10/14, 4:05 PM
Seen: 1081 times
Last updated: 3/16/15, 8:10 AM