Performance Issue Extracting OrderItems Table via SP-API (Airbyte / Fivetran)
Dear Amazon Support,
I'm currently using the Amazon Seller Partner API to extract data via Airbyte, and I'm encountering significant performance issues specifically with the OrderItems table. While other tables extract data normally, the OrderItems table is averaging only around 3,000 rows per hour, which is far slower than expected.
To troubleshoot, I’ve also tested the extraction using Fivetran, but experienced the same issue. This makes me wonder whether the slowdown is related to API limitations, throttling behavior, or a known issue with the OrderItems endpoint.
Additionally, I use MyRealProfit for reporting. Could this third-party connection be contributing to the slow performance or hitting API rate limits that affect my current integrations?
Could you please confirm:
Whether this performance is expected for OrderItems?
If there are any known limitations or recommended best practices to improve throughput?
Whether existing integrations like MyRealProfit could impact SP-API performance?
Looking forward to your guidance.
1 reply
Danny_Amazon
Hello @Seller_I5GGGjDKMJm6X- and thank you for sharing this experience here on the seller forums.
You may be able to get assistance with submitting your SP-API via the SP-API General FAQ. If you need more direct Support I would recommend you reach out via the Developer Support Help Page.
Thank you,
Danny