• Home
  • Services
    • Retail & eCommerce
      • .NET eCommerce
      • Multichannel eCommerce
      • Mobile Apps for eCommerce
      • eCommerce Chatbots
      • Dynamics365 Integration
    • SharePoint Portal
      • Document flow
      • Request approval services
      • Staff directory and orgchart
      • Helpdesk
      • HR-services
      • Reporting and documentation
  • Projects
  • Customers and partners
  • Blog
  • Contact us
ISDK - eCommerce development, omnichannel solutions, CRM-marketing
  • EN
    • EN
    • DE
    • NL
  • Home
  • Services
    • Retail & eCommerce
      • .NET eCommerce
      • Multichannel eCommerce
      • Mobile Apps for eCommerce
      • eCommerce Chatbots
      • Dynamics365 Integration
    • SharePoint Portal
      • Document flow
      • Request approval services
      • Staff directory and orgchart
      • Helpdesk
      • HR-services
      • Reporting and documentation
  • Projects
  • Customers and partners
  • Blog
  • Contact us
Dynamics integrationDynamics integration

Microsoft Dynamics 365 – nopCommerce integration: real case

As our first post on the integration between Dynamics 365 and nopCommerce caused some questions requiring to go more into details, we decided to publish a second part and demonstrate a real case settings and data schema.

Settings on Dynamics side

Allow creating products in active state: Settings → Administration → System Settings → Sale

Microsoft Dynamics 365 – nopCommerce integration

 

Create the required currency and a price list: Settings → Product Catalog → PriceList

 

Data schema and mappings

Microsoft Dynamics 365 – nopCommerce integration

 

Fields matching description

CRM entityCRM propertyNop entityNop property
ProductproductnumberProductSku
ProductproductidProductDynamicsId
ProductnameProductName
ProductdescriptionProductFullDescription
ProductpriceProductPrice
ProductcurrentcostProductProductCost
ProductquantityonhandProductStockQuantity
ProductstatecodeProductPublished
Productdefaultuomid
Productdefaultuomscheduleid
ProductManageInventoryMethod
ProductProductType
SalesOrdersalesorderidOrderDynamicsId
SalesOrdernameOrderName
SalesOrderemailaddressOrderBillingAddress.Email
SalesOrderdiscountamountOrderOrderSubTotalDiscountInclTax
SalesOrderstatuscodeOrderPaymentStatus
SalesOrderstatecodeOrderOrderStatus
SalesOrderstatuscodeOrderShippingStatus
SalesOrdershippingmethodcodeOrderShippingMethod
SalesOrderBillingAddressOrderBillingAddress
SalesOrderShippingAddressOrderShippingAddress
SalesOrdertotalamountOrderOrderTotal
SalesOrder_customerid_valueOrderCustomerId
SalesOrderpricelevelidOrder
SalesOrdertransactioncurrencyidOrderCustomerCurrencyCode
SalesOrderdescriptionOrder
PaymentMethodSystemName
ShippingRateComputationMethodSystemName
SalesOrderDetailsalesorderdetailidOrderItemDynamicsId
SalesOrderDetailsalesorderOrderItemOrder
SalesOrderDetailproductidOrderItemProduct
SalesOrderDetailquantityOrderItemQuantity
SalesOrderDetailuomidOrderItem
SalesOrderDetailpriceperunitOrderItemUnitPriceInclTax
SalesOrderDetailmanualdiscountamountOrderItemDiscountAmountInclTax
SalesOrderDetailtaxOrderItemPriceInclTax – PriceExclTax
SalesOrderDetailextendedamountOrderItemPriceInclTax
SalesOrderDetailextendedamount – taxOrderItemPriceExclTax
msdyn_ProductInventorymsdyn_productinventoryidProductWarehouseInventoryDynamicsId
msdyn_ProductInventorymsdyn_qtyallocatedProductWarehouseInventoryReservedQuantity
msdyn_ProductInventorymsdyn_qtyavailableProductWarehouseInventoryStockQuantity
msdyn_WarehousemsDyn_WarehouseIdWarehouseDynamicsId
msdyn_Warehousemsdyn_nameWarehouseName
WarehouseAdminComment
ContactContactIdCustomerDynamicsId
Contactemailaddress1CustomerEmail
ContactmobilephoneCustomerPhoneAttribute
ContactbirthdateCustomerDateOfBirthAttribute
ContactlastnameCustomerLastNameAttribute
ContactfirstnameCustomerFirstNameAttribute
ContactcompanyCustomerCompanyAttribute
ContactfaxCustomerFaxAttribute
ContactdescriptionCustomer
ContactgendercodeCustomerGenderAttribute
ContactdonotemailCustomer
Contactaddress1CustomerBillingAddress
Contactaddress2CustomerShippingAddress
Contactaddress3CustomerGenericAddress

Have questions about the integration? Contact us for a free consultation.

Request a quote

Dynamics365integrationMicrosoftnopCommerce

Contact us

logo

“The only way to do great work is to love what you do” - Steve Jobs

Search by topic

.NET Core .NET Framework 1С Adjust Ajax Apache JMeter ARIS ASP.NET ASP.NET MVC Bootstrap Business Connectivity Services DevExpress DevExpress XAF DevExtreme ESB Google Geoservices Google Map InfoPath Java Message Service JavaScript JQuery Knockout.js Knockoutjs Microsoft Azure Microsoft Flow MS Active Directory MS SQL MS System Center Nintex Nintex Forms Nintex Workflow nopCommerce QlikView Reporting Services SharePoint Sharepoint Search Sharepoint workflow Snowplow Telerik UML Visual Studio Web Services Xamarin

Projects

https://isdk.pro/wp-content/uploads/Barcode-scanning-small-150x150.jpegMVP app to test an E-Commerce business idea in 3 weeks
https://isdk.pro/wp-content/uploads/GlobeIn-Shop-small-1-150x150.jpgiOS app with Apple in-app subscriptions and purchases
https://isdk.pro/wp-content/uploads/globein-box-small-150x150.jpgSubscription boxes iOS app set up for marketing campaigns
https://isdk.pro/wp-content/uploads/book-publisher-small-150x150.jpgnopCommerce multi-store for a book publisher
https://isdk.pro/wp-content/uploads/clinic-small-150x150.jpgRoutine automation with Office 365 and Teams chatbot
https://isdk.pro/wp-content/uploads/SharePoint-in-a-business-school-150x150.jpgSharePoint Online and Office 365 in a business school
https://isdk.pro/wp-content/uploads/SharePoint-for-a-DMS_ed-small-150x150.pngSharePoint 2019 Document Archive
https://isdk.pro/wp-content/uploads/nopCommerce-upgrade-case-featured-400-200-150x150.pngnopCommerce Upgrade to .NET CORE
https://isdk.pro/wp-content/uploads/Harman-JBL-ecommerce-case-featured-400-200-150x150.pngHigh-traffic eCommerce webstore Harman.club
https://isdk.pro/wp-content/uploads/Herbalife-banner-400-200-150x150.pngE-Commerce Omni-Channel
https://isdk.pro/wp-content/uploads/hr-sharepoint-trainings-home-400-200-150x150.pngEnterprise SharePoint Portal. HRM-Trainings
https://isdk.pro/wp-content/uploads/Automobile-company-sharepoint-hr-portal-400-200-150x150.pngSharePoint HR-Portal – Employee Request Approvals

Contact us

  • USA Austin, TX
    +1 737 2413109

    GERMANY Berlin
    +49 15233977274

    BENELUX (BELGIUM, Antwerp)
    +32 484 40 10 53

    RUSSIA Moscow
    +7 495 651 66 62

    LATVIA Riga
    +371 27869927

  • [email protected]
  • https://isdk.pro
  • https://www.linkedin.com/company/isdk/
ISDK ©2010-2020

All rights reserved.

X
Request trial hours!
Submit
ISDK website uses cookies for statistics and content. Learn more ACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary Always Enabled

Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.

Non-necessary

Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.