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.
id, title, description, link, image_link are eav attributes and Product main table
You can find attributes table type from
eav_attribute by running below query:
SELECT * FROM
entity_type_id for the product is 4 and that why I added condition ``entity_type_id = 4`
backend_type column of
eav_attribute table, you understand the table for save that attribute value like
description backend type is
value save for this attribute at
So, you need to build a Mysql joining query on table
catalog_product_entity respective table with attributes.