Join a Stock or Supplier Feed
Your current stock, cost or margin often lives in a separate warehouse or supplier feed. Join it to your product feed with a lookup so stock and prices refresh on every import.
Updated November 6, 2026
Your current stock and your supplier's prices usually sit outside your main product feed, in a warehouse export, an ERP
feed or a supplier price list. Join that feed in with a lookup and they refresh on every import.
Stale stock means paying to advertise sold-out products, and a wrong price can get products disapproved. Copying numbers
over by hand doesn't last, because the next import overwrites them.
How a lookup works#
A lookup takes a value your main feed already has, such as a barcode or your product ID, finds the matching row in
the second feed, and returns one column from that row into a field of yours. You add the second feed once as an
Auxiliary feed, then point a field at it. The dialog is covered step by step in
Joining another feed with a lookup.
Keep stock current from a warehouse feed#
Say your warehouse exports a feed keyed by GTIN, with a stock count for each product.
- On the catalog's Data sources tab, add the warehouse feed as an Auxiliary feed: choose Feed URL… and paste
its address.
- On the Mapping tab, open the value editor for Stock count and add a lookup against the warehouse feed.
- Match your product's GTIN against the warehouse feed's barcode column, and set that pair's matching mode to
Barcode.
- Return the warehouse feed's stock column, and watch the live chip to confirm your products are finding their row.
matches 48 / 50 sampled is a good sign.
- Publish the catalog.
Stock count is the field to fill because a channel's built-in Availability rule goes by it: a product with a count of
0 goes out as out of stock. A product with no stock information also counts as 0, so unless In stock is mapped too, a
product the lookup can't match goes out as out of stock. If your main feed carries a stock count, add that column as a
fallback behind the lookup.
If the warehouse feed carries a status rather than a count, put the lookup on In stock instead, and add a Map
values step that turns its wording into yes and no. See Steps.
Either way, keep a raw number out of the Availability field: 42 isn't a valid availability value. More on how these
fields work together is in Product availability and stock.
Pull the current price from a supplier feed#
A supplier price list works the same way. Add the supplier feed as an Auxiliary feed, add a lookup on your Price
field, match on the key both feeds share, and return the supplier's price column.
You can return any other column the supplier carries, such as cost, RRP or lead time, into a
custom attribute for reporting or campaign segmentation.
Which key to match on#
- A GTIN, EAN or UPC: use Barcode mode.
- A SKU or your own product ID: use Smart, the default, or Exact when both feeds format the value
identically.
When the feeds share no single reliable key, you can match on two columns together, such as brand and MPN, or try one key
and fall back to another. Joining another feed with a lookup shows how.
Or ask Aimée#
Tell Aimée what you want, for example "Pull stock from my warehouse feed, matching on GTIN." She can add the auxiliary
feed, build the lookup, test that it matches before saving, and publish once you approve.
FAQ#
The lookup only matches some of my products. Why?
Your key columns probably don't line up, or you're matching barcodes without Barcode mode. See
Joining another feed with a lookup, and if stock or prices are still off after publishing,
Prices or stock look wrong.
Do I need to re-import the warehouse feed on a schedule?
No. Renable fetches your auxiliary feeds with every import of your main feed, so the join is as current as your last
import. An uploaded file is the exception: it changes only when you replace it. If an auxiliary feed a lookup uses can't
be read, the whole import stops with an error, and your catalog stays as it was until an import succeeds.