Websites

Customer list for your online store, built from every order and form

A customer list for an online store gathers everyone who bought, booked or signed up into one table you can search, tag and export. On OneCraft the agent writes it into your site's admin with the crm guide: customers, notes, tags, segments and a timeline of what each person did, all private to admins.

Create a website with OneCraftThe customers table the agent writes, how it fills from orders, bookings, forms and sign-ups, the timeline and notes per customer, and segments you can export.

How the list fills itself

A function called sync_customers reads every table on your site that holds an email: orders, bookings, quote requests, form responses, newsletter subscribers and profiles. It adds each email once, keeps the first and latest time the person was seen, and works out orders and money spent from paid or fulfilled orders. It runs when the customers page opens and when you press Refresh; there is no scheduler.

One page per customer

Each customer has contact details with email and phone links, tags you add and remove, notes newest first, and a timeline. The timeline joins that person's orders, bookings, requests, form responses, tickets and notes, newest first, up to 100 rows, each linking to the record it came from.

Segments and exports

A segment is a saved filter: tags, a minimum spend, last seen before or after a date, or where the person came from. Open one to see the count and the people, export it as a CSV file, or copy the emails for your own mail tool. The admin dashboard shows new customers this month and repeat customers.

Private by design

The list is for admins only. Every customer table allows reads and writes only to people in site_admins, and the agent checks this as an anonymous visitor, a signed-in person and an admin before it finishes. The list never appears on the public site, and in a phone app it shows only on the Admin tab.

How it works, in three steps

  1. Step 1

    Ask for a customer list

    Name the CRM in the generator's brief or features, or ask in chat for a customer list with notes and tags on a site that already takes orders or bookings.

  2. Step 2

    Give it a database

    Every plan gets a hosted site database, or you can connect your own Supabase account in the site's Settings, Database card.

  3. Step 3

    Open it in the admin

    Sign in to /admin with the admin account the agent reports and open Customers; publish from the builder on a paid plan to use it on the live site.

Limits worth knowing

Questions people ask

Is a customer list the same as a CRM?

It is the core of one. The list the agent writes has what a small shop uses a CRM for: one record per email, notes, tags, saved segments and a timeline of orders, bookings and requests. It does not send campaigns, score leads or track deals in a pipeline; for email campaigns to a segment you copy the emails into your own mail tool.

Do guest buyers appear on the list?

Yes. The sync reads the email on every order, signed in or not, and matches people by email with letter case ignored. A guest who later creates an account is joined through their profile, so their earlier orders and later activity sit on one customer page instead of two.

Can I add a customer who never used the site?

Yes. The customers page has Add customer, and a manual entry is marked with manual as its source. That is useful for people who order by phone or in person. Notes and tags work the same for them, and if they later order online with the same email, the order joins their existing record.

Can my staff see the customer list?

Anyone in the site's site_admins table can, owners and staff alike, because the customer tables allow admins only. If a person should not see customer details, do not add them as staff. Visitors and signed-in buyers are refused by the database itself, not just hidden from the menu.

How is the spent column worked out?

From paid and fulfilled orders only. Pending, cancelled and refunded orders do not count, so the column shows money that actually arrived. The orders count and the amount spent are recomputed each time the sync runs, which keeps them right after a refund has marked an order refunded.

What should I tell customers about the details I keep?

Say in your privacy policy what you keep, why and who sees it: name, email, phone, orders and any notes staff write. Notes are visible to every admin, so keep them factual. The site can have a legal page and a way for signed-in people to delete their own data when you ask for them in chat.

Make your own website

The button opens the generator with this use case already described. Change the wording to match yours, generate, then edit anything you like.

Create a website with OneCraft

Not ready to start? See the AI website builder page first.

Related pages

More finished work of this kind is on the website examples hub.

Sources

Written and checked by the OneCraft team. Last checked .