Joining Another Feed with a Lookup

Pull stock levels, supplier prices or extra attributes from a second feed into your catalog. A lookup matches a value in your feed to a column in the other feed and returns another column.

Updated November 6, 2026

Pull values from a second feed into your catalog with a lookup: stock levels from a warehouse feed, cost or margin from a supplier feed, or richer attributes from a secondary export. You add the second feed as an Auxiliary feed, then add a lookup that matches a value in your feed to a column in the other feed and returns another column.

A lookup is set wherever you set a field: a row on the Mapping tab or a Set field action in a rule. See Mapping your feed to catalog fields and Fixing your feed data with rules.

Step 1: Add the second feed as an auxiliary feed#

  1. Open the catalog and go to the Data sources tab.
  2. Click + Add auxiliary feed.
  3. Choose Feed URL… and paste the second feed's URL.

The same menu offers three other sources:

The feed's card has a download button, handy for checking which columns the feed carries before you match against it.

Step 2: Add the lookup to a field's value#

Open the value editor for the field you want to fill, such as Stock count, and add a lookup. For stock, fill Stock count or In stock rather than Availability: see Join a stock or supplier feed. A dialog titled Look up a value from another feed opens, or Look up from a mapping table when the source is a mapping table. Pick the source, say how to match, and choose which column to return.

Set the match pairs#

A match pair says this value in my feed equals this column in the other feed: your value on the left, a column of the auxiliary feed on the right, joined by equals.

One pair is enough when both feeds share a reliable key like a barcode. When no single column is unique, add another with + Match on another column, for example brand and MPN together. A row in the other feed has to satisfy every pair to count as a match.

Choose how each pair is matched#

  • Smart (the default) lines values up despite differences in casing and surrounding spaces.
  • Barcode is for GTIN, EAN or UPC. It treats 012345678905 and 12345678905 as the same code, which the other modes don't.
  • Exact requires the two values to be identical, character for character. Use it when you know both feeds format the value the same way.

Pick the column to return#

Choose the Return column. Its value is what gets written into your field when the lookup finds a match.

Check the match before you save#

As you build the lookup, a live chip such as matches 46 / 50 sampled shows how many of a sample of your products found a match in the other feed. A low number means your columns don't line up, or you need Barcode mode instead of Smart.

When the match looks right, choose Insert lookup, then Publish the catalog to start using it.

When a product has no match#

A product with no match gets no value, and the field moves on to its next fallback in the value editor.

To try a second way of matching, add another lookup as the fallback. Build one lookup that matches on GTIN, then add a second as its fallback that matches on brand and MPN. Products with a good barcode resolve on the first lookup, and the rest fall through to the second.

How auxiliary feeds stay current#

Renable fetches your auxiliary feeds at import time, so the join runs against the data both feeds served at the last import. An uploaded file or a mapping table changes only when you change it.

If an auxiliary feed that a lookup uses can't be read, or holds more than 250,000 rows, the whole import stops with an error. No products are removed, and your catalog stays as it was until an import succeeds.

Or ask Aimée#

Tell Aimée what you want in the chat, such as "pull stock levels from my supplier feed", and she can add the feed, build the lookup and test that it matches, then publish once you approve.

Where to go next#