Showing orders by SKU (and items purchased together)

[Benton_Frisse]

Hello, Parabola community! I am hoping to build a flow allowing me to see orders by item SKU, and ideally be able to tell what items are frequently bundled together to plan building bundled items as an added value for the customer.

I can build a flow to show orders by SKU, but orders with multiple items from Shopify show as a second line, with the same order ID, and different sku. Can anyone recommend any tools to help display this data? Thank you so much!

[sachi]

Hey @Benton_Frisse - I can think of a few different ways to accomplish this, but here’s a snippet that will get you a list of unique line item combinations ordered in descending order by the count of occurrences!
parabola:cb:fa4053de-98ee-4111-bd18-d031a0525a1f

Here’s what the flow looks like: