All posts

When a spreadsheet stops being enough for your creator program

A spreadsheet runs a creator program well until three questions get slow to answer: what each creator is owed, what product each one already has, and which of them actually sell. When answering any of those means an afternoon of cross-checking, the sheet is costing more time than an app would.

A sheet with names, codes, rates and a running total is a fine start. It costs nothing, everyone can use it, and with five creators you can hold most of it in your head anyway.

Working out a balance takes an afternoon

A creator asks what they've earned this month, and to answer you check Shopify orders against the sheet and the sheet against your PayPal history. Then a refund comes in and you can't tell whether you already paid on that order.

Say you have 25 creators and each balance takes ten minutes to work out properly. That's over four hours every pay day before you've sent a cent, or more than a full working day each month if you pay twice, and every one of those balances was typed in by hand from an order somewhere else.

The same sheet usually makes sense to one person only. If you're the one who built it, nobody else can run a payout, and a week off means creators wait.

Gifts and stock stop matching

A creator says a parcel never came, and you have no order and no tracking number to check. Your stock count in Shopify doesn't match the shelf either, because gifts never went through as orders.

Once you can't say what a creator already has, you either send twice or not at all. How to keep track of who got free product shows how to fix this part on its own, by sending each gift as a $0 order, and it's worth doing even if you keep the sheet for everything else.

Nobody can see what each creator sells

A creator asks how their link is doing, or which product their audience bought most, and you can't tell them quickly or with confidence. A creator who can see their own sales has a reason to keep posting, and one who has to ask you each time has a reason to stop.

The same gap affects your own decisions. You keep sending product to a creator because you like their posts, or drop one who seems quiet without checking whether their link still brings in orders. That's fine in the first month. Once the program costs real money every month, who to keep should rest on numbers you can pull up in a minute.

What an app should take off your hands

A dedicated creator app earns its fee when it does the tedious parts without you:

  • Ties each sale to the right creator from the order itself, with nothing retyped.
  • Works out commission on the right amount, and reverses it on refunds.
  • Holds commission until your return window passes.
  • Sends gifts as real orders, so stock and history stay right.
  • Gives creators a place to check their own link, code, sales and balance.

Don't take those from a feature page. How to choose a creator affiliate app turns each one into a test you can run with two orders during a free trial.

What it should leave with you

Some things should stay yours. The money is one: paying creators the way you already do and recording it keeps you in control of cash and timing. Your data is another, and it should stay in Shopify, so leaving an app later doesn't cost you orders or codes. Before you install, check what the app turns on by default, such as discount codes or emails to creators, so nothing happens in your store you didn't expect.

Seedr emails creators by default and leaves discount codes off until you switch them on. Payouts go out through PayPal, your bank or whatever you use, and you mark them in the app. If you ever uninstall, your orders, discount codes and customer data are still in Shopify.

Moving off the sheet without losing anything

Pick a quiet week. Check that every creator's code still works, settle each balance or carry it over exactly, and tell creators where they'll see their numbers from now on. Keep the old sheet, read only, for at least a year. Moving your creator program to a new app has the full order of steps.

Run the app and the sheet side by side for the first month. If the totals agree, retire the sheet. If they don't, the difference usually points to a gap the sheet was hiding.

How long one answer takes

Time yourself on a single question: how much is your top creator owed right now, after refunds? If it takes more than five minutes, start a trial of a creator app and run it beside the sheet until the next pay day, then compare the two totals.