Configurable Product Update Nav-Magento2 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 Configurable Product from Ms Dynamics NAV to Magento2 (Multi-store).

Brief Description


In this integration scenario, multiple connections have been made for Updating Configurable 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 (child items) first, followed by the sync process of adding Configurable Products. Click here, to know more about creating simple products in MS Dynamics NAV. For knowing about the addition of Configurable items, Click Here.

For updating Configurable 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 Web TaxClass Id, WebDescription and WebShortDescription.
  • Updates in Web ProductWebsites Page: The user can change/update the WebSiteId of the product.
  • Updates in Web ProductAttribute Page: No changes required in this section.AttributeOptionId is always blank in Configurable product.
  • Updates in Web ProductCategory Page: The user will be able to modify/update the CategoryId of the product in this page. Also the AttributeOptionId is always blank in Configurable product.
  • Updates in the Web Product Child Details Page: You can add new child items (belonging to the same Attribute set as that of the configurable) and remove the existing child item.
  • The changes in the AEC Application Item list will be modified as per the changes in the Web Product Details CP Page.

On completion of the process click OK button. The entire ItemCard for this Configurable product is given below. confgprdctadd_navtomage2multi1

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).

  • The mapping changes required are: Disable the attributes named Attribute_set_id and type_id.
  • Rest mapping changes are similar to Configurable product add
  • The new complex object type variable named getCustomAttributeOption is added under the section configurable_product_options.

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.


Post Conditions

The user can view the product synced in Magento2.


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).


Frequency of use

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