Hello. Im exploring an odoo (now mainly manufacturing), If I understand correct odoo demo shows more service/workflow as assembly from separate components which has SKU which can be added to BOM and etc. + operations which need to get final product. 

I will try describe our product, pls help to understand or we can use odoo or what we need.

1. We have few permanent customers.
2. All orders we get in .csv files. (in near feature planning API)
3. We are producing mainly doors and plinths
4. Door/plinth can have different size (width, length, thickness) and in order can be different quantity of each. 
5. Doors/plinths have about 10 different designs (used different materials to produce)
6. Most of position of doors/plinths are default (size, material, drillings, process are described and has determined price). But some can be without drilling or opposite with drillings, with additional material.

I will try show example how we get orders:

So we got an order:

order1.csv

Now I will summarize:

To produce door1, door2 we need: 

• width + 10mm (MDF),  length + 10mm (MDF)

• width + 20mm (VENEER), length + 20mm (VENEER)

So for production we use mainly row materials which has price per m2/kg + operations and sell we by pieces, default pieces have default prices, not default have +% depending what changed.

One order can have many pieces/positions.

We are looking an system to represent our workflow, have capability to plan (need something to select list of order by attribute and plan to specific week. We are planning by weeks etc.)

Some calculations can be made before importing to odoo or can be written to db directly if some step hardly achievable in odoo. 

We need to see main situation/picture in our manufacture, planning an orders, get reports.   

How would be the best way to fulfil an odoo with that kind materials, pieces and manage that kind of orders in odoo. Thx for advice.