Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Attribute Sorter and Copier v5.0


Guest

Recommended Posts

I just installed about every contribution I can find today dealing with sorting your product attributes. (3 of them I believe)

 

I finially went with the attribute sorter and copier contribution because it has the best of all of them, however I am having a very nagging problem.

 

In every case I could install the contribution and get everything running (admin area working perfectly), but when I go to check it in the catalog the attributes are not sorting out. It seems as though it is still pulling the sort order from options_values_id, instead of the sort order. Has anyone else faced this problem? does anyone have a clue on what it could be?

 

I am including below a copy of my product_info.php file if someone could please give it a going over and see what I have done incorrectly. (side note I have the ultimate images, header tag controller, options as images, ask question contributions installed that are also part of this file.

 

<?php

/*

$Id: product_info.php,v 1.98 2003/09/02 18:52:33 project3000 Exp $

 

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright © 2003 osCommerce

 

Released under the GNU General Public License

*/

 

require('includes/application_top.php');

 

require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_PRODUCT_INFO);

// WebMakers.com Added: Attribute Sorter - Definitions

// Move to /languages/english

 

//$product_check_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");

//$product_check = tep_db_fetch_array($product_check_query);

?>

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">

<html <?php echo HTML_PARAMS; ?>>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">

<?php

// BOF: WebMakers.com Changed: Header Tag Controller v1.0

// Replaced by header_tags.php

if ( file_exists(DIR_WS_INCLUDES . 'header_tags.php') ) {

require(DIR_WS_INCLUDES . 'header_tags.php');

} else {

?>

<title><?php echo TITLE ?></title>

<?php

}

// EOF: WebMakers.com Changed: Header Tag Controller v1.0

?>

<base href="<?php echo (getenv('HTTPS') == 'on' ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">

<link rel="stylesheet" type="text/css" href="stylesheet.css">

<script language="javascript"><!--

function popupWindow(url) {

window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,res

izable=yes,copyhistory=no,width=100,height=100,screenX=150,screenY=150,top=150,le

ft=150')

}

//--></script>

</head>

<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">

<!-- header //-->

<?php require(DIR_WS_INCLUDES . 'header.php'); ?>

<!-- header_eof //-->

 

<!-- body //-->

<table border="0" width="100%" cellspacing="3" cellpadding="3">

<tr>

<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">

<!-- left_navigation //-->

<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>

<!-- left_navigation_eof //-->

</table></td>

<!-- body_text //-->

<td width="100%" valign="top"><form name="cart_quantity" method="post" action="<?php echo tep_href_link(FILENAME_PRODUCT_INFO, tep_get_all_get_params(array('action')) . 'action=add_product', 'NONSSL'); ?>"><table border="0" width="100%" cellspacing="0" cellpadding="0">

<?php

$product_info = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . $HTTP_GET_VARS['products_id'] . "' and pd.products_id = '" . $HTTP_GET_VARS['products_id'] . "' and pd.language_id = '" . $languages_id . "'");

if (!tep_db_num_rows($product_info)) { // product not found in database

?>

<tr>

<td class="main"><br><?php echo TEXT_PRODUCT_NOT_FOUND; ?></td>

</tr>

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

</tr>

<tr>

<td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">

<tr class="infoBoxContents">

<td><table border="0" width="100%" cellspacing="0" cellpadding="2">

<tr>

<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>

<td align="right"><br><a href="<?php echo tep_href_link(FILENAME_DEFAULT, '', 'NONSSL'); ?>"><?php echo tep_image_button('button_continue.gif', IMAGE_BUTTON_CONTINUE); ?></a></td>

<!-- old <td align="right"><?php echo '<a href="' . tep_href_link(FILENAME_DEFAULT) . '">' . tep_image_button('button_continue.gif', IMAGE_BUTTON_CONTINUE) . '</a>'; ?></td> -->

<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>

</tr>

</table></td>

</tr>

</table></td>

</tr>

<?php

} else {

// BOF MaxiDVD: Modified For Ultimate Images Pack!

$product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, p.products_image_med, p.products_image_lrg, p.products_image_sm_1, p.products_image_xl_1, p.products_image_sm_2, p.products_image_xl_2, p.products_image_sm_3, p.products_image_xl_3, p.products_image_sm_4, p.products_image_xl_4, p.products_image_sm_5, p.products_image_xl_5, p.products_image_sm_6, p.products_image_xl_6, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");

// EOF MaxiDVD: Modified For Ultimate Images Pack!

$product_info_values = tep_db_fetch_array($product_info);

 

tep_db_query("update " . TABLE_PRODUCTS_DESCRIPTION . " set products_viewed = products_viewed+1 where products_id = '" . $HTTP_GET_VARS['products_id'] . "' and language_id = '" . $languages_id . "'");

 

//old tep_db_query("update " . TABLE_PRODUCTS_DESCRIPTION . " set products_viewed = products_viewed+1 where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and language_id = '" . (int)$languages_id . "'");

if ($new_price = tep_get_products_special_price($product_info_values['products_id'])) {

$products_price = '<s>' . $currencies->display_price($product_info_values['products_price'], tep_get_tax_rate($product_info_values['products_tax_class_id'])) . '</s> <span class="productSpecialPrice">' . $currencies->display_price($new_price, tep_get_tax_rate($product_info_values['products_tax_class_id'])) . '</span>';

} else {

$products_price = $currencies->display_price($product_info_values['products_price'], tep_get_tax_rate($product_info_values['products_tax_class_id']));

}

$products_attributes = tep_db_query("select popt.products_options_name from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . $HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . $languages_id . "'");

if (tep_db_num_rows($products_attributes)) {

$products_attributes = '1';

} else {

$products_attributes = '0';

}

?>

<tr>

<td><table border="0" width="100%" cellspacing="0" cellpadding="2">

<?php

// BOF: WebMakers.com Added: Show Category and Image

if (SHOW_CATEGORIES=='1') {

?>

<tr><td colspan="2"><table align="right">

<tr>

<td class="main" align="center"><?php echo tep_image(DIR_WS_IMAGES . tep_get_categories_image(tep_get_products_catagory_id($product_info_values['products_id']))); ?></td>

</tr>

<tr>

<td class="main" align="center"><?php echo tep_get_categories_name(tep_get_products_catagory_id($product_info_values['products_id'])); ?></td>

</tr>

</table></td></tr>

<?php

}

// EOF: WebMakers.com Added: Show Category and Image

?>

<tr height="40">

<td class="pageHeading"><?php echo $product_info_values['products_name']; ?></td>

<td align="right" class="pageHeading"><?php echo $products_price; ?></td>

</tr>

<?php

if (PRODUCT_LIST_MODEL) {

echo ' <tr>' . "\n" .

' <td colspan="2" class="pageHeading">' . $product_info_values['products_model'] . '</td>' . "\n" .

' </tr>' . "\n";

}

?>

</table></td>

</tr>

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

</tr>

<tr>

<td class="main"><table border="0" cellspacing="0" cellpadding="2" align="right">

<?php

if ($product_info_values['products_image'] != '') {

?>

<tr>

<td align="center" class="smallText">

 

<!-- // BOF MaxiDVD: Modified For Ultimate Images Pack! //-->

<?php

if ($product_info['products_image_med']!='') {

$new_image = $product_info['products_image_med'];

$image_width = MEDIUM_IMAGE_WIDTH;

$image_height = MEDIUM_IMAGE_HEIGHT;

} else {

$new_image = $product_info['products_image'];

$image_width = SMALL_IMAGE_WIDTH;

$image_height = SMALL_IMAGE_HEIGHT;}?>

<script language="javascript"><!--

document.write('<?php echo '<a href="java script:popupWindow(\\\'' . tep_href_link(FILENAME_POPUP_IMAGE, 'pID=' . $product_info_values['products_id']) . '\\\')">' . tep_image(DIR_WS_IMAGES . $product_info_values['products_image'], addslashes($product_info_values['products_name']), SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '<br>' . TEXT_CLICK_TO_ENLARGE . '</a>'; ?>');

//--></script>

<tr>

<td align="center" class="smallText">

<?php // ################### Ask a question ############## ?>

<a href="ask_a_question.php?products_id=<?php echo $product_info['products_id']; ?>" ONMOUSEOVER="window.status='.<?php echo TEXT_QUESTION ; ?> .' ; return true">

<?php echo TEXT_QUESTION ; ?> <b><?php echo $product_info['products_name']; ?></b></a>

<?php // ################ end added ask a question ############ ?>

</td>

</tr>

<noscript>

<?php echo '<a href="' . tep_href_link(DIR_WS_IMAGES . $product_info_values['products_image_med']) . '">' . tep_image(DIR_WS_IMAGES . $product_info_values['products_image'], $product_info_values['products_name'], $image_width, $image_height, 'class=shadow1', 'hspace="5" vspace="5"') . '<br>' . tep_image_button('image_enlarge.gif', TEXT_CLICK_TO_ENLARGE) . '</a>'; ?>

</noscript>

<!-- // EOF MaxiDVD: Modified For Ultimate Images Pack! //-->

 

</td>

</tr>

<?php

}

?>

</table><p><?php echo stripslashes($product_info_values['products_description']); ?></p>

<?php

if (OPTIONS_AS_IMAGES_ENABLED == 'false'){

$products_attributes_query = tep_db_query("select count(*) as total 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 . "'");

$products_attributes = tep_db_fetch_array($products_attributes_query);

if ($products_attributes['total'] > 0) {

?>

<table border="0" cellspacing="0" cellpadding="2">

<tr>

<td class="main" colspan="2"><?php echo TEXT_PRODUCT_OPTIONS; ?></td>

</tr>

<?php

///////////////////////////////////////////////////////////////////////////

// BOF: attribute options

if ($products_attributes == '1') {

$products_options_name = tep_db_query("select distinct popt.products_options_id, popt.products_options_name, popt.products_options_sort_order from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . $HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . $languages_id . "'" . " order by popt.products_options_sort_order");

echo '<b>' . TEXT_PRODUCT_OPTIONS . '</b><br>';

echo '<table border="0" cellpading="0" cellspacing"0">';

while ($products_options_name_values = tep_db_fetch_array($products_options_name)) {

$selected = 0;

$products_options_array = array();

echo '<tr><td class="main">' . $products_options_name_values['products_options_name'] . ':</td><td>' . "\n";

// BOF: WebMakers.com Added: Attributes Copy and Sort

if ( PRODUCTS_OPTIONS_SORT_BY_PRICE !='1' ) {

$products_options = tep_db_query("select pa.products_options_sort_order, 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 = '" . $HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . $products_options_name_values['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . $languages_id . "'" . " order by pa.products_options_sort_order, pov.products_options_values_name");

} else {

$products_options = tep_db_query("select pa.products_options_sort_order, 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 = '" . $HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . $products_options_name_values['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . $languages_id . "'" . " order by pa.products_options_sort_order, pa.options_values_price");

}

// EOF: WebMakers.com Added: Attributes Copy and Sort

while ($products_options_values = tep_db_fetch_array($products_options)) {

$products_options_array[] = array('id' => $products_options_values['products_options_values_id'], 'text' => $products_options_values['products_options_values_name']);

if ($products_options_values['options_values_price'] != '0') {

$products_options_array[sizeof($products_options_array)-1]['text'] .= ' (' . $products_options_values['price_prefix'] . $currencies->display_price($products_options_values['options_values_price'], tep_get_tax_rate($product_info_values['products_tax_class_id'])) .') ';

}

}

echo tep_draw_pull_down_menu('id[' . $products_options_name_values['products_options_id'] . ']', $products_options_array, $cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name_values['products_options_id']]);

echo '</td></tr>';

}

echo '</table>';

}

//Options as Images. Add the curly bracket as shown on the next line

} //added by me to solve problem with unexpected end parse error

}

?>

 

<?php

//Options as Images. This whole php clause needs to be added

if (OPTIONS_AS_IMAGES_ENABLED == 'true') include ('options_images.php');

?>

</td>

</tr>

 

<?php

// BOF MaxiDVD: Modified For Ultimate Images Pack!

if (ULTIMATE_ADDITIONAL_IMAGES == 'Enable') { include(DIR_WS_MODULES . 'additional_images.php'); }

// BOF MaxiDVD: Modified For Ultimate Images Pack!

; ?>

 

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

</tr>

<?php

$reviews = tep_db_query("select count(*) as count from " . TABLE_REVIEWS . " where products_id = '" . $HTTP_GET_VARS['products_id'] . "'");

// old $reviews_query = tep_db_query("select count(*) as count from " . TABLE_REVIEWS . " r, " . TABLE_REVIEWS_DESCRIPTION . " rd where r.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and r.reviews_id = rd.reviews_id and rd.languages_id = '" . (int)$languages_id . "'");

$reviews_values = tep_db_fetch_array($reviews);

if ($reviews_values['count'] > 0) {

?>

<tr>

<td class="main"><br><?php echo TEXT_CURRENT_REVIEWS . ' ' . $reviews_values['count']; ?></td>

</tr>

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

</tr>

<?php

}

 

if ($product_info_values['products_url']) {

?>

<tr>

<td class="main"><br><?php echo sprintf(TEXT_MORE_INFORMATION, tep_href_link(FILENAME_REDIRECT, 'action=url&goto=' . urlencode($product_info_values['products_url']), 'NONSSL', true, false)); ?></td>

</tr>

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

</tr>

<?php

}

 

if ($product_info_values['products_date_available'] > date('Y-m-d H:i:s')) {

?>

<tr>

<td align="center" class="smallText"><br><?php echo sprintf(TEXT_DATE_AVAILABLE, tep_date_long($product_info_values['products_date_available'])); ?></td>

</tr>

<?php

} else {

?>

<tr>

<td align="center" class="smallText"><br><?php echo sprintf(TEXT_DATE_ADDED, tep_date_long($product_info_values['products_date_added'])); ?></td>

</tr>

<?php

}

?>

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

</tr>

<tr>

<td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">

<tr class="infoBoxContents">

<td><br><table border="0" width="100%" cellspacing="0" cellpadding="0">

<tr>

<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>

<td class="main"><a href="<?php echo tep_href_link(FILENAME_PRODUCT_REVIEWS, substr(tep_get_all_get_params(), 0, -1)); ?>"><?php echo tep_image_button('button_reviews.gif', IMAGE_BUTTON_REVIEWS); ?></a></td>

<!-- old <td class="main"><?php echo '<a href="' . tep_href_link(FILENAME_PRODUCT_REVIEWS, tep_get_all_get_params()) . '">' . tep_image_button('button_reviews.gif', IMAGE_BUTTON_REVIEWS) . '</a>'; ?></td> -->

<!-- Begin Wishlist Code w/Attributes-->

<td align="center" class="main"><?php echo tep_draw_hidden_field('wishlist_action', 'add_wishlist') . tep_image_submit('button_wishlist.gif', IMAGE_BUTTON_ADD_WISHLIST, 'onClick="document.cart_quantity.action=\''. FILENAME_WISHLIST . '\';document.cart_quantity.submit();"'. ' action=add_wishlist'); ?></td>

<!-- End Wishlist Code w/Attributes-->

<td align="right" class="main"><input type="hidden" name="products_id" value="<?php echo $product_info_values['products_id']; ?>"><?php echo tep_image_submit('button_in_cart.gif', IMAGE_BUTTON_IN_CART); ?></td>

<!-- old <td class="main" align="right"><?php echo tep_draw_hidden_field('products_id', $product_info['products_id']) . tep_image_submit('button_in_cart.gif', IMAGE_BUTTON_IN_CART); ?></td> -->

<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>

</tr>

</table></td>

</tr>

</table></td>

</tr>

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

</tr>

<tr>

<td><br>

<?php

//added for cross -sell

if ( (USE_CACHE == 'true') && !SID) {

echo tep_cache_also_purchased(3600);

include(DIR_WS_MODULES . FILENAME_XSELL_PRODUCTS);

} else {

include(DIR_WS_MODULES . FILENAME_XSELL_PRODUCTS);

include(DIR_WS_MODULES . FILENAME_ALSO_PURCHASED_PRODUCTS);

}

}

//EOF for cross sell

?>

</td>

</tr>

</table></form></td>

<!-- body_text_eof //-->

<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">

<!-- right_navigation //-->

<?php require(DIR_WS_INCLUDES . 'column_right.php'); ?>

<!-- right_navigation_eof //-->

</table></td>

</tr>

</table>

<!-- body_eof //-->

 

<!-- footer //-->

<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>

<!-- footer_eof //-->

<br>

</body>

</html>

<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

 

 

Thank you,

Doug

Link to comment
Share on other sites

usually it is something overlooked in the installation procedure, where something got installed in the wrong spot or missed something in the installation procedure. double check, comparing the code to make sure it is there. i use beyond compare, a great program for code comparison.

Link to comment
Share on other sites

usually it is something overlooked in the installation procedure, where something got installed in the wrong spot or missed something in the installation procedure.  double check, comparing the code to make sure it is there.  i use beyond compare, a great program for code comparison.

 

Howyd Mibble,

 

I went back to a drawling board (actually I have installed this 6 times now, with no luck)

 

part of my problem I think is that it was written on an older snapshot and much of the coding changed between them. I can get parts of the admin working (just spent the last 3 hrs doing this install by:

 

A. comparing the files in the contribution to their clean version (from sourceforge)

B. comparing the old snapshot files to clean versions matching mine (from sourceforge)

c. Comparing clean versions matching mine to my current files with other added contributions

D. Finally comparing contribtuion files to my files and merging them.

 

I can get the admin area to work except that the edit button for products now just does new product, so I can't edit anything.

 

I STILL can't get the attributes to sort at all. I have installed a total of 7 times, 3 days worth of work, and I am pulling my hair out now. I know I haven't missed anything that was changed in the contribution files, but my coding is ummmm well poor would be an understatement LOL.

 

can anyone, will anyone be able to update the contribution to the current 2.2ms2 version?

 

At this point I really don't know what to do. I can't believe I am having this much trouble just sorting the attributes. I installed a contribution that enable sorting the products with no trouble at all..sigh.

 

Does anyone have any advice I what I should do or where I should go to find something to help?

 

Thank you all for the hard work you do, and the wonderful contributions you put out.

 

Doug

Link to comment
Share on other sites

I'm having something of a similiar problem...

Some of my items sort correctly, and some of them don't... with no appearant rhyme or reason.

 

So... the only thing I can think to do is remove all of my attributes then re-add them... which seems a tedious and irritating prospect for more than a handful of items, which thankfully is the case!

 

Is there a way to set the SQL file to sort the items or something?

The shop I'm working on is going to eventually have 2000 or so items... and I'm not looking forward to having to keep trying to correct the damn thing every time...

Link to comment
Share on other sites

I am also trying to sort attributes, although I haven't installed any contributions to do this yet.

 

I've tried simply adding an "ORDER BY" statement to the SQL, but that doesn't seem to have any effect.

 

I'm wondering if it because of the way the array is built that contains the attributes; perhaps the sort order is lost in this step.

 

Any PHP gurus know anything about how this might work?

 

Best,

 

- James

 

-------------------------------------------

The Arts Coop - Art for Everyone!

http://www.theartscoop.com

-------------------------------------------

Link to comment
Share on other sites

Well, I still don't know the answer to the question I posed, but I just installed this contribution: Product Attributes Sort Order v1.0 located here:

 

http://www.oscommerce.com/community/contributions,1822

 

And it seems to work just fine. Very simple installation.

 

- James

 

I am also trying to sort attributes, although I haven't installed any contributions to do this yet.

 

I've tried simply adding an "ORDER BY" statement to the SQL, but that doesn't seem to have any effect.

 

I'm wondering if it because of the way the array is built that contains the attributes; perhaps the sort order is lost in this step.

 

Any PHP gurus know anything about how this might work?

 

Best,

 

- James

 

-------------------------------------------

The Arts Coop - Art for Everyone!

http://www.theartscoop.com

-------------------------------------------

Link to comment
Share on other sites

Well, I still don't know the answer to the question I posed, but I just installed this contribution: Product Attributes Sort Order v1.0 located here:

 

http://www.oscommerce.com/community/contributions,1822

 

And it seems to work just fine. Very simple installation.

 

- James

 

 

Howdy ArtsCoop,

 

I have to agree with you, I have installed that same contribution and it works just fine. 2 points though.

 

1. I think I figured out part of my problem with the attributes not sorting on the catalog side. It was because I also have options as images installed, so a bit of the code for the product_info.php file had to also be installed in the options_images.php file (also had to do the same thing to get the Product Attributes Sort Order v1.0 contribution to work also).

 

2. I would love to get the attributes sorter copier to work, as I love the copier part also. but the file differences are too great "I think" between my copy, and the copy it was created on. I hate the fact that I am going to try for the same thing this one contribution does, but with 2-3 others. sigh.

 

Does anyone know if an update will be made to it? the last real update I think was in 2003. If anyone is listening, and can do it, would you please do an update on it.

 

Thank you!

Doug

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...