Automating consignment and vendor payouts on Shopify means three things working together: every order attributed to the vendor who supplied it, a commission calculation that survives refunds, and a payout run that produces a statement each vendor can check. Shopify does none of this natively — it records a vendor field on the product and stops there. This guide covers how to structure vendors and commission, why refunds are where most setups break, and what a payout record needs to contain.
What Shopify gives you, and what it does not
Shopify has a vendor field on every product. That is genuinely useful — it is the hook everything else hangs off — and it is where native support ends.
Shopify will not calculate what a vendor is owed, will not adjust for a refund, will not produce a statement, will not track what you have already paid, and will not show a vendor anything. Every one of those is left to you, which is why most consignment stores start in a spreadsheet.
The spreadsheet works. It works for about twenty vendors, or until the first month with a lot of refunds, whichever comes first.
Structuring vendors before anything else
Two decisions here shape everything downstream, and both are annoying to change later.
One vendor per product, or can a product have several? One is almost always right. A product supplied by two vendors is really two products with two SKUs. Splitting a single product's revenue between vendors creates reconciliation work at every stage and is rarely what the commercial arrangement actually says.
Does the vendor field match the vendor's legal identity? "Jane" is fine until you are producing a payment record and need "Jane Smith Ceramics Ltd" with a VAT number. Decide early whether the Shopify vendor field is a display name with a proper vendor record behind it, or the record itself.
Then there is the question of new products. Someone adds a listing and forgets to set the vendor, and it quietly earns nobody anything until a vendor notices a sale missing from their statement — which is an awkward conversation, because they are right and you cannot explain it. Automatic product-to-vendor matching, by tag or title pattern or collection, removes this class of error entirely, and it is worth setting up on day one rather than after the first complaint.
Commission: percentage, fixed, or per product
Three models, and most stores need more than one.
- Flat percentage per vendor. "Jane gets 60% of everything." Simplest to explain and to audit. The right default.
- Percentage per product or SKU. For vendors whose range spans very different margins — handmade pieces at 60%, their bought-in stock at 30%.
- Fixed amount per unit. Common in consignment for standardised items, and easier for vendors to predict than a percentage of a price that moves with discounts.
Then the question everyone skips until it bites: what is the percentage a percentage of?
Gross sale price, or after discounts? After shipping, or including it? Before or after tax? Before or after payment processing fees?
None of these has a universally right answer, and all of them need to be written down in the vendor agreement. The one that causes the most arguments is discounts: if you run a 20% store-wide sale, does the vendor absorb a share of it or do you? Both are defensible, and a vendor who discovers the answer on a statement rather than in an agreement will be unhappy either way.
Refunds, where most setups break
This is the part that breaks spreadsheets, and it is worth walking through concretely.
A customer buys a £100 item from Vendor A on 3 March. Commission is 60%, so the vendor earns £60. You pay out on 31 March. On 5 April the customer returns it and you refund £100.
You are now £60 down. The vendor has been paid for a sale that no longer exists. Your options are all uncomfortable: ask for the money back, absorb it, or deduct it from the next payout — which only works if there is a next payout.
Refund-aware commission tracking means the system knows that order was refunded and adjusts, rather than treating the refund as a separate event nobody connects to a payout. Three things worth getting right:
- Partial refunds. A £20 goodwill refund on a £100 order is not a cancelled sale. Commission should adjust proportionally, not vanish.
- Refunds after payout. The system should carry the adjustment into the next period rather than silently rewriting a statement the vendor has already seen.
- A holding period. Paying out weekly with a 30-day returns window guarantees this situation repeatedly. Paying 30 days in arrears mostly avoids it.
That last point is the single most effective fix available, and it costs nothing to implement. Vendors accept a delay far more readily than they accept a clawback.
Consignment, wholesale or marketplace?
These three get used interchangeably and they are different arrangements with different consequences, which is worth settling before you configure anything.
- Consignment. You hold stock you do not own and pay the vendor after it sells. No cash outlay, no inventory risk, and a payout obligation on every sale. Your margin is the commission.
- Wholesale. You buy the stock, own it, and sell it. Cash out up front and inventory risk on you, but no ongoing payout mechanics and the full margin is yours.
- Marketplace. The vendor holds and often ships their own stock; you provide the storefront and take a cut. Lowest risk, most operational complexity — fulfilment is distributed and returns are complicated.
The payout machinery described here applies to consignment and marketplace. Wholesale does not need it, because the transaction between you and the supplier already happened.
Many stores run two of these at once — consignment for local makers, wholesale for their bought-in range — which is fine, as long as the consignment products are cleanly identifiable. If a vendor supplies you on both terms, that is two vendor records, not one.
Payout cadence and thresholds
Three variables, and they interact.
Frequency. Monthly is the sensible default: it is enough volume to be worth processing, and it lines up with how most small vendors think about income. Weekly creates a lot of small transfers and a lot of refund adjustments. Quarterly is too slow for a vendor relying on the income.
Minimum threshold. A vendor who earned £4 this month probably should not trigger a bank transfer that costs you more than that. Carry small balances forward — and tell vendors the threshold exists, or the missing payment looks like an error.
Arrears. How long after the period closes do you pay? This is your returns buffer. Thirty days is common and mostly matches consumer returns windows.
Whatever you choose, publish it. "Paid monthly, 30 days in arrears, £25 minimum" answers most of the questions a vendor would otherwise email you, and the questions vendors ask are the real cost of running consignment at scale.
The statement
A payout without a statement is a number in a bank account that the vendor has to trust. A statement is what makes the arrangement auditable, and it is what stops the monthly email thread.
What it needs:
- Line-level orders — date, order number, product, quantity, sale value. A vendor should be able to match an entry to a sale they know happened.
- The commission rate applied to each line, not just the total. Rates change; a statement that hides which rate applied is unverifiable.
- Refunds and adjustments as their own lines, with the original order referenced. Never net them silently into the total.
- The period covered, explicitly, including the arrears offset.
- Carried balance, if anything was held back under the threshold.
Get this right and vendor support questions largely stop, because the answer is already in front of them.
Giving vendors a portal
A statement answers last month's question. A portal answers this month's, which is the one vendors actually ask: how am I doing right now?
A vendor logging in to see their own orders, running total and payout history removes the most common support load in consignment: the mid-month "how are my sales going" email. It also removes the temptation to give a vendor Shopify admin access, which is how vendors end up able to see each other's numbers, edit products that are not theirs, and view customer data they have no business seeing.
Scope a portal tightly: a vendor should see their own sales, their own earnings, their own payout history and their own products. Nothing about other vendors, nothing about customers beyond what is needed, and no ability to change prices.
Actually moving the money
Calculating what a vendor is owed and paying them are separate problems, and the second one is less automatable than merchants expect.
Most Shopify consignment setups calculate in the app and pay by bank transfer, PayPal or Wise, done by a human from a list. That is not a failure of tooling; moving money on someone's behalf is regulated, and an app that could do it automatically would need to be a payment institution.
What good tooling does instead is make the human step short and auditable:
- A payout run that produces one list of amounts on one date, rather than a per-vendor calculation each time.
- A record of what was marked paid, when, by whom, and against which period — so the next run starts from a known position.
- Payment details stored with the vendor, so nobody retypes an IBAN under time pressure.
Two operational points. Vendors paid across borders bear currency conversion and fees — say which side carries them, in writing. And once a payout is marked paid it should be immutable, with corrections handled as adjustments in the next period. A payout history that can be silently edited is not a record.
Reporting you can hand to an accountant
Consignment has a specific accounting shape: for goods you do not own, the money is not all yours. The gross passes through you and a defined share belongs to someone else.
Which means the report at the end of the year has to separate:
- Gross sales, by vendor.
- Your share — the actual revenue.
- The vendor share — a liability until paid, and an expense once paid.
- Refunds, against the period they belong to.
- Tax, which has its own treatment depending on whether you or the vendor is the seller of record.
That last one is worth raising with an accountant before the first payout rather than after the first tax year, because the answer changes how you should record everything else. It varies by jurisdiction and by how the agreement is written.
Practically: whatever tool you use should export this as CSV. A payout system that shows you numbers but will not hand them over in a form your accountant can work with has solved the easy half.
The point where the spreadsheet gives up
Spreadsheets do not fail all at once. They degrade, and the signs are recognisable.
- Refunds are adjusted by hand. The first symptom, and the one that actually costs money, because a missed adjustment is an overpayment you never notice.
- The payout run takes more than an hour. Not the arithmetic — the chasing, the checking, the one vendor whose rate changed mid-month.
- Vendors email to ask how they are doing. Each one is a few minutes of lookup, and the number scales with vendors, not sales.
- Nobody but one person can run it. The formulas have grown history and only their author understands the edge cases. This is the expensive one, and it shows up as a problem while that person is on holiday.
- A vendor disputes a number and you cannot reconstruct it. Because the sheet holds the current state, not how it got there.
Around twenty vendors is where most stores hit two or three of these at once. It is not a hard limit — plenty of stores run forty on a spreadsheet — but each one costs time every month, and they compound.
Setting it up
With Payvenda the sequence is:
- Add vendors with their real payment identities, not just display names.
- Set commission rules — flat per vendor to start, per product only where the arrangement genuinely differs.
- Decide what the percentage applies to and write it into the vendor agreement.
- Turn on automatic product-to-vendor linking so new listings cannot be orphaned.
- Set cadence and threshold — monthly, 30 days in arrears, with a minimum — and publish it.
- Run one payout period in parallel with your spreadsheet and reconcile the two before trusting either.
The free plan covers 5 vendors and 20 synced orders a month, which is enough to run that parallel period. The vendor portal and unlimited order sync are on the $40 plan; unlimited vendors and API access on the $80 plan.
Mistakes worth avoiding
- Paying out before the returns window closes. The clawback conversation is avoidable.
- Leaving the commission base undefined. Discounts, shipping and fees all need an answer in writing.
- Products with no vendor set. They earn nobody anything until someone complains.
- Netting refunds silently. A statement that does not show why the number moved is a statement nobody trusts.
- Shopify admin access instead of a portal. Vendors should not see each other's numbers or your customers.
- No CSV export. Your accountant will ask, and "it is in the dashboard" is not an answer.
Where to go next
If you have fewer than about ten vendors and few returns, a spreadsheet is genuinely fine and you should keep it. The point to automate is when refunds start needing manual adjustment, or when the monthly "how am I doing" emails take longer than the payout run itself.
You can see how Payvenda handles commission rules, refund-aware calculations and vendor portals, with a free plan for the first five vendors.
