Breaking down bundles into individual items

Zuko
Zuko Member
in Magic ETL

Hello Everyone,

I am currently pulling in sales data from shopify. We have a core range of about 20 products and another 20 or so bundles which are made up of those core products.

I am hoping for some assistance with how to break down these bundles into its components (core products) as we would love to see how the core products are selling inclusive of those sold in bundles.

Has anyone been able to find a work around for this issue?

Thank you in advance

Tagged:

Best Answer

  • DashboardDude
    DashboardDude Coach
    Answer ✓

    Hi @Mattwjones ,

    So shopify is a bit of a beast. If you need revenue, I would suggest just pulling from the Orders report. However, if you need to know progress of individual products, you'll have to use the Order Lines object. It's quite a doozy becaus the order lines report, double counts revenue becase there are usually several types of taxes and it gives a how new duplicate row because there could be a breakout of tax by state, county, etc .

    Feel free to email me at john.le@dashboarddudes.com and we can discuss more,

    John Le

    https://www.dashboarddudes.com/

    Circle.png

    John Le

    You're only one dashboard away.

    Click here for more video solutions: https://www.dashboarddudes.com/pantry

Answers

  • Billobi
    Billobi Contributor

    Shopify really just gives you the products & variants datasets last time I was in there...if your bundle relationships don't jump out at you from that you'll be pretty limited with what comes from Shopify. Unfortunately with all the bundling apps out there the storefront API doesn't have a uniform way of reporting on them.

    Usually I see folks connecting to the bundle app (custom API) or a Google Sheets connection where they track all their product attributes (as well as build out kit/bundle lists). Join up the bill of materials from those kits against the orders and you can get an expanded set of products ordered based on the kit components. You could set the relative ratio of price (to multiple line items by the total amount) in the attributes sheet, or try to base it on a function of the compare_at price on each of the pieces.

    The frequency that you're adding new products & kits would help you decide if you wanted to invest in a custom API (lots of product adds every week, no bandwidth or interest for offline tracking in Sheets) versus using a lookup in Sheets (very few product additions, already using Sheets to some degree for tracking kit composition)

  • DashboardDude
    DashboardDude Coach
    Answer ✓

    Hi @Mattwjones ,

    So shopify is a bit of a beast. If you need revenue, I would suggest just pulling from the Orders report. However, if you need to know progress of individual products, you'll have to use the Order Lines object. It's quite a doozy becaus the order lines report, double counts revenue becase there are usually several types of taxes and it gives a how new duplicate row because there could be a breakout of tax by state, county, etc .

    Feel free to email me at john.le@dashboarddudes.com and we can discuss more,

    John Le

    https://www.dashboarddudes.com/

    Circle.png

    John Le

    You're only one dashboard away.

    Click here for more video solutions: https://www.dashboarddudes.com/pantry

Categories