HELP CENTRE

Map your feed’s columns

Each supplier names its columns its own way. Mapping tells invtri which column holds the EAN, the cost, the stock and the rest. You map the columns once in the app, and invtri reads the feed the same way at every update.

What to map

invtri uses the values you map for pricing, stock, matching and listings. Column names vary between suppliers: one might call its stock column Qty and its cost column Cost.

What invtri uses each value for
Value in your feedWhat invtri uses it for
SKUMatching your imported listings to the feed, and spotting products that leave it
EANMatching products to marketplace catalogues by EAN/GTIN, with UPC converted automatically
Supplier costThe starting point for your sell price on each channel
StockThe stock your channels show, through the supplier’s Stock table, whose top row works as a cap
Title, description and imagesYour listings’ content, as your supplier provides it

Why the EAN matters

On Amazon and OnBuy, invtri matches your products to the marketplace’s catalogue by EAN. On Mirakl marketplaces, products are listed by EAN.

So if your supplier’s file has an EAN column, map it, and check it is filled in for the products you want to sell on those channels.

Map a supplier’s columns

  1. Add the supplier first

    Connect the supplier’s files by FTP, SFTP or a web link: see Add a supplier feed.

  2. Match each value to a column

    Tell invtri which column in the supplier’s file holds each value, whether everything comes in one file or in separate catalogue, stock and price files.

  3. Run a first update

    Press Run now to start an update. Then check that costs, stock and titles look right in invtri.

  4. Leave the rest to the schedule

    From then on, invtri reads the feed with the same mapping, on the schedule you set for that supplier.

Questions

Do I map the columns again at every update?

No. You map the columns once in the app.

My supplier sends UPCs, not EANs. Will that work?

Yes. Products are matched by EAN/GTIN, with UPC converted automatically.

Do I need to map columns for invtri Supply?

No. When you connect invtri Supply, invtri sets up the supplier, the column mapping and the updates for you.

Still stuck?

Licence holders can email [email protected]. We reply within 1 to 2 business days.