Small and medium business | Business Central, N...

Import invoices and payments from external retail or ecomm platforms to BC

(1) Share

Report

Posted on by CU23011009-0

Hi everyone,

I'm looking for recommendations on solutions for importing invoices and payments from external retail or ecomm platforms to Microsoft Dynamics 365 Business Central.

Has anyone had good experiences with a particular existing solution for this business need?

Any insights and recommendations would be greatly appreciated.

Many thanks,

Fjorela

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Khushbu Rajvi. 22,130 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hope this helps:https://community.dynamics.com/forums/thread/details/?threadid=d242ea60-b9bc-4f99-96c2-4d3492848a1c

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 99,086 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

You can use the API or Power Automate. For example,

Dynamics 365 Business Central: How to use standard customerPayment API to get customer payments (customerPayments/customerPaymentsJournals APIs returns empty records)

https://yzhums.com/52159/

How to import data from a csv file to Business Central with Power Automate (No customization) – csv to JSON

https://yzhums.com/47113/

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 32,208 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

If you only need to import invoices and payments, you can use Excel files and configuration packages. However, this method is more manual.

For more automated solutions, you'll typically need to build your own connector or integration. Yun Zhu mentioned two options for this: APIs and Power Automate.

In most cases, the platform you're trying to integrate with Business Central doesn't have an out-of-the-box connector, as each integration needs to be customized. However, some popular solutions might have one available—you can check the App Store for those.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Suggested answer

Kntx 11 on at

Like (1)

Report
Copy link

Link copied!

Hi Fjorela,

it depends on the external system and the quantity of orders - if you have to import documents from an ecommerce and you don't have specific requirements, you will probably find an app that will be able to connect smoothly and manage all your syncronization needs just like it is possible to do for Shopify in the standard solution, eg:

- Woocommerce: https://appsource.microsoft.com/en-us/product/dynamics-365-business-central/PUBID.synfynal%7CAID.woocommerce-connector%7CPAPPID.91445282-543f-41e8-825c-a1186639bb82?tab=Overview

- Magento: https://appsource.microsoft.com/en-us/product/dynamics-365-business-central/PUBID.nvisioncommercesolutions%7CAID.commerce365%7CPAPPID.6eeb7693-fd33-4df0-9fb6-cf975ed7f279?tab=Overview

If the ecommerce\retail platform integration is a custom solution and it is ok to manually import documents for example once a day (because it is not time sensitive and the volume is not high), you can use one of the many apps for data import that allow for easy configuration of the format like:

- Import Data Templates (disclaimer: I work for this company): https://appsource.microsoft.com/en-us/product/dynamics-365-business-central/PUBID.mementosrls1588695843705%7CAID.importdatatemplates%7CPAPPID.e6318f89-69a6-4e4b-aebe-9f7f6cf24ef5?tab=Overview

- Excel Importer: https://appsource.microsoft.com/en-us/product/dynamics-365-business-central/PUBID.thetasystemslimited%7CAID.bc_excel_importer%7CPAPPID.24466323-aee9-4049-a66d-a1af24466323?tab=Overview

If you need a more complex integration with a high volume of documents, you should really look at having a custom integration developed.

Best.

Was this reply helpful? Yes No
CU23011009-0 14 on at

Like (1)

Report
Copy link

Link copied!

Many thanks to all for your suggestions!

Was this reply helpful? Yes No