Magento - Select some customer infos

Magento - Select some customer infos

September 30, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Magento - Select some customer infos

Retrieving Customer Information in Magento

As a developer working on custom Magento modules, you may find yourself needing to retrieve specific customer data for various purposes. In this post, we’ll guide you through the process of crafting a database query to fetch the address, name, and surname information for one or more customers.

Before diving into the code, let’s quickly orient ourselves with the relevant tables in the Magento database:

  1. customer_entity - Stores the primary customer data like entity_id (customer ID), created_at, updated_at, etc.
  2. customer_address_entity - Contains the address information for each customer.

The key relationship here is between customer_entity and customer_address_entity via the entity_id field, which is the customer’s internal Magento ID.

Writing a Query to Fetch Customer Data

To write an efficient query that retrieves the required data, we can use the following SQL structure:

SELECT
    ce.entity_id AS customer_id,
    ce.firstname AS first_name,
    ce.lastname AS last_name,
    ca.street AS address_street,
    ca.city AS address_city,
    ca.postcode AS address_postcode,
    ca.country_id AS country_code
FROM
    customer_entity AS ce
JOIN
    customer_address_entity AS ca ON (ce.entity_id = ca.parent_id)
WHERE
    -- Add your condition here, e.g., `ce.created_at >= '2022-01-01'`

This query joins the two tables and selects a predefined set of columns from each. The result will be a list of rows with the customer ID, first name, last name, address street, city, postcode, and country code for customers who meet your specified condition.

Optimizing Your Query

To optimize performance, especially when dealing with large datasets:

  1. Add an index on ca.parent_id if it doesn’t exist already. This field is the foreign key connecting to the customer entity ID.
  2. Limit the number of rows returned using a statement like LIMIT 50. This is particularly useful for debugging purposes or when you know the dataset size is manageable.

Remember, always be mindful of database performance and ensure that your queries are as efficient as possible to avoid straining the system.

Conclusion

In this post, we’ve demonstrated how to craft a simple but effective query to retrieve customer information in Magento. By understanding the core tables involved and leveraging proper join operations, you can efficiently obtain the necessary data for your custom modules or extensions.

For more advanced techniques in Magento development, such as working with collections and EAV (Entity Attribute Value) structures, we recommend exploring the official Magento Developer Documentation and checking out resources from our team at Laravel Company.

Happy coding! Let us know if you have any other questions about Magento development.

Database Extensions Customers

Our network