Stitch Documentation
has moved!

Please update your bookmarks to https://www.stitchdata.com/docs

If you're not automatically redirected after 5 seconds, click here.

Expected Magento Data

After you’ve connected your Magento store, you can use the Integrations Details page to easily track relevant data fields from your Magento database for analysis.

After the setup for Magento is complete, the following tables will be created in your data warehouse:

Table name Description
Customers The customer_entity and related tables describe the information associated with each registered customer in your database, like their email address and registration date. With this information, you can begin segmenting by customer-level attributes and cohorts.
Orders The sales_flat_order table records all orders, including the created_at timestamp that the order was placed and the base_grand_total field that sums up revenue. These fields will be the basis for your order-level metrics. If the order was made by a registered customer, the customer_id field will link back to the  customer_entity table to allow analysis on customer buying behavior.
Order items The sales_flat_order_item table records each item belonging to an order. This includes the price and qty_ordered fields, as well as the order_id field which connects to the sales_flat_order table. This table is the foundation for metrics like “Item sold”, and allows you to segment by product and product type.
Products The catalog_product_entity table stores information on product-level attributes, like category, size, and color.
Categories Your products will belong to one or many different product categories, depending on how your Magento build is set up. The catalog_category_entity table stores the hierarchy of these categories (Apprarel -> Tops -> T-Shirts, for example), and the catalog_category_product table logs the connections between your products and those categories.
Was this article helpful?
0 out of 0 found this helpful

Comments

Questions or suggestions? If something in our documentation is unclear, let us know in the comments!