Attribute Option Sort Order

[stlads]

I am having an issue with sorting Attribute Options in the Admin, when editing products in Core 17. It appears that the new number based ordering does not sort the Attribute Options. Am I missing something. I can sort the attributes, but when option order is changed and I hit update, the order is not changed.

[Laura Schindler]

Re: Attribute Option Sort Order

Hello,

We just identified this yesterday. If you look in s01_options you will probably see that the product_id field is set to zero.

If you open a ticket with us we can take care of it for you: [email protected]

Thanks.

[stlads]

Re: Attribute Option Sort Order

Hello,

We just identified this yesterday. If you look in s01_options you will probably see that the product_id field is set to zero.

If you open a ticket with us we can take care of it for you: [email protected]

Thanks.

You are correct product_id is set to zero. I am a developer and have a number of clients that have either upgraded to core 17 or are scheduled to do it shortly. Do we individually have you take care of it or is there a fix that can be deployed by the developers?

[Laura Schindler]

Re: Attribute Option Sort Order

By chance, do you know how the attributes were added? Manually or some sort of module?

We're not sure what causes this error, but if it's a mySQL store you can run this command:

update s01_Options set product_id = ( select product_id from s01_Attributes where id = s01_Options.attr_id );

DISCLAIMER: For any end users reading this that run into this issue- please do not make changes to your store's databases unless you have an intimate knowledge of Miva Merchant's database structure. ALWAYS make a backup before making any major changes to your store. If you have any doubts or if you don't know what you are doing, please contact our support department for help.

Sorry for the big scary warning, but I don't want to be responsible for anyone breaking their store. :-)

[stlads]

Re: Attribute Option Sort Order

By chance, do you know how the attributes were added? Manually or some sort of module?

I think the client that brought it to our attention adds the attributes manually. I was also able to duplicate this by making a copy of the attribute template to a product. When I tried to sort, nothing happened.

[stlads]

Re: Attribute Option Sort Order

We're not sure what causes this error, but if it's a mySQL store you can run this command:

It appears that this issue has now been reported by a couple of our clients. After applying the query fix you provided. When new attributes are inserted, wouldn't the data get messed up again? Any chance you can release a patch script that can be run?

[scott hayden]

Re: Attribute Option Sort Order

I am having the same issue reordering a set of copied attributes. Is there patch status or work around for this issue? Thanks!

[legacytack]

Re: Attribute Option Sort Order

I'm having this problem too. It seems to be just with attributes copied from a template. I tried manually adding an attribute list and I was able to re-sort those options.

[sebenza]

Re: Attribute Option Sort Order

Is there any kind of status update on this bug?

[Rick Wilson]

Re: Attribute Option Sort Order

It should be fixed in PR6 are you still seeing it after installing PR6?

[sebenza]

Re: Attribute Option Sort Order

Well... I just ran the MySQL query. So, maybe it will be solved going forward. I will keep you posted.

[sebenza]

Re: Attribute Option Sort Order

The user just reported to me that that the issue is back again. They are unable to sort the attributes. All updates are installed.

[delcorsets]

Re: Attribute Option Sort Order

I am having this issue as well running PR6. Attributes copied from templates only.. any further updates?

[Rick Wilson]

Re: Attribute Option Sort Order

You should open a support ticket, we're not aware of this still being an issue. Email [email protected]