Old order ids - how to get them?

GraphQL API
1

Hi there,

I am wondering if there is any way to export a CSV with order number and shiphero order id. The reason for this is that we are currently running shiphero on a magento 1 store and are working to change integration using graphql api. Once we will make the switch, I will need the order ids so that even orders created via the magento integration are able to be updated using the new integration. A CSV would be useful because it would allow me to upload it directly to my database.
Is this possible?

Thanks
Claudia

2

hi there… any update on this?

3

Hi @Csraspini!
I apologize for the delayed response about this!

We don’t have that available at the moment, but getting that data using our Public API works for you?

Something like this and paginating through results using the cursor:

query {
  orders {
    request_id
    complexity
    data(first: 1000) {
      pageInfo {
        hasNextPage
        endCursor
      }
      edges {
        node {
          id
          legacy_id
          order_number
          partner_order_id
        }
      }
    }
  }
}

You can also use date ranges with the order_date_from and order_date_to and narrow the results for a specific time frame.

Please let us know if that doesn’t work for you.
Thanks in advance!
Tom

4

thank you for your assistance!