How to map separate inventory and pricing files in Sync?

TB Sync · vendors · Last updated October 13, 2026 · Version 1

This process works in apps: TB Sync

This article will teach you how to match two vendor files by a phrase in the file name, map each file on its own, and keep quantity when a price file drops.

Some distributors send quantity in one file and cost in another (for example an ATD inventory file plus a pricing file). On the vendor Details tab, How this vendor sends inventory can stay on One file, or switch to Two files. Each row has a match phrase such as inventory or price. Sync uses that phrase against the original file name, ignoring dates and upload timestamps. The Mapping tab then shows Mapping for so you map Inventory fields (part number and qty) separately from Pricing fields (part number and cost). A pricing file never zeroes quantity, even if inventory sync mode is Full replace. Vendor locations (optional) let one inventory file carry qty per warehouse; B2B dealers still only see distribution center names, never the supplier location names.

Feed files card set to separate inventory and pricing files, with Mapping for listing Inventory mapped and Pricing needs mapping.

Steps

Open the vendor in Sync → Vendors and stay on Details. Under How this vendor sends inventory, choose Two files (inventory file + pricing file).
On the Inventory row, keep Contains (or Starts with) and type the stable phrase from the file name, such as inventory. Confirm Matches lists a recent upload. Repeat for Pricing with a phrase such as price.
If a phrase matches nothing, or both rows match the same file, change the phrases until each file hits only one row. Unmatched files stay Unassigned on the Files tab — use Assign as or Map this file.
Open Field Mapping. Under Preview & Header Selection, click the row that contains the column names (marked HEADERS) for that file. Use Mapping for to pick Inventory, map part number and quantity (and specs if present), then save. Switch Mapping for to Pricing, click that file’s header row the same way, and map part number and cost. FET and MSRP are optional. The part-number key must match between the two files.
Optional: under Quantity, choose A quantity column per location. On Field Mapping, use + Location and pick each quantity column header (for example QTY_DALLAS). The header becomes the location name unless you rename it. Those locations appear on Details. Quantity on the item is the sum of those columns.
The vendor becomes Active only after every feed file is mapped. Search a known part in Inventory and confirm qty comes from the inventory file and cost from the pricing file. On the vendor connection, set each vendor location to a distribution center and save. That updates Organization Settings → Distribution Centers and B2B Settings. Dealers see the center name only.

Conclusion & best practices

Leave Feed files on One file when the distributor already sends qty and cost together — existing vendors keep working that way. Split mode is for two files with different jobs. Never process a price-only file as the full inventory feed: Full replace would wipe quantity. If a mapping dropdown shows a part number or a price, the preview header row was clicked — see How to change the column header row on a vendor file or catalog import?. Keep vendor location names staff-only; B2B stock lines use distribution centers. Related: How to match a vendor file by part number only in Sync? and How to configure B2B Settings and show inventory as 100+?.