Get orders by updated date


#1

Hi,

Our application need track all orders changes. Initially we load all orders and after this once a day we need to load all orders updates (new and updated orders since previous load). Ideally we need to filter orders by update date, but I did not find such filter in documentation.

Is there any way to filter orders by update date? Or is there another way to incrementally load only orders updated after previous load?

Thank you!


#2

Hi,

The API does not have a filter for orders updated. Using the v3 Orders API, these are the fields for which you may make a specific date requests and filter on:

  • created_after
  • created_before
  • order_placed_after
  • order_placed_before
  • shipped_after
  • shipped_before

You can also sort on the following in ascending or descending order:

  • order_placed_date
  • order_number
  • ship_date
  • shipping_method
  • status
  • grand_total

For other fields that you may filter on, check out the docs.

Hope this helps,

Sophie


#3

Thank you, I’ve read docs. But could you please advice what is the best way to achieve my task?

Initially our application loads all available orders and stores them in database. After this on daily basis we need to load all orders updates (updated and new orders). It is not efficient to reload all orders every time. For new orders I can use ‘created_after’ filter. But is it possible to know which orders were updated since previous load?


#4

As previously mentioned, there is not a way to do so specifically using the API.


#5

Any plans to implement this?


#6

I’m afraid it’s not on our roadmap as we don’t have a use case for it in our app at this time.


#7

Let me join the party.

Is there a way to get orders cancelled in specified period? (cancelled from date1 to date2)


#8

Hi,

You could get orders that were created/placed between a certain date range, and also filter on status=canceled, but the following still stands with respect to the updated date, and there is no field for canceled date.


#9

Feature request:
The main idea is to have an endpoint/filter to get status changed over time. Like for “shipped” status.
This is important for such thing like a report. Weekly/Monthly.
Without that feature, I must search back for 6 months.
It is a big difference, to process 10 orders in a period, or process 60000 to find those 10 orders.