Importing the buyers you already have from any CSV, in one evening

The empty dashboard is the discouraging part. You have sold before — a few hundred downloads on a marketplace, a checkout tool you used for a year, an old newsletter, a spreadsheet of people who paid you by bank transfer — and now the customer list on your new storefront says zero. It is not really zero. Those people exist, they just live in five different exports on your laptop. One evening moves them into one place.

Why this job gets postponed

Nobody postpones the import because it is difficult. They postpone it because the source data is embarrassing. One file has full names, another has "customer_email" and nothing else, a third is a PayPal statement with amounts but no product, and somewhere there is a Google Sheet you filled in by hand and stopped updating in March. Merging them means confronting how loose the record-keeping has been.

The other reason is that it feels backward-looking. New storefront, new start, why drag the old stuff along. But the people who already paid you once are the most likely people to pay you again, and they are the only audience you have that has proven anything. Rebuilding them from social media is far more work than an hour with a spreadsheet.

The genuinely hard bit is consent. Not every row in every old file is a person you may email now. A buyer from a marketplace who agreed to the marketplace's terms did not necessarily agree to hear from you directly. You can still keep the record for your own purposes — it is your sales history — but be conservative about what you send, and to whom.

Five scattered files, or one list

The status quo for most creators is that customer data lives wherever the sale happened, and nowhere else. That is fine until you want to answer a question that spans platforms, like whether the person asking for a discount today bought your first product two years ago.

The evening, step by step

Set aside ninety minutes and a spreadsheet. Do not try to be clever: one master sheet, four columns, then import once. If you want the wider version of this job, including files and products, the migration guide covers moving a whole storefront rather than just the people.

1. 1Gather every export you can find into one folder: marketplace sales reports, old checkout exports, PayPal or Stripe payout CSVs, newsletter exports, and any spreadsheet you kept by hand.
2. 2Open a new sheet with four headers: email, name, product, date. Paste each source underneath the last, mapping its columns into yours as you go. Ignore any column you cannot map.
3. 3Lowercase every email address with a formula, then sort by email so duplicates sit next to each other.
4. 4Remove exact duplicates. Where the same person appears twice with different products, keep the row with the earliest date and note the second product in the product column, separated by a semicolon.
5. 5Delete rows with no email address at all. They are not contacts, they are memories.
6. 6Scan for obvious typos in the domain part: gmial, hotmial, gmail.con. Fix the ones you are sure about and delete the ones you are not.
7. 7Save as CSV with UTF-8 encoding so accented names survive the trip.
8. 8In your dashboard, open Customers, choose import, upload the file and map your four columns to the fields on screen.
9. 9Import, then check the row count against your spreadsheet. If the numbers differ, the difference is almost always duplicates the import caught, which is the system doing you a favour.

What 340 rows looks like in practice

Suppose the folder holds three real files: 210 rows from a marketplace, 90 from an old checkout tool, and 55 from a hand-kept sheet of people who paid you directly. That is 355 rows before cleaning. Sorting by email typically surfaces a run of people who appear in two files, because your best customers are exactly the ones who bought in more than one place. Say fifteen of those collapse into single rows. You import 340.

The interesting part comes after. With everything in one place you can see that eleven people bought from you three or more times across those years, and those eleven are worth a personal email rather than a broadcast. You can also see which of the old products has the longest tail, which is a decent hint about what to rebuild first as a digital download on the new storefront.

The mistake most people make

The mistake is treating the import as a mailing list rather than a record. People finish the upload, feel the count jump to 340, and immediately send a launch email to all of it. Two things go wrong: the people who barely remember you mark it as spam, and the people who do remember you get a message that reads as though you have never met. Import first, then decide who has actually earned a message from you, then write to that smaller group as though you know them, because you do.

Everything described here works on the free plan, including the export you take afterwards, so nothing about this job depends on which tier you land on — the pricing page shows what changes when you do upgrade. By the end of the evening the dashboard stops lying to you. The number in the corner reflects everyone who has ever handed you money or an email address, not just the people who arrived since Tuesday. That is a better place to make decisions from, and it costs you one sitting with a spreadsheet and a cup of tea.