In our ERP database, there is 1 table for products called PRODUCTS, which contains both kits and single SKU product information, and a table called PRODUCT_KIT_ITEMS that contain the relationships between kit SKUs and their components. In the PRODUCT table, each kit has a kit id on the parent SKU row and the PRODUCT_KIT_ITEMS tableRead more