iphone screen with icons on screen
/ / Capturing Shopify Orders in the Microsoft Teams List App

Capturing Shopify Orders in the Microsoft Teams List App

Chase Street Accessories & Engraving is a small business that collects orders though multiple e-commerce platforms. Over time, we discovered a need for a consolidated list of all incoming orders where we could track order status and other data. We were already using Microsoft Teams to stay connected and organized, so when the Lists app came out, it looked like the perfect solution for tracking orders. It only took a few basic steps to create a proof of concept for our Shopify orders:

Create a list in Teams

The first thing to do is create a list that includes the basic information about the order. The easiest way to get started was to create an “Orders” channel in teams, then add a tab for the Lists app, then create a new list with the most basic information about the order.

Create a new list

Create a Power Automate flow to capture data and add it to the list

Because Shopify is our primary sales platform, we decided to make this our starting point for importing orders for tracking. Fortunately, the Shopify settings include the option to create webhook subscriptions that work well with Microsoft Power Automate. To get started, create a new HTTP Request instant flow.

Create a new flow triggered by HTTP request

Add a Compose step and save so that you can copy the HTTP POST URL for the trigger. That URL won’t show up until the flow has actually been saved.

Copy the HTTP POST URL

Subscribe to a Shopify webhook to trigger the flow

Next, in Shopify, go to Settings/Notifications and scroll all the way down to Webhooks. Click “Create webhook” and set the Event to “Order creation,” then paste the HTTP POST URL from Power Automate into the “URL” field. Save.

Subscribe to a Shopify webhook

Run a manual test of your Power Automate flow, then in Shopify use “Send test notification” for order creation. You’ll have to scroll all the way to the right to find this option.

Send a test notification

You’ll then see the JSON data pop up in the flow!

View example JSON

Parse JSON and add to list

To keep things simple, start with just a few critical order properties that you want to add to the list. You can then add additional properties by referencing the Shopify webhook documentation. For our beginning list, we’re just starting with the order id, customer email, and order name. Update the JSON schema with the following:

{
    "type": "object",
    "properties": {
        "id": {},
        "email": {},
        "name": {}
    }
}
Update JSON schema for request

You can now “Create item” in your Teams list using this data:

Create a new list item and populate with JSON data

Success! Now what…

Test the flow either by sending another test webhook event from Shopify, or by re-running the previous test. You’ll see the data populate into the list! The Title now includes a link to the list item, called by the same order number you see in Shopify. The order ID is the unique identifier Shopify uses to refer to the order internally. The email is the customer’s email address. The URL will take you directly to the order in your Shopify admin panel.

List view
Single item view

Now that you have the data in a List, you can use it to trigger notifications in Teams, track the status of the order, and much more!

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *