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.
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
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.
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.
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
- The list refreshes when the customers page opens or you press Refresh; it is not updated on a timer.
- A newsletter goes to every confirmed subscriber, not to a segment; segments are exported or copied for your own mail tool.
- CSV import and export live in the website's admin, not in the phone app.
- When a new capability adds a table with emails, ask in chat for the sync to include it.
- A hosted database comes with every plan, or you can connect your own Supabase account in the site's Settings, Database card.
- The Free plan builds and previews a site but cannot publish it, connect a domain, take payments or run Expo builds.
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 OneCraftNot ready to start? See the AI website builder page first.
Related pages
Order management for a small online store: pending to fulfilled
Order management for a small online store is seeing each order, knowing which are paid and moving them through to sent. On OneCraft the agent writes it with the orders and admin guides: an orders table with a status, a timeline of events per order, and an admin page where you filter, open and fulfil them.
Pre-order website with ship dates, limits and bundles
A pre-order website sells a product before it is in stock and tells the buyer when it ships. It works when the ship date is on every step, a limited run stops at its limit, and the order is paid through your own account like any other.
Delivery and pickup ordering with time slots and tracking
Delivery and pickup ordering lets customers choose how they get their order, see the delivery fee for their postcode before they pay, and pick a time slot that still has room. After that, a tracking page tells them where the order is up to without a phone call.
More finished work of this kind is on the website examples hub.
Written and checked by the OneCraft team. Last checked .