Have your say in Community Polls: What was/is your greatest motivation to start your own business?

Re: Synchronizing Orders and Fetching Related Transactions via REST API

Solved

Synchronizing Orders and Fetching Related Transactions via REST API

KacperPe
Shopify Partner
1 0 0

Hi everyone,

I am working on integrating my system with Shopify and have encountered a challenge that I hope someone here can help me solve.

I would like to synchronize orders from my Shopify store with an external system. I have already set up the basic order synchronization using the Shopify REST API, but I also want to fetch transactions related to the orders to have a complete picture of each transaction (e.g., payment information, refunds, etc.).

I have encountered a problem with too many requests, leading to API rate limit issues. I have heard that the Bulk API supported by GraphQL might be helpful in this case. Is it better to use the Bulk API via GraphQL, or should I consider implementing a delay between each request to avoid hitting the rate limits?

Could someone share some guidance on how best to approach this issue?
Thank you in advance!

Accepted Solution (1)

BSSCommerce-B2B
Shopify Partner
1969 564 566

This is an accepted solution.

Hi @KacperPe,

 

It depends. You have 2 req/s with the Basic plan or 4 with the Advanced, and each request returns 255 records with REST API

If your data is quite small or you don't care about sync time, you can use REST API for ease.

Opposite, if your store has too many orders and transactions in the first sync, you should use bulk API (FYI, you should use bulk API in the first sync or full sync because data grows by time). You should store sync time to use in the next partial sync to filter data by time (e.g. created_at_min,...)

 

Hope that can help you somehow.

B2B Wholesale Solution: Streamline your B2B operation with advanced features like wholesale registration forms, custom pricing.


B2B Portal, Quote, Net 30: Speed up purchasing and streamline your quotation process with advanced features like quick order, request for quote.


B2B Lock Password Protect: Easily control access to pages, products, and pricing with robust features.


BSS Commerce - Full-service eCommerce Agency I Use Shopify for 1$ in the first month now

View solution in original post

Reply 1 (1)

BSSCommerce-B2B
Shopify Partner
1969 564 566

This is an accepted solution.

Hi @KacperPe,

 

It depends. You have 2 req/s with the Basic plan or 4 with the Advanced, and each request returns 255 records with REST API

If your data is quite small or you don't care about sync time, you can use REST API for ease.

Opposite, if your store has too many orders and transactions in the first sync, you should use bulk API (FYI, you should use bulk API in the first sync or full sync because data grows by time). You should store sync time to use in the next partial sync to filter data by time (e.g. created_at_min,...)

 

Hope that can help you somehow.

B2B Wholesale Solution: Streamline your B2B operation with advanced features like wholesale registration forms, custom pricing.


B2B Portal, Quote, Net 30: Speed up purchasing and streamline your quotation process with advanced features like quick order, request for quote.


B2B Lock Password Protect: Easily control access to pages, products, and pricing with robust features.


BSS Commerce - Full-service eCommerce Agency I Use Shopify for 1$ in the first month now