I need to know SQL Table Structure for adding new product.I don't want to any sql queries only want to know effecting tables names.

  • catalog_product_entity - this one is the main product table. It contains the id, sku, attribute set and a few other details
  • catalog_product_entity_int|varchar|text|datetime|decimal - these tables contain attribute values. Each attribute has a type and based on that type the value is inserted in the right table.
  • catalog_product_website - this table contains the association of products on websites (product id, website id). If you don't add the products to at least a website nothing will be inserted here.
  • catalog_category_product - this table contains the association between products and categories (product id, category id). if you don't assign products to categories nothing will be inserted here
  • catalog_category_product_index - this tables also holds the association between products and categories but it is populated after reindexing.
  • catalog_product_entity_gallery, catalog_product_entity_media_gallery, catalog_product_entity_media_gallery_value - these hold references to images assigned to products
  • catalog_product_link this holds the links between products: cross-sells, up-sells, related products, child products of configurable & grouped products
  • catalog_product_link_attribute, catalog_product_link_attribute_decimal|int|varchar, hold the positions and other attribute values that might be related to the links above for the related products up-sells and cross-sells
  • catalog_product_entity_tier_price contains the tier prices for the products
  • catalog_product_option holds the product custom options
  • catalog_product_option_price holds the custom options prices
  • catalog_product_option_title holds the custom options titles
  • catalog_product_option_type_value holds the custom options type values
  • catalog_product_option_type_price holds the custom options price types
  • catalog_product_relation holds a kind of redundant parent-child relation for configurable products
  • catalog_product_index_* hold values for product attributes after reindexing
  • catalog_product_bundle_* hold relations and options for bundle products
  • donwloadable_* - hold data related to downloadable products

That's all I got. I hope I didn't miss anything.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.