theman Posted December 27, 2004 Share Posted December 27, 2004 hi how can i sort attributes manually IE/ S/M/L/XL/XXL in that order i cant seem to get it to work when i set it i tried Products Attributes Sort v1.0 (http://www.oscommerce.com/community/contributions,1690) but that is sorting products attributes individually wheere as i would like to sort S/M/L/XL/XXL globally i tried modifying the code to make it work for attribute values instead of atribute product values but i cannot seem to figure it out some direction/help would be great thank you Link to comment Share on other sites More sharing options...
theman Posted December 27, 2004 Author Share Posted December 27, 2004 i think i have to do somethin like the following for this line but i think i got sdomething wrong..im not the best at sql..any help would be great i have a column in the table products_options_values as attribute_sort and then numbered my options 1/2/3/4/5 whichever sortorder i want but still doesent work any help? $products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . "' order by pa.attribute_sort"); Link to comment Share on other sites More sharing options...
OceanRanch Posted December 27, 2004 Share Posted December 27, 2004 Maybe order by pa.attribute_sort should be order by pov.attribute_sort Of course you could just install the attribute sorter contribution.... :-) HTH Tom Link to comment Share on other sites More sharing options...
theman Posted December 27, 2004 Author Share Posted December 27, 2004 Of course you could just install the attribute sorter contribution.... :-) <{POST_SNAPBACK}> ya but that is for sorting individual products attributes while i would like it to be ona global scale there is no point settin each attribute sort order if i only need one sort order for all my products also pov works thx alot for ure help i knew iw as jus missing one small thing :) Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.