which table to store data like simple product in Magento2?

Question

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.

Rakesh Donga · Accepted Answer · 2020-09-19 07:20:34Z

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

answered Sep 19, 2020 at 7:20

Rakesh Donga

5,3242 gold badges24 silver badges57 bronze badges

Thanks for the response. Just that not any other table @Rakesh
– Prits
Sep 19, 2020 at 7:26
okk like 6 tables to see product in frontend and backend @Rakesh
– Prits
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
– Rakesh Donga
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
Sep 19, 2020 at 7:36
1

@Prits here all information please look at: magento.stackexchange.com/a/140227/68695
– Rakesh Donga
Sep 19, 2020 at 7:39

| Show 2 more comments

1 Answer 1