I am looking for a way to relate the ProductVariant table to the Inventory table.

The variant has the SKU modifiers in a comma separated string within the Color and Size Modifiers field.

I want to be able to relate each record in the Inventory Table to each of those variant SKU Modifiers.

What I want to do is be able to join my business database to the VendorFullSKU field which I'll populate with an update consisting of the SKU from the Products + SKU Suffix + ColorSKU + SizeSKU

I see this combo in the shopping cart so I know there is a way to do it... But am stuck on how I can create a view that has a record for each variant combo.