Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

willer2k

Pioneers
  • Posts

    55
  • Joined

  • Last visited

1 Follower

Profile Information

  • Real Name
    Alex
  • Gender
    Male
  • Location
    Toronto

Recent Profile Visitors

7,067 profile views

willer2k's Achievements

  1. @@claireb85 No, not yet :( Sorry. I'll let you know as soon as I do. @@kymation Ok, thank you Jim! That is very helpfull! :D
  2. @@kymation Hi jim! Thanks, the code fixed the problem! :D This is what I meant : http://postimage.org/image/5h8aolh5j/ I can't fix it... I think it's me not configuring the contribution properly, I guess I can figure this one out, not such a big deal. The major problems I am facing right now thou; - When I filter the catalog for a specific vehicle, the filter works fine, but when I go to a different category, the filter is no longer filtering, the filter variables dont get passed along in the categories... So the prospect has to re-submit the attributes every time he switches categories. I am using this contribution for an auto parts store, ideally, I need the prospect to be able to submit his vehicles information once [make mode and year] and then keep surfing all categories, see parts only for his vehicle. -Second problem for me, the catalog is going to hold over 8000 products, is it possible to submit all attributes first, then hit "SEARCH" filter everything at once as oposed to filter the entire catalog when the prospect selects [vehicle make], then further filters when they select [vehicle models] and then a 3rd time whent he select [submodel] fallowed by [year], it will create delays and frustration for the client. Are any of those fixable?? Thank You -Alex
  3. @@DunWeb -UPDATE- I've been informed that it might be possible to fix this issue I am facing by passing the variables into the links for the categories, so this way when you click on a category, it applies all the specified "YMMP" attributes to filter a category's contents, would you have any idea how to do that?? Does anyone know??
  4. @@kymation Hi Jim! I get this error message: ( ! ) Deprecated: Function ereg() is deprecated in C:\wamp\www\products_filter.php on line 177 Call Stack # Time Memory Function Location 1 0.0012 770248 {main}( ) ..\products_filter.php:0 It happens when I pick a filter, then I pick another filter, (like HONDA, then ACCORD), filter works fine, filters everything out, but I get this error message at the top of the screen, cant be good right? :/ Also, I cant give titles to my filters like such: I need it like this: Select make of your vehicle [pulldown box] Select model of your vehicle [pulldown box] Select year of your vehicle [pulldown box] Instead, I have this at the moment: Make Model Year Make Model Make [Pulldown box] [Pulldown box] [Pulldown box] Any suggestions?? :(
  5. @@kymation Oh ok! I think I understand how to make it work! Thank you Jim! BTW, I am getting this error at the top when I am creating a specification inside of a group in filters. It doesn't seem to have any effect on the filtering, but maybe it does, I dun know. Anyone else getting this error message?? ( ! ) Deprecated: Function ereg_replace() is deprecated in C:\wamp\www\admin\products_specifications.php on line 1442 Call Stack # Time Memory Function Location 1 0.0199 2461296 {main}( ) ..\products_specifications.php:0 ( ! ) Deprecated: Function ereg_replace() is deprecated in C:\wamp\www\admin\products_specifications.php on line 1442 Call Stack # Time Memory Function Location 1 0.0199 2461296 {main}( ) ..\products_specifications.php:0
  6. @@kymation Hi jim! First of all, thank you SOOOO much for your hard work that you put into this contribution!! Your awsome! :D Now, I have a question for you thou. I installed the contribution, and I can't make the filter have sub-categories, I read the entire manual, and it don't say how to make sub categories of filters. :( (or maybe I misread) What I mean, is that I am trying to open an auto parts store, and I need to filter the parts by "MAKE OF THE VEHICLE, MODEL OF THE VEHICLE, YEAR and SUBMODEL." So if I pick "Acura" for exemple, then the next drop down should have vehicle models ONLY from acura. Can I do that with this contribution?? If anyone knows, please let me know... Any information would help! Thanks! :D
  7. AH, disregard! Found it, thank you guys so much! You are awesome for contributing this! :D
  8. Hey guys, does any one have this contribution for osCommerce 2.3.1 ?? I tried the one available for 2.2 but its not working on my standard 2.3.1 osCommerce :(
  9. @@DunWeb hey chris, I finally managed to get the contribution to work! (somewhat) yay! The only problem I am facing right now thou, is that when I put the year/make/model/part(engine size), the filter works, but when i go to a different category, say, from brakes rotors to radiators, the filter stops working and shows me all radiators I have. In the navigation tree, it shows "Radiators (1)" witch is true, I only have one radiotor for that specific car, but when I go to radiators, it shows ALL radiators I have. Also, I dont know if its normal, but in [catalog]/admin , in configuration/year make model, its empty. I can't configure anything their. Anyways, ANYTHING will help! Thanks guys.
  10. Hey Chris, so if I understand correctly, I don't need to modify the codes, I just need to find the right place to input the code? BTW, thank you so much for such a quick reply, I didn't except help so quickly! :D
  11. Further question, can someone tell me what this code does? : 9.b] Find: include(DIR_WS_MODULES . FILENAME_PRODUCT_LISTING); ?> </div> <?php } Add after: //bof Year_Make_Model Contribution v2.3.x by Dunweb Designs elseif($_GET['Make'] || $_GET['Model'] || $_GET['Year']){ $define_list = array('PRODUCT_LIST_MODEL' => PRODUCT_LIST_MODEL, 'PRODUCT_LIST_NAME' => PRODUCT_LIST_NAME, 'PRODUCT_LIST_MANUFACTURER' => PRODUCT_LIST_MANUFACTURER, 'PRODUCT_LIST_PRICE' => PRODUCT_LIST_PRICE, 'PRODUCT_LIST_QUANTITY' => PRODUCT_LIST_QUANTITY, 'PRODUCT_LIST_WEIGHT' => PRODUCT_LIST_WEIGHT, 'PRODUCT_LIST_IMAGE' => PRODUCT_LIST_IMAGE, 'PRODUCT_LIST_BUY_NOW' => PRODUCT_LIST_BUY_NOW); asort($define_list); $column_list = array(); reset($define_list); while (list($key, $value) = each($define_list)) { if ($value > 0) $column_list[] = $key; } $select_column_list = ''; for ($i=0, $n=sizeof($column_list); $i<$n; $i++) { switch ($column_list[$i]) { case 'PRODUCT_LIST_MODEL': $select_column_list .= 'p.products_model, '; break; case 'PRODUCT_LIST_NAME': $select_column_list .= 'pd.products_name, '; break; case 'PRODUCT_LIST_MANUFACTURER': $select_column_list .= 'm.manufacturers_name, '; break; case 'PRODUCT_LIST_QUANTITY': $select_column_list .= 'p.products_quantity, '; break; case 'PRODUCT_LIST_IMAGE': $select_column_list .= 'p.products_image, '; break; case 'PRODUCT_LIST_WEIGHT': $select_column_list .= 'p.products_weight, '; break; } } if($current_category_id){ $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where " . (YMM_FILTER_PRODUCT_LISTING == 'Yes' ? $YMM_where : '') . " p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'"; }else{ $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where " . (YMM_FILTER_PRODUCT_LISTING == 'Yes' ? $YMM_where : '') . " p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "'"; } if ( (!isset($HTTP_GET_VARS['sort'])) || (!preg_match('/^[1-8][ad]$/', $HTTP_GET_VARS['sort'])) || (substr($HTTP_GET_VARS['sort'], 0, 1) > sizeof($column_list)) ) { for ($i=0, $n=sizeof($column_list); $i<$n; $i++) { if ($column_list[$i] == 'PRODUCT_LIST_NAME') { $HTTP_GET_VARS['sort'] = $i+1 . 'a'; $listing_sql .= " order by pd.products_name"; break; } } } else { $sort_col = substr($HTTP_GET_VARS['sort'], 0 , 1); $sort_order = substr($HTTP_GET_VARS['sort'], 1); switch ($column_list[$sort_col-1]) { case 'PRODUCT_LIST_MODEL': $listing_sql .= " order by p.products_model " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_NAME': $listing_sql .= " order by pd.products_name " . ($sort_order == 'd' ? 'desc' : ''); break; case 'PRODUCT_LIST_MANUFACTURER': $listing_sql .= " order by m.manufacturers_name " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_QUANTITY': $listing_sql .= " order by p.products_quantity " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_IMAGE': $listing_sql .= " order by pd.products_name"; break; case 'PRODUCT_LIST_WEIGHT': $listing_sql .= " order by p.products_weight " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_PRICE': $listing_sql .= " order by final_price " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; } } $catname = HEADING_TITLE; if (isset($HTTP_GET_VARS['manufacturers_id'])) { $image = tep_db_query("select manufacturers_image, manufacturers_name as catname from " . TABLE_MANUFACTURERS . " where manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'"); $image = tep_db_fetch_array($image); $catname = $image['catname']; } elseif ($current_category_id) { $image = tep_db_query("select c.categories_image, cd.categories_name as catname from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = '" . (int)$current_category_id . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "'"); $image = tep_db_fetch_array($image); $catname = $image['catname']; } ?> <h1><?php echo $catname; ?></h1> <div class="contentContainer"> <?php include(DIR_WS_MODULES . FILENAME_PRODUCT_LISTING); echo '</div>'; //eof Year_Make_Model Contribution v2.3.x by Dunweb Designs If I know what the code actually does, it will greatly help to fix the issue i'm facing. Thanks!
  12. I am having the exact same problem. I purchased a template and everything looks fine during installation, except step 9b where I have add codes into [catalog]/index.php My index.php file is different from the standard one, I realise I need to adjust the code somehow to make it work with my template, but can someone point me to the right direction? Where do I even begin?... Any advice will help... Thank You!
×
×
  • Create New...