Channel Identification - Bundler Product Bundles

Highlighted
Tourist
12 0 4

Hi there,

 

It seems that sales coming through some apps like "Bundler - Product Bundles" are identified natively in Shopify Analytics. However, when querying these through the API, both "app_id" and "source_name" get populated with the id of the draft order app.

 

Example order id - 1999932522541 which is from channel Bundler in Shopify analytics. However, both identifiers are populated with "draft order" channel.

 

ffc016c46fb09b5f552dc95166c9f24a.png

 

bfc3d14f853b08a225c6afe5faaf3faa.png

 

I believe Shopify has an identifier to separate out such orders in their native reporting. However, I do not see it exposed in the API.

 

I hope someone can point me to an identifier that can be used to segregate these.

1 Like
Highlighted
Shopify Staff (Retired)
Shopify Staff (Retired)
624 103 124

Hey @KBetterReports ,

 

From a quick investigation it looks like this "Bundler" app creates a draft order, and then the draft order gets completed independently and becomes an order. Which would explain why the app_id and source_name fields from the order resource just point to draft order only - that was the source of the order and the order wouldn't have any knowledge on how the draft order was made.

 

You might have more luck investigating the original draft order via the Draft Order API and finding ties to the "Bundler" app through that approach.

 

 

Hassain | Developer Support Specialist @ Shopify
 - Was my reply helpful? Click Like to let me know! 
 - Was your question answered? Click Accept as Solution 

0 Likes
Highlighted
Tourist
12 0 4

Hi Hassain,

 

Thank you for getting back to us.

 

We took a look at draft order api, but couldn't find any field that could help in any way. No app_id or source_name...

We also searched the graphql API for any identifications - 
https://shopify.dev/docs/admin-api/graphql/reference/object/draftorder
https://shopify.dev/docs/admin-api/graphql/reference/object/order

to no avail.

 

Could you tell us how Shopify in Analytics is isolating these? Maybe we could use the same approach?

 

Thanks again for looking into this. Really appreciate it!

 

 

0 Likes
Highlighted
Shopify Staff (Retired)
Shopify Staff (Retired)
624 103 124

Hey @KBetterReports ,

 

Shopify Analytics pulls data from their own unique sets of database tables with their own separate schemas (https://shopify.dev/docs/admin-api/rest/reference/analytics/shopify-ql#selecting-schemas-from)

 

If your store is on Shopify Advance plan or Shopify Plus, you could use the Shopify Analytics API to pull the report directly or use the Shopify Query Language to make your own reports with this data:

https://shopify.dev/docs/admin-api/rest/reference/analytics

https://shopify.dev/docs/admin-api/rest/reference/analytics/report

https://shopify.dev/tutorials/get-store-metrics-with-analytics-api

Hassain | Developer Support Specialist @ Shopify
 - Was my reply helpful? Click Like to let me know! 
 - Was your question answered? Click Accept as Solution 

0 Likes
Highlighted
Tourist
12 0 4

Hi @hassain and Shopify Support,

Appreciate the reply. 

Shopify Analytics seems to be pulling the channel name by looking it up from ShopifyQL: https://shopify.dev/docs/admin-api/rest/reference/analytics/shopify-ql/sales#sales-channel-propertie...

But ShopifyQL is only available for Advanced and Plus customers and is expensive to run since it doesn't have any webhooks and needs to be polled for every run. 

Are there any plans of adding this channel information in the regular orders API? 

If not, could you please pass on the request to the developers as it would ensure that reporting via API ties to Shopify Analytics.

0 Likes