SKU/ID Assignment Process for Combos

[davidAtayde]

Hi everyone!

I'm working on a process for assigning SKUs/IDs. The app allows users to create combos, each containing one or more products. The idea is that if a new combo contains the same products in the same quantity as an existing combo, it should be assigned the same SKU as the existing combo. Otherwise, a new SKU should be generated.

The tables are as follows:

Combo: Contains the combos.

Combo_details: Contains the details of each combo, i.e., the quantity of each product in a combo.

Combo_sku: Records the SKU for each combo. This is done in a separate table to maintain a historical record of all generated SKUs, including those that belonged to a combo that has been deleted.

Product: Products.

• I've created a bot to register SKUs for each combo.

In the Combo table, I created a VC called "Matching?" to determine if a combo has one or more combos with the same product content. I use the value of this column as a condition for the process of registering the combo and its SKU in the Combo_sku table. If "Matching?" is false, then the combo will be registered with a new SKU. If it's true, the combo will be registered with an existing SKU.

The problem is when I want to assign the existing SKU. I've tried different formulas, but none have been successful.

 App link 

Do you have any ideas on how to solve this? 
Thanks in advance for your help!

Best regards,

David