Install and Configure the Recipe

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

Install the recipe on your Oracle Integration instance. See Install a Recipe or Accelerator.

After you've installed the recipe, configure the following resources:

Configure the Oracle Shopify Connection

  1. In the Connections section, click the connection name.
  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 again.
  5. Click Test to ensure that your connection is successfully configured. In the resulting dialog, click Test again.
    A message confirms if your test is successful.
  6. To return to the project workspace, click Go back Back icon.

Configure the Oracle ERP Cloud Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, enter the Oracle ERP Cloud host name. For example: https://your_domain_name.fa.DC.oraclecloud.com.
  3. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Select Username Password Token.
    User Name Enter the user name of the account created for Oracle Integration on Oracle ERP Cloud. See Configure Oracle ERP Cloud.
    Password Enter the password of the account created for Oracle Integration on Oracle ERP Cloud.
  4. Click Save. If prompted, click Save again.
  5. Click Test to ensure that your connection is successfully configured. In the resulting dialog, click Test again.
    A message confirms if your test is successful.
  6. To return to the project workspace, click Go back Back icon.

Update Integration Property

Update the integration property with appropriate value.

Note:

This is an app-driven integration, and you can update the property values only before activating the recipe.
  1. In the Integrations section, click Actions Actions icon on the integration flow, then select Update property values.
  2. In the Update property values panel, update the EmailTo integration property with appropriate values.
    • EmailTo: This integration property holds the email address to which error notifications are sent. Enter an email address of your choice.
  3. Click Submit.

    A message confirms that the integration properties have been updated successfully.

Configure the Lookup Tables

Edit the following lookup tables to map the fields between Shopify and Oracle ERP Cloud.

  • ORACLE-BRT-SHOPIFY_ERP_PO_LOOKUP: Used to map the fields related to the purchase order between Shopify and Oracle ERP Cloud.

  • ORACLE-BRT-SHOPIFY_ERP_PO_LINES_LOOKUP: Used to map the fields related to each line item in the purchase order between Shopify and Oracle ERP Cloud.

  • ORACLE-BRT-SHOPIFY_ERP_CURRENCY_LOOKUP: Used to map the currency fields between Shopify and Oracle ERP Cloud.

  1. In the Lookups section, click the lookup name.
  2. In the Property column, enter the name of the Oracle ERP Cloud field you want to map.
  3. In the Value column, enter the name of the field in Shopify to which the Oracle ERP Cloud field has to be mapped.
  4. Click Save. If prompted, click Save again.
  5. To return to the project workspace, click Go back Back icon.

Configure the Integration Flow (Optional)

If you want to add or edit the Oracle ERP Cloud fields (other than what is pre-configured in this recipe), you must update all the Stage File elements of the Oracle Shopify ERP Order2PurchaseOrder Create integration flow with a new schema file that contains the structure of the updated data set.

Update the Stage File Element

  1. Add the required additional fields to your sample schema file.
  2. In the Integrations section of the project workspace, click Actions Actions icon on the Shopify ERP Order2PurchaseOrder Create integration flow, then click Edit.
  3. On the integration canvas, edit all the Stage File elements and upload the modified file to them, and complete the required mappings. See Configure a Stage File Action in Using Integrations in Oracle Integration 3.