How to Choose Supplier Price and Stock Priority
Set clear rules for which supplier wins when multiple feeds list the same SKU. Learn the tradeoffs between lowest price, highest stock, and explicit priority ordering.
The selection rules
The consolidator offers five ways to decide which supplier wins when multiple feeds contain the same SKU:
| Rule | When to use | | --- | --- | | Priority | Your primary supplier should always win, with others as backup | | Lowest price | You want the cheapest unit for every item | | Highest stock | You want the supplier with the most inventory | | First | Supplier order in your upload determines the winner | | Last | The last supplier in your upload order wins |
Priority: explicit supplier ordering
Reorder suppliers to set their priority. The first supplier in the list always wins ties unless a different rule is selected.
Price vs. stock tradeoffs
Lowest-price selection can drain your primary supplier's inventory faster, leaving lower-priority suppliers at risk of overselling. Highest-stock selection can lead to higher costs if your cheapest supplier has less inventory. Choose based on your business's fulfillment strategy.
Conflict reporting
Every time two suppliers disagree on price or quantity for the same SKU, the tool records a conflict row. Open the conflict report alongside the consolidated feed to review these decisions.
Consolidate supplier feedsSee the transformation
Two tables meet on one exact lookup key.
Add matching customer details to each order while keeping missing or repeated matches visible.
Need to do this now?
Consolidate supplier feedsRelated tools
Open the tool this guide is about, or explore a related one.
- Compare CSV files online freeCompare two CSV files and review added, removed, and changed rows directly in your browser.
- Join CSV files online freeJoin two CSV files on matching key columns, choose inner, left, or full results, and control duplicate lookup keys without uploading your data.
- Remove duplicate CSV rows online freeChoose the columns that define a duplicate, preview the cleanup, and download both the cleaned CSV and removed rows.
- CSV column mapper and renamerRename, reorder, and remove CSV columns before importing data into a CRM, store, database, or accounting system — without uploading your file.