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 http://www.novusweb.com/1622/e-commerce-technology/fixing-magento-category-order-problems/ but we definitely have the 'position' set on each category with a number and the table catalog_category_entity confirms this.