cancel
Showing results for 
Search instead for 
Did you mean: 

Table that stores Global names for products and categories,

SOLVED

Table that stores Global names for products and categories,

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.

2 ACCEPTED SOLUTIONS

Accepted Solutions

Re: Table that stores Global names for products and categories,

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!

View solution in original post

Re: Table that stores Global names for products and categories,

@Vimal

 

Thanks a lot! This is exactly what i was looking for,Didn't know the globals were saved with store_id=0 Smiley Happy

 

 

View solution in original post

2 REPLIES 2

Re: Table that stores Global names for products and categories,

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!

Re: Table that stores Global names for products and categories,

@Vimal

 

Thanks a lot! This is exactly what i was looking for,Didn't know the globals were saved with store_id=0 Smiley Happy