Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Connector Improvement: Sales Channel Information for Shopify Products

Completed
Linda Xu User

Please add "Sales Channel" as a property for the Products table in the Shopify connector. This property is very important for us to monitor the status of the product as this property tells us which sales channel (Online Store, Facebook Shopping, etc) that the product is published to.

Please sign in to leave a comment.

Comments

3 comments

Date Votes
  • Official comment
    Ray User

    Hi Linda,

    Thanks for the request! I did some digging into the Product API we use to populate the Products table and didn't find any sales channel information in the response from Shopify. From the Sales Channels documentation, I better understood how a Product can be published in multiple channels. I believe that this sales channel information should be included in the Orders table to represent sales that have happened as well as in a ProductListing table which indicates which products are available in which sales channels. That said, I didn't find any "Sales channel" object for reference, only "vendor" in the product listing object and "source_name" in the Order object (which we do capture already).

    Are you able to confirm whether the ProductListing response's "vendor" property represents the missing data you're looking for?

    All the best,

    Ray Harris
    Product Manager, Sales & Customer Success Analytics

  • Alberto Jose Jovel User

    Hi Ray & team.

    I believe OP meant these that are visible at the product pages. I am also looking for a way to read those through the Fivetran ERD but have no clue at the moment how to get those for each Product (tags/collections are OK, but these are missing).

  • Sandeep Preetam Saila Fivetranner

    Hi Linda,

    Thanks for your feedback and patience. We added sales channel information to our Shopify connector in December 2024. Here’s how you can map products to their sales channel:

    PRODUCT → PRODUCT_PUBLICATION → PUBLICATION → CATALOG → APP

    The handle field in the APP table serves as the identifier for the sales channel.

    You can find more details in our release notes.

    Best regards,
    Sandeep