What table is the following?
product title
product meta title
product meta keyword
product meta description
The table db_catalogrule_product became empty after a mass 500. i restored it but i want to at least salvage a few days work if possible. FYI Lesson to you: Download your DB everyday manually that you work on it.
db_catalog_product_entity_varchar??
Also I did not see how to change my avatar. I can't stand being a squishi.
Hi @sparxx
Magento 2 use following table to store the information related to the metadata.
and these are the Main table which define the entity attributes and entity types:
You can check these tables for the values of above listed fields.
I hope it will help you.
Thanks
--
If my answer is useful, please Accept as Solution & give Kudos
Thanks
As per data type, Magento 2 store the values in table.
- name (Type: varchar)
- meta_title (Type: varchar)
- meta_description (Type: varchar)
- meta_keyword (Type: text)
'varchar' attributes type values saved in `catalog_product_entity_varchar` table.
'text' attributes type values saved in `catalog_product_entity_text` table.
Product entity main Table is `catalog_product_entity`.
You can use the Below SQL to check data for one Product into CSV file.
SELECT attribute_code, value FROM catalog_product_entity_varchar LEFT JOIN eav_attribute ON catalog_product_entity_varchar.attribute_id = eav_attribute.attribute_id WHERE entity_type_id='4' and attribute_code IN ('name', 'meta_title', 'meta_description') AND row_id IN (SELECT entity_id FROM catalog_product_entity WHERE sku = '{{SKU}}');
Replace placeholder '{{SKU}}' with product SKU.
Same way you need to check in `catalog_product_entity_text` table for meta_keyword attribute.
Hope this help !!