Simple Product Update Nav-Mage2 MultiConnection



2 minute read

Executing the process is a vital part when integrating any applications. This Document will let the users to understand how the integration process can be executed through workflow for Updating a Simple Product from Ms Dynamics NAV to Magento2 Multi-store.

Brief Description


In this integration scenario, multiple connections have been made for Updating Simple Products from Ms Dynamics NAV to Magento2 (along with multiple Magento websites from a single Magento admin).

As a pre-requisite, the user needs to create and sync the Simple Products first. Click here, to know more about creating simple products in MS Dynamics NAV. For updating Simple Products from Ms Dynamics NAV to Magento2 (Multistore), these are the changes that could be performed for updating a configurable product.

  • Updates in Web Product Details CP Page: The user can update the WebAttributeSetId, the Web TaxClass Id, WebDescription, WebShortDescription.
  • Updates in Web ProductWebsites Page: The user can change/update the WebSiteId of the product.
  • Updates in Web ProductAttribute Page: The user can modify/update the AttributeId and the AttributeOptionId
  • Updates in Web ProductCategory Page: The user be able to modify/update the CategoryId of the product in this page.
  • The changes in the AEC Application Item list will be modifies as per the changes in the Web Product Details CP Page.
  • On completion of the process click on the OK button. The entire ItemCard for this Configurable product is given below.


Lookup Mapping

The Lookup mapping for Currency shall be required in case the business logic deals with multiple currencies.

Attribute Mapping/Transformation

The pre-packaged mappings will successfully sync data MS Dynamics NAV to Magento2 (MultiStore). However, for more informations related to mapping, see Mapping & Transformation Techniques.

Action Filters

Add a node to the given pre-packaged order of the Action filter with two sub-nodes Field and Criteria. View the image below to define the Action Filters.



Executing the Workflow Integration

Note: Before integrating with Magento2 and MS Dynamics NAV , make sure all the Master Data Touchpoints are synced.

  1. Once the workflow is designed, Update the Configuration in agent for deploying the workflow in the agent.
  2. Navigate to the Workflow Panel in the agent and click on the Start Sync Button for executing the Process.
  3. Once the Execution is finished, click Resync Button in the agent.
  4. The Resync Panel show the Success Result in the agent.


Integration Data Survey

The user can survey the data by viewing the Processed Snapshot from the node level of the workflow. This Snapshot View displays the successful execution of the workflow.



The user can view the product synced in Magento2 from Ms Dynamics NAV.


The user can also go to NAV and check if the WebID has returned and the WebSyncFlag has been set to ‘T’ (True) from F (False).


NOTE: After making changes in the item card, the sync flag changes from T to F

Frequency of use

The user can execute the Integration through workflow as and when required.