Odoo Help

Welcome!

This community 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.

0

How to import products from .csv file with "attribute price extra"?

By
Güney Çıngı
on 1/10/15, 4:44 AM 1,551 views

I am creating all my product definitions by importing from a .csv file.

Many of the products i create, has variants that are common (i.e. coatings types on aluminum profiles) for product categories. I can create each variant on profile by following columns:

product_variant_ids/attribute_line_ids/attribute_id

product_variant_ids/attribute_line_ids/value_ids

Is there a way to import them also with the extra prices for each product variant? Or any other way besides importing?

You want to include the extra_prices of variants while importing?

Akhil P Sivan
on 1/11/15, 7:53 AM

Yes, this is what i need to do while importing. Otherwise, takes to much time to edit extra prices for each product within odoo.

Güney Çıngı
on 1/12/15, 2:41 AM

@erastus, yes, users can also see products created by admin. So did you achieve to import extra prices while importing?

Güney Çıngı
on 1/12/15, 2:43 AM
0
Giuliano Lotta
On 8/2/15, 5:40 PM

Dear Güney Çıngı,

As for version 8.0, you will NOT find the price_extra field in the import available fields.

As you can check in the product.py file, The price_extra is a COMPUTED field.

 price_extra=fields.function(_get_price_extra, type='float', string='Variant Extra Price', help="This is the sum of the extra price of all attributes", digits_compute=dp.get_precision('Product Price')), 

A product template may have multiple product variants that have a combination of some attribute values. EACH single attribute value can have an extra price. The SUM of those extra prices for applicable product variant attributes, will be calculated as the price_extra.

0
Erastus
On 1/10/15, 2:26 PM

I am learning this topic as well .  What I did is to select all the fields in the demo database and export that to a file.  I used that as an example.  This helped me to learn the process and also Mohamed Magdy helped me. The documentation re this is a little ifish ( if I may say)

 

If you import yours as admin can the users see that product?

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

3 follower(s)

Stats

Asked: 1/10/15, 4:44 AM
Seen: 1551 times
Last updated: 8/2/15, 5:40 PM