Some Archived Imported Orders Not Returned from Orders API

Retired Boards Appdev Fulfillment Api

Topic summary

Main issue: Archived orders imported into Shopify (Nov 2020) were largely missing from the Orders API results, despite using status=any and having read_all_orders. Only about 5% appeared, typically those updated after import.

Initial action: A Shopify staff member requested an x-request-id to investigate. The original reporter later confirmed they resolved it on their side, without sharing details.

Related case: Another user who imported via Matrixify could fetch individual orders by ID, but list queries did not return them.

Key finding: Imported orders have created_at set to the import timestamp, not the original purchase date. The purchase date is stored in processed_at.

Practical guidance:

  • Do not filter imported orders by created_at for historical ranges; use processed_at to target the original purchase date.
  • Orders updated after import may surface via updated_at filters.
  • Fetching by specific order_id works even if list queries miss them.

Status: Issue appears resolved for participants with the above approach; no platform changes were indicated.

Summarized with AI on December 17. AI used: gpt-5.
4

Hi,
I have the same issue. I have imported orders using Matrixify but cannot see them when calling the orders endpoint. How did you resolve this?

I can see order only calling single order by follow endpont:

https://Shopify_token/admin/api/2020-10/orders/order_id.json

Thanks