Configure Shopify Product Data Imports

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

About this task

Shopify stores product data by storing parent products with variants, where Bronto stores each product variant as its own product. There are two ways this impacts product data imports. First, when a parent product in Shopify only has a single variant Bronto will still import both a parent and variant for that product and will fill in all parent product fields with the sole variant's data.

Secondly, sometimes Shopify stores title data for a variant in the parent product which can lead to incomplete product title field data in Bronto. To prevent this you will need to indicate how you want to populate the title product field in Bronto for products by selecting the Shopify value to use for variant titles from the Variant Title Format and indicating if you want to append the Shopify parent product title to the variant title as you import product data. The combination of these two options determine what is stored for a product title in Bronto. For example, the title for a parent product in Shopify might be Shirt and the title for a variant is Red. If you set

  • Variant Title Format to Shopify Original Value and Add Parent Title To Variant to No, the Bronto product title for the product (variant) will be Red.
  • Variant Title Format to Shopify Original Value and Add Parent Title To Variant to Yes, the Bronto product title for the product (variant) will be Shirt - Red.
  • Variant Title Format to Parent Title and Add Parent Title To Variant to No, the Bronto product title for the product (variant) will be Shirt.

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

Table 1. Bronto and Shopify Mapped Fields
Bronto Product Field Shopify Field Description
Product ID id The unique API ID of the parent product or the unique API ID of the variant (Example: 7256427462716). See note above for how Bronto's treatment of parents and children is different than how Shopify approaches variants.
Title title Includes the name of the product. See note above to configure how the variant title displays.
Description body_html The Description field in Shopify, which stored in HTML (Example: <p>This is an amazing bike.</p>.
Image URL image_url The product image for a variant or the parent image.
Parent Product ID product_id The parent Product ID for a variant product.
Product Category product_type The category of a product.
Product URL product_url The product URL. For variants, the variant identifier will be appended to the URL string (Example: /products/hat?variant=123456").
Quantity variant.inventory_quantity The number of remaining items (Example: 45). Quantity will only display on a parent product if there is only one variant.
Price variant.price or variant.compare_at_price
Note:

Bronto and Shopify handle price in a different way. In Shopify, the Compare at price is the full price for an item. When a Compare at price is set, the Shopify Price is the sale price of a product. In comparison, the Bronto Price for a product is the full price of an item and the Sale Price is the discounted price for a product on sale.

If a parent product has multiple variants then the variant_price is not imported for the parent product. When a parent product has a single variant, the variant_price for the variant is also used for the parent product.

The price of a product (Example: 35.99). When the Shopify Compare at price is blank, the Bronto Price is the Shopify Price. When the Compare at price is populated, the Bronto Price is the Compare at price value in Shopify.
Sale Price variant.price (not always populated)
Note:

If a parent product has multiple variants then the sale_price is not imported for the parent product. When a parent product has a single variant, the sale_price for the variant is also used for the parent product.

The discounted price of the variant (Example: 30.00). This will only have a value when the Shopify Compare at price is populated. When the Shopify Compare at price is populated, then the Shopify Price corresponds to the Bronto Sale Price for a product.

You can use the Create New button to map additional Shopify product attributes to Bronto product fields. Once enabled, you can see the mapped product fields by going to Tables > Products and clicking on View Product Fields. Product imports/updates will automatically run roughly every 15 minutes, but can also be run manually from the Advanced page.

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

Procedure

  1. Go to Settings > Integrations > Connector.
  2. Locate the connector you want to work with and click its Edit link.
  3. Click Products.
  4. Set Enable Connection to Yes.

    Once this is enabled, the product fields listed above are automatically imported.

  5. Select the Shopify product attribute you want to use to supply the variant title from the Variant Title Format list:

    This is what will be stored as a product's title in Bronto.

    • Shopify Original Value Uses the data found in the variant's title field.
    • Parent Title Uses the data found in the parent product title field.
    • Variant Option X Uses the data found in Shopify option selected. So if you select Option 1, then the variant's data stored for Option 1 in Shopify will be imported.
    • Option 1 / Option 2 / Option 3 Uses the data for all three options with each option separated by a / in Bronto's product title field.

  6. Indicate whether you want to Add Parent Title To Variant in a product's title in Bronto.

    When you select Yes the parent title followed by a - will be included before the rest of the title data in Bronto.

  7. When you have finished configuration for all of the import settings on the Products page, click Save Changes.
  8. Optional: If you want to map additional product fields:
    1. Click Create New.
    2. Select a Shopify product attribute from the Product Attribute list.
    3. Select the Bronto catalog field from the Catalog Field list. If you are creating a new catalog field, leave the selection as ** Catalog Field **.
    4. Click Save to save the new mapping.
    5. Repeat as necessary to map all of the relevant Shopify product attributes.
    6. Ensure that you complete Step 10.
  9. Optional: If you want to import Shopify product 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 Product Metafield to Catalog Field Mapping.
    3. Enter the Shopify product metafield in the Key box.

      The key is the identifier for a metafield.

    4. Enter information 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 product field from the Field list. If you are creating a new field, leave the selection as ** Catalog Field **.
    7. Click Save.
    8. Repeat as necessary to map all of the relevant Shopify product attributes.
    9. Ensure that you complete Step 10.
  10. Optional: If you have added any product attributes or product metafields, you need to manually update your Bronto product catalog:
    1. From the Shopify Configuration menu, select Advanced.
    2. Under Product Catalog, select:
      • Sync Catalog Field Mappings to kick off a manual import of the new product field mappings you made.
      • Sync Recently Updated Products to kick off a manual import of all of the mapped Shopify product attributes.
    3. Click Execute.
    4. Click Save Changes in the bottom-right corner.
    5. Navigate to Commerce > Products and Search Products to verify that you see your new Shopify field.
  11. Optional: If you have previously added any product attributes or product metafields and you want to manually update your Bronto product catalog:
    1. From the Shopify Configuration menu, select Advanced.
    2. Under Historical Import, select Product as the Type.
    3. Edit the date ranges as necessary.
    4. Click Execute.
    5. Click Save Changes in the bottom-right corner.