Magento – In which table the products quantity are stored

databasemagento-1.9product

What is database table namewhich store the product quantity in Magento 1.9

Best Answer

First of if you want to see the relation between all the tables then you can refer this link

cataloginventory_stock_item have qty column which holds the qty details.

schema

main table for products in Magento:

catalog_product_entity

Above table is the main table, for the child tables table names as catalog_product_entity_prefix.

catalog_product_entity_datetime for Date attributes are stored here. catalog_product_entity_decimal for Product price related values.

catalog_category_entity_text for category attributes

To know more visit below mentioned links

  1. https://magento2.atlassian.net/wiki/spaces/m1wiki/pages/14024879/Catalog+Database+Tables
  2. https://jutesenthil.wordpress.com/2015/01/12/list-of-product-tables-in-magento/
  3. http://anna.voelkl.at/uploads/magento/ce1922.png
  4. https://www.ubertheme.com/magento2/infographic-magento-1-vs-magento-2-database-structure/