Configure Shopify Order Data Imports

When you have the Shopify Connector configured it can be used to import your Shopify order data into Bronto.

About this task

Importing Shopify order data into Bronto will allow you to see RFM metrics on this data and use the data for emails and for the Cart and Browse Recovery apps.

Note: If you want to test these settings before you start an import, make sure Test Mode is set to Yes.

The following Shopify order attributes are mapped automatically from Shopify to Bronto when you enable order data imports:

Table 1. Bronto and Shopify Mapped Order Fields
Bronto Order Field Shopify Field Description
Order Id order_id or order_number or name depending on setting See overview of Order ID, Order Number, and Order Name.
Email email The email address associated with an order.
Origin IP browser_ip The IP address of the customer at the time the order was made (Example: 111.111.104.210).
Ordered created_at The date and time the order was created in Shopify in ISO 8601 format.
Currency currency Currency code for the order (Example: USD).
Discount Amount total_discount The total amount of the discounts applied at checkout.
Subtotal subtotal_price The sum of the order's line-item prices after any line-item discount or cart discount has been deducted.
Grand Total total_price The total price of the order at checkout.
Tax Amount total_tax The sum of taxes applied to the order.
Shipping Tracking URL tracking_url The URL used to track the fulfillment (Example: http://track.com/startairmail.php?code=112345Z2345 ).
Shipping Date updated_at The date and time when the fulfillment was last modified in ISO 8601 format.
Shipping Details tracking_company The name of the tracking company (Example: UPS).
Shipping Amount The sum of all of the prices for each member in the shipping_lines array. The total cost of shipping.
Table 2. Bronto and Shopify Mapped Line Item Fields
Bronto Line Item Field Shopify Field Description
SKU item.variantId or item.sku The unique ID of the item. If there is a variant, it will be the variantId.
Name item.title Title of the line item. Defaults to the product's title.
Quantity quantity The quantity of the line item.
Unit Price price The price of the line item's variant.
Sale Price price The discount price of the line item.
Total Price line_price The combined price of all the items in the line_item if set. Or, the value of price * quantity.
Description body_html The Description field in Shopify, which stored in HTML (Example: <p>This is an amazing bike.</p>. This field is only available when you have enabled product data imports in the Shopify Connector.
Image URL image_url The product image for a variant or the parent image. This field is only available when you have enabled product data imports in the Shopify Connector.
Product Category product_type The category of a product. This field is only available when you have enabled product data imports in the Shopify Connector.
Product URL product_url The product URL. For variants, the variant identifier will be appended to the URL string (Example: /products/hat?variant=123456"). This field is only available when you have enabled product data imports in the Shopify Connector.

Procedure

  1. Go to Settings > Integrations > Connector.
  2. Locate the connector you want to work with and click its Edit link.
  3. Click Orders.
  4. Set Enable Connection to Yes.
  5. Select whether you want imported Shopify orders to have a Pending or Processed status in the Assign this Status in Bronto list.
  6. Select the Shopify order statuses you want used to determine that an order should be imported from the Import Orders with Status list.

    An order status can be removed from the list by clicking the X icon on a status.

  7. Select the Shopify order statuses you want used to determine that an order should be deleted from Bronto from the Delete Orders with Status list.

    You might want to remove an order from Bronto in order to clear up your RFM statistics. An order status can be removed from the list by clicking the X icon on a status.

  8. In the Map Order Fields section, select what fields to map to the Bronto order fields by selecting values in the Shopify Field lists.
    The default for Order ID is the Shopify Order Number.
    OptionDescription
    Order Number Example: 1001. Order Number is a unique numeric identifier for the order that is used by the shop owner and customer. This is different from the Order ID property, which is also a unique numeric identifier for the order, but is generally much longer and only used by programmers working with the API.
    Order Name Example: #1001. Order Name is the Order Number preceded by a pound symbol. It is used by shop owners who prefer that their order identifiers do not begin with a number.
    Order ID Example: 380770159904. The API identifier for the order.
    You can map anything to Other, for example, SKU.
  9. If you want to map a Shopify order property to a contact field:

    This will import the most recent order property value provided for each contact.

    1. Click Create New.
    2. Click Last Order Property To Contact Field Mapping.
    3. Select the Shopify value from the Order Property list.
    4. Select the Bronto contact field from the Contact Field list.

      If you need to add a new Bronto contact field, select Create New Field in Bronto from the list and use the pop up to create the new contact field. Then make sure this new field is selected in the list.

    5. Click Save.

    You can repeat this set of steps as many times as necessary to map all of the relevant Shopify order properties.

  10. Optional: Include the Source field in your order data. The Shopify order property that maps to the Source field is labeled source_name.
    The following chart shows how the Shopify Connector maps source_name values onto the Source field:
    Table 3. Bronto and Shopify Source Field Mapping
    Shopify source_name Property Bronto Source Field
    web WEBSITE
    pos INSTORE_POS
    iphone CUSTOM1
    android CUSTOM1
    custom CUSTOM2
    null null
    Any other value not listed in this chart CUSTOM3
  11. Optional: If you want to import Shopify order metafields:

    All of the information you need to supply about the metafield can be found in Shopify.

    1. Click the Create New button.
    2. Click Last Order Metafield to Contact Field Mapping.
    3. Enter the Shopify order metafield in the Key box.

      The key is the identifier for a metafield.

    4. Enter the in the Namespace box.

      The namespace functions as a container for a set of metafields which help to distinguish between metadata that you created and metadata created by others with a similar namespace.

    5. Select whether the metafield is a String or Integer from the Value Type list.
    6. Select the Bronto contact field from the Contact Field list.

      If you need to add a new Bronto contact field, select Create New Field in Bronto from the list and use the pop up to create the new contact field. Then make sure this new field is selected in the list.

    7. Click Save.

    You can repeat this set of steps as many times as necessary to map all of the relevant Shopify order metafields.

  12. Click Save Changes, when you have finished configuration for all of the import settings on the Orders page.
    Note: If you want to test these settings before you start an import, go set Test Mode to Yes.