How to Keep a Customer List as a Coin Dealer
· 7 min read
To keep a customer list as a coin dealer, make one record per customer with their name, email, phone, and address, and add every sale to that record as it happens, so each customer shows what they bought, what they spent, and what they owe. Add what they collect and short notes your team can use. Match every new sale to an existing customer by email before you create a new one, and review the list every month to call the buyers who matter.
Most dealers keep the list in their head, a phone, and a stack of old invoices. That works until a good customer's want list walks out the door with an employee, or you buy a nice Carson City Morgan and cannot remember who asked for one. The steps below turn the list into something you can sell from.
What to keep on each customer
| Field | Why it matters |
|---|---|
| Name and company | Who they are. Dealers and collectors both buy. |
| The best key for matching sales to the right person, and how you reach them. | |
| Phone | Many coin buyers still want a call. |
| Shipping address | So shipped sales go to the right place, and you notice a sudden change. |
| Every purchase, with its invoice | What they bought and paid. |
| Amount owed | Open balances, so you know before you ship more. |
| What they collect | Their want list: series, grades, budget. |
| Team notes | "Pays by wire, always on time." "Prefers PCGS." |
| Status | Active, inactive, or blocked. |
Leave out what you do not need. Never write a card number, a full Social Security number, or a password in a note. A customer list is a target, and the less sensitive data it holds, the less there is to lose. Some states have their own rules on how you store and protect personal data, so check with your state attorney general's office or a lawyer.
Step 1: Capture every buyer at the sale
The list is only as good as the moment you add to it. Record the buyer on every invoice, including counter sales and show sales, when they will give you a name and email. A walk-in who pays cash and leaves no name is fine as a walk-in sale. A buyer who spent $3,000 at a show and left no email is a lost customer.
Marketplace orders add buyers too. Keep them on the same list, so a collector who buys from you on eBay and at your counter shows as one person.
Step 2: Keep one record per person
Duplicates are the main way a customer list goes bad. "Rich Lawson" at one show and "Richard Lawson" on an invoice look like two customers with $900 each, when one customer has spent $1,800 with you.
Match in this order:
- Email. The same email is the same customer, whatever the name says. Ignore upper and lower case.
- Exact name, only when there is no email match and only one saved customer has that name.
- A new customer, when nothing matches or two saved customers share the name.
Do not let a name match override a different email. Two different John Smiths are common.
Step 3: Know who your best customers are
Lifetime value is the total a customer has spent with you after returns. Count only invoices that were really sold: leave out drafts, void invoices, and cancelled invoices.
Worked example
Five customers from last year:
| Customer | Invoices | Lifetime value |
|---|---|---|
| Thomas Greene | 11 | $14,960 |
| Linda Price | 6 | $8,420 |
| Richard Lawson | 3 | $2,150 |
| Gary Holt | 2 | $1,160 |
| Karen Mitchell | 1 | $310 |
| Total | 23 | $27,000 |
- Average lifetime value: $27,000 ÷ 5 = $5,400.
- Median lifetime value: $2,150, the middle customer.
- Thomas and Linda together: $14,960 + $8,420 = $23,380, or $23,380 ÷ $27,000 = 86.6% of the total.
The average says a typical customer spends $5,400. The median says the typical customer spends $2,150, and two customers carry the rest. On a real list, the gap is often wider. Know who those top customers are, and make sure they hear about the right coins first.
Returns come off
Linda's last invoice was $4,035, and she returned a $425 Morgan dollar. That invoice counts as $4,035 − $425 = $3,610 in her lifetime value. If you count the full $4,035, every return makes a customer look more valuable than they are.
Step 4: Keep want lists where you can find them
A want list is the most useful thing on a coin customer's record. Keep it in a form you can search:
- Use short, consistent tags: "Morgan dollars", "Carson City", "Type set", "Gold $20", "Proof sets".
- Put the details in a note: "Wants 1880s CC Morgans, MS63 to MS65, PCGS or NGC, up to $1,500 each."
- Review it when you buy a collection. Before you list new coins, check who asked for them.
Worked example
You buy a group that includes an 1882-CC Morgan dollar, PCGS MS64, at $480 and plan to price it at $650. Three customers have the "Carson City" tag, and one note says "up to $700." You call that customer first. If they buy at $650, you make $650 − $480 = $170 on a coin that never went into your case or onto a listing.
Step 5: Use the list every month
Set a monthly half hour to:
- Call the top customers with coins that match their want lists.
- Check who has not bought in a year. Sort by last purchase. A short note with two or three coins they might like often brings them back.
- Check open balances. A customer who owes you $2,000 on one invoice should not get another shipped on credit.
- Mark customers inactive when they have moved on, so they do not clutter the list.
Step 6: Block bad actors
Sometimes a customer bounces a check, files a chargeback after delivery, or sends back a different coin from the one you sold. Mark them blocked, with the reason, so nobody on your team sells to them again by mistake. Keep their old invoices. The history matters if a dispute comes back.
Emailing your list
Email is the cheapest way to tell buyers about new coins. Commercial email has rules, such as identifying yourself, giving a working way to opt out, and honoring opt-outs. Read the FTC's CAN-SPAM guide for businesses, and ask a lawyer if you are unsure how it applies to you. A short personal email to one customer about one coin they asked for often gets a better answer than a newsletter to the whole list.
Common mistakes
- No email on the record. You cannot match future sales or reach the customer.
- Duplicates. One customer split across three records looks like three small buyers.
- Want lists in your head. They leave when you are busy or when staff change.
- Counting drafts and voids as sales. Lifetime value goes up for sales that never happened.
- Sensitive data in notes. Card numbers and ID numbers do not belong on a customer list.
How CoinManagerPro keeps your customers
CoinManagerPro customers lists the people and businesses you sell coins to. You add a customer with "Add customer", but most customers add themselves: a new buyer on "New invoice" or "Sell" becomes a customer, and so does the buyer on an eBay or Walmart order. For a new buyer on an invoice, CoinManagerPro looks for a saved customer with the same email, case not counting, and then for the one customer with the same name. A customer with a different email does not match. When it finds no match, it adds a new customer.
Each row shows "Purchases", "Lifetime value", "Last purchase", and "Status". Lifetime value counts invoices that are not drafts, void, or cancelled, with returns taken off. You can search by name, email, phone, or company, sort by "Highest value", "Most purchases", or "Last purchase", and filter by "Status" ("Active", "Inactive", "Pending", or "Blocked") or by "Tags". The top of the list shows the number of customers and the "Average lifetime value".
The customer page shows the purchases, the lifetime value, what the customer owes, the newest invoices, and team-only "Notes". In the "Tags" section, "Add tag" adds a tag such as a want list series. Under "Messages" you can email the customer from CoinManagerPro, and replies come back to the Messages page. "Block" stops anyone from putting the customer on a new invoice or memo, with a reason only your team sees. When a Carson City Morgan comes in, filter the list by your "Carson City" tag and sort by "Highest value" to see whom to call first. "Export" downloads a CSV of the filtered list with names, emails, phones, addresses, tags, notes, and totals. The steps are in Manage customers. For the invoices behind each customer, see invoices.
The short version
Keep one record per customer, with contact details, every invoice, the amount owed, a want list, and short notes. Match new sales by email before you add anyone new. Measure lifetime value after returns, and look at the median as well as the average. Tag want lists so you can find them, call your best customers first when the right coin comes in, and block buyers who cost you money.
Questions
- What should a coin dealer keep on each customer?
- Name, email, phone, company if any, shipping address, every purchase with its invoice, what they owe, what they collect, and short team notes such as payment habits. Leave out card numbers and anything you do not need.
- How do I avoid duplicate customers?
- Match each new sale to a saved customer by email first, then by exact name. Add a new customer only when nothing matches. Fix duplicates as soon as you see them, before their purchases split further.
- What is customer lifetime value for a coin dealer?
- The total a customer has spent with you, after returns. Add up the totals of their invoices that were actually sold, leaving out drafts, void and cancelled invoices, and take off any returns.
- Can I email my customer list about new coins?
- Yes, but commercial email has rules, such as identifying yourself and honoring opt-outs. Read the FTC's CAN-SPAM guide for businesses, and ask a lawyer if you are unsure how it applies to you.
See how CoinManagerPro does this