System Logic for Splitting Customer Orders by Fixed Percentage (Parent/Child Items)

Hello everyone,

We have a situation where a customer places an order using a generic Parent Code (e.g., Code A - NO COLOR), but internally, this code corresponds to multiple, specific Child SKUs based on color.

Current Setup (Item Substitution by Stock Rank)

• Parent Code: CODE_A (Ordered by the customer for a quantity of 100 units).
• Child SKUs (Color Variants):
  • ITEM_COLOR_RED
  • ITEM_COLOR_GREEN
  • ITEM_COLOR_YELLOW

If the substitution logic is based on stock availability (e.g., using a GOP) or a defined Rank), it's straightforward: the system allocates from the Child SKU with the highest rank or priority until its stock is depleted, then moves to the next.