Contents
How to find product category in Magento table?
With the associated catalog_category_entity_varchar table and the catalog_category_product mapping table, you can obtain category information for each product. Each row in the catalog_category_product table lists a combination of a product and a category.
What does the customer entity table in Magento mean?
This includes when that product was created in your Magento account and its SKU. Each row in the customer_entity table represents a registered user on your website. Basic customer-level details like their registration date and email address live on this table.
How many Magento tables are there in MBI?
Although this offers a great starting point, most Magento instances generate tens if not hundreds of additional tables which can provide critical insight into the performance of your business. Below is a list of some of the more common tables that MBI customers utilize.
What do the rows in the Magento order table represent?
Each row in the sales_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. Each row on the sales_order_address table contains shipping and billing information for a specific order.
How can I track Magento data in MBI?
Below is a list of some of the more common tables that MBI customers utilize. After you connect your Magento instance to MBI, you can use the Data Warehouse Manager to track relevant data fields. Each row in the catalog_category_entity table describes a specific category.
When to delete a Magento sales order table?
Due to the potential size of this table, Magento recommends you periodically delete records if certain criteria are met, such as if there are any unconverted carts older than 60 days. Each row in the sales_order table represents an order placed on your site.
How many Magento Commerce tables are there in MBI?
When you first connect a Magento instance to MBI, MBI automatically replicates data from some of your Magento commerce tables (typically 4-6 tables) in order to configure the initial set of dashboards and reports.