CODEWITHSUNDEEP
csvimportodooproductodoo-8
joe
joe

Reputation: 332

Odoo 8: How to import a product's Public Price from CSV?

I am trying to import a number of products into Odoo using the CSV import. The "Public Price" attribute does not seem to import correctly when creating a new product, it always defaults to 1.0. As an example, I have created a Foo product with a price of 20.00. After exporting this record, I have a CSV with the name and lst_price fields:

Export CSV

"id","name","lst_price"
"__export__.product_template_27","Foo","20.0"

To illustrate the difference between creating/updating, I have changed the price in the CSV to 50.0 and add a new product:

Import CSV

"id","name","lst_price"
"__export__.product_template_27","Foo","50.0"
"","Bar","50.0"

The import preview displays correctly, and Foo is updated to a public price of 50.00. Bar, however, is created with a public price of 1.00.

Am I missing something here? Thanks!

Joe

Upvotes: 0

Views: 1025

Answers (3)

joe
joe

Reputation: 332

It appears to be a bug, an issue has been opened on Github: https://github.com/odoo/odoo/issues/9905

Upvotes: 0

JordyRitzen
JordyRitzen

Reputation: 702

When creating a new product you should also set the id of the product. So for example __import__.Bar01 Keep in mind that the id of the product should be unique.

This should work for you:

"id","name","lst_price"
"__export__.product_template_27","Foo","50.0"
"__import__.Bar01","Bar","50.0"

Upvotes: 0

Priyesh Solanki
Priyesh Solanki

Reputation: 707

By clicking on "Import" button, odoo always create new records in the system. I would prefer you to do not import with "ID" field. Just try with it:

name,lst_price
foo,50
bar,50

It should work for you.

Upvotes: 0

Related Questions