Report that's sales by sku for fulfillment being "pick up in store"

Custom Data
1

my company had an event where people had to order online and pick up in person - all inventory was allocated to a unique location and was NOT sold by POS. is there any way to create a report that meets these conditions? thank you!!

1 Like
2

Hey @Dae_Lim :waving_hand: - I did a bit of digging into this, and it looks like there isn’t currently a way to pull this info directly through Analytics Reports in the admin/through ShopifyQL, but if you wanted to to look into our GraphQL Admin API, there is a way to do this. Here’s a quick example:

{
  orders(first: 50, reverse:true) {
    edges {
      cursor
      node {
        id
        name
        processedAt
        fulfillmentOrders(first: 10) {
          edges {
            node {
              assignedLocation {
                location {
                  id
                  name
                }
              }
              deliveryMethod {
                methodType
                displayName
              }
            }
          }
        }
      }
    }
    pageInfo {
      hasNextPage
    }
  }
}

Example output:

{
  "data": {
    "orders": {
      "edges": [
        {
          "cursor": "eyJsYXN0X2lkIjoxMzU5NDc3NTgxNDE2NiwibGFzdF92YWx1ZSI6IjIwMjUtMDQtMjQgMjA6NTg6MjMuNjQ2OTU0In0=",
          "node": {
            "id": "gid://shopify/Order/13594775814166",
            "name": "#1864",
            "processedAt": "2025-04-24T20:58:23Z",
            "fulfillmentOrders": {
              "edges": [
                {
                  "node": {
                    "assignedLocation": {
                      "location": {
                        "id": "gid://shopify/Location/75214782486",
                        "name": "The Place"
                      }
                    },
                    "deliveryMethod": {
                      "methodType": "PICK_UP",
                      "displayName": "Pickup in store"
                    }
                  }
                }
              ]
            }
          }
        }

As long as your API integration has access to the Fulfillments/Orders APIs, you should be able to pull a list of orders that were set to be picked up at a particular location, even if they weren’t sold through the POS sales channel.

Hope this helps a little bit - let me know if I can clarify anything here on our end :slight_smile:

3

Hi @Dae_Lim

Does the approach that Alan suggested work for you?