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.

1

Inventory with many variants is choking our system

By
kim
on 1/21/16, 4:10 PM 431 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.
kim
on 1/21/16, 8:25 PM
0

Ermin Trevisan

--Ermin Trevisan--
3548
| 6 3 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/

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

1 follower(s)

Stats

Asked: 1/21/16, 4:10 PM
Seen: 431 times
Last updated: 1/22/16, 12:23 PM