Import Shopify Historical Data

The Shopify Connector starts importing contact and/or order data from when the connector is enabled, but sometimes you may want to import Shopify data that is older than this.

About this task

You can use the Historical Imports section on the Advanced tab to import older data into Bronto.

Note: If you set up your Shopify integration before July 2018 and want to import order data that is older than 60 days, you need to refresh Shopify app permissions so that Bronto can access this data. On the Connector dashboard, click Sync. When you see the option to Refresh Shopify Permissions?, click Yes.

Procedure

  1. Go to Settings > Integrations > Connector.
  2. Locate the connector you want to work with and click its Edit link.
  3. Click Advanced.
  4. Scroll to the Historical Import section.
  5. Select whether you want to import Contact or Order data from the Type list.
  6. If you want to import all records since a particular contact or order, enter the unique ID in the Since ID box.
  7. If you want to import contacts/orders based on creation date:
    1. Click in the Created After box and enter or select a date.
    2. Click in the Created Before box and enter or select a date.
  8. If you want to import contacts/orders based on the last updated date:
    1. Click in the Updated After box and enter or select a date.
    2. Click in the Updated Before box and enter or select a date.
  9. Click Execute to start the import.
    After the import completes, go to the Execution Results page and click View Results to see the details of the import. Some of the records in this table might be marked as Skipped, which means they were not imported. A historical import uses the same import validation rules as a normal import but, depending on what you have configured in Connector, might handle a number of different types of transformations. This means a historical import might attempt to import more events than just the order itself, which causes these records/events to be skipped. Reasons a record might be skipped include:
    • Coupon are scanned to import redemptions. When there are no redemptions the transform is skipped.
    • Order must meet import / delete state. When an order is "out of state" the transform is skipped.
    • Metafields are gleaned. When an order doesn't have metafields, or the metafields aren't mapped the transform is skipped