Magento Business Intelligence Help Center

Common Magento Tables

After you’ve connected your Magento store, you may use the Data Warehouse Manager to track relevant data fields. These tables are commonly replicated for analytics:

Table name Description
customer_entity Each row in the customer_entity table represents a registered user on your website. Basic customer-level details like their creation date and email address live on this table.
sales_flat_order Each row in the sales_flat_order table represents an order placed on your site. This table contains order-level information such as the order's date, the customer who placed the order, the order total, and discount and coupon code usage.
sales_flat_order_item Each row in the sales_flat_order_item table identifies a specific item from a specific order. Each row contains details such as the product, the quantity purchased, and the order that the given item is associated with.
sales_flat_order_address Each row on the sales_flat_order_address table contains shipping and billing information for a specific order. On the sales_flat_order table, the billing_address_id and the shipping_address_id for a given order refer to a specific row (identified by entity_id) on the sales_flat_order_address table.
catalog_product_entity Each row in the catalog_product_entity table represents a specific product. This includes when that product was created in your Magento account and its sku.
catalog_category_entity Each row in the catalog_category_entity table describes a specific category. With the associated catalog_category_entity_varchar table, you can obtain category information, such as category name.
catalog_category_product Each row in the catalog_category_product table lists a combination of a product and a category. Therefore, a given product can exist on this table multiple times with different categories, and a given category can exist on this table multiple times associated with different products. This table is the "middle-man" between the catalog_category_entity table (which holds category-level details) and the catalog_product_entity table (which holds product-level details).

 

Related:

Was this article helpful?
0 out of 0 found this helpful

Comments

Powered by Zendesk