# Customer list: search, group and import

> Your customer list: search, filter, save views, add or import people, write to them, group them, merge duplicates and download the list.

Source: https://docs.personacart.com/commerce/customers

In short: {"Your customer list: search, filter, save views, add or import people, write to them, group them, merge duplicates and download the list."}

- Everyone who has paid you is in this list, with what they spent, how often they ordered and whether you may email them.
- Open a person to see everything about them in [Customer 360](/commerce/customer-360).
- Use the tabs for [groups](/commerce/segments) and for people who signed up but have not paid yet.

Video: Customers: what each person earned you (https://www.youtube.com/watch?v=yCNa44Xb0i0)

Online buyers appear here by themselves, usually within a minute of paying. You only add someone by hand when they paid you another way, for example cash at the door.

1. Open **Commerce → Customers**.
2. Search a name, email or phone, or use **Filter**.
3. Click a person to open their page, or tick people to act on several at once.
4. Press **Add a customer** for someone who paid another way.

## Where to find it

Sidebar → COMMERCE → Customers. The sidebar also has two shortcuts under it: **Segments** and **Leads**.

The page has three tabs:

| Tab | What it shows |
|---|---|
| **Everyone who paid** | The main list described on this page. |
| **Groups** | Lists that fill themselves, such as "Bought 2 or more times". See [Customer groups](/commerce/segments). |
| **Signed up, not paid yet** | People who gave you their email but have not bought. See [Leads tab](/commerce/leads). |

- Above the tabs, four figures sum up the store: **Total customers**, **Earned**, **Earned per customer** and **At risk** (buyers who may be drifting away).
- **Earned** is sales minus refunds, and its note spells the sum out: "Sales 1,200.00 minus refunds 150.00. Test orders not counted." **Earned per customer** is that total divided by your customers.
- Tap **At risk** to see exactly those people.
- On an empty store the figures stay hidden because there is nothing to add up yet.
- On the **Signed up, not paid yet** tab the figures change to **Total Leads**, **Hot Leads** and **Converted**.

## The buttons at the top

- **Add a customer** (the main button) opens a side sheet, see below.
- **More** opens a menu with four jobs: **Bring in a list**, **Download my list**, **Download everything** and **Find the same person twice**.
  - These four are shown only to people allowed to export customers.
  - If your Academy menu is on and you opened the list from Families, **More** also offers **Add family**.

## Add a customer

Use this for someone who paid you in cash or at the door.

1. Press **Add a customer**.
2. Type **Their name**.
3. Type **Their email**. PersonaCart uses it only so you can write to them.
4. Press **Save** (the button carries the person's first name).

- Until both boxes are filled the sheet says what is missing ("Type their name to save", "Type a full email address to save").
- Saving adds the person to your list and sends no email.
- If that email already belongs to a customer, PersonaCart opens the existing person instead of making a second copy.
- After the first customer you add, a card offers **Next: write to &lt;name&gt;** or **Add another**.

## Bring in a list

- Press **More → Bring in a list**, then **Look at my file**.
- This opens [Import & Export](/commerce/import-export), where you choose a spreadsheet saved from Excel or Google Sheets (.csv).
- The file needs a column for name and a column for email.
- You see how many people will be added and how many are skipped, and nothing is added until you press the button.

## Download my list

- **More → Download my list** saves your customers as a spreadsheet.
- The sheet tells you how many customers are in the file and reminds you that it contains names and email addresses, so keep it somewhere safe.
- You can download once every few minutes; if you try too soon, the button shows how long to wait.

**More → Download everything** gives one ZIP with contacts, bookings and payments. It can be requested three times in five minutes.

:::note[Big downloads are capped]
Each file in the download holds up to 50,000 rows. If you have more, PersonaCart tells you the file was capped and a `MANIFEST.txt` inside the ZIP lists what was left out. Use filters or tick specific customers to download the rest in parts.
:::

## Quick groups

Under the tabs, **Quick groups** are chips that narrow the list to one idea, each with its head-count:

- **Bought 2 or more times**
- **Not back for a while**
- **New customers**

A chip with nobody in it is not shown. Tap a chip to filter; tap it again to clear.

## Worth your attention

When you have customers, a row of cards points at people who may need you. Tap a card to filter the list to exactly those people (tap again to clear):

- **Email**: how many of your customers agreed to get email from you. If the answer is none, a campaign today would reach nobody. **Show who was never asked** filters the list.
- **Gone quiet**: customers who have not ordered in 90 days. **Show them, biggest spenders first** sorts by what they earned you, highest first.
- **Possible duplicates**: email addresses used by more than one customer. **Review** opens the duplicates window.

## Search, filters and saved views

The search box looks through every customer by **name, email or phone number**, not only the rows on screen. Press `/` to jump to it.

The **Filter** button opens the filter panel. It shows how many filters are on, and it opens by itself when a filter is already applied (for example from a link). **Clear filters** removes all of them.

| Filter | What it does |
|---|---|
| **Tags** chips | Only four fixed tags: **VIP**, **Wholesale**, **Course Learner**, **Event Attendee**. Pick several to combine. Tags you make yourself cannot be filtered here yet. |
| **With children** | Only parents who have a child on file (Academy). |
| **Status** | **All**, **Active** or **Inactive**. |
| **Customer Behavior Group** | One of nine groups worked out from how recently, how often and how much they buy: **Champion**, **Loyal**, **New customer**, **Promising**, **About to sleep**, **Can't lose**, **At risk**, **Lost**, **Needs attention**. |
| **Last ordered** | **Any time**, **More than 90 days ago**, **More than 180 days ago**, **More than a year ago**. |
| **Consent** | **All consent**, **Mailable** (can get marketing email), **Subscribed**, **Customer (purchased)**, **Campaigns: not opted in**, **Unsubscribed**. |
| **Orders** | A minimum and maximum number of orders. |
| **Spent** | A minimum and maximum amount spent, in your store currency. |
| **Created** | A **From** and **To** date for when the customer was created. |

**Saved views** sit beside the search box. Set up a filter, then press **Save this view**, name it (for example "Big spenders gone quiet") and it is one click away next time. Each view shows how many customers it holds. Deleting a view removes only the view, never the customers.

:::note[Counts come from the whole store]
Counts such as "Showing 50 of 126" always come from the whole store, not from the page you are looking at. If a count cannot be loaded, it is left out instead of showing a wrong 0.
:::

## The table

- The table opens with six columns: **Name** (with a child chip like "Aarav · 9" for Academy families), **Email** (with a small badge when you cannot market to that person: **Unsubscribed** or **Campaigns: not opted in**), **Orders**, **Earned**, **Last order** and **Status**. **Customer number**, **Updated** and **Tags** are in the **Columns** menu. PersonaCart remembers your choice.
- **Earned** is what the customer is worth to you: their sales minus their refunds. If they were refunded, a small line under it says so ("150.00 refunded"). It replaces the old **Total spent** column.
- **Test orders are never counted.** In **Orders**, a customer with practice orders shows them beside the real count ("3 + 2 test"). A customer with only test orders is not shown as "0 orders" or "Never": **Last order** reads "12 Oct (test)".
- Click a column heading to sort by it (name, customer number, orders, earned, last order). The sort is done on the whole store, not only the rows on screen.
- A line above the table says how the rows are sorted, for example "Sorted by last order, newest first". The list starts with the customers who ordered most recently.
- The tags column shows two tags and "+N" for the rest.
- The column menu lets you hide columns you do not use.
- Click a row, the name, or the eye icon to open the customer.
- On a phone each customer is a tappable card instead of a table row.

Keyboard: **J** and **K** move down and up, **X** selects, **Enter** opens, **/** searches, **?** shows every shortcut.

## Work on several people at once

Tick the box at the start of one or more rows. A bar appears at the bottom saying how many are selected and, for email, how many **can get email**, how many were **never asked** and how many **unsubscribed**. The bar offers:

- **Ask for email permission**: sends each person one email with a button.
  - Until they press it, nothing changes and you still cannot send them marketing email.
  - People who unsubscribed are never asked, people asked in the last 7 days or who already agreed are skipped, and there is a daily limit that the sheet shows ("You can ask N more today").
- **Write to them**: for one person, opens a short message window (subject and message, sent as one email they can reply to). For several, the people are first saved as a group, because campaigns go to groups, and then the writing screen opens on that group.
- **Add to group**: gives the people a tag with the group's name and saves a group with that name once. Nothing is sent.
- **Merge**: enabled only when exactly two people are ticked. See [Merge duplicate customers](/commerce/customer-merge).
- **Bulk Tag**: type a tag and press **Apply Tag**. The tag is saved in lower case with underscores ("VIP" becomes "vip"). A tag typed on a customer's own page is saved exactly as typed, so the two can differ and the filter does not match a different spelling.
- **Export Selected**: downloads only the ticked people as a CSV.

## Find the same person twice

- **More → Find the same person twice** (or **Review** on the Possible duplicates card) lists customers who share an email address.
- For each group, choose which record to **Keep as primary** and press **Merge N**.
- The merged copies are hidden, and a merge can be undone for 30 days.
- For the full flow, including phone and name matches, see [Merge duplicate customers](/commerce/customer-merge).

## What to know

- **Customers are created for you** when someone pays or creates an account. Adding by hand is for people who paid another way.
- **Tags group people, they do not change what a customer can do.**
- **Marketing email needs permission.** Order and account emails still go to everyone. A person who is **Unsubscribed** or **Campaigns: not opted in** will be skipped by campaigns.
- **Hiding a customer or merging does not delete their orders.** Orders stay with the customer they were placed under.

## Questions

## Every field on this screen

The controls on this screen, read straight from the live app.

## In this section
