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, scroll to the Accelerators & Recipes section.

  2. Click Search All.

  3. Find the recipe package that you want to install.

  4. Select the package, and then click the Install Install icon icon.

  5. After the package is installed, click the Configure Configure icon icon on the recipe card to configure the resources deployed by the package.

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

Configure the Oracle Shopify Connection

  1. On the Configuration Editor page, select Oracle Shopify Connection, then click Edit Edit icon.
    The connection configuration page appears.

  2. In the Connection 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 Back Back icon to return to the Configuration Editor page. Click Save again if prompted.

Configure the Oracle REST Stripe Connection

  1. On the Configuration Editor page, select Oracle REST Stripe Connection.

  2. Click Edit Edit icon.
    The connection configuration page appears.

  3. In the Connection 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/.

  4. 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.

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

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

  7. Click Back Back icon to return to the Configuration Editor page. Click Save again if prompted.

Activate and Run the Recipe

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

  1. On the Configuration Editor page, 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 created a customer record in Shopify and triggered the recipe.

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

    1. On the Configuration Editor page, select the integration flow.

    2. Click Run Run icon, 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