Admin Option Value Sorter Issue for categories having too many produts

[pizza392]

Admin->Catelog->Option Value Sorter, i tried updating option values sort, this is a very useful tool,
i successfully updated the sorts of one product, or one category not having too many products,

but when i tried the categories having many products or products with too many attributes, failed

is there any other way to update those option value sort? what do i update them manually from phpmyadmin?
i just want the value sorted as the sort i set for each option value, i don't know why i have to update the sort each time after i add or modify the attributes to the products, they couldn't be sorted automatically just as the sort i set in admin?

any idea?

[Ajeh]

First, you need to update the Option Values default Sort Order for each Option Name ...

Update Option Values Sort Order
Select an Option Name:

Once the defaults are set, you need to run the:

Update All Products' Attribute Sort Orders
to match Option Value Default Sort Orders: UPDATE

To apply those new Option Values default Sort Orders to your existing Products ...

[pizza392]

do you mean update those sorts from admin by clicking on the update button?

[Ajeh]

First use the settings in:

Update Option Values Sort Order
Select an Option Name:

Select the Option Name from the dropdown and click EDIT ...

Set the Sort Order and click UPDATE SORT ORDER ...

You will return back to the screen and see lower down the:

Update All Products' Attribute Sort Orders
to match Option Value Default Sort Orders:

Click the UPDATE button and ALL of your Option Names will have ALL their Option Values updated on ALL the Products in your store to ALL existing Option Value default Sort Orders ...

Now, when you add new Attributes to Products in the Attributes Controller, if you do not set a Sort Order, then it will pick up the Option Value default Sort Orders ...

[pizza392]

yep i did use these buttons for updating the sort, i successfully updated them
my problem is that this function doesn't work for the categories with too many products and the products with too many attributes, it would go to blank page due to max execution time
so i need to run the sql to update the sort from phpmyadmin or admin sqlpatches, but i don't know what sql do i run

[Ajeh]

How many Categories do you have?

How many Products do you have?

How many Attributes do you have?

[pizza392]

for certain categories, handreds products in each category
for certain products, hundreds attributes of each product
since i don't want to change them, they work well except the option value sorter updating issue
i want to run the sql to update those sorts if it's possible

[Ajeh]

Could you go to phpMyAdmin and look at your tables and tell me how many records are in:
products
categories
products_to_categories

[pizza392]

3000 around for table products, 300 for categories and 2000 for products to categories

[Ajeh]

Sorry, I forgot one ... how many are in:
products_attributes