Jump to content

xspykex

Members
  • Content count

    23
  • Joined

  • Last visited

Profile Information

  • Real Name
    ryan smith
  1. xspykex

    Products Attributes Sort v1.0

    ok i got the sql run and did all the changes except putting the values to the options. i'm not exactly clear on what is the best way to do the attribute sorting. in the read-me file it suggest small=0 medium=1 etc etc i am doing different options on different products such as ram upgrades, hard drive upgrades, etc. each product does not have the same options. is there a quick way to do sorting by price other than doing like $1=0 $2=1 and sorting them by doing that as the order? that could take forever if i have to type up a thousand of those lines. i'll do it if i have to but hopefully there's a better way? thanks for helping me
  2. xspykex

    Products Attributes Sort v1.0

    it's kinda disheartening no one posts in this topic anymore to help out...
  3. xspykex

    Products Attributes Sort v1.0

    i want to double check that i do the right steps in the right order, please let me know if this is correct: 1-upload the sql query to my site? (not quite sure what running the sql means) 2-in file --/catalog/product_info.php-- FIND: $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 . "'"); REPLACE 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 pa.attribute_sort"); 3-in file --/admin/includes/functions/general.php-- ADD (anywhere): function tep_attributes_sort($attributes_id) { global $languages_id; $attributes_sort = tep_db_query("select attribute_sort from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_attributes_id = '" . (int)$attributes_id . "'"); $attributes_sort_values = tep_db_fetch_array($attributes_sort); return $attributes_sort_values['attribute_sort']; } 4-file --/admin/products_attributes.php upload over the old one with the new one included in the zip file 5-go to file --/admin/products_attributes.php and find "attrib sort" column at bottom of page and update values for attributes. is that what i should do? also, there is /admin/includes/functions/general.php do i need to upload that as well? so basically i need to upload all the files included in the zip so they overwrite the old ones? and then do something with the sql and make some changes to products_attributes.php? i think i'm on the right track, just need a little guidance. thanks
  4. i was trying to follow the steps in the "product attribute sort" contribution by following what people had said on that topic...but now something is up with my store. can anyone give me some help on how to fix it since no one is replying to me on that topic? sidebysidecomputing.com is the location of the store. any help is greatly appreciated since php is still new to me. thanks.
  5. xspykex

    Products Attributes Sort v1.0

    i tried to install this and figure it out and i've done something quite wrong. can someone please help? sidebysidecomptuing.com is where you can view my now messed up pages haha...thanks in advance for any help
  6. xspykex

    Products Attributes Sort v1.0

    I downloaded the file to have a sort order for product attributes but I'm having difficulty understanding what to do with it. The readme.txt file says to run the included sql query...what sql query? i don't see anything... also the insert_attrib_sort.txt file says alter table ... (i'm sure anyone reading this knows what it says) and i'm not exactly sure what i'm supposed to do with that. any chance i could get a "first do this" "then do this" from someone? i'm new to php so this is all still somewhat greek to me. thanks
×