Import only paid Shopify orders into Business Central
Set up the Shopify Connector for Microsoft Dynamics 365 Business Central to import paid orders only, so each order arrives once with every upsell in it.
Last updated
If Business Central imports a Shopify order before the buyer has seen your upsells, the sales order is created without them. This guide sets up Business Central so it imports only paid orders. Together with capturing payments after the upsell window, each order arrives once, final, with every upsell in it.
Why it matters
With Elite Post Purchase set to capture payments after upsells, an order stays unpaid in Shopify until a few minutes after the buyer is done. If Business Central only imports paid orders, it doesn't see the order until then. An order that has already been processed in Business Central can't take later edits, so importing late avoids conflicts.
Set it up
Open the Shopify Shop Card
In Business Central, search for Shopify Shops, open it, and select your shop to open the Shopify Shop Card.
Open the order import
Choose the Orders action, then the Sync Orders from Shopify action.
Filter for fully paid orders
On the request page, define a filter so only fully paid orders are included. Microsoft gives this as an example: you can import fully paid orders. Then choose OK.
Schedule it
To run the import on a schedule, schedule the Sync Orders From Shopify batch job as a recurring task, using the same filter.
Microsoft's own steps are in Synchronize and fulfill sales orders.
Or wait for the ready tag
Instead of waiting for payment, Business Central can wait for a tag. Tag orders when they're ready to ship adds the tag EPP-ready to each order once upsells are done, whether or not you capture payments later.
In the same Sync Orders from Shopify request page, set the Tags filter to @*EPP-ready*, and use the same filter on the scheduled job. Turn off Auto Sync Orders, which ignores filters, and run the job every 5 to 15 minutes.
If you renamed the tag in the app, use your name here. The tag means upsells are done, not that the order is paid, so keep the paid filter on as well if Business Central should wait for both.
Still stuck?
Chat with us and we'll help you get your offer live. Or email contact@elitecart.app.