There’s been known bugs in shopify orders where the order query will return incorrect results. First reported to Shopify in June of 2022 and still unresolved in Shopify’s latest Order update at the end of January 2022.
There are reported unresolved bugs in Shopify Orders:
- Reported to Shopify and confirmed by Shopify in June of 2022: If you query Shopify Orders for a term, like an order name such as “#ORDER12345”, Shopify will return incorrect orders in the order list results that contains subsets of the search term such as “#ORDER1234”.
- Reported to Shopify in February of 2023: If you query Shopify Orders for items using “OR”, like “#ORDER12345” OR “#ORDER12346” OR “#ORDER12347”, Shopify at random will return additional non-matching order(s) at random in the order list results.
Both of these Shopify Bugs are easy to spot on order list results of a few records, however, it gets much dicier when you have a large number of orders returned in the results.
If you know how many orders should be returned by your query, you can check the count again the count of orders returned for incorrectly included orders due to the Shopify bugs. For large returned results, you can export the query to get a count.
If you’re having issues with Order Results, be sure to contact shopify support to report it. It appears Shopify does not correct (or delays indefinitely correcting) Shopify confirmed bugs until a lot of customers also report being affected by the bug. Hence, bug’s that are quite detrimental, but hard to spot may remain for months, years or indefinitely.
Hope that helps anyone else searching for help with this Shopify Orders bug.