Syncing Catalog with Smart Ingest

You can keep your Iterable catalogs up-to-date with Smart Ingest. Sync your catalog items from your data source to Iterable with a catalog sync.

When you set up a catalog sync, you can choose how to match records from your data model to catalog items in Iterable. You can also map fields from your data model to catalog fields in Iterable, and choose how to handle records that leave your data model's query results. Remember that your data model should meet the requirements for syncing catalog items.

# In this article

# Data model requirements

To set up a catalog sync, your data model should contain:

• A unique identifier for your catalog items that matches itemId in Iterable.
• Any columns you wish to sync as data fields for each catalog item.

Make sure your data model contains columns for each of the fields you intend to update in Iterable.

# Record matching for catalog items

To match rows from your model to catalog items, you need to select the model column that contains values that match the Product ID (itemId) field in Iterable.

The Product ID (itemId) field value must contain only alphanumeric characters and dashes, and has a maximum length of 255 characters.

# Field mapping

Once you've selected a catalog, Smart Ingest automatically pulls existing fields from your Iterable catalog for you to map data into.

Use field mapping to sync additional catalog fields.

# Delete behavior

You have these options for how to treat records that leave your model's query results: