Create Products in Shopify for Items in Oracle ERP Cloud

Create Products in Shopify for Items in Oracle ERP Cloud

Use this recipe to create corresponding products in Shopify when items are created in Oracle ERP Cloud.

Note: This recipe is available as Oracle ERP Cloud — Shopify | Create Products for Items 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 product in Shopify whenever an item is created in Oracle ERP Cloud.

To use the recipe, you must install the recipe package and configure the connections and other resources within the package. When an item record is created in the Oracle ERP Cloud instance, the recipe is triggered, and it creates a corresponding product record in Shopify. Basic data, such as attachments, price, title, and product type are synchronized between the two platforms.

System and Access Requirements

Before You Install the Recipe

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

Configure Oracle ERP Cloud

To access the Oracle ERP Cloud instance from Oracle Integration, you’ll require a separate user account on Oracle ERP Cloud.

Log in to your Oracle ERP Cloud instance as an Administrator and perform the following tasks.

  1. Create a user account for Oracle Integration. Make a note of the user name and password you set for the account. You’ll use the credentials of this user account to connect to Oracle ERP Cloud from Oracle Integration.

  2. Assign the following roles to the user account. For more information on these roles, see Assign Required Roles to an Integration User.

    • Integration Specialist

    • Oracle ERP Cloud-specific data access to the integration user

Configure Shopify

To configure Shopify, see Prerequisites for Creating a Connection.

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 ERP Cloud Connection

  1. On the Configuration Editor page, select Oracle ERP Cloud Connection.

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

  3. In the Connection Properties section, enter the Oracle ERP Cloud host name. For example: https://your_domain_name.fa.DC.oraclecloud.com.

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

  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.

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.

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 integrations have been submitted for activation. Refresh the page to view the updated status of the integrations.

  2. Run the recipe.
    To run the recipe, you must perform the following tasks in the Oracle ERP Cloud instance.

    1. On the home page, click Menu Menu icon.

    2. From the list, select Product Management, then click Product Information Management.

    3. On the Product Information Management page, click Tasks, then Create Item.

    4. On the Create Item page, select the required organization and item templates, and click OK.

    5. On the Item Details page, enter all the mandatory information for the item, like name, description, and so on.

      1. On the Overview tab, enter the unit of measure.

      2. On the Specifications tab, enter the pricing details.

      3. On the Attachments tab, add an attachment to the item record.

      4. Click Save.

    You’ve now created an item record in Oracle ERP Cloud and triggered the recipe.

  3. Monitor the execution of the 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 product record in Shopify.

  4. Log in to your Shopify instance and check for the new product created.

    1. On the home page, select your Shopify store, for example, orcl-shop-connector-dev-store.

    2. On the store page, click Products on the left navigation pane.
      The list of products is displayed, which contains the corresponding product record for the item created in Oracle ERP Cloud.

Related Documentation