Which Magento 2.x database tables store Product details

Catalog Products are EAV Entity, There are following below 6 Catalog Products Entity Tables, where product details are stored.

[1] – catalog_product_entity
[2] – catalog_product_entity_datetime
[3] – catalog_product_entity_decimal
[4] – catalog_product_entity_int
[5] – catalog_product_entity_text
[6] – catalog_product_entity_varchar

[1] – catalog_product_entity:: stores (SKU, Creation & Update Date) of products


[2] – catalog_product_entity_datetime:: stores (Special From Date) of products


[3] – catalog_product_entity_decimal:: stores product’s price


[4] – catalog_product_entity_int:: stores following below data values

manufacturer
color,
features_bags,
manufacturer,
tax_class_id,
visibility,
is_featured,
material,
pattern,
occassion,
brand,
size


[5] – catalog_product_entity_text::


[6] – catalog_product_entity_varchar:: stores following below data values

 image,
   meta_description,
   meta_title,
   name,
   thumbnail,
   url_key,
   url_path,
   country_of_origin,
   country_of_shipping,
   gift_message_available,
   hsn_codes,
   image,
   in_the_box,
   meta_description,
   meta_title,
   name,
   options_container,
   package_dimensions_breadth,
   package_dimensions_height,
   package_dimensions_length,
   rollover_image,
   small_image,
   swatch_image,
   thumbnail,
   unit_sets,
   url_key,
   url_path,

Magento 2 All Database Tables [500 & more Tables]

Which Magento 2 database tables store Product details


Which Magento 2 database tables store Category details


How To Delete Magento 2 Categories & Products in Magento 2


Which Magento 2 Database Table Store Bundles Product


Which Magento 2 Database Table Having All Catalog (Categories & Products) URLs Rewrite Storage Data


Which Magento 2 Database Tables Store Product Attributes


How To Delete Magento 2 Products


How To Delete Magento 2 Categories


How To Delete Magento 2 Categories & Products in Magento 2


Which Magento 2 Database Table Store Customer Group Price of products


Which Magento 2 Database Table Store Products Special Discount Price

Leave a Reply

Your email address will not be published. Required fields are marked *