Hi everyone,
I am looking for the best way to break down Bundles made out of 2 skus (A,B) combinations.
The way our theme is set up on Shopify, it requires 1 variant for each bundle combination. The issue is that neither my supplier nor the fulfillment center’s inventory system recognizes these bundles. They can only recognize sku A and Sku B.
How can I convert the exported csv with bundles from Shopify into airtable using only sku A and B?
CSV file has 1 line per order ID. How can I automatically add a second line matching the same order ID when bundle has both sku A and sku B?
Sku A
Sku B
Bundle 1 = A+B
Bundle 2 = A+A
Bundle 3 = B+B
Bundle 4 = A+A+A
Bundle 5 = A+A+B
Bundle 6 = B+B+B
Bundle 7 = B+B+A
I will need to repeat the same step in reverse to push the data back into Shopify once the fulfillment center sends me the orders with the tracking numbers.
Any help is greatly appreciate it