# Order Sync Flows issues Realtime and Scheduled creating duplicate orders

Here is the scenario:
Realtime order sync used to miss some order syncs and we were unable to detect from Shopify end.
The reason being the Shopify orders were synced with SO number from NetSuite. We would not know about this until the Customer opened a support ticket enquiring about the product shipment.

So the solution was to enable the scheduled order sync flow so that this would pickup all the Shopify orders and ignore the ones already created and create the missed ones. This solution is working well, however we had further issues during the high velocity order times. Due to some glitch in NetSuite/Celigo the orders were created by real time flow did not have eTail IDs. Later the Scheduled order flow kicked in and created duplicate orders. This led to duplicate fulfillment and shipping of products. This was a revenue loss to the company.

##### Post Metadata
- Posted at: over 5 years ago
- Net upvotes: 1


## Comments
### Comment 1

Set up a time offset of a few MS to ensure the records are not overlapping.  

##### Comment Metadata
- Posted at: about 5 years ago
- Author title: NetSuite Business Systems Analyst, PMP



### Comment 2

Hi - I checked back with our support team, it looks like they had isolated this to a NetSuite-specific bug (#609066) that adversely impacted one of your NetSuite configurations. Is this your understanding as well? Our understanding is that this resulted in custom fields not being written to the NetSuite transaction and thus, when you executed the scheduled instance of the order flow, it created a 2nd order within NetSuite.

We consulted with NetSuite to obtain a fix for the issue you faced and hope that this hasn't recurred. It's challenging to diagnose problems when the connected endpoints have sudden issues but I hope our team was able to address this for you. Please let me know otherwise.

##### Comment Metadata
- Posted at: over 5 years ago
- Author title: Introducing iPaaS to the world.




## Related Product
[Celigo](https://www.g2.com/products/celigo/reviews)

## Related Category
[iPaaS](https://www.g2.com/categories/ipaas)

## Related discussions
- [How well does Trello scale into a larger team?](https://www.g2.com/discussions/1-how-well-does-trello-scale-into-a-larger-team)
  - Posted at: almost 13 years ago
  - Comments: 6
- [Can we please add a new section](https://www.g2.com/discussions/2-can-we-please-add-a-new-section)
  - Posted at: almost 13 years ago
  - Comments: 0
- [Quantifiable benefits from implementing your CRM](https://www.g2.com/discussions/quantifiable-benefits-from-implementing-your-crm)
  - Posted at: almost 13 years ago
  - Comments: 4