Hi @nmoonga, I do manage an Small wood working company with ERPNext, but I focused on Integrate with the CAD software in the market, in my case (Promob) than doing huge changes in ERPNext.
As the way @Suresh_Thakor suggest, can work, only for products that don’t vary dimensionally, if this rappen, you will need to maintain a really ruge database for every partnumber you want to track.
In my ERPNext I do have some dimensional products, but I managed they by Mt2 (Square Meter), because is easy to get the pricing computing (Width X Length), instead of manage handreds of thousands of variations for every product varying in millimeters.
If you are planning to use ERPNext, the path I can recomend for you are 2:
1 - Get integrated with your CAD software, it will simplify a lot the things for you, if it’s not available, look for step 2:
2 - Build a product hierarchy instead of create variations of products
A product Hierarchy will require a custom field, with some informations Like
- Material Name: [Wood], [Red Wood], [Black Wood]
- Min Tickness: 6mm
- Max Tickness: 6mm
Product Hierarchy Tree
- Generic Item Code - [Doors], [Cabinets], [Drawers]
- Product Family - [Wood Doors], [Glass Doors], [Mirror Doors]
- Materials - [RED Wood], [Black Wood], [Pinus Painted Marfin], [Pinus Natural Wood]
- Min Depth
- Max Depth
- Min With
- Min Height
- Max Width
- Max Height
- Price Formula
So, this information can be used in a set of chained comboboxes, so for example
- Item Code : Drawer
- Material: Black Wood
- Material Tickness (mm): 15
- Width (mm): 300
- Height (mm): 150
- Depth (mm): 400
The user will be able to associate all the needed information to define an drawer, and you can use the Product Hierarchy, to validate that the information is coherent.