Tracking the same item across multiple vendors

Almost no kitchen buys everything from one distributor. You have a broadline supplier, a produce specialist, a restaurant-supply store for the gaps, and a cash-and-carry for emergencies. The same ingredient shows up on two or three of those invoices at two or three different prices. Your cost guide should hold all of them.

One item, several priced lines

Resist the urge to create “Diced Tomatoes (Sysco)” and “Diced Tomatoes (US Foods)” as separate items. That splits every recipe match and doubles your upkeep. Instead, keep one item — “Diced Tomatoes, 6/#10” — with a price line per vendor:

• $38.13 / case / Sysco
• $36.90 / case / US Foods
• $41.00 / case / Restaurant Depot

Same unit, three vendors. Now the item has a real market picture attached to it, and every recipe that uses tomatoes still matches one item.

Which price does a recipe use?

By default, recipe costing uses the cheapest compatible price among the vendors. That gives you a “best case” food cost — what the dish costs if you always buy optimally. It's a useful baseline, but it's optimistic, because in real life you buy from whoever delivers Tuesday.

When you want costing to reflect reality instead, pin a preferred vendor on the item. That tells the tool “cost this ingredient at this supplier's price, even if another line is cheaper.” Pin the vendor you actually order from for that item, and your recipe costs match your invoices. Leave it unpinned for items where you genuinely shop around each week.

A pin is a deliberate choice and it survives ordinary edits — changing a price or fixing a typo in the item name won't clear it. You set and clear it explicitly.

Reading a vendor comparison

With multiple vendors on an item, the tool can show them side by side, normalized to a common unit so the comparison is apples-to-apples even when one vendor quotes by the case and another by the pound. Two things to look for:

• The spread. A 3% spread is noise — not worth splitting an order over. A 15% spread on something you buy every week is a standing line item of savings.
• Consistency over time. One cheap quote is a promotion. A vendor who is consistently 8% under on your top ten items is a relationship worth building.

When to switch, and when not to

The cheapest price on a spreadsheet is not always the cheapest ingredient. Before you move an order:

• Check the spec. A lower price on “diced tomatoes” that turns out to be a lighter drained weight or a thinner pack isn't a saving.
• Check the delivery cost. Adding a second delivery day, or dropping below a free-freight minimum on your main supplier, can erase the difference.
• Check the labor. Splitting one order into three to chase per-item savings costs someone an hour of receiving and reconciliation.

The point of tracking every vendor isn't to always buy the cheapest. It's to make the trade-off visible — so “we stay with our broadline supplier for convenience” is a choice you made with the number in front of you, not a habit.

Keeping vendor prices current

Vendor lines go stale at different rates. Your primary supplier's prices you'll update constantly from invoices. A backup vendor you check quarterly — ask for a current quote on your top 20 items and update those lines in one sitting. If a vendor line is more than a few months old, treat it as a rough reference, not a number to switch orders over.

Next: turning a cost guide into recipe costs, where these per-vendor prices start doing real work.