Skip to content
ShopiAgents

Import buyers from a spreadsheet

Bring a whole buyer list into Shopify at once from a CSV file: match your columns, see which rows are ready, and import up to 1,000 buyers.

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

  1. Go to Buyers and click Import buyers.
  2. 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.
  3. 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.
  4. 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.
  5. Click Import 42 buyers (the button shows your number).
  6. 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 fieldNotes
Company nameRequired
Account numberYour own customer number
First name, Last nameThe main contact
Email or PhoneOne of the two is required. Phone with the country code (+1…)
Location nameLeave empty to use the city
Address, Apartment, suite, etc., City, Postal / ZIP code, State / province codeAddress, city required
CountryRequired. A 2-letter code (US) or a name (United States)
Price listThe wholesale price list they go on
Trusted buyeryes or no: approve their orders automatically (Pro plan)
Tax ID / VAT numberShown on quotes and invoices
WebsiteKept 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.

Still stuck? Email support@shopiagents.com and a person will help.