Published Jul 3, 2024

How to create your first flow

Create and configure integrations, build flows, map data fields, and handle duplicate records.
Adam Peña

Technical Product Marketing Associate

Adam Peña

Managing product data between multiple platforms can be time-consuming. If you’re dealing with slow, manual updates in Salesforce, integrating your Shopify data can streamline this process.

This guide walk you through automating product updates from Shopify to Salesforce using the Celigo Platform.

Use case

Suppose you work for a retail business that sells physical items to customers. You use Shopify to add and manage your items for sale. Without visibility into these items, your sales team, which primarily works out of Salesforce, will not have the product details they need to make sales to prospective customers.

In this demo, we’ll integrate Shopify with Salesforce, create and configure integrations, build flows, connect Shopify and Salesforce, map data fields, and handle duplicate records.

Set up your environment

Log in to Celigo:

  1. Navigate to Celigo’s integration platform, and log in. You will see the home screen displaying your integrations.

Create an integration:

  1. Click the blue “Create” button in the top right corner and select “Integration.”
  2. Name your integration clearly, e.g., “Shopify to Salesforce Example Integration.”
  3. Add a description to explain the purpose of the integration and click “Save and Close.”

Create a flow

Navigate to the flows tab:

  1. Once your integration is created, you will be taken to the “Flows” tab inside the integration.

To create a flow:

  1. Click “Create Flow” to start building your flow.
  2. Name your flow appropriately, e.g., “Shopify Products to Salesforce Products.”

Add a source (Shopify)

Add source:

  1. Click “Add Source” in the first flow step.
  2. Select “Shopify” from the list of connection endpoints.

Create a Shopify connection:

  1. Click “Create Connection” and follow the prompts to connect your Shopify store.
  2. Follow any recommended steps, like creating a connection directly from the Shopify app store.

Configure export:

  1. Select “Export Records from Source Application.”
  2. Choose the appropriate API endpoint, e.g., “Products.”
  3. Set the export type to “All” to export all product data.

Preview data:

  1. Use the preview feature to ensure the correct data is being pulled from Shopify.

Add a destination (Salesforce)

Add destination:

  1. Click “Add Destination Lookup” on the right side of the flow step.
  2. Select “Salesforce” as the application.

Create a Salesforce connection:

  1. Click “Create Connection” and fill out the form with your Salesforce credentials.
  2. Select the appropriate authentication method, such as “OAuth 2.0 Refresh Token.”

Configure import:

  1. Name the import step, e.g., “Post Products to Salesforce.”
  2. Select the Salesforce API type, e.g., “SOAP.”
  3. Choose the “Product” SObject type.
  4. Set the operation to “Insert.”

Map fields

Map Shopify fields to Salesforce:

  1. Click the mapping icon in the import step to start mapping fields.
  2. Map the Shopify product ID to the Salesforce “External ID.”
  3. Map the Shopify product title to the Salesforce “Product Name.”
  4. Use hard-coded mapping to set the product status to “True.”

Handle duplicate records

Configure duplicate handling:

  1. Click the import icon in the Salesforce import step.
  2. Check “Ignore Existing Records.”
  3. Define a filter to identify duplicates using the Shopify ID and Salesforce External ID.

Run and test the flow

Enable and run flow:

  1. Enable the flow using the switch in the top right.
  2. Click the play button to run the flow manually.
  3. Monitor the run console for status updates and any errors.

Verify results:

  1. Ensure that the products are correctly imported into Salesforce without duplicates.
  2. Re-run the flow to verify that only new products are added and duplicates are ignored.

By following these steps, you can automate the synchronization of product data between Shopify and Salesforce, saving time and reducing errors in manual updates.