Category sort order for different stores

by Gavin   Last Updated September 11, 2019 16:09 PM

We want to change the order of categories so they are different in our stores but every time we change the order in say the FRENCH store, the UK store is also changed.

Looking at the database it seems there is one table which powers the sort order. catalog_category_entity

Can this not be done for stores sharing the one default category tree?

We have used the 3rd party software emagicone for doing mass updates in the past and there is a discussion about this being an issue here but we definitely have the 'position' set on each category with a number and the table catalog_category_entity confirms this.

Answers 2

Any need for reorganization of categories in different store scopes means that you have to duplicate your categories under distinct root categories. Sorry - it's a limitation to Magento's tree modeling of the categories which ultimately resolves (as you noticed) to the global-scope sorting attribute on the entity table.

February 19, 2014 00:11 AM

You can do that using custom attribute. in Magento 2. I think same could be done in M1.

  1. Add new product attribute with seting "Used for Sorting in Product Listing" to Yes. Add new attribute to your attribute set.

  2. Assing numbers for products.

  3. Catalog => Categories => choice Category => change store view, and change "Available Product Listing Sort By" and "Default Product Listing Sort By" to use your attribute.

September 11, 2019 15:33 PM

Related Questions

Multi-Store Category Disable Not Working

Updated January 31, 2018 08:09 AM