Taking the ratchet under-anchor compensation device for tunnel excavation as an example,this paper analyzed the product structure and installation technical conditions.By establishing geometric relationships of ratchet base structural dimensions with tunnel cross-section dimensions,turning pulley installation height,conductor height,contact suspension structure height,and under-anchor elevation,this paper used the parametric modeling capabilities of 3D software to achieve parametric driving of products,batch assignment of variables,batch generation of instance models and drawings,automatic generation of BOM(Bill of Materials),and automatic data integration and transmission.This approach enables intuitive evaluation of the compatibility between product structure and actual installation conditions,thereby avoiding installation mismatches caused by interface size and specification errors and improving product design quality and efficiency.Through exploration of data integration,this paper realized 3D instance model design,2D CAD drawing output,product BOM output,and intelligent integration with the PLM system based on the 3D parametric model.