jewelrytrends Posted April 7, 2005 Share Posted April 7, 2005 Hi, i have the same problem as dpl882. How can we solve this? Quote Link to comment Share on other sites More sharing options...
jewelrytrends Posted April 7, 2005 Share Posted April 7, 2005 Hi, sorry I forgot to ask this ask in my earlier post. I also would like the box to show selections in euro's if that is the currencie the customers select. Is this possible and what do I need to change (please explain this to me stap-by-stap, I'm not a expert in php) Quote Link to comment Share on other sites More sharing options...
MinkgLove.com Posted June 21, 2005 Share Posted June 21, 2005 Hi. Any way how to make this excellent contrib compatible with the "Special Price"contrib? Most of the products in my shop have a "Special Price". Does anyone know how to modify the "Shop by Price" contrib so that it sorts according to the Special prices instead of the Retail prices? Thanks! C?cile Quote Link to comment Share on other sites More sharing options...
♥Monika in Germany Posted June 21, 2005 Share Posted June 21, 2005 Hi.Any way how to make this excellent contrib compatible with the "Special Price"contrib? Most of the products in my shop have a "Special Price". Does anyone know how to modify the "Shop by Price" contrib so that it sorts according to the Special prices instead of the Retail prices? Thanks! C?cile <{POST_SNAPBACK}> C?cile, I needed that too, and also support of additional currencies/languages, so I modded it a bit ... http://www.noahsark4kids.com/test/shop_by_price.php?range=0 If you'd like the code give me a holler! :-) Monika Quote :-) Monika addicted to writing code ... can't get enough of databases either, LOL! my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum Interactive Media Award July 2007 ~ category E-Commerce my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ... Link to comment Share on other sites More sharing options...
Blackberry Posted March 2, 2006 Share Posted March 2, 2006 Hi all Just installed 2.2.1 Shop By Price and it looks great. However, when I click on any of the price range options on the shopping pages, I get the full product list, beginning with the cheapest items onwards. Any suggestions? Thanks M?che?l Quote Link to comment Share on other sites More sharing options...
azer Posted March 12, 2006 Share Posted March 12, 2006 (edited) hello guys i m goint to release if your are ok a version , where the the price could me easily modified in admin + better multilanguage implementation but i got 5 question : 1.the price we enter in seems to be the price without taxe , i wanna for exemple show prodcut under 200 ? , and it show one porduct at 235? that is in fact 175? taxe excluded, but my customer wanna shop by price including Taxes 2. don't u think we could add one line to the navigation ? 3. i don't understand why , but my weight colum is empty , i cheded in admin listing , and it is set to be shown .. any idea ? 4. does the listing product found by shop by price follow the rule of osc lsiting configureed in admin , like other all products contrib use ? 5. why the $price_ranges = Array( and $price_ranges_sql are done in the language file instead of in the module ? Edited March 12, 2006 by azer Quote MS2 Link to comment Share on other sites More sharing options...
zalik22 Posted April 5, 2006 Share Posted April 5, 2006 Hi, I installed this contribution. It shows up on my webpage, but the filters do not work properly. I did not change the ranges. Can somebody please help or give me advice? Thanks in advance! Quote Link to comment Share on other sites More sharing options...
zalik22 Posted April 6, 2006 Share Posted April 6, 2006 My limit variables are not defined. If you click on all of the price ranges, they all show products 0-20. Please help! Quote Link to comment Share on other sites More sharing options...
zalik22 Posted April 6, 2006 Share Posted April 6, 2006 After some more troubleshooting, no matter what ranges I click on, I get "Products under $20" to be displayed. In the shop_by_price.php file in the languages folder, I noticed that the header variable is defined as 'Shop By Price -' followed by the price ranges. My problem is that these ranges are not defined. When I click on a range, the only thing displayed is "Shop By Price -" and the right side is empty. This would probably explain why I get the same products displayed, regardless of what I click on. I noticed this same file does not have quotes in the ranges. "20" seems to have quotes around it, but 50 and 100 do not have quotes around it (the first of three arrays near the bottom). Ugghh...this contribution seemed so easy, yet I still get problems. If anybody has any ideas, please let me know. Thanks for your help! Quote Link to comment Share on other sites More sharing options...
Kjolebutikken Posted May 7, 2006 Share Posted May 7, 2006 Well, I thought I had this working as a form within my header, but I discovered the action is blank so nothing happens. If I use the modified drop down code in an info box, it works. Here's my code, if anyone can help: $price_range_list = ''; $price_range_list[] = array('id' => '0', 'text' => 'Shop by price' ); for ($range=0; $range<sizeof($price_ranges); $range++) { $price_range_list[] = array('id' => $range, 'text' => $price_ranges[$range] ); ? ? ? ?} ? ? ? <form class="form" method="get" action="<?php tep_href_link(FILENAME_SHOP_BY_PRICE); ?>"><?php echo ?tep_draw_pull_down_menu('range', $price_range_list, $range, 'onchange="this.form.submit();"'); ?></form></td> Hi, I also wonder about this. I want to add a shop by price pulldown meny and I don't want it in its own box, but in my search box. Have tried the tips in this thread, but cannot make it work. I run sts, but I'm not sure if this has any significance to this matter. Can somebody help me? Thanks Kjolebutikken Quote Best regards Kjolebutikken Link to comment Share on other sites More sharing options...
matrix2223 Posted May 7, 2006 Share Posted May 7, 2006 does anyone have a solution for this with ultimate seo urls and as to what I need to do to get it to display. Thanks, Eric Quote Link to comment Share on other sites More sharing options...
Kjolebutikken Posted May 10, 2006 Share Posted May 10, 2006 Hi, I also wonder about this. I want to add a shop by price pulldown meny and I don't want it in its own box, but in my search box. Have tried the tips in this thread, but cannot make it work. I run sts, but I'm not sure if this has any significance to this matter. Can somebody help me? Thanks Kjolebutikken Hi there, still have not been able to get this to work. Basically what I need is to place the dropdownmenu for shop by price at the end in the search box. I do not want it in its own box like now. Can this be done??? Here is a link to my page to let you see how it looks at the moment: http://www.kjolebutikken.com/oscdemo1/index.php All help is very appreciated. Thanks Kjolebutikken Quote Best regards Kjolebutikken Link to comment Share on other sites More sharing options...
Guest Posted June 30, 2006 Share Posted June 30, 2006 I sorted out the shop by price infobox not showing the proper ranges when search-engine friendly URLs were turned on in admin simply add the following to your /includes/languages/english/shop_by_price.php file switch ($HTTP_GET_VARS['range']) { case '0': $get_range='0'; break; case '1': $get_range='1'; break; case '2': $get_range='2'; break; case '3': $get_range='3'; break; } so that it looks like this:- <?php /* $Id: shop_by_price.php,v 2.2 2005/12/10 $ Contribution by Meltus http://www.highbarn-consulting.com Adapted for OsCommerce MS2 by: Sylvio Ruiz [email protected] osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ // Modified by Sylvio Ruiz in 10/12/2005 to format the currency string and to // locate the price of the products based in the value of each currency. // It only must return one. The value of $currency must be only. $sel_currency = array(); $sel_currency_query = tep_db_query("select symbol_left, symbol_right, value from " . TABLE_CURRENCIES . " where code = '" . $currency . "' limit 1"); $sel_currency = tep_db_fetch_array($sel_currency_query); $price_ranges = Array( "?Under " . $sel_currency['symbol_left'] . "20" . $sel_currency['symbol_right'], "?From " . $sel_currency['symbol_left'] . "20" . $sel_currency['symbol_right'] . " to " . $sel_currency['symbol_left'] . 50 . $sel_currency['symbol_right'], "?From " . $sel_currency['symbol_left'] . "50" . $sel_currency['symbol_right'] . " to " . $sel_currency['symbol_left'] . 100 . $sel_currency['symbol_right'], "?Above " . $sel_currency['symbol_left'] . "100" . $sel_currency['symbol_right']); $price_range = Array( "under " . $sel_currency['symbol_left'] . "20" . $sel_currency['symbol_right'], "from " . $sel_currency['symbol_left'] . "20" . $sel_currency['symbol_right'] . " to " . $sel_currency['symbol_left'] . "50" . $sel_currency['symbol_right'], "from " . $sel_currency['symbol_left'] . "50" . $sel_currency['symbol_right'] . " to " . $sel_currency['symbol_left'] . "100" . $sel_currency['symbol_right'], "above " . $sel_currency['symbol_left'] . "100" . $sel_currency['symbol_right'] ); $price_ranges_sql = Array( //"p.products_price < 20", "p.products_price < " . 20 / $sel_currency['value'], //"(p.products_price <= 50.00 and p.products_price >= 20.00)", "(p.products_price <= " . 50 / $sel_currency['value'] . " and p.products_price >= " . 20 / $sel_currency['value'] . ")", //"(p.products_price <= 100.00 and p.products_price >= 50.00)", "(p.products_price <= " . 100 / $sel_currency['value'] . " and p.products_price >= " . 50 / $sel_currency['value'] . ")", // "p.products_price > 100.00"); "p.products_price > " . 100 / $sel_currency['value']); define('NAVBAR_TITLE', 'Shop by Price'); define('HEADING_TITLE', 'Shop by Price - ' . $price_ranges[$range]); define('BOX_HEADING_SHOP_BY_PRICE', 'Shop By Price'); define('TABLE_HEADING_BUY_NOW', 'Buy Now!'); define('TABLE_HEADING_IMAGE', ''); define('TABLE_HEADING_MANUFACTURER', 'Manufacturer'); define('TABLE_HEADING_MODEL', 'Model'); define('TABLE_HEADING_PRICE', 'Price'); define('TABLE_HEADING_PRODUCTS', 'Product Name'); define('TABLE_HEADING_QUANTITY', 'Quantity'); define('TABLE_HEADING_WEIGHT', 'Weight'); define('TEXT_NO_PRODUCTS', '<p align="center"><br>Any product found ' . $price_range[$range] . '.<br>Try other option!<br><br></p>'); switch ($HTTP_GET_VARS['range']) { case '0': $get_range='0'; break; case '1': $get_range='1'; break; case '2': $get_range='2'; break; case '3': $get_range='3'; break; } ?> then go into your /shop_by_price.php file and comment out the following line:- //$get_range = ( (isset($_GET['range']) AND isset($price_ranges_sql[$_GET['range']])) ? $_GET['range'] : 0 ); thats it :) see it in action on my store http://www.outdoorbits.com UK Motorhome Accessories :) Quote Link to comment Share on other sites More sharing options...
Shanke Posted July 1, 2006 Share Posted July 1, 2006 Is anyone using this with Master Products v1.1.5 ? All of my products show up on the "under $20" list, presumeably because all of my master products are set at $0. Any suggestions how I can exlude the masters? Cheers Shane Quote Link to comment Share on other sites More sharing options...
awarner20 Posted July 1, 2007 Share Posted July 1, 2007 I see it's been awhile since anyone has been on this thread, but maybe someone can offer me a solution. I've installed this successfully and it's working great except that the "Shop by Price" infobox has the title "Manufacturers" instead of "Shop by Price". I've tried to change the title to no avail. I do have many contribs installed too. Could something be interferring? Any advice is greatly appreciated. Here's the site http://derbydogma.com Quote We see our customers as invited guests to a party, and we are the hosts. It's our job every day to make every important aspect of the customer experience a little bit better. - Jeff Bezos Link to comment Share on other sites More sharing options...
mig7 Posted July 17, 2007 Share Posted July 17, 2007 I see it's been awhile since anyone has been on this thread, but maybe someone can offer me a solution. I've installed this successfully and it's working great except that the "Shop by Price" infobox has the title "Manufacturers" instead of "Shop by Price". I've tried to change the title to no avail. I do have many contribs installed too. Could something be interferring? Any advice is greatly appreciated. Here's the site http://derbydogma.com you should do some modification to fix this thing.. open catalog/includes/languages/english.php and add define('BOX_HEADING_SHOP_BY_PRICE', 'Shop by Price'); then open catalog/includes/boxes/search_by_price.php and find: //$info_box_contents = array(); //$info_box_contents[] = array('text' => BOX_HEADING_SHOP_BY_PRICE); //new infoBoxHeading($info_box_contents, false, false); then : delete // from those 3 lines.. its done.. hope it can fix your problem.. :thumbsup: Quote Link to comment Share on other sites More sharing options...
Guest Posted December 11, 2007 Share Posted December 11, 2007 (edited) Hello, I have installed it but when i select a price range i always receive this error: Fatal error: Cannot redeclare tep_show_category() in /home/userl/public_html/sport/includes/boxes/categories.php on line 13 My install is based on osCommerce 2.2-MS2 . What can i do since i want to make it work ? Edited December 11, 2007 by newagetech Quote Link to comment Share on other sites More sharing options...
gibke Posted December 19, 2007 Share Posted December 19, 2007 I installed Shop By Price, and it works fine. Except, when a visitor enters the site, all prices are set to zero. If you f5 or click a link, the correct prices show. How do I fix this? http://www.boekingskantoor.eu/catalog/ Gabriel Quote Link to comment Share on other sites More sharing options...
Freelance GD Posted January 30, 2008 Share Posted January 30, 2008 I want to use the contribution in MS2. But I dont find any thing like require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_SHOP_BY_PRICE); in shop_by_price.php Do I have to manually add it or what? Thank you Quote Link to comment Share on other sites More sharing options...
-GuiGui- Posted March 7, 2008 Share Posted March 7, 2008 Hello, I've just uploaded a new version of Shop By Price. Main changes : - Items with special prices should be in the right range selection - Shop by price should work well with "Display prices with tax" activated - Title Fix Shop by price is a bit different now, price under X or above X now also include X, I had to make this change to fix the "Display prices with tax" feature. It would have been too annoying to make it work exactly the same as before. And few small more things This said, I also have a question, is there a cvs/svn repository for this contribution ? -GuiGui- Quote Link to comment Share on other sites More sharing options...
harmsway14 Posted April 18, 2008 Share Posted April 18, 2008 I have installed version 2.4, everything works fine EXCEPT when I click on the dropdown and select "Above $50.00". When I choose this, I get this error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 select count(p.products_id) as total from products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' left join specials s on p.products_id = s.products_id where p.products_status = '1' and [TEP STOP] Anyone have any ideas? Harmonie Quote Link to comment Share on other sites More sharing options...
chrish123 Posted May 22, 2008 Share Posted May 22, 2008 Hi, I am having a problem with this mod, I dont know why but on one site (same code) any item under £100 will show twice so each product is side by side, on another site this still happens but under every price range. Anyone know what can cause this? Kind regards Chris Quote Link to comment Share on other sites More sharing options...
azer Posted June 13, 2008 Share Posted June 13, 2008 for the price range instead of editing them in languages files we could use the systeme from the genius GniDhal that would allows us to put range in admin : here is the code that he uses in application top.php that we can find in the contribution here : http://www.oscommerce.com/community/contributions,4352 // BOF: Search price range $sel_currency = array(); $sel_currency_query = tep_db_query("select symbol_left, symbol_right, value from " . TABLE_CURRENCIES . " where code = '" . $currency . "' limit 1"); $sel_currency = tep_db_fetch_array($sel_currency_query); $price_range_values = array(); $price_range_array = array(); $step_range = split('[/,:]',STEP_PRICE_RANGE_VALUES); foreach($step_range as $key => $step) { $price_range_values[$key]['to'] = intval($step); $price_range_values[$key+1]['from'] = intval($step); $price_range_array[$key] = array('id' => $key, 'text'=> ($price_range_values[$key]['from'] !=0) ? FROM_RANGE_PRICE.$sel_currency['symbol_left'].$price_range_values[$key]['from'].$sel_currency['symbol_right']. TO_RANGE_PRICE .$sel_currency['symbol_left'].$price_range_values[$key]['to'].$sel_currency['symbol_right'] : UPTO_RANGE_PRICE .$price_range_values[$key]['to'].$sel_currency['symbol_right']) ; $price_range_array[$key+1] = array('id' => $key+1, 'text'=> ($price_range_values[$key+1]['to'] !=0) ? FROM_RANGE_PRICE.$sel_currency['symbol_left'].$price_range_values[$key+1]['from'].$sel_currency['symbol_right']. TO_RANGE_PRICE .$sel_currency['symbol_left'].$price_range_values[$key+1]['to'].$sel_currency['symbol_right'] : ABOVE_RANGE_PRICE .$sel_currency['symbol_left'] .$price_range_values[$key]['to'].$sel_currency['symbol_right']) ; } $price_range_array[0] = array( 'id'=>0, 'text'=> SELECT_RANGE_PRICE); // EOF: Search price range Quote MS2 Link to comment Share on other sites More sharing options...
azer Posted June 14, 2008 Share Posted June 14, 2008 is there anybody who achieved to modify the contribution for enable - dsable categories contributions ? Quote MS2 Link to comment Share on other sites More sharing options...
tudoroiuj Posted December 28, 2008 Share Posted December 28, 2008 hei can anyone help me with this:? i read all the topics and replies but didn't manged to resolve the problem that i seen that a lot of people had... i want first to print the price range withouth those decimals second i am in a category and i click a price range... the results must be from that category.. can you help me with this? thank you! 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.