Several suppliers, one Shopify SKU
Buy the same product from more than one supplier, each with its own code, price and pack size, and keep one product in Shopify with one first-in, first-out cost queue behind it.
Updated 19 September 2026
You sell one product. You buy it from two suppliers, because one is cheaper and the other is faster, or because the first ran out. Each supplier has its own code for it, its own price, and maybe its own carton size. In Shopify it is one product with one SKU, and that is how it should stay.
A spreadsheet handles this badly. It holds one cost per SKU, so the second supplier's price either overwrites the first or gets averaged into it, and the stock you still hold from the first supplier is suddenly costed at a price you never paid for it. Landara keeps one product and every supplier's real cost behind it.
Link each supplier's code to your SKU
A link says "when this supplier writes this code, they mean this Shopify SKU". Links are kept per supplier and code, so any number of suppliers can point at the same SKU:
| Supplier | Supplier's code | Your Shopify SKU | Pack |
|---|---|---|---|
| Brightstar | BS-OXY-01 | oxygen-board | × 1 |
| Saigon Artisan | SA-7700 | oxygen-board | × 6 |
You make links as you go: correct a code on a shipment and Landara offers to remember it. All of them are listed on COGS → Cost Layers → Supplier SKU links, where each row can be edited, including its supplier and its pack size. A link with no supplier applies to any supplier, which is right when you buy each product from one place; give it a supplier as soon as a second one uses a different code.
The next invoice from either supplier arrives with its lines already filed under your SKU.
One product, one cost queue
Every delivery becomes its own cost layer under your one Shopify SKU, at what that delivery actually cost, landed. Layers from every supplier sit in a single queue in the order the stock arrived, and each sale draws from the oldest stock first, whichever supplier it came from. That is first-in, first-out as the accounting standards define it: a cost flow, not a label on a physical box.
A labelled example with round numbers: you hold 20 boards from Brightstar at a landed $12. Saigon's delivery of 30 lands at $10. You sell 25.
- The first 20 sales cost $12 each, from the Brightstar layer.
- The next 5 cost $10 each, from the Saigon layer.
- Cost of goods sold is $290, and the 25 boards left are valued at $10 each.
A single cost per SKU would have costed all 25 sales at one blended or overwritten figure, and your stock value along with it.
Which supplier is it from?
Cost Layers shows each layer's supplier and the shipment it came from, and the search there finds layers by supplier. So "how much stock do I still hold from Saigon, and what did it cost" is one search, not a spreadsheet.
Things worth knowing
- Pack sizes are per supplier. Saigon can sell you cartons of 6 while Brightstar sells singles, and each is converted correctly.
- Two different products must not share a SKU in Shopify. Several suppliers for one SKU is fine; one SKU on two products is not, and Landara matches neither until each has its own. See Get your SKUs lined up.
- Suppliers' codes kept in Shopify. If you record supplier codes in Shopify's product fields, Landara can read them and build the links for you. That route holds one supplier name per product, so add the second supplier's links on the Supplier SKU links card.
