Hey @Amichay
Thanks! I checked the logs and this particular query is causing a DB performance issue, and so Internal Server error was returned. I know you’d mentioned you’d streamlined the query but if it’s an option at all to break that main query on orders into seperate run queries for high volume stores, it could be worth considering.
Internal Server Error is a good reason to investigate - particular when errors are consistent. However, there isn’t much further our team can go since we currently don’t provide authenticated support through these forums, limiting our ability to dig deeper, locate accounts, stores, or much else past generic API logs.
That said, if you can replicate any unexpected response after polling the Bulk Operation status and if feel you are facing an issue, I’d suggest logging any RAW request bodies, returned x-request-id response headers, errors, and then send those along with a short description using our bug reporting tool.
You can get to the bug reporting tool by following this link to authenticate your account, and select the new option to “Report an issue [BETA]”. We can’t guarantee all requests or bugs reported here are answered directly, but I would thoroughly encourage you to use this option.