Excluding orders loaded with Transporter App from Orders pulled from Order API

Retired Boards Appdev Customers Discounts And Orders
1

Hi - we have just launched a new store on Shopify Plus and loaded the previous orders up through Transporter App. These orders have been marked as ‘Archived’ and ‘Fulfilled’ and this is reflected in Shopify. We were using the parameter of orders that were ‘Open’ and less than 7 days old to pull new orders through the API into our ERP system. It seems that this is allowing the archived orders to come through too. The created date loaded for these orders is in the past, but Shopify seems to be looking at the date loaded up in Transporter, which is ridiculously stupid.

Has anyone else experienced this?

We’re assuming the best thing we can do is now filter all orders by a status of Fulfilled/Unfulfilled and ignore that Shopify says it’s ‘Open’. Seems going against the grain, but I need these orders out of my ERP system pronto!

Any pearls of wisdom would be much appreciated!

Regards

Rachel

2

You can query orders via GraphQL with a search string for order status. Eg:

query {
  orders(first:250, query:"status:\"open\"") {
    pageInfo {
      hasNextPage
    }
    edges {
      node {
        id
      }
    }
  }
}

That will return all open orders, excluding cancelled and archived orders from what is returned. Docs: https://help.shopify.com/en/api/graphql-admin-api.

Cheers.