Hi Team, Which API can be used to get all order details based on the latest updated datetime of the individual orders? This way, the result set will fetch only unique orders based on the latest updated datetime only, which is our requirement. Regards, Yash

Hi Yash, If you’re using REST API you can use updated_at_min param with your GET to /orders.json endpoint. updated_at_min Show orders last updated at or after date (format: 2014-04-25T16:15:47-04:00). https://shopify.dev/docs/admin-api/rest/reference/orders/order?api[version]=2020-07 I…

Hi Sam, Lets say, I created an Order on June 20, 2020 at 14:30:00 UTC. I first updated it on June 25, 2020 at 15:40:00 UTC. Again I updated this order by creating a fulfillment on June 27, 2020 at 16:00:00 UTC. Now, when I’ll retrieve orders setting updated_at_min = June 15, 2020 00:00:00 UTC,…

Hi Team, Can someone respond back on my query asap? Regards, Yash

Yash, You can email me directly here: admin@achieveapplabs.com . Regards, Sam

Yash, Make sure you’re getting the datetime format correct this works for us: const created_at_min = moment(new Date()).format('llll'); Also you may have archived orders so you should specify the order status in params as well Filter orders by their status. (default: open) open: Show only ope…

Hi Sam, Date format is correct that we used, and we’d like to retrieve all orders irrespective of the status of the order.

At the very end the last Params doesn’t look correct try removing it.

Hi, Then what is the way to retrieve the orders in an ascending order of updated_at_min time? Regards, Yash

Get order details based on latest updated datetime of the order only

Retired Boards Appdev Customers Discounts And Orders

yashrastogi2020 July 23, 2020, 12:59am 8

Hi Sam,

Following call should fetch the outcome on ascending order of
updated_at_min time:

/admin/api/2019-10/orders.json?limit=5&updated_at_min=
2019-07-19T00:04:46Z&status=any&order=updated_at%20asc)

What is wrong here?

Topic		Replies	Views
Orders not filtering based on Updated_at Graphql Basics And Troubleshooting	1	71	March 1, 2022
Why isn't GET Orders API showing all updated orders? Shopify Apps shopify-apps	3	144	August 14, 2023
Order REST API missing orders when queried by updated_at_min Customers Discounts And Orders	1	60	July 15, 2021
Orders API using updated_at_min and updated_at_max returning incomplete data Graphql Basics And Troubleshooting	1	493	January 28, 2022
Rest API orders filtering by created date Customers Discounts And Orders order-management , Setting-Up	1	159	February 18, 2024

Get order details based on latest updated datetime of the order only

Related topics