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 Stack Exchange is a question and answer site for users of the Magento e-Commerce platform. It only takes a minute to sign up.
Sign up to join this communityMagento 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.
https://jutesenthil.wordpress.com/2015/01/12/list-of-product-tables-in-magento/
https://inchoo.net/magento/magentos-database-layout-and-its-eav-structure/
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
WHEREentity_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.