Report on sales of Bundles using Shopify Bundles app

[dbianchi]

We've launched some virtual bundles on our store using the Shopify Bundles app and things are working perfectly. I have unique tags on the bundles, but I cannot find a way to generate any reporting on how many bundles are sold or which are more popular. The order itself simply has the various SKUs that makeup the bundle (which have their own tags, but not the tags applied to the bundles) - The only reference to the bundle in the order is the bullet point underneath the product name of the SKU added to the cart (from the Bundles API documentation this is possibly the "Components, with reference to parent through groupings" in the Store Order. But I don't see anything in Flow to be able to target or look for that line so that I can run a flow to tag that order. Has anyone found a way to get a report on orders that contain bundles? (either through Shopify Flow tagging or some other mechanism?)
Attaching a screenshot to call out what value form the order I need to try to "catch" in flow...
Any help appreciated as right now I'd have to look at each and every order individually (the line I need does not come through in the export of orders either)

[sle]

Hi @dbianchi , just to confirm my understanding, are you looking for a way to tag the order with a bundle's name when the order contains a bundle? 

[dbianchi]

Correct! Because the order itself just has the items in the bundle, I can't find a way to differentiate that order from an order where someone just purchased the elements of the bundle, except for that "line" underneath the product name that tells you it was part of a bundle. And we've sold a bunch already but unless I go order by order in the Admin, I can't find a way to just see how many bundles we've sold (only the product making up the bundles... which are often purchased separately)

[sle]

You can setup a workflow like this where it checks if the order contains a bundle then go through each item in the line items list, find the bundle item, and tag the order with the SKU of the bundle. You can also tag it with the title of the bundle but it'll be hard to query and report on. 

[dbianchi]

Thanks! I will try that out. The bundles themselves do not currently have a SKU (since the order just has the components of the bundle), but maybe I can tag it regardless by looking for certain components.

[dbianchi]

I cannot get that to work. I still think there's something missing for what I'm trying to do.  I'll try to be more descriptive.
I've got a Product listing that is a VersaNotes 4X4 9 Pack. It was created by the Shopify Bundles app, so it appears to the end user as a product. It is tagged with "4x4 9 Pack". When a customer 'buys' this, their order never shows this as a line item... instead it shows the 3 SKUs that make up the bundle (2 of our '4x4 expansion packs', 1 stylus and 1 set of magnets) - Those 3 line items in the order say "Part of: VersaNotes™ Reusable Notes 4X4 6 Pack", but the individual SKUs do not have the "4x4 9 Pack" tag (because they are also part of a '6 pack, 12 pack and 15 pack', as well as for sale by themselves.
I think the "requires components" part might work in the Flow automation, but I need to be able to either retrieve the ""4x4 9 Pack" tag, or the "Part of: VersaNotes™ Reusable Notes 4X4 6 Pack" that is added underneath the SKU in the order. I suppose I could give the bundles "phantom SKUs" that aren't in our system but match the bundle name - is that what you're suggesting I do and then try to set up that workflow you shared? (I did also have trouble with the 2 'Requires Components" parts of the flow as I wasn't sure what to attach those to - not sure if you could reshare the flow you built but with the side panel of details showing?

[sle]

do you mind sharing the workflow you're working on so I can troubleshoot further?

[dbianchi]

Thanks. I ended up deleting the workflow because after struggling to get it to work it was stuck in a running state and erroring out. Let me recreate it this morning and it would be great if you could troubleshoot. What is the best way to share the workflow - do you just need the name of it?

[sle]

You can share the url to the workflow here and I'll be able to access it to help you 🙂

[dbianchi]

Great. I've gone in and added a SKU to the bundle product listings (in case that helps) - I tried to recreate from your screenshot and ran the flow on an order with bundles, but it stopped after the first step stating variant requires components was false on each item...
The workflow is here: https://admin.shopify.com/store/kent-displays/apps/flow/web/editor/b7391881-db4a-46e0-b179-794f5016f...

[dbianchi]

Sle - Just checking if you had a chance to review the workflow and help correct any errors

[sle]

hi @dbianchi , thank you for your patience. I had a wrong assumption about Bundles. I thought when the customer purchase the bundle, the bundle product will be in the order. It's not the case here. In order to do this properly, we need to wait for another field on the variant to be released from the `unstable` API.

It's not possible to tag the order with the bundle's name right now given that the bundle product is not included in the order. 

[dbianchi]

Thanks for looking... So as far as you know even though the order has that line item note which says which bundle the pieces are part of, there's no way to "grab" that from an order? Also are you saying that work is being done to make this type of reporting possible? I would imagine people using the bundles app would want to report out on sales by these bundles (which is what we're hoping to do) - I did manually go thru orders for a week to get some data, but that takes quite a bit of time...

[sle]

That's correct, in the unstable version of the admin API, you'd be able to determine which bundle the items belong to using the productParents field. Flow tries to be on the latest stable version of the Admin API at all times which is 2023-07 as of this writing. Unfortunately, until the new field goes from unstable to a stable version, we don't have a way to determine if a variant belongs to a bundle without some manual works.

[bee33j]

Hi any update on this? Looking for the same functionality as the OP

[Jeff-Armstrong]

The `productParents` field is not in the latest release of the API - it is still in the unstable version. It will need to be in the latest release before Flow exposes the field.

[JaredBA]

Hello. Was just looking at this same thing to try to pull bundle details. We tried GET /admin/api/unstable/orders/<orderId>.json but we don't see anything that looks like productParents in the returned JSON for the line_items detail, even in the unstable API version. Is there something special we need to do to retrieve the bundle parent?

[Jeff-Armstrong]

I don't see the productParents field in the unstable version of the REST API for Product Variant.

It is in the unstable version of the graphql API for Product Variant.

[JaredBA]

Thanks, Jeff.

What is the difference between productParents and lineItemGroups (which does appear to be in the current API)? I just tried building a Flow referencing lineItems_item.lineItemGroup.title and it seems to tag orders with bundles. Will this work reliably? Thanks!

[paul_n]

Are far I can tell, lineItemGroups is available on each lineItem in an Order and the title field does match the Bundle title. productParents is the field on variants. If you want to check if a lineItem is part of a bundle, lineItemGroups does appear to work.

[bee33j]

Thanks so much for finding this mate, exactly what we needed

[hquack]

Any update on this reporting feature for bundles?

[JaredBA]

This is what we are trying to tag orders with bundles:

[WJ-Kungfu]

Hi, I'm coming across this topic because we currently create bundles externally, in our inventory program.  We'd like to use the Shopify Bundles app but we need to sort orders in Shipstation by bundle SKU.  Using your flow above, is the bundle product tagged with the Bundle Name and then the order is tagged with that product tag?  We can import the Order Tag to Shipstation.

[ekansh_unilever]

Any way we can track sales now directly of the bundle products made via Shopify bundles app?

[hquack]

Asking same question -- any update on tracking sales for bundle products? @Jeff-Armstrong @paul_n @sle 

[brant]

Hi @dbianchi,

Bit late, but just in case anyone is still looking - I've had luck tagging these type of orders by using lineItemGroup:

{% capture unique_titles %} {% for lineItems_item in order.lineItems %} {% unless unique_titles contains lineItems_item.lineItemGroup.title %} {{ lineItems_item.lineItemGroup.title }}, {% endunless %} {% endfor %} {% endcapture %} {{ unique_titles }}