Import Customer Records from Shopify to Stripe

Import Customer Records from Shopify to Stripe

Use this recipe to import customer records from Shopify to Stripe.

Note: This recipe is available as Shopify — Stripe | Import Customer Records in the Integration Store. Oracle provides this recipe as a sample only. The recipe is meant only for guidance, and is not warranted to be error-free. No support is provided for this recipe.

Overview

This is an application-driven recipe that creates a corresponding customer record in Stripe whenever a customer record is created in Shopify.

To use the recipe, you must install the recipe package and configure the connections and other resources within the package. When a customer record is created in the Shopify instance, the integration flow of the recipe is triggered, and it creates a corresponding record in Stripe. Basic data, such as customer name, city, state, postal code, country, email, and phone, are synchronized between the two platforms.

System and Access Requirements

Before You Install the Recipe

You must perform the following configuration tasks on your Shopify and Stripe instances in order to successfully connect to these external systems using Oracle Integration and transfer customer records between them.

Configure Shopify

To configure Shopify, see Prerequisites for Creating a Connection.

Obtain Stripe API Keys

To access the Stripe instance from Oracle Integration, you’ll require the API key associated with your Stripe account.

To obtain your Stripe account’s API key:

  1. Log in to your Stripe instance as an administrator.

  2. In the left navigation pane, click Developers, then API keys.
    The API keys page is displayed with all the keys associated with your account.

  3. In the Standard keys section, click Reveal test key in the Secret key row.

  4. Note the secret key.

Install and Configure the Recipe

On your Oracle Integration instance, install the recipe package to deploy and configure the integration and associated resources.

  1. On the Oracle Integration Home page, in the Pick a Recipe/Accelerator section, click View All.

  2. Find the recipe you want to install.

  3. Hover over the recipe, then click Install Install icon.
    A message confirms that the recipe was successfully installed, and the recipe card shows INSTALLED.

  4. Hover over the recipe again, and click Configure Configure icon to configure the resources of the recipe.

    The Configuration Editor opens, displaying all the resources of the recipe. Configure the following resources before you activate and run the recipe.

Configure the Oracle Shopify Connection

  1. In the Configuration Editor, under Connections, hover over the Oracle Shopify Connection, then click Edit Edit icon
    The connection configuration page appears.

  2. In the Properties section, enter the following details.

    Field Information to Enter
    Host Name Enter the Shopify host name. The Shopify host name appears in the Shopify home URL. For example: https://hostname.myshopify.com.
    Shopify REST API Version Enter the REST API version.

  3. In the Security section, enter the following details.

    Field Information to Enter
    Security Policy Leave Shopify Security Policy selected.
    Username Enter the API key obtained earlier. See Configure Shopify.
    Password Enter the password obtained earlier.
    Shared secret Enter the shared secret obtained earlier.

  4. Click Save. If prompted, click Save for a second time.

  5. Click Test to ensure that your connection is successfully configured. In the resulting dialog, click Test again.
    A confirmation message is displayed if your test is successful.

  6. Click Go back Back icon to return to the Configuration Editor. Click Save again if prompted.

Configure the Oracle REST Stripe Connection

  1. In the Configuration Editor, under Connections, hover over the Oracle REST Stripe Connection, then click Edit Edit icon
    The connection configuration page appears.

  2. In the Properties section, enter the following details.

    Field Information to Enter
    Connection Type Leave REST API Base URL selected.
    Connection URL Enter the following URL: https://api.stripe.com/.

  3. In the Security section, enter the following details.

    Field Information to Enter
    Security Policy Leave API Key Based Authentication selected.
    API Key Enter the API key associated with your Stripe account. See Obtain Stripe API Keys.

  4. Click Save. If prompted, click Save for a second time.

  5. Click Test to ensure that your connection is successfully configured.
    A confirmation message is displayed if your test is successful.

  6. Click Go back Back icon to return to the Configuration Editor. Click Save again if prompted.

Activate and Run the Recipe

After you’ve configured the connections, activate the recipe package and run it.

  1. In the Configuration Editor, click Activate in the title bar. In the Activate Package dialog, click Activate again.
    A confirmation message is displayed informing that the integration has been submitted for activation. Refresh the page to view the updated status of the integration.

  2. Run the recipe.
    To run the recipe, you must create a customer record in Shopify.

    1. Log in to the Shopify instance.

    2. On the left navigation pane, click Customers.

    3. In the Customers window, click Add Customer.

    4. Enter the following details, and click Save.

      • First Name, Last Name, Email, Phone, and Address.

      • Select the Collect Tax check box if the customer is not tax exempted.

      • Add additional notes if necessary.

    You’ve now triggered the recipe.

  3. Monitor the execution of the recipe’s integration flow in Oracle Integration.

    1. In the Configuration Editor, click Activation to view the integrations in the recipe.

    2. Hover over the integration to monitor, click Actions Actions icon and select Run, then click Track Instances.

    3. On the Track Instances page, you’ll see the integration flow of the recipe being triggered and executing successfully. The recipe now creates a corresponding customer record in Stripe.

  4. Log in to your Stripe instance and check for the new customer record created.
    On the Stripe instance, click the Customers tab. The list of customers is displayed, which contains the corresponding customer record for the record created in Shopify.

Related Documentation