Regarding Item Master Solution for Engineer to Order industry


I need a help regarding how to do a item master upload of to engineer to order specific industry.

Here the item are designed to fit into fixtures (a work holding or support device used in manufacturing industry) which may or may not be standard so for different project the Items are all together newly designed.

So every time Item master has alltogether new items as per project.

I am thinking of a solution to do a excel import of all items specific to a project under a BOM again and again.

If any body knows more specific about it , welcome .