which database table to store data like simple product in Magento 2 and its all related info. like custom attribute?

Any Help will be appreciated.

1 Answer 1


Here some information

catalog_product_entity_varchar = Title & Description & URL

catalog_product_entity_decimal = Product Price

catalog_category_product = Assign Product to Category

cataloginventory_stock_item = For Inventory Quantity

catalog_url_rewrite_product_category = For URL Rewrite

eav_attribute = which store ALL Attributes

  • Thanks for the response. Just that not any other table @Rakesh
    – Prits
    Commented Sep 19, 2020 at 7:26
  • okk like 6 tables to see product in frontend and backend @Rakesh
    – Prits
    Commented Sep 19, 2020 at 7:29
  • @Prits here i have main table described, also other many table like:catalog_product_website(website),catalog_product_entity_decimal(price),catalog_product_entity_int (visibility) also other many table Commented Sep 19, 2020 at 7:33
  • Actually i want all tables when a product is created how many tables are there to insert data @Rakesh will you please tell me all the table name or any post link which have all table name.
    – Prits
    Commented Sep 19, 2020 at 7:36
  • 1
    @Prits here all information please look at: magento.stackexchange.com/a/140227/68695 Commented Sep 19, 2020 at 7:39

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.