What are the basic tables which need to use, so Product data will be inserted with image and custom attribute.

Which is visible both in frontend and admin.

Please Any one point out the table name for the products entry.

Any help is appreciated.

1 Answer 1


Product image paths are stored in 'catalog_product_entity_varchar' table in Magento 2.

Below you can see attribute_id field which holds the meaning of each value, for example, attribute_id with values 87, 88, 89 are the attributes for the image.

enter image description here enter image description here enter image description here

enter image description here

Additionally if you wish to figure out how you can store product's images programmatically, you may find this article useful : https://magemeta.com/2020/03/31/magento-2-add-image-to-product-programmatically/

  • Thanks for your response @Natha what about custom attribute and product info.
    – Prits
    Sep 19, 2020 at 5:21
  • entity_id you see in the table is product id the image or attribute is associated with. Sep 19, 2020 at 5:23
  • Yupp got that bit i want to know about all tables that stores the data of product @Natha
    – Prits
    Sep 19, 2020 at 5:42
  • In question you asked related to images of product, please be specific. Anyway, you can find tables related to product starting with prefix as “catalog_product_”. Sep 19, 2020 at 5:44
  • Ah, sorry for that i want to know about all the tables where product data is stored and thought asked the same question. 'catalog_product_' prefix has 74 tables so all the tables would be used @Natha
    – Prits
    Sep 19, 2020 at 6:22

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.