Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

swewico

Members
  • Content count

    9
  • Joined

  • Last visited

Profile Information

  • Real Name
    michael
  1. Currently the sort order is used on the product_info page, this is the relevant code that i could find in that file, that sort and present the dropdown there. <?php $products_options_name_query = tep_db_query("select distinct popt.products_options_id, popt.products_options_name from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "' order by popt.products_options_sort_order"); while ($products_options_name = tep_db_fetch_array($products_options_name_query)) { $products_options_array = array(); $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.products_options_sort_order"); while ($products_options = tep_db_fetch_array($products_options_query)) { $products_options_array[] = array('id' => $products_options['products_options_values_id'], 'text' => $products_options['products_options_values_name']); if ($products_options['options_values_price'] != '0') { $products_options_array[sizeof($products_options_array)-1]['text'] .= ' (' . $products_options['price_prefix'] . $currencies->display_price($products_options['options_values_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) .') '; } } if (isset($cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']])) { $selected_attribute = $cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']]; } else { $selected_attribute = false; } ?> <tr> <td class="main"><?php echo $products_options_name['products_options_name'] . ':'; ?></td> <td class="main"><?php echo tep_draw_pull_down_menu('id[' . $products_options_name['products_options_id'] . ']', $products_options_array, $selected_attribute); ?
  2. It didn't give any error on the page so thats good, but it doesn't sort the attribute drop down either :( Any ideas?
  3. Not yet dont have any coding skills :(, but a guess would be order by patrib.products_options_sort_order ?
  4. Tried but both both gave error, i checked in sql sort order is stored in products_options_sort_order and is in the main table products_attributes
  5. Works perfect, THANKS A LOT! For attributes we have a field for sort order when we add/edit product, i don't remember if this is a standard feature in OSC or a add-on we added, but it would be great if the grid view also would sort the attributes drop down.
  6. Im using the contribe SaleMaker (http://addons.oscommerce.com/info/1340) does anyone know what i need to modify to have the gridlisting display the sale price?
  7. Im using the contribe SaleMaker (http://addons.oscommerce.com/info/1340) does anyone know what i need to modify to have the gridlisting display the sale price?
×