Teams that sell online and in store need orders posted to ERP without delay. This build pulls paid Shopify orders and creates the right record in Microsoft Dynamics 365 Business Central, using Sales Orders for web and Sales Invoices for POS. It helps reduce manual steps and cut posting errors.

A schedule runs on a timer and reads Shopify orders updated in the last 24 hours. Paid orders move forward, and the flow fetches fulfillment orders to find the active location for each line. The system looks up the customer in Business Central and creates one if none is found. It also checks for existing sales orders or invoices to prevent duplicates, then posts the correct document type. Line items are mapped and created, and if any line fails, the header is deleted so your ERP stays clean.

Setup needs a Shopify Admin API token and a Business Central OAuth app, plus company, tenant, tax, and discount item values. Expect hours of data entry to drop to minutes, with fewer mistakes in finance posting. This is a strong fit for multi location retailers and distributors that want clean, repeatable ERP posting from Shopify.

• Schedule Trigger runs the sync on a set timetable to keep ERP updated daily or hourly
• Shopify node pulls all orders updated in the last 24 hours and returns all results
• Filter node passes only paid orders to avoid posting unpaid transactions
• HTTP request gets fulfillment orders to resolve the active location per line for multi location shops
• Customer lookup in Business Central with auto create when no match is found
• Duplicate checks for Sales Orders and Sales Invoices before creating records
• POS branch creates Sales Invoices, web branch creates Sales Orders based on source
• Header mapping for orders and invoices, then split and post each line item
• Error control removes the header if any line fails to create to prevent partial data
• Batch processing and loop control to handle large order volumes safely

• Reduce manual order entry from hours per day to minutes by posting Shopify orders to Business Central automatically
• Automate up to 95 percent of order posting, including header and line creation
• Improve data accuracy by 80 percent by removing copy paste and blocking duplicates
• Handle up to 5 times more orders without adding staff through scheduled batching
• Connect Shopify and Microsoft Dynamics 365 Business Central with consistent field mapping
• Keep ERP clean by deleting headers when line creation fails

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Shopify and Microsoft Dynamics 365 Business Central. See the Tools Required section above for links to create accounts with these services.
3. Open the Shopify node, click Credentials, then Create new credential. Choose Access Token. In your Shopify admin create a custom app, grant Orders and Fulfillment read scopes, and copy the Admin API access token. Paste the token into n8n and save.
4. For Business Central, double click any Business Central HTTP node, choose Credential to connect with, and Create new credential using OAuth2. If unsure, follow the on screen steps. Use your Azure AD app Client ID and Secret, set the correct Tenant ID, and grant API permissions to Dynamics 365 Business Central.
5. Open the D365 BC Environment Settings node and fill tenantId, companyId, company name, and the SKU items for taxes and discounts.
6. Check the Shopify node filter. It is set to pull orders updated in the last 24 hours. Adjust the time window if needed.
7. Open the Filter node and confirm only paid orders pass. Set financial status conditions to match your rules.
8. Review the Sales Order Mapping and Sales Invoice nodes. Map fields like external IDs, posting dates, customer IDs, and currency to your Business Central setup.
9. Set the Schedule Trigger to your cadence, such as every hour during business hours.
10. Run a test with one recent order. Confirm Lookup Customers returns a match or that Create Customer runs and the customer ID is set.
11. Validate duplicate protection by running the same order twice. Check that Lookup Sales Order or Lookup Sales Invoice stops a second post.
12. For multi location shops, confirm Get Fulfillment Orders returns a location for each line and that these map correctly in Business Central.
13. If lines fail to create, check SKU mappings for taxes and discounts. Fix the item setup and run again. The flow will delete bad headers and keep Business Central clean.