Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email

Magento Forum

Can anyone help me to understand “position” attribute in catalog_category_entity table? 
Jr. Member
Total Posts:  12
Joined:  2011-07-04

I already migrated my products from opencart to magento.  They are fine now,

As of now I’m trying to migrate my categories from opencart to magento..

But i don’t understand how this position values are used…

I mean i dumped deafult magento database. It has the code like this

INSERT INTO `catalog_category_entity` (`entity_id`, `entity_type_id`, `attribute_set_id`, `parent_id`, `created_at`, `updated_at`, `path`, `position`, `level`, `children_count`) VALUES
(1300'2012-07-30 16:54:16''2012-07-30 16:54:16''1'001),
2331'2012-07-30 16:54:17''2012-07-30 16:54:17''1/2'110);

`entity_id`, - unique id
`entity_type_id`, - I guess its 3 for all categories
`attribute_set_id`, - I guess its 3 too for all categories
`parent_id`, - For root i guess its 1
`created_at`, - timestamp
`updated_at`, - timestamp
`path`, - root cate id/sub cat id/sub cat id ..etc..
`position`, - ????
`level`, - I guess its depth 1/2/3/4 path will have depth 3
`children_count` - How many children categories a parent category have…

So can anyone help me to understand that position attribute?


Magento Community Magento Community
Magento Community
Magento Community
Total Posts:  867
Joined:  2012-07-09

Hello Viruthagiri,

Position is a sort order of the category in the menu or category tree within any specific parent category.
So you may have categories sorted alphabetically or specify position and have them sorted according to your needs.

As I know it is not required and you can leave default values there.

Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top