January 20, 2023 By Team HIC

Salesforce Customization for a Public Health Nonprofit to sync Shopify customer data with Salesforce based on Shopify ID

Salesforce Customization for a Public Health Nonprofit to sync Shopify customer data with Salesforce based on Shopify ID

Highlights

  • Eliminated duplicate entries.
  • Minimized data redundancy, ensuring accurate records.
  • Achieved real-time updates of customer records.
  • Enhanced the ability to assign and update records accurately with various combinations.
  • Streamlined processes and saved time by automating customer data synchronization.

Highlights

  • Eliminated duplicate entries.
  • Minimized data redundancy, ensuring accurate records.
  • Achieved real-time updates of customer records.
  • Enhanced the ability to assign and update records accurately with various combinations.
  • Streamlined processes and saved time by automating customer data synchronization.

Overview:

See how HIC Global Solutions resolved Girl Trek’s Shopify-Salesforce integration issues, ensuring complete redundancy removal and a seamless customer data sync.

What You Need to Know

Shopify, a cloud-based eCommerce platform, facilitates easy store setup, while Salesforce, a CRM leader, consolidates sales, service, and marketing. Shopify Made Easy is the integration connector ensuring real-time sync between Shopify and Salesforce.

Why It Matters

Efficient integration enhanced data accuracy for Girl Trek, eliminating duplications and streamlining customer information with HIC’s tailored Salesforce solutions.

What HIC did

HIC Global Solutions resolved Girl Trek’s data integration challenges by customizing the connector for refined searches and utilizing Apex Trigger and Process Builder.

Overview:

See how HIC Global Solutions resolved Girl Trek’s Shopify-Salesforce integration issues, ensuring complete redundancy removal and a seamless customer data sync.

What You Need to Know

Shopify, a cloud-based eCommerce platform, facilitates easy store setup, while Salesforce, a CRM leader, consolidates sales, service, and marketing. Shopify Made Easy is the integration connector ensuring real-time sync between Shopify and Salesforce.

Why It Matters

Efficient integration enhanced data accuracy for Girl Trek, eliminating duplications and streamlining customer information with HIC’s tailored Salesforce solutions.

What HIC did

HIC Global Solutions resolved Girl Trek’s data integration challenges by customizing the connector for refined searches and utilizing Apex Trigger and Process Builder.

About the Client

Our client Girl Trek is a leading public health Nonprofit that is dedicated to inspiring African-American females and young ladies to utilize walking as a practical first step to promote healthy lifestyles, households, and communities.
In addition to walking, GirlTrek’s active members back local and national laws to raise physical activity through walking, enhance access to secure areas to walk, safeguard and retake green areas, and boost the walkability built environments of 50 highly-demanding communities around the United States.

About the Client

Our client Girl Trek is a leading public health Nonprofit that is dedicated to inspiring African-American females and young ladies to utilize walking as a practical first step to promote healthy lifestyles, households, and communities.
In addition to walking, GirlTrek’s active members back local and national laws to raise physical activity through walking, enhance access to secure areas to walk, safeguard and retake green areas, and boost the walkability built environments of 50 highly-demanding communities around the United States.

Challenges faced

Our client Girl Trek has been using the Shopify Made Easy connector app to integrate their Shopify store data with Salesforce. However, they needed advanced capabilities as they faced challenges with record searching on Salesforce.

Existing buyers’ new purchases in Shopify were not updating records in Salesforce, leading to outdated information.

Increased duplicity and redundancy hindered accurate customer data, causing operational challenges for Girl Trek.

Difficulty in segregating and syncing newly added Shopify customers with existing Salesforce data prompted the need for enhanced data sorting.

Faced issues in widening their record search on Salesforce with the basic version of the app.

Challenges faced

Our client Girl Trek has been using the Shopify Made Easy connector app to integrate their Shopify store data with Salesforce. However, they needed advanced capabilities as they faced challenges with record searching on Salesforce.

Existing buyers’ new purchases in Shopify were not updating records in Salesforce, leading to outdated information.

Increased duplicity and redundancy hindered accurate customer data, causing operational challenges for Girl Trek.

Difficulty in segregating and syncing newly added Shopify customers with existing Salesforce data prompted the need for enhanced data sorting.

Faced issues in widening their record search on Salesforce with the basic version of the app.

Challenges faced

Our client Girl Trek has been using the Shopify Made Easy connector app to integrate their Shopify store data with Salesforce. However, they needed advanced capabilities as they faced challenges with record searching on Salesforce.

They were facing issues with
  • Outdated Records on Purchase:
  • Existing buyers’ new purchases in Shopify were not updating records in Salesforce, leading to outdated information.

  • Increased Duplicity and Redundancy:
  • Increased duplicity and redundancy hindered accurate customer data, causing operational challenges for Girl Trek.

  • Data Sorting Challenges:
  • Difficulty in segregating and syncing newly added Shopify customers with existing Salesforce data prompted the need for enhanced data sorting.

  • Customization issues with Shopify Made Easy
  • Faced issues in widening their record search on Salesforce with the basic version of the app.

Solution Offered

HIC Global Solutions, a registered Salesforce Crest partner, was brought to address these pressing concerns. Our developers sat for a brainstorming session to offer a suitable solution to our client.

We offered to create customization on their Salesforce org and developed an APEX Trigger on their org, which enabled the Shopify Made Easy connector app to perform the following actions under their specified criteria-

As a result of the trigger set, the Shopify Made Easy connector app looks for an existing contact in Salesforce based on the Shopify ID whenever a new buyer creates a new account on Shopify or creates a new ID if no match is found.

If an existing Salesforce contact lacks a matching Shopify ID, the connector app searches using last name and personal email. If found, the connector updates the contact under the existing Shopify ID; otherwise, a new Shopify ID is created

In the third scenario, when the same contact in Salesforce is not found with the last name and personal email ID, then the connector app looks for contact with the same last name and work email. If the last name and work email combination match, then the connector updates the existing contact in the same Shopify ID.

If no match is found with last name and work email, the connector app searches for the contact’s alternate email under the same last name. If found, the existing contact is updated under the same Shopify ID without creating a new ID

If the contact is not found with the same last name and alternate email or with any other parameter as mentioned above, the connector app create a new contact in Salesforce with a new Shopify ID.

Creating Automation for Updating Records Automatically

Created automation for new records to auto-update new fields from email fields, helping the client Sync their Shopify Product images into Salesforce as Attachments.

Solution Offered

HIC Global Solutions, a registered Salesforce Crest partner, was brought to address these pressing concerns. Our developers sat for a brainstorming session to offer a suitable solution to our client.

We offered to create customization on their Salesforce org and developed an APEX Trigger on their org, which enabled the Shopify Made Easy connector app to perform the following actions under their specified criteria-

As a result of the trigger set, the Shopify Made Easy connector app looks for an existing contact in Salesforce based on the Shopify ID whenever a new buyer creates a new account on Shopify or creates a new ID if no match is found.

If an existing Salesforce contact lacks a matching Shopify ID, the connector app searches using last name and personal email. If found, the connector updates the contact under the existing Shopify ID; otherwise, a new Shopify ID is created

In the third scenario, when the same contact in Salesforce is not found with the last name and personal email ID, then the connector app looks for contact with the same last name and work email. If the last name and work email combination match, then the connector updates the existing contact in the same Shopify ID.

If no match is found with last name and work email, the connector app searches for the contact’s alternate email under the same last name. If found, the existing contact is updated under the same Shopify ID without creating a new ID

If the contact is not found with the same last name and alternate email or with any other parameter as mentioned above, the connector app create a new contact in Salesforce with a new Shopify ID.

Creating Automation for Updating Records Automatically

Created automation for new records to auto-update new fields from email fields, helping the client Sync their Shopify Product images into Salesforce as Attachments.

Solution Offered

HIC Global Solutions, a registered Salesforce Crest partner, was brought to address these pressing concerns. Our developers sat for a brainstorming session to offer a suitable solution to our client.

We offered to create customization on their Salesforce org and developed an APEX Trigger on their org, which enabled the Shopify Made Easy connector app to perform the following actions under their specified criteria-

Customization and APEX Trigger Development
  • Search based on Shopify ID
  • As a result of the trigger set, the Shopify Made Easy connector app looks for an existing contact in Salesforce based on the Shopify ID whenever a new buyer creates a new account on Shopify or creates a new ID if no match is found.

  • Contact Search based on last name and personal email,
  • If an existing Salesforce contact lacks a matching Shopify ID, the connector app searches using last name and personal email. If found, the connector updates the contact under the existing Shopify ID; otherwise, a new Shopify ID is created

  • Work Email Matching
  • In the third scenario, when the same contact in Salesforce is not found with the last name and personal email ID, then the connector app looks for contact with the same last name and work email. If the last name and work email combination match, then the connector updates the existing contact in the same Shopify ID.

  • Search with alternate emails
  • If no match is found with last name and work email, the connector app searches for the contact’s alternate email under the same last name. If found, the existing contact is updated under the same Shopify ID without creating a new ID

  • Creating New Contact
  • If the contact is not found with the same last name and alternate email or with any other parameter as mentioned above, the connector app create a new contact in Salesforce with a new Shopify ID.

    Creating Automation for Updating Records Automatically

    Created automation for new records to auto-update new fields from email fields, helping the client Sync their Shopify Product images into Salesforce as Attachments.

Ready to take your Salesforce journey to new heights?

Partner with us today and experience the difference that our Salesforce Consulting Company can make for your business.

Related Client Stories

All resources featured on this website, including images and content, are proprietary assets reserved exclusively for HIC Global Solutions's use.

Our Location worldwide
Indian Flag India
3rd Floor, A-10, Pegasus Tower, Sector 68, Noida, Uttar Pradesh 201301 +91-1203117884
United States of America Flag USA
333 West Brown Deer Road Unit G – 366 Milwaukee WI, USA 53217 +1(262) 310-7818
United Kingdom Flag UK
7 Bell Yard, London, WC2A 2JR +44 20 3239 9428
Canada Canada
HIC Global Solutions INC
43 Lafferty Lane, Richmond Hill, L4C 3N8, CA +1(262) 310-7818