Find Customer by Email
find_customer_by_emailFind a customer by exact email address and retrieve their order count summary. Requires a full valid email; partial email searches are not supported.
Instructions
Exact email lookup on customer_entity (full valid email required). Returns order count summary. For partial name search use find_customers_by_name. Password hash is never returned.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| Yes | Exact customer email address (full valid email). For name search use find_customers_by_name — partial strings like 'jigar' are rejected here. | ||
| profile | No | Override the MAGENTO_SQL_PROFILE env var for this call only. Use list_connection_profiles to see available names. | |
| magentoRoot | No | Absolute path to the Magento root (must contain app/etc/env.php). Defaults to MAGENTO_ROOT env var or auto-discovery. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| note | No | ||
| rows | Yes | ||
| sampled | No | ||
| rowCount | Yes | ||
| truncated | No |