Notifications
Announcements
No record found.
Hello experts,
I am doing integration with Shopify. My current requirement is that whenever on hand of an item is changed I want to do same in Shopify. I think I can achieve that by business events but I don't know to which method should I go for achieving this.
Could you suggest which approach would be best for such scenario?
Thanks,
Samkit Jain
I guess you could hook on updates in InventTrans table. But I'm not sure if it's a good idea to trigger a business event whenever on-hand qty (or InventTrans) changes.
Other possible approaches would be to ask the on-hand from D365 via web service whenever it's needed.
Or, have some batch that exports the info periodically.
What kind of volumes are you expecting in Shopify? How many times is the on-hand for an item expected to be displayed every hour / day?
Hello Nikolaos,
The client has multiple stores right now. They are planning to expand the business on Shopify now. So Shopify and D365 FO needs to be in Sync. Which means if an item has gone out of stock in D365 FO, it should also reflect in Shopify instantly to stop selling. So I am think periodic tasks won't help.
Thanks
Sorry Nikolaos,
I guess I didn't understood your question. What do you mean by 'kind of volumes'?
I want Shopify to reflect inventory update in real time.
My idea was that Shopify could ask the on hand for an item when it needs it. But whether that is feasible or not depends on the amount of such requests coming from Shopify.
How many times is the on-hand for an item expected to be displayed every hour / day?
You could also have two separate integrations: a batch job that sends out all on hand qty each hour (or any interval). This "rough" info you could use on screens where many items are shown (such as search results that are shown to the user). But if someone opens product details, a real-time call to D365FO would be made so that we could be sure to show the latest information.
Just some thoughts.
Hi Samkit,
You can check also 3rd party solutions as they provide many out of the box features to sync data between F&O and Shopify.
For example dynamics.folio3.com/.../
Another option could be syncronization via CDS + power automate and there is out of the box entity for on hand level in CDS.
docs.microsoft.com/.../synchronize-inventory-level-info
docs.microsoft.com/.../connection-cds
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 449 Super User 2025 Season 2
Martin Dráb 422 Most Valuable Professional
BillurSamdancioglu 239 Most Valuable Professional
