Odoo Help


Inventory with many variants is choking our system

on 1/21/16, 4:10 PM 823 views

We manufacture custom tiles.  Our tiles come in a variety of colors, finishes and sizes.  The large matrix of options is ideal for Odoo's variants model, where we build one product line with many variants (>100,000 items generated).  When we try to build the template there is no problem but the system quickly bogs down as we try to populate the variants (loading screen runs forever, even overnight).  We went back and tried importing from spreadsheets and even loading the data directly to the tables.  It appears that anything over 200 items at a time just triggers a timeout.

After finally successfully creating our inventory items, the next problem was trying to use the system.  Running a customer order also takes forever (loading screen for minutes at a time).  We have the checked the server's resources and the server appear to be idling at 10-20%, so we don't think that is the problem.

Obviously we must be doing something wrong.

Has anyone else experienced this problem or have any advice for us?  We are using the community edition running on a Windows server.


Hi Ray. 

We are new to Odoo and the forum. Did we post the right question?  I don't see an answer. 

On Jan 21, 2016, at 1:44 PM, Ray Carnes <ray.carnes@bistasolutions.com> wrote:

A new question Inventory with many variants is chocking our system has been asked on Help. Click here to access the question.

Ray Carnes

This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
on 1/21/16, 8:25 PM

Ermin Trevisan

--Ermin Trevisan--
| 6 5 7
Walchwil, Switzerland
--Ermin Trevisan--

Ermin Trevisan
On 1/22/16, 1:34 AM

Maybe you should think of dynamic variants based on dynamic BoMs and sales orders. Did you check all the work done by the OdooMRP team in the Apps store? Especially this one: https://apps.openerp.com/apps/modules/8.0/sale_product_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: 1/21/16, 4:10 PM
Seen: 823 times
Last updated: 1/22/16, 12:23 PM