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

  • Hello i posted the database schema relation of cataloginventory_stock_item hope it help you a bit.Thank You
    – inrsaurabh
    Mar 11, 2018 at 17:16

2 Answers 2


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.


main table for products in Magento:


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/

Database table name that store product quantity is called cataloginventory_stock_item.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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