Feed Mixer: Joining Additional Data Sources

Feed Mixer lets you enrich your records by joining additional columns from an external data source - a live CSV URL or an uploaded file - using a shared ID column.

When to use Feed Mixer

Use it when your primary project data is missing columns you need in the feed, but those columns exist in a separate file.

Example: your scraped product data has title, price, and URL but you need to add GTIN and brand from a supplier CSV. If both datasets share a SKU column, Feed Mixer can join them automatically.

Setting up Feed Mixer

Feed Mixer is configured on the Data Sources tab of your project.

1. Set the Primary ID column

This is the column in your project's own data that uniquely identifies each record - typically SKU, product ID, or similar. Ducted will use this to match records against the additional source.

2. Add a data source

Click + Add Source and choose:

• URL feed - enter the URL of a CSV feed; Ducted loads the columns so you can pick the matching ID column
• CSV upload - upload a file; columns are detected automatically

Set the ID column for the source - the column that matches the primary ID column.

3. Fetch & Merge

Click Fetch & Merge to join the data. Ducted does a LEFT JOIN: every primary record is kept, and matching columns from the source are added. Non-matching records simply have empty values for the mixer columns.

Using merged columns in feeds

Once merged, all columns from the additional source appear in the Feed Editor column picker under a Mixer group. Add them to your mapping like any other column.

The Raw Feed is not modified - mixer columns only appear in custom feeds where you explicitly add them.

Column naming collisions

If a mixer source has a column name that already exists in the primary data, the primary data always wins. The mixer column is still accessible, renamed to source_label__column_name.

Keeping data fresh

Mixer data is not refreshed automatically. Click Fetch & Merge again whenever the source data changes.