Attributes Manager

[Lara Croft]

Hi Everyone - with regards to the attributes part of the software i am trying to allocate size and colour choices. you can see this at

planet-moto.co.uk/catalog/product_info.php?cPath=2_9&products_id=7


problem is that it only displays the options in the order that i inserted them into the attributr tables rather than in numerical or appropriate order. For instance - x small should be above small in the list etc.

Is there a way i can change the order of how the drop down lists are displayed or do i have to start over and in admin, put them in the order of how i want them to display in my shop drop down menus if you see what i mean.

Any help would be very much appreciated.

thanks in advance

[michael_s]

Attribute manager - sorting attributes on SELECT
attribute sort

Both should help.

[Lara Croft]

i looked at those threads and didn't really understand them but went back to the attributes section and started from scratch. I inserted the option values in the order that i wanted to see them displayed.
I then added them using the product attributes to a particular model again in the order i wanted them displayed but now they are all mixed up again when i checked in catalog/admin/new_attributes_include.php and the line reads ASC as

$query2 = "SELECT * FROM products_options_values_to_products_options WHERE products_options_id = '$current_product_option_id' ORDER BY products_options_values_id ASC";
but still the list is now not displaying in order and i also noticed that the product attributes list ID numbers are no longer in numerical order (They were for the first 3 i inputed but then for the remainder went out of sync).

the page to see what i mean on is

planet-moto.co.uk/catalog/product_info.php?cPath=2_9&products_id=7

sorry for being a bit slow on this but i'm stuck

thanks

[michael_s]

Either one of those threads I pointed you to explain exactly how to sort. Just change the specified query to exactly what they say, and you will have sorted attributes.

[Lara Croft]

thanks - it was because i couldn't find the pad base file but got there eventually - but now i have sorted that i can't seem to make the attribute manager work - i select the product and then check the boxes according to the sizes i want as options and click the save button (which coincidentally it's image is missing ???) and it transfers the data into the product attributes table but without the product name and therefore will not show up in the attributes of the product in the catalog. Why is it not carrying across the product name - i have to sort this by editing each one in turn and selecting the corresponding product name.

[michael_s]

Remove your modification to the file and try again. If it the problem is only present with the query change, you did not do it correctly. Retrace your steps.

[Lara Croft]

it still does it before the file was modified - can i just confirm that the only file i have to modify is the pad base one ??

[Lara Croft]

ok - looked around the forum and checked this bug fix out -

183: RC3 Attributes Manager Issue - no attributes aren't selected. - Bug Tracker - open source Commerce Maximized :: osCMax

took note of what was written and it has sorted out the problem.

Now hopefully when i mod the page back again to display attributes in order it will carry on working

[Lara Croft]

with regards to this attribute manager -

firstly - attribute selection was saving everything across to product attributes but without the product name so wasn't showing up in catalog product page.

the following bugfix 183 sorted that out and it started to work properly.

then had the issue with product attributes not displaying in the order i wanted them to. ie x small up to xx large in chronological order.

Attribute manager - sorting attributes on SELECT

and

attribute sort

sorted that issue out - or so i thought !!!!!!!!!

It worked for the first 3 of my 7 products within the category but the remaining 4 didn't follow suit and then just displayed the attributes randomly.

You can see what i mean if you look at

planet-moto.co.uk/catalog/index.php?cPath=2_9

and go through each of the 7 products.

I didn't do anything different with the attribute manager for the remaining 4 products that i did with the first 3 which display fine

Now i'm sorry but this is now baffling me beyond belief and i just don't get it - either i'm completely stupid or just plain thick but i'd rather say that i'm just missing something due to inexperience which is why i'm on here looking for help cos it just don't make a blind bit of sense.

Please help me