Sync product details from BigCommerce to Microsoft Dynamics 365 Business Central as a custom record

The BigCommerce product details to Microsoft Dynamics 365 Business Central item ID map record (add or ignore) flow syncs BigCommerce product details (product ID and variant ID) as a Celigo eTail item map custom record to Microsoft Dynamics 365 Business Central. The flow creates custom records for existing items when the BigCommerce SKU and Microsoft Dynamics 365 Business Central Item No. match. This is a scheduled flow.

Understand the flow 

In the BigCommerce product details to Microsoft Dynamics 365 Business Central Celigo eTail item map(add or ignore) flow, the Get products from BigCommerce export runs a query for BigCommerce product and their variant information. The flow looks for the products in Microsoft Dynamics 365 Business Central for each BigCommerce product and their variants with a matching SKU and internal ID. If a matching BigCommerce SKU and Microsoft Dynamics 365 Business Central internal ID is found, the product ID and variant ID are synced. If a match is not found, the record is ignored. The Post Celigo eTail item map to Microsoft Dynamics 365 Business Central import creates a custom record Celigo eTail item map in Microsoft Dynamics 365 Business Central based on the product ID, variant ID, store ID, and BigCommerce channel. 

Prerequisite: Ensure that the BigCommerce SKU and Microsoft Dynamics 365 Business Central Item No. match in both the systems.

Run the flow

To run the flow:

1. Log in to your integrator.io account.
2. Click on the BigCommerce - Microsoft Dynamics 365 Business Central integration app tile.
3. Go to Flows > Inventory.
4. Next to the BigCommerce product details to Microsoft Dynamics 365 Business Central Celigo eTail item map (add or ignore) flow, use the toggle button to enable the flow.
5. If you run the flow for the first time, a delta flow pop-up window is displayed. This helps you to sync the historical products. 
• Automatic: Choose this option to process and sync data from the last flow run time (OR)
• Custom: Choose this option to select a custom start date and time from when you wish to process and sync data.
  
6. Click Run.

You can see the flow status in the Integration App Dashboard.

Understand the BigCommerce and Microsoft Dynamics 365 Business Central product id records