Exporting subscriptions with shipping address?

Products and Orders APIs
1

Hey folks,

I have a client with a magazine business who needs to export a list of their currently active subscribers (not email marketing), but the app they are using (Appstle) can’t export customers who have cancelled their subscription and are still within the length of the subscription plan. Example: a customer subscribes to a 1 year subscription delivered quarterly, cancels after 6 months, but will still receive the remaining magazines until the end of their subscription. The client needs to know which subscribers should still receive magazines even though they’re status is technically cancelled.

I’ve tried filtering and exporting from the customer side, but it doesn’t include shipping information, which could be different than billing.

Exporting orders does have shipping info, but it can have many additional orders from the same customer and I’m having a tough time figuring out a way to filter/sort those to only get what my client needs.

Any ideas out there?

2

Steps:

  1. From your Shopify admin, go to Subscriptions > Contracts.

  2. Click Export.

https://help.shopify.com/en/manual/products/purchase-options/subscriptions/shopify-subscriptions/import-export/importing-and-exporting#download-sample-csv

3

Thanks @AMaL I also saw that documentation, but I don’t even see any option in my admin settings to access Subscriptions or Contracts. If I search, I see these options, but none show any way to export that I can find.

image
image282×384 6.78 KB

Perhaps this is due to the 3rd party subscription app I’m using?

4

Oh, yes… you’re talking about the official Shopify Subscription app. I’m not using that as stated in my OP.

5

Using GraphQL api we can fetch the details?

query GetSubscriptionContractsWithDeliveryAddress {
  subscriptionContracts(first: 10, query: "status:CANCELLED") {
    edges {
      node {
        id
        status
        deliveryMethod {
          ... on SubscriptionDeliveryMethodShipping {
            address {
              address1
              address2
              city
              company
              countryCode
              firstName
              lastName
              phone
              provinceCode
              zip
            }
          }
        }
      }
    }
  }
}
1 Like
6

Hey @Jason_Florence :waving_hand: - I think @AMaL ‘s suggestion may be the best option here to grab that data. If you don’t have an API client already set up, you should be able to access the Admin API using our GraphiQL app:

Let me know if we can help out further though, happy to troubleshoot if needed :slight_smile: