Multi-supplier Shopify: picking a winner for each SKU

Most Shopify apps assume one SKU equals one supplier. If you run a dropship or wholesale store, you know that is wishful thinking. Acme has the widget. Northside has the same widget. Continental had it until six months ago and is now permanently out. Shopify's inventory fields can hold exactly one number, so the question becomes: whose number?

The default — "most recent" — is almost always wrong

Most inventory sync tools overwrite the field every time they see a new number. Supplier A sends a weekly update Monday (42 on hand). Supplier B sends Tuesday (0 on hand). By Wednesday your product page says 0, even though Supplier A has 42 ready to ship.

The real question is not "who sent the latest number." It is "who are you going to buy from when a customer orders this."

Pick a preferred supplier per SKU

The cleanest approach: mark one supplier as preferred for each SKU. Stockpost writes that supplier's number to your main metafield. Other suppliers' numbers are tracked but do not overwrite it.

This gives you a truthful product page — showing the supplier you would actually buy from — and a complete audit trail if someone asks "why is this product showing in stock when Acme is at zero?"

When your preferred supplier is out

What should happen when your preferred supplier runs out? Three options: fall back silently to the next supplier, surface both numbers on the product page so the shopper can see the fallback, or switch preferred supplier manually in the admin.

Stockpost shows both numbers — preferred on-hand and backup with-supplier — as two pills on the product page. Customers see clearly where stock is coming from and when they can expect it.

The shared-inventory trap

Two suppliers each claiming they have 50 of the same thing does not mean you have 100 to sell. They are probably both drawing from the same manufacturer or regional warehouse.

Treat supplier stock as "who can ship it," not "how many exist." Your reorder math should be per preferred supplier, with the backup as a resilience signal — not an additive.

Keep stale signals visible, not silent

A supplier that stopped reporting three months ago should not silently drop off the page. You want to see "Continental: 0, stale (97 days)" — not nothing. Someone on the buying team has to decide whether to onboard a replacement or chase Continental for updates.

The worst outcome is a supplier who quietly stops sending files and whose last number stays in your metafield forever. Stockpost dims rows older than 30 days so staleness is a visible state, not a hidden one.

Stockpost does this end-to-end: supplier email in, live supplier stock on your Shopify products. 14-day free trial, $39/month per store.