ROOM SKUs are like pseudo-kitting and need to be dealt with in a specific way
...
SKU1 x 2
SKU2 x 4
SKU3 x 6
SKU2 x 3
SKU5 x 3
SKU2 x 9
SKU6 x 12
Table of Parent/Child SKUs for Order#1
Line | Parent | Child | Quantity |
|---|---|---|---|
1 | SKU1 | 2 | |
1 | SKU2 | 4 | |
1 | SKU3 | 6 | |
2 | SKU2 | 3 | |
3 | SKU5 | 3 | |
3 | SKU2 | 9 | |
3 | SKU6 | 12 |
SKUs used in example above
...
In line 3 there is one parent SKU with two child SKUs. The child SKUs are counted.
Results
SKU2 x 16 (4 from line 1, 3 from line 2, 9 from line 3)
SKU3 x 6 (6 from line 1)
SKU6 x 12 (12 fom from line 3)
There are no SKU1 or SKU5 counted because they are parents with children and are therefore not counted.
Order#1
16xSKU2
6xSKU3
12xSKU6