User documentation: Export customer list for WooCommerce

Registered Customer

Select the user role to download

Choose which user role’s records you want to export.

• Leave blank → downloads WooCommerce customers.
• Example: Select Customer, Subscriber, or another role.

Registration done between (Start Date – End Date)

Filter customers by registration date.

• Set both dates → export customers registered in that range.
• Leave blank → export all customers.

Delimiters

Select how values are separated in the CSV file.

• Default: , (comma).
• Options: semicolon ; .

Extraction speed

Number of records processed per batch during export.

• Higher value → faster export.
• Too high on shared hosting → may cause errors.
• Default: 60.

Number of rows to extract

Define how many rows you want to export.

• 0 → export all rows.
• Any positive number → export only that many rows.

Number of rows to skip

Define how many rows from the top should be skipped before export starts.

• Useful for partial exports or continuing from a previous export.
• Default: 0 (no rows skipped).

Customize Columns – Registered customer

The Customize Columns option lets you control which fields are included in your exported CSV/Excel file and how they are labeled. You can define different Customize columns for Registered customer and Guest customer. All this data is extracted from user meta data.

Tick the columns you want

• Each row represents a user field (e.g., ID, user_login, user_email).
• Tick the checkbox to include that field in the export.
• Untick to exclude it.

Column name

• Define the column header name for the CSV file.
• By default, it shows the database field name (e.g., user_email).
• You can change it to a more readable name (e.g., Email Address) for your exported file.

Example

• If you tick user_email and rename the column to Email,
  your CSV will have a column header called Email containing customer email addresses.

Add Custom Meta Fields

This option allows you to include additional custom user meta field in your export that are not available by default.

How it works

1. Enter the exact meta field name (e.g., _automatewoo_birthday_full).
2. Click Add Field → it will appear in the list.
3. After saving, go to Customize Columns – your added field will be available there.
4. Tick the checkbox to include it in your export and give it a column name.

Important Notes

• The field name must be an existing user meta key in your database.
• If you no longer need a field, you can:
  • Unselect it from Customize Columns (to exclude from CSV but keep for future use).
  • Or click Remove here to delete it completely.

Guest Customer

Guest customers are those who checked out without creating an account. This screen allows you to export their data.

Guest customer based on order status

• Export guest customers filtered by order status.
• You can select multiple statuses (e.g., Completed, Pending, Failed).
• If left empty → all guest customers will be included.

Guest checkout done between (Start Date – End Date)

• Filter guest customers by the date they placed an order.
• Set both dates → only guest orders within that range are exported.
• Leave empty → all guest customers will be exported.

Other Options

Delimiters

• Defines how values are separated in the CSV.
• Default: , (comma).
• Options: ;, |, etc.

Extraction Speed

• Controls how many records are processed per batch during export.
• Default: 50.
• Increase for faster export on strong servers.
• Lower it if you’re on shared hosting to avoid timeouts.

Customize Columns – Guest customer

The Customize Columns option lets you control which fields are included in your exported CSV/Excel file and how they are labeled. You can define different Customize columns for Registered customer and Guest customer. All this data is extracted from order meta data.

Add Custom Meta Fields

This option allows you to include additional custom order meta fields in your export that are not available by default.

How it works

1. Enter the exact meta field name (e.g., pickup_date).
2. Click Add Field → it will appear in the list.
3. After saving, go to Customize Columns – your added field will be available there.
4. Tick the checkbox to include it in your export and give it a column name.

Product customer list

Using this you can filter and download a list of customers who bought specific products.

Get customer who purchased → Choose how to match products.

• Any One of this product → Exports customers who purchased at least one of the selected products.
• All of these products (if available) → Exports customers who purchased every product in the selection.

Select products → Pick the product(s) you want to target.

Order status → Narrow results by order status (Completed, Processing, Refunded, etc.).

Purchase done between (Start Date – End Date) → Restrict customers to a specific date range.

Customize Columns – The Customize Columns option lets you control which fields are included in your exported CSV/Excel file and how they are labeled.

Schedule CSV Emails

This feature allows you to automatically receive customer list reports by email at regular intervals. The CSV file will be sent as an attachment.

• Send customer list in email – Enable or disable the scheduling option.
• Email ID – Enter one or more email addresses (separated by commas) where the CSV report should be sent.
• Subject of the email – Define the subject line for the email.
• Message of the email – Add your custom message. Supports two shortcodes:
  • [after] → Displays the start date of the report.
  • [before] → Displays the end date of the report.
• Frequency of email – Choose how often the report is sent:
  • Hourly
  • Twice daily
  • Daily
  • Weekly (sent every Monday)
• Include Customer – Select whether to include registered customers, guest customers, or both in the report.
• Registered user role – Choose which WordPress roles should be included in the registered customer CSV.