REST API Pulling Orders by since_id, issue with Shopify API order vs order_number sequence

Shopify Discussion
1

Hello,

We pull new orders by since_id parameter with created_at_min date (the client has a buyer’s remorse window to consider) and just recently encountered an issue where the Shopify order_number (i.e. 1001) and the Shopify API Order ID (i.e. id value) aren’t in the right sequence so we’ve missed a few orders by using the since_id parameter.

For example:

A session ran to pull orders after a certain since_id and I get orders 1001, 1003, 1004, so on and so on.

1001 was created at 2024-04-20 [email removed] 01:35:36

However, order 1002 is an older since_id than 1001 (resulted in the API call to miss this order) but was created after 1001 like 2024-04-20 [email removed] 01:40:36

Has anyone encountered this before? How can 1002 be an older since_id value but was created after 1001?

2 Likes
2

Bumping this, we’ve just seen a bunch of orders duplicated, and since id is the safeguard we currently have in place. Think I will have to rush through transitioning to webhooks instead, since this caused quite a big mismatch in our accounts. Only happened on the 3rd of June, so the timing suspiciously lines up with your issue.

3

+1, started happening this year