lyndsiesal Posted May 5, 2006 Share Posted May 5, 2006 I have been searching thru the contributions for something that will allow me to set a quantity per attribute, and also sort them. I'm dealing with shoes so for example I have 2 pair of size 10, 1 pair of size 11, 1 pair of 12. I need to specify those quantites for inventory purposes and also list them in size order. I'm also trying to find something that will allow me to add more pics of an item. I've found all the individual contributions to address my issues, but I'm not slick enought to install them all and not have them conflict with each other. Any help or advice would be so very appreciated!! Quote Link to comment Share on other sites More sharing options...
Istanbutik Posted June 1, 2006 Share Posted June 1, 2006 Hi- I'm struggling with exactly the same problems - both of 'em. Thought I'd give this a bump and also see if you'd figured anythng out. I'll post if I do find anything. I imagine that both of these things have ben discussed here, but searches are not giving much. If any vets could point me to a thread somewhere, I'd much appreciate it. Thanks I have been searching thru the contributions for something that will allow me to set a quantity per attribute, and also sort them. I'm dealing with shoes so for example I have 2 pair of size 10, 1 pair of size 11, 1 pair of 12. I need to specify those quantites for inventory purposes and also list them in size order. I'm also trying to find something that will allow me to add more pics of an item. I've found all the individual contributions to address my issues, but I'm not slick enought to install them all and not have them conflict with each other. Any help or advice would be so very appreciated!! Quote Link to comment Share on other sites More sharing options...
Istanbutik Posted June 1, 2006 Share Posted June 1, 2006 Well.. I think I found the answers to both problems... Don't have them installed yet, but here are links that look promising. http://www.oscommerce.com/community/contributions,1289 and http://www.oscommerce.com/community/contributions,888 Quote Link to comment Share on other sites More sharing options...
dtpreuss Posted June 9, 2006 Share Posted June 9, 2006 I've been looking for the same solution to the same problem of Attributes not sorting properly, no matter how you put them in, but all I've really seen is questions and no real solutions. It's really frusterating to add attributes only to have the code sort them into no real order at all. Quote Link to comment Share on other sites More sharing options...
Buesi Posted July 12, 2006 Share Posted July 12, 2006 I've been looking for the same solution to the same problem of Attributes not sorting properly, no matter how you put them in, but all I've really seen is questions and no real solutions. It's really frusterating to add attributes only to have the code sort them into no real order at all. Are you looking to sort the attribute values by their id or alphabetically? I spent ages looking for this too and found that the solution lies in product_info.php (around line 133 in my file): replace $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 . "'"); with $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 products_options_values_id"); That orders the values by id, to order them by name simply change the last bit to products_options_values_name and if you use STS then in sts_product_info.php do the same as above (around line 65 in my file) Hope that helps! Quote Thanx, Buesi Link to comment Share on other sites More sharing options...
Buesi Posted July 12, 2006 Share Posted July 12, 2006 I've been looking for the same solution to the same problem of Attributes not sorting properly, no matter how you put them in, but all I've really seen is questions and no real solutions. It's really frusterating to add attributes only to have the code sort them into no real order at all. Are you looking to sort the attribute values by their id or alphabetically? I spent ages looking for this too and found that the solution lies in product_info.php (around line 133 in my file): replace $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 . "'"); with $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 products_options_values_id"); That orders the values by id, to order them by name simply change the last bit to products_options_values_name and if you use STS then in sts_product_info.php do the same as above (around line 65 in my file) Hope that helps! Quote Thanx, Buesi Link to comment Share on other sites More sharing options...
dtpreuss Posted July 12, 2006 Share Posted July 12, 2006 Hey, thanx! I'll give this a try. :D Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.