Skip to Content
Menu
This question has been flagged

Hello. I have a problem and maybe somebody can help me. I am making plastic bottles and i have over 2000 products in my database. Now I want to add attributes for every product (neck size, color, diameter, material, etc). I need the attributes to show to my customers on website and also to generate the data sheet of the product from Odoo. I don’t want to use variants. Each product will have only one value / attribute. I know is possible to update the product from excel but please tell me a solution to add the same attributes values to all products from a category and then to export to excel, change values and upload. To add those fields in excel for more than 2000 products is a lot of work. 

Also I need a solution for the next products that I am adding. I have products in categories and it will be real help for me to have some standard attributes for every category. When add a product and set a specific category to automatically add the attributes set up for that category and only to insert the values before saving. I am using the category based on machines, moulds and material that i am using. 

I am using Odoo 13

Thank you very much and I will give some beers to the one will solve my problems

P.S. I am from Romania :) 

Avatar
Discard
Best Answer

You can do this with Automated Actions or User-defined defaults.

Automated Actions are more flexible and powerful, and they can update the values before saving a record.  You can add various conditions (so it can be based on Product Category).  

This would apply both to records entered through the user interface and uploaded from an Excel (and it's also possible to use them on existing products, through "Contextual Actions").  

Can I suggest you read these articles: Automated Actions​ and Automated Actions to set income and expense accounts (which might be close to what you want to do).

User-defined defaults are simpler, and maybe worth investigating.

Avatar
Discard
Related Posts Replies Views Activity
1
Aug 24
1001
1
Aug 22
2221
0
Mar 17
3677
0
Mar 15
2604
1
Dec 22
2433