Catalog Database Tables

Last modified by joaneunlee on Thu, July 5, 2012 16:06
Source|Old Revisions  

=

Idea

If you wonder what’s the idea behind this wiki page I’ll tell you ;) Actully I’m working on a database product import for my company. But the main issue for this task is to figure out which tables I have to use for this import. I searched the whole Magento wiki but I couldn’t found any information about the intension/functionality behind the database tables of Magento.

An import based on sql statements will be massivly faster than a regular Magento import, so this is an very important task for us. (MAGMI won’t work for us if think of this project)

I think a good begining is to write a (very short) description about the catalog tables. If this is done everbody can get an idea about the effects this databases having in Magento. Maybe the next step could be to describe the tables fields to get more knowledge.

If think this is a good idea please participate in this page and add the missing descriptions.

p.s. and feel free to correct my bad english.

Category

Category Entity

catalog_category_entity - This table contains information about category entities.

catalog_category_entity_datetime - Values of category attributes with the datatype “datetime”.

catalog_category_entity_decimal - Values of category attributes with a floating point number content.

catalog_category_entity_int - Values of category attributes with the datatype “integer”.

catalog_category_entity_text - Values of category attributes with the datatype “text” (unlimited string).

catalog_category_entity_varchar - Values of category attributes with the datatype “varchar” (limited string, maximum 255 characters).

Unknown Functionality

catalog_category_anc_categs_index_idx - ?

catalog_category_anc_categs_index_tmp - ?

catalog_category_anc_products_index_idx - ?

catalog_category_anc_products_index_tmp - ?

Crosstables

catalog_category_product - Connection beween category entity and product entity

catalog_category_product_index - Setting the store of category/product-connection

catalog_category_product_index_enbl_idx - ?

catalog_category_product_index_enbl_tmp - ?

catalog_category_product_index_idx - ?

catalog_category_product_index_tmp - ?

Products

Attributes

catalog_eav_attribute - ?

Bundleproducts

catalog_product_bundle_option - Bundleitems/-options of a product entity (producttype is bundle-product).

catalog_product_bundle_option_value - Naming of a bundleitem/-option.

catalog_product_bundle_price_index - ?

catalog_product_bundle_selection - Bundlecombinations.

catalog_product_bundle_selection_price - ?

catalog_product_bundle_stock_index - Stock values of bundleproducts.

Productstatus

catalog_product_enabled_index - Defines the visibility status of a product entity in the Magento stores.

Product Entity

catalog_product_entity - This table contains information about product entities.

catalog_product_entity_datetime - Values of product attributes with the datatype “datetime”.

catalog_product_entity_decimal - Values of product attributes with a floating point number content.

catalog_product_entity_gallery - ?

catalog_product_entity_int - Values of product attributes with the datatype “integer”.

catalog_product_entity_text - Values of product attributes with the datatype “text” (unlimited string).

catalog_product_entity_varchar - Values of product attributes with the datatype “varchar” (limited string, maximum 255 characters).

catalog_product_entity_tier_price - Values of product tier prices. The datatype is a floating point number.

Product Media

catalog_product_entity_media_gallery - Linking of images to a specified product entity based on the attribute_id.

catalog_product_entity_media_gallery_value - Defines the position and the visibility of a product-media.

Produkt Index

catalog_product_index_eav - ?

catalog_product_index_eav_decimal - ?

catalog_product_index_eav_decimal_idx - ?

catalog_product_index_eav_decimal_tmp - ?

catalog_product_index_eav_idx - ?

catalog_product_index_eav_tmp - ?

catalog_product_index_price - ?

catalog_product_index_price_bundle_idx - ?

catalog_product_index_price_bundle_opt_idx - ?

catalog_product_index_price_bundle_opt_tmp - ?

catalog_product_index_price_bundle_sel_idx - ?

catalog_product_index_price_bundle_sel_tmp - ?

catalog_product_index_price_bundle_tmp - ?

catalog_product_index_price_cfg_opt_agr_idx - ?

catalog_product_index_price_cfg_opt_agr_tmp - ?

catalog_product_index_price_cfg_opt_idx - ?

catalog_product_index_price_cfg_opt_tmp - ?

catalog_product_index_price_downlod_idx - ?

catalog_product_index_price_downlod_tmp - ?

catalog_product_index_price_final_idx - ?

catalog_product_index_price_final_tmp - ?

catalog_product_index_price_idx - ?

catalog_product_index_price_opt_agr_idx - ?

catalog_product_index_price_opt_agr_tmp - ?

catalog_product_index_price_opt_idx - ?

catalog_product_index_price_opt_tmp - ?

catalog_product_index_price_tmp - ?

catalog_product_index_tier_price - ?

catalog_product_index_website - ?

Product Links (e.g. Crossseller)

catalog_product_link - ?

catalog_product_link_attribute - ?

catalog_product_link_attribute_decimal - ?

catalog_product_link_attribute_int - ?

catalog_product_link_attribute_varchar - ?

catalog_product_link_type - ?

Product Options

catalog_product_option - ?

catalog_product_option_price - ?

catalog_product_option_title - ?

catalog_product_option_type_price - ?

catalog_product_option_type_title - ?

catalog_product_option_type_value - ?

Unknown Functionality

catalog_product_relation - ?

catalog_product_super_attribute - ?

catalog_product_super_attribute_label - ?

catalog_product_super_attribute_pricing - ?

catalog_product_super_link - ?

catalog_product_website - ?

catalog_compare_item - ?




 

Magento 2 GitHub Repository

Magento Job Board - Some sort of tag line goes here

Latest Posts| View all Jobs