---
title: The customers list
description: Find customers with search and filters, sort them, change many at once, and import or export them as a file.
---

Press **Customers** in the sidebar to see every customer in your store. Above the table, the list says how many customers it shows, such as **2 customers**.

![The Customers list with Bilal Ahmed and Ayesha Khan, 2 customers, and the Segment, Search customers and Sort by boxes](/screenshots/orders-customers/30-customers-list.jpg)

## What the list shows

| Column | What it means |
| --- | --- |
| **Customer** | The customer's name. Press it to open their page |
| **Email** | Their email address |
| **Email marketing** | **Subscribed** (green), **Not subscribed** or **Unsubscribed** |
| **Location** | The city and country of their default address |
| **Orders** | How many orders they placed (test orders are not counted) |
| **Amount spent** | What their orders came to, less refunds |
| **Created** | When they were added |

The buttons at the top right:

| Button | What it does |
| --- | --- |
| **Segments** | Opens your saved customer searches (see [Segments](/orders-and-customers/segments)) |
| **Imports** | Lists the CSV files you imported (below) |
| **Export** | Downloads customers as a file (below) |
| **Import** | Adds customers from a CSV file (below) |
| **Add customer** | Adds a customer (see [Add and edit a customer](/orders-and-customers/add-and-edit-a-customer)) |

The list shows 50 customers a page. The arrows next to **Page 1** go to the next and previous pages.

## Search

Type in **Search customers** and press **Enter** on your keyboard. You can type a name, an email or a phone number, or a filter. The hint under the box gives examples:

| Type | To find |
| --- | --- |
| `tag:vip` | Customers with the tag **vip** |
| `country:PK` | Customers whose address is in Pakistan |
| `email_subscription:subscribed` | Customers subscribed to email marketing |
| `amount_spent:>100` | Customers who spent more than 100 |

Put several filters one after the other to find customers that match them all. Here, `tag:vip` finds only Ayesha Khan, and the count says **1 customer**:

![Searching for tag:vip shows 1 customer, Ayesha Khan, and the Save as segment button](/screenshots/orders-customers/31-search-tag.jpg)

A **Save as segment** button appears next to the count: it keeps this search as a segment (see [Segments](/orders-and-customers/segments)).

When the search can't be read, the box turns red and says why, such as **Search query: unknown field "orders".** The list says **No results.**

![Searching for orders:>1: the message Search query: unknown field "orders". and No results.](/screenshots/orders-customers/32-search-error.jpg)

To see everyone again, empty the box and press **Enter**.

## Sort

Press the box under **Sort by** and choose:

- **Updated**: the most recently changed first (this is where it starts);
- **Created**: the newest first;
- **Name**: A to Z;
- **Amount spent (highest first)**;
- **Number of orders (most first)**;
- **Last order date (newest first)**.

![The Sort by list open, with Updated, Created, Name, Amount spent (highest first), Number of orders (most first) and Last order date (newest first)](/screenshots/orders-customers/33-sort.jpg)

Here is a store with orders, sorted by **Amount spent (highest first)**:

![The customers list sorted by amount spent: Bilal Ahmed PKR 2,000, Ayesha Khan PKR 1,500, Sara Malik PKR 0](/screenshots/orders-customers/131-customers-with-orders.jpg)

## Change many customers at once

1. Tick the box at the start of each customer you want. The box in the heading row ticks everyone on the page.
2. A bar appears above the list, saying how many you chose, such as **2 customers selected**, with the buttons **Add tags**, **Remove tags** and **Delete customers**.

![2 customers selected, with Add tags, Remove tags and Delete customers](/screenshots/orders-customers/34-bulk-actions.jpg)

### Add or remove tags

1. Press **Add tags**.
2. A box opens: **Add tags to 2 customers**. Type the tags in **Tags**, separated by commas, such as `newsletter`.
3. Press **Add tags**. The list says **Tags added to 2 customers.**

![The box Add tags to 2 customers with newsletter typed in Tags](/screenshots/orders-customers/35-bulk-add-tags.jpg)

**Remove tags** works the same way: type the tags to take off and press **Remove tags**. The list says, for example, **Tags removed from 1 customer.**

![The message Tags removed from 1 customer. above the list](/screenshots/orders-customers/36-bulk-done.jpg)

### Delete customers

1. Tick the customers and press **Delete customers** (the red button).
2. A box asks, for example, **Delete 1 customer?** It says customers with orders can't be deleted, and when any of them has orders, none is deleted. This cannot be undone.
3. Press **Delete customers**, or **Keep** to change your mind.

![The box Delete 1 customer? with Keep and Delete customers](/screenshots/orders-customers/41-bulk-delete.jpg)

The list says **1 customer deleted.**

## Export customers

1. Press **Export** at the top right.
2. The **Export customers** box says the CSV file downloads straight away, with the same columns as Shopify's customer CSV.
3. Under **Customers**, choose which ones:
   - **All customers**;
   - **Current search**: the customers the list shows now (with a segment chosen, it names the segment);
   - **Selected**: the customers you ticked (only when you ticked some).
4. Press **Export**. The file `customers_export.csv` downloads.

![The Export customers box with All customers and Current search (all customers)](/screenshots/orders-customers/37-export.jpg)

## Import customers

You can add many customers at once from a CSV file, such as one exported from Shopify.

1. Press **Import** at the top right.
2. The **Import customers** box says the file must be a CSV file in UTF-8, up to 15 MB and 50,000 rows, with the same columns as Shopify's customer CSV.
3. Press **Choose CSV file** and pick the file. Its name and size appear under the button.
4. Tick **Overwrite customers with the same email or phone** to update customers you already have. Leave it empty to skip them.
5. Press **Upload and import**.

![The Import customers box with customers.csv chosen and the Overwrite customers with the same email or phone box](/screenshots/orders-customers/38-import.jpg)

The import's page opens. It shows **Finished** when it is done, how many customers were read, and how many were **Created**, **Updated** and **Skipped**, and the **Errors**. Each row with a problem is listed with its row number, such as **Email: Enter a valid email address.**

![The import page for customers.csv: Finished, 3 of 3 customers, Created 2, Updated 0, Skipped 0, Errors 1, and row 4 with Email: Enter a valid email address.](/screenshots/orders-customers/39-import-page.jpg)

Press **Imports** above the file name (or the **Imports** button on the customers list) to see every customer import with its **Status**, **Progress**, how many were **Created, updated, skipped**, its **Errors** and when it **Started**.

![The Imports page listing customers.csv, Finished, 3 of 3 customers, 2, 0, 0, 1 error](/screenshots/orders-customers/40-imports-list.jpg)

## What's next

[Segments](/orders-and-customers/segments): save a search and keep it up to date.
