# Real BOM Product Stage

Order -> Product cards -> Product detail -> SolidWorks BOM import -> cleaned BOM table.

Implemented:
- Products are cards inside order detail.
- Clicking a product opens product detail.
- Product detail includes SolidWorks BOM Excel import.
- Imported BOM rows are normalized and classified.
- SolidWorks-style columns supported: ITEM NO, LENGTH, DESCRIPTION, ANGLE1, ANGLE2, Sheet Metal Thickness, Bounding Box Width, Bounding Box Length, QTY.
- Unknown materials are marked as Tanimsiz and should not be used for automatic pricing until matched.

Database update:
Run database/update_real_bom_stage.sql once.

Current scope:
This prepares clean BOM structure for material normalization, profile/lama optimization, sheet grouping, unknown material control, and final pricing flow.
