I am looking for others inputs on what your company does to export your bill of materials. It seems like there must be a more efficient way to do what we are doing.

Some background: we are a custom door manufacturer. We design the doors 100% in solidworks with every nut, bolt and peice of raw steel. Once the design in complete and approved, we purchase all the components at once. Our final BOM that