Hi,
Our Magento site is in three countries each have different languages, there is a global setting where the names and categories are saved with global names.
Can anyone help me to find out which all are the tables that is storing those global names.
Solved! Go to Solution.
Hi @sandeep_salim,
Products and categories data are saved in eav tables.
For
Product: catalog_product_entity
Category: catalog_category_entity
Global data are saved with store_id = 0.
Different language data are saved with different store_id in the same tables.
You can also check attribute id for the name (category and product) from the eav_attribute table.
I hope it will help you!
@Vimal
Thanks a lot! This is exactly what i was looking for,Didn't know the globals were saved with store_id=0
Hi @sandeep_salim,
Products and categories data are saved in eav tables.
For
Product: catalog_product_entity
Category: catalog_category_entity
Global data are saved with store_id = 0.
Different language data are saved with different store_id in the same tables.
You can also check attribute id for the name (category and product) from the eav_attribute table.
I hope it will help you!