Dev GuideAPI Reference
Dev GuideAPI ReferenceUser GuideLegal TermsGitHubNuGetDev CommunitySubmit a ticketLog In

Import data from Optimizely Commerce Connect 13 or 14

Import your customer list, product catalog, and order data from Optimizely Commerce Connect 13 into Optimizely Data Platform (ODP).

📘

Note

This integration imports data from Commerce Connect 13 or 14 into Optimizely Data Platform (ODP).

This app is in the ODP App Directory and is an older approach. For a more stable integration depending on your version of Commerce Connect, use one of the following:

With this integration, import your existing customer list, product catalog, and order data from your Optimizely Commerce Connect account into ODP continuously.

Integrating Optimizely Commerce Connect has the following values and benefits:

  • Unify your data across multiple sources and gain access to comprehensive, persistent customer profiles. ODP combines online and offline, historical and real-time customer data to get a complete view of your customers.
  • Leverage important analytics, enhanced by AI-driven segmentation, to understand how your organization performs against its goals, including customer behavior and engagement.
  • See the complete customer journey and understand how your various channels are performing.
  • Enrich your customer understanding and segmentation with predictive insights, including Time to Next Order, Likelihood to Purchase, and Winback Zone.
  • Refine your segmentation strategy based on your customers’ on-site and buying behaviors through ODP’s data science-driven insights.
  • Use customer data to personalize messages, content and recommendations, and create relevance at every customer interaction.
  • If you have multiple Optimizely Commerce Connect markets, you can select specific markets to import to ODP. This way, you can split your market data between various ODP accounts.

    📘

    Note

    For markets support, you must have version 6.3.0 or later of the Commerce Connect Service API.

Requirements

  • You must have an existing Optimizely Commerce Connect storefront with the Service API installed.
  • If you have multiple sites to integrate into ODP, you must request an ODP account for each site.
  • Before installing the Optimizely Commerce Connect app in ODP, you must get the Optimizely Service API NuGet package. If you are using .NET 5.0 or .NET 6.0, use this NuGet package. For information on installing and configuring the Service API, see the Optimizely Commerce Connect developer documentation.
  • You must have Commerce Connect 13 or 14.

Configure the integration

Step 1. Authorize connection in ODP

  1. In ODP, go to App Directory > Optimizely Commerce Cloud.
  2. Click Install App.
  3. On the Settings tab, complete the following fields:
    • Site URL – Enter the URL for your ecommerce site.
    • Authentication Type – Select your preferred authentication type. Service API is the default. However, if you use the Content Delivery API, select Delivery API.

      📘

      Delivery API

      If you select Delivery API, the Client ID field displays. Enter Default into this field.

    • Username – Enter your Optimizely Commerce Connect username.
    • Password – Enter your Optimizely Commerce Connect password.
  4. Click Authorize.

Step 2. Configure data imports

  1. Expand the Imports section.
  2. Choose which objects to manage through the integration. ODP enables imports by default.
  3. Click Import.

📘

Note

You can track the progress of the data imports using the Activity Log.

Step 3. Configure on-site tracking

To track Optimizely Commerce Connect events on your site, you must add ODP’s JavaScript tag to your site. If you want to track other events including:

  • Product detail viewed
  • Checkout started
  • Checkout completed
  • Add to cart
  • Add to wishlist
  • Remove from cart
  • Remove from wishlist

See Web SDK events.

Commerce Connect and ODP fields

Each row in the table below shows a field from Optimizely Commerce Connect used in this integration and the corresponding field in ODP.

Optimizely Commerce Connect fieldODP fieldField type
Contact.PrimaryKeyIdopticommerce_idCustomers
Contact.EmailemailCustomers
Contact.FirstNamefirst_nameCustomers
Contact.LastNamelast_nameCustomers
Contact.RegistrationSourceopticommerce_sourceCustomers
OrderForm.OrderNumberorder_idOrders
OrderForm.TotaltotalOrders
OrderForm.SubTotalsubtotalOrders
OrderForm.TaxTotaltaxOrders
OrderForm.ShippingTotalshippingOrders
OrderForm.Discounts.DiscountNamecoupon_codeOrders
OrderForm.LineItem.Codeproduct_idEvents
OrderForm.LineItem.DiscountedPricepriceEvents
OrderForm.LineItem.QuantityquantityEvents
OrderForm.LineItem.ExtendedPricesubtotalEvents
Entry.Codeproduct_idProducts
Entry.NamenameProducts
Entry.Assets.Titleimage_urlProducts
EntryRelation.ParentEntryCodeparent_product_idProducts