Moving from another system, or back from a trade show with a list of new accounts? Import them in one go from a CSV file. Each row becomes a B2B company in Shopify with its contact, location, price list and tax ID.
Plan: every plan. Who can do it: admins and approvers.
Before you start
- Save your list as a .csv file. Any spreadsheet app can do this (in Google Sheets: File → Download → Comma-separated values).
- Each row needs a company name, an address, city and country, and an email or a phone number.
- Up to 1,000 rows per file. Split a longer list into several files.
Starting a new list from scratch? Click Download template on the import page. Every column is named and has an example row.
Import your buyers
- Go to Buyers and click Import buyers.
- Choose the file: click Add CSV file, or drop the file on the page. Your own export from another system works; the column names don't need to match ours.
- Match the columns: for each Column in your file you see a few Examples and Our field. Columns with names we know are matched for you, and your AI agent suggests the rest. Change any that look wrong, or choose Don't import for columns you don't need.
- Check the line that says how many are ready, for example "Ready: 42 buyers will be created in Shopify." Rows that can't be imported are listed with the reason.
- Click Import 42 buyers (the button shows your number).
- Import: the page shows "Creating buyers in Shopify: 12 of 42…". When it says "Import finished", click See buyers.
In the app your agent is called Ava by default; you can rename her.
<!-- screenshot: buyers/import-buyers-1.png — Match the columns step with examples and the Ready line -->Fields you can import
| Our field | Notes |
|---|---|
| Company name | Required |
| Account number | Your own customer number |
| First name, Last name | The main contact |
| Email or Phone | One of the two is required. Phone with the country code (+1…) |
| Location name | Leave empty to use the city |
| Address, Apartment, suite, etc., City, Postal / ZIP code, State / province code | Address, city required |
| Country | Required. A 2-letter code (US) or a name (United States) |
| Price list | The wholesale price list they go on |
| Trusted buyer | yes or no: approve their orders automatically (Pro plan) |
| Tax ID / VAT number | Shown on quotes and invoices |
| Website | Kept with the buyer |
What your buyers see
Nothing. Importing doesn't email anyone. When you're ready, tell them about their account (see Tell your buyers about it).
Good to know
- Each buyer is created as a B2B company in Shopify. A row whose email already belongs to a contact in Shopify is skipped, so importing the same file twice doesn't make duplicates.
- Only the first 1,000 rows are imported. The page tells you if your file is longer.
- After the import, open any buyer to add more contacts, locations, credit limits or own prices.
If something goes wrong
- "No rows could be imported": look at the reasons under the skipped rows. Most often a required column isn't matched: go back and match Company name, Email or Phone, and the address fields.
- A row says the country is wrong: use a 2-letter code like US, CA or GB, or the full country name.
- A row failed during the import: the message after the row number says why. Fix it in your file and import just those rows again.
More fixes: Buyer sign-in, portal and sign-up problems.