Report on sales of Bundles using Shopify Bundles app

dbianchi
Shopify Partner
15 0 1

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)

 

Replies 21 (21)
sle
Shopify Staff
Shopify Staff
13 0 0

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? 

To learn more visit the Shopify Help Center or the Community Blog.

dbianchi
Shopify Partner
15 0 1

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
Shopify Staff
Shopify Staff
13 0 0

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. 

 

 

Screenshot 2023-09-12 at 1.39.40 PM.png

To learn more visit the Shopify Help Center or the Community Blog.

dbianchi
Shopify Partner
15 0 1

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
Shopify Partner
15 0 1

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
Shopify Staff
Shopify Staff
13 0 0

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

 

To learn more visit the Shopify Help Center or the Community Blog.

dbianchi
Shopify Partner
15 0 1

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
Shopify Staff
Shopify Staff
13 0 0

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

To learn more visit the Shopify Help Center or the Community Blog.

dbianchi
Shopify Partner
15 0 1

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
Shopify Partner
15 0 1

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

sle
Shopify Staff
Shopify Staff
13 0 0

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. 

To learn more visit the Shopify Help Center or the Community Blog.

dbianchi
Shopify Partner
15 0 1

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
Shopify Staff
Shopify Staff
13 0 0

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.

To learn more visit the Shopify Help Center or the Community Blog.

bee33j
New Member
4 0 0

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

Jeff-Armstrong
Shopify Staff
Shopify Staff
10 2 0

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.

To learn more visit the Shopify Help Center or the Community Blog.

JaredBA
Shopify Partner
3 0 0

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
Shopify Staff
Shopify Staff
10 2 0

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.

To learn more visit the Shopify Help Center or the Community Blog.

JaredBA
Shopify Partner
3 0 0

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!

g3R3eYJCFJ.png

paul_n
Shopify Staff
Shopify Staff
603 97 154

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.

Paul_N | Flow Product Manager @ Shopify
- Finding Flow useful? Leave us a review
- Need Flow help? Check out our help docs.
- Building for Flow? Check out Flow's dev docs.
bee33j
New Member
4 0 0

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

JaredBA
Shopify Partner
3 0 0

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

JaredBA_0-1699995855099.png