Odoo Help


on the fly variant generation

Hariharan Gopalan
on 9/19/14, 3:16 PM 1,180 views

I have products that have too many attributes and values that it makes it heavy to get the variants generated automatically. sometimes the number of variants for each product exceeds 15 - 20 K. Wondering if it would be lighter if the variants could be generated on the fly when a customer orders a particular combination. Though it is possible to get the variants generated and delete the ones not required, going through such a large number of variants manually is not an option.




Hariharan Gopalan
On 9/22/14, 10:26 AM

Thanks Fabrice. But I am more inclined with having no variants generated at all in the beginning and only generating a specific variant when a particular combination of attribute values are chosen by a visitor. Wonder if that makes sense. the reasoning is to keep the the system light and fast.


Fabrice Henrion (fhe)

--Fabrice Henrion (fhe)--
| 7 7 9
San Francisco, United States
--Fabrice Henrion (fhe)--

Director Odoo Americas

Fabrice Henrion (fhe)
On 9/20/14, 12:20 AM

One way of doing this without having to program an import script is to generate those 15K variants in Excel and import them with the import function in the list view of the products variants (not the template). Make sure the URL says model="product.product" You will probably have to import them by batch of 1000 to avoid timeout. That would be 15 imports. A little time consuming but feasible. If you want to know how to format your excel document for the import, you can export a dummy record to see how it's structured and fill in that excel document with your 15K variants.

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/19/14, 3:16 PM
Seen: 1180 times
Last updated: 3/16/15, 8:10 AM