I want a text file with all the products with below columns: id, title, description, link, image_link, availability, price, sale_price

How can I export this data from phpMyAdmin?

I am using Magento 2.3.3

Please any suggestions?


Magento does not save Product data in a single table. It is using an Eav Structure for saving Product attribute data.So first you have to understand this Eav structure then you able to get your required data.

At Magento's, id, title, description, link, image_link are eav attributes and Product main table catalog_product_entity.

You can find attributes table type from eav_attribute by running below query:

SELECT * FROM eav_attribute WHERE entity_type_id = 4

Magento 2,entity_type_id for the product is 4 and that why I added condition ``entity_type_id = 4`

From backend_type column of eav_attribute table, you understand the table for save that attribute value like description backend type is text.it means value save for this attribute at catalog_product_entity_text

So, you need to build a Mysql joining query on table catalog_product_entity respective table with attributes.

  • Thank you so much for your reply sir. Sorry, I am not that expert to run queries using join commands. Is there any pre-developed query to get the results that I want. Please help me if any. – Sonu Sonu Nov 26 '19 at 8:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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