Where do I find the customer ID in a Magento 2 database?

Where do I find the customer ID in a Magento 2 database?

October 5, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Where do I find the customer ID in a Magento 2 database?

Locating Customer IDs in Magento 2: A Developer’s Guide

As an e-commerce developer working on Magento 2 projects, you’ll frequently need to reference customer data across different parts of the system. This often leads to questions about where specific identifiers like customer_id are defined or stored within the database schema.

Understanding Customer Entities in Magento 2

Magento 2 uses a robust set of tables to store customer-related information. The primary table for managing customers is called customer_entity. This table contains core data such as email addresses, passwords (hashed), and basic personal details like first name, last name, etc.

Here’s an example of what the customer_entity table looks like:

CREATE TABLE `customer_entity` (
  `entity_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `created_at` DATETIME NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` DATETIME NULL DEFAULT CURRENT_TIMESTAMP,
  `created_in` INT(10) UNSIGNED NULL DEFAULT NULL,
  `updated_in` INT(10) UNSIGNED NULL DEFAULT NULL,
  `increment_id` VARCHAR(50) NOT NULL,
  `parent_id` INT(11) UNSIGNED NULL DEFAULT NULL,
  `email` VARCHAR(254) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'Customer Email',
  `website_id` SMALLINT(6) NOT NULL DEFAULT '0',
  PRIMARY KEY (`entity_id`)
);

As you can see, the customer_entity table uses entity_id as the primary key for identifying individual customers. This is the value commonly referred to as customer_id.

Connecting Customer IDs Across Tables

When using plugins like CreativeMinds Multi User Accounts, you’ll find references to customer_id and parent_customer_id in custom tables. These identifiers link to the entity_id field (primary key) in the core customer_entity table.

For example, consider the cminds_multiuseraccounts_subaccount table:

CREATE TABLE `cminds_multiuseraccounts_subaccount` (
  `subaccount_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `parent_customer_id` INT(10) UNSIGNED NULL DEFAULT NULL,
  `customer_id` INT(10) UNSIGNED NULL DEFAULT NULL,
  PRIMARY KEY (`subaccount_id`)
);

Here, both customer_id and parent_customer_id are foreign keys that reference the entity_id in the customer_entity table. This allows you to retrieve full customer details by joining these tables based on the customer_id.

Best Practices for Working with Customer IDs

When dealing with customers in Magento 2, here are some best practices:

  • Always use the core customer_entity table for basic customer data operations.
  • Join custom tables to customer_entity using either entity_id, customer_id, or parent_customer_id as needed.
  • Ensure your code handles NULL values gracefully, especially when dealing with parent-child relationships.

Conclusion

Understanding where Magento 2 stores and references customer IDs is crucial for writing efficient and maintainable code. By familiarizing yourself with the database schema and following best practices, you can navigate customer-related operations with ease.

Remember, accurate data management starts from the core tables. Make sure to check our blog understanding Magento 2 table relationships for a deeper dive into how Magento 2 organizes its database.

Happy coding!

Magento 2 Database Email Customers

Our network