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

The Shopify product details to Microsoft Dynamics 365 Business Central Celigo eTail item map (add or ignore) flow syncs Shopify product details (product ID, variant ID, and inventory item 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 Shopify SKU and Microsoft Dynamics 365 Business Central Item No. match. This is a scheduled flow.

Understand the flow 

In the Shopify product details to Microsoft Dynamics 365 Business Central Celigo eTail item map (add or ignore) flow, the Get products from Shopify export runs a query for Shopify product and their variant information. The flow looks for the products in Microsoft Dynamics 365 Business Central for each Shopify product and their variants with a matching SKU and internal ID. If a matching Shopify SKU and Microsoft Dynamics 365 Business Central internal ID is found, the internal ID is 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 variant ID, store ID, and Shopify channel. 

Run the flow

Know before you run the flow: Ensure that the Shopify SKU and Microsoft Dynamics 365 Business Central Item No. match in both the systems.

To run the flow:

1. Log in to your integrator.io account.
2. Click on the Shopify - Microsoft Dynamics 365 Business Central integration app tile.
3. Go to Flows > Inventory.
4. Next to the Shopify 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 Shopify and Microsoft Dynamics 365 Business Central product id records