Guide Me On Products

Importing and maintaining a product catalog in Bronto allows you to take your email marketing strategy to the next level.

When your product data is in Bronto, it can be used to dynamically insert products into messages. This means that you won't need to remember to update an image, or a sales price, or any product data in your messages when these things change. As long as you keep your Bronto product catalog up-to-date, Bronto can insert the current data for a product field at the time a message is sent.

First, select whether you plan to import a delimited or XML file and clean up your file for import. Then configure Bronto's product import settings, import your product data into Bronto, and verify your import was successful. Finally, learn how to use product tags in your messages.

Prepare Delimited Product Data File for Import

Important: Skip this section if you are importing an XML product data feed file.

A delimited file is a document that contains rows of data where each data element is separated by a delimiter and each line represents a new item. You can use tabs, pipes, commas, colons, semi-colons or tildes as the delimiter in your delimited file. You must consistently use the same delimiter in the file. Whatever delimiter you use cannot be used within a field, unless the contents of the field is within quotation marks. For example, if you use a comma as your delimiter, you cannot use a comma to offset items in an attribute list unless the list is in quotation marks.

This two-minute video covers the common requirements for setting up your delimited file to import properly.

There is no limit to the number of attributes a product data feed may have, but only attributes that have been mapped to a Bronto field are imported. At a minimum, each product must have a Product ID and a Title. Each mapped attribute must validate against the rules for the Bronto field it is mapped to or it will not import successfully. For more information about field format and validation rules see Product Field Descriptions.

Prepare XML Product Data File for Import

Important: Skip this section if you are importing a delimited product data feed file.

This two-minute video covers the common requirements for setting up your XML file to import properly.

There is no limit to the number of attributes a product data feed may have, but only attributes that have been mapped to a Bronto field are imported. At a minimum, each product must have a Product ID and a Title. Each mapped attribute must validate against the rules for the Bronto field it is mapped to or it will not import successfully. For more information about field format and validation rules see Product Field Descriptions.

Configure Bronto to Properly Manage the Import

Before you can import product data feeds, you need to configure your feed settings on the Configure Import Feed page so Bronto knows how to properly handle your data feed file. Whether you are importing an XML or a delimited file, this guide will help you configure your import. This guide also helps you set up automatic daily imports, which we highly recommend.

Next you need to map the product fields in your file to product fields in Bronto. This video explains how to map fields, as well as how to create custom fields.

Need more information? See Product Field Descriptions for information about the default product fields that Bronto provides or Product Field Data Types for information about the data types you can use when setting up a custom field.

Import Your Product Catalog For The First Time

Bronto requires you to run a manual import the first time a product data feed is imported. This provides the opportunity to clean up any issues with your data feed file before imports are run automatically.

Verify Your Import

After your import completes, check to make sure all of your product data was imported properly. This quick guide shows you how to verify your product data in Bronto.

If your data wasn't imported successfully, you can use the Product Import Transaction Log to see what went wrong. Some common things to check for:
  • Are your fields mapped properly?
  • Are your delimiters or XML tags being used correctly?
  • Do you have any special characters in your product data that is breaking the import?
  • Did you forget to use quoted fields or indicate that you use quoted fields?

Use Product Tags To Include Products In Messages

Once your product catalog is in Bronto, you can use product tags to pull your imported product data into messages. This video shows how to include product data in messages designed using the email message editor.

If you don't use the email message editor, this topic explains how to manually add product tags to a message.