♥raiwa Posted April 8, 2015 Share Posted April 8, 2015 Hello John @@grandpaj, You did not read my instructions??:-):-) -------------------------------------------------------------------------------------------------------IMPORTANT: If you are using Header Tag Grid List Javascript Module, include the Page: shop_by_price.php------------------------------------------------------------------------------------------------------- Admin=>Modules=> Header Tags=>Grid List Javascript (jQuery)=> Pages=>Add "shop_by_price.php" regards Rainer Quote About Me: http://www.oscommerce.com/forums/user/249059-raiwa/ Need help? How To Get The Help You Need Is your version of osC up to date? You'll find the latest osC community version CE Phoenix here. Public Phoenix Change Log Cheat Set on Google Sheets Link to comment Share on other sites More sharing options...
Guest Posted April 8, 2015 Share Posted April 8, 2015 @@raiwa Hi Rainer, Apologies, I thought I had done it. All good Many thanks Grand Quote Link to comment Share on other sites More sharing options...
ringo667 Posted August 8, 2015 Share Posted August 8, 2015 (edited) thx for this contrib but the Listing do not work Alll links are like this: http://www.++++++++++.de/-p-.html?slave_id=170 Edited August 8, 2015 by ringo667 Quote Link to comment Share on other sites More sharing options...
♥raiwa Posted August 8, 2015 Share Posted August 8, 2015 Hello Cris @@ringo667, It would be helpful to mention your store and add-on version. Supposing you are using 2.3.4 bootstrap and the newest shop by price version, then where did you get "slave_id=170" from. It looks like you have master products or something similar installed. I do not know too much about this, but you may need to apply additional modifications to shop by price to get it to work with other add-ons. Otherwise you can pm your store URL to me and I'll have a closer look. regards Rainer Quote About Me: http://www.oscommerce.com/forums/user/249059-raiwa/ Need help? How To Get The Help You Need Is your version of osC up to date? You'll find the latest osC community version CE Phoenix here. Public Phoenix Change Log Cheat Set on Google Sheets Link to comment Share on other sites More sharing options...
♥raiwa Posted August 9, 2015 Share Posted August 9, 2015 Just for other users of the master product add-on.@@ringo667 fixed it like this: i have insert p.products_master, p.products_master_status, int the $select_str request.now it works :thumbsup: Quote About Me: http://www.oscommerce.com/forums/user/249059-raiwa/ Need help? How To Get The Help You Need Is your version of osC up to date? You'll find the latest osC community version CE Phoenix here. Public Phoenix Change Log Cheat Set on Google Sheets Link to comment Share on other sites More sharing options...
ringo667 Posted September 12, 2015 Share Posted September 12, 2015 (edited) Hello, where can I shorten the long description in listing? Edited September 12, 2015 by ringo667 Quote Link to comment Share on other sites More sharing options...
firstbizsoft Posted February 10, 2016 Share Posted February 10, 2016 (edited) Hi Rainer, I installed the last Shop by Price BS v.4.2 on my shop. But working without IVA included, only. This is the link to my shop: http://tiendaguay.com thank you Edited February 10, 2016 by firstbizsoft Quote Link to comment Share on other sites More sharing options...
♥raiwa Posted February 10, 2016 Share Posted February 10, 2016 Hola Costel @@firstbizsoft, When I choose "all prices" it shows one procuct with "IVA" and several products without. But it doesn't show all products of the store. Sure all is correct installed and configured?? I just checked on my demo store and it seems you are right. It doesn't show a product when I take off VAT in edit product. May be it's a problem to have some products with and some without. Is this needed in a real store? But if I schoose "all products" it shows all. Anyway I'll have a deeper look soon. Me puedes contactar por mensaje personal también en español. Un saludo Rainer Quote About Me: http://www.oscommerce.com/forums/user/249059-raiwa/ Need help? How To Get The Help You Need Is your version of osC up to date? You'll find the latest osC community version CE Phoenix here. Public Phoenix Change Log Cheat Set on Google Sheets Link to comment Share on other sites More sharing options...
♥raiwa Posted February 10, 2016 Share Posted February 10, 2016 Hello Costel @@firstbizsoft, Please apply this modification explained in the Installation file: 4: TroubleshootingIf you are usiong "show prices with tax" and you have a very complicate tax setup and get wrong range results, try the following fix:NOTE: this change will slow down the queries, so use only if needed.- [catalog]/shop by price.phpFIND [line 101]: $from_str .= " left join tax_rates tr on p.products_tax_class_id = tr.tax_class_id inner join zones_to_geo_zones gz on tr.tax_zone_id = gz.geo_zone_id and (gz.zone_country_id is null or gz.zone_country_id = '0' or gz.zone_country_id = '" . (int)$customer_country_id . "') and (gz.zone_id is null or gz.zone_id = '0' or gz.zone_id = '" . (int)$customer_zone_id . "')";REPLACE WITH: $from_str .= " left join tax_rates tr on p.products_tax_class_id = tr.tax_class_id left join zones_to_geo_zones gz on tr.tax_zone_id = gz.geo_zone_id and (gz.zone_country_id is null or gz.zone_country_id = '0' or gz.zone_country_id = '" . (int)$customer_country_id . "') and (gz.zone_id is null or gz.zone_id = '0' or gz.zone_id = '" . (int)$customer_zone_id . "')"; i just checked and it solves the problem regards Rainer Quote About Me: http://www.oscommerce.com/forums/user/249059-raiwa/ Need help? How To Get The Help You Need Is your version of osC up to date? You'll find the latest osC community version CE Phoenix here. Public Phoenix Change Log Cheat Set on Google Sheets Link to comment Share on other sites More sharing options...
firstbizsoft Posted February 11, 2016 Share Posted February 11, 2016 Hi Rainer @@raiwa This is not a real shop, it is for testing. Throughout the day, I'll make the changes and and keep you informed. Tks, Costel Quote Link to comment Share on other sites More sharing options...
firstbizsoft Posted February 11, 2016 Share Posted February 11, 2016 Hi Rainer @@raiwa I apply the modification explained in the Installation file and now working fine. Tks for your help. Quote Link to comment Share on other sites More sharing options...
♥raiwa Posted February 11, 2016 Share Posted February 11, 2016 Hi Rainer @@raiwa I apply the modification explained in the Installation file and now working fine. Tks for your help. OK, but in a real store if you have all products with tax, you shouldn't need this modiofication. It makes the query noticeable slower if there are a lot of products. Quote About Me: http://www.oscommerce.com/forums/user/249059-raiwa/ Need help? How To Get The Help You Need Is your version of osC up to date? You'll find the latest osC community version CE Phoenix here. Public Phoenix Change Log Cheat Set on Google Sheets Link to comment Share on other sites More sharing options...
firstbizsoft Posted February 11, 2016 Share Posted February 11, 2016 Now have all products with tax. With the original code on the line 101 in the shop in the [catalog]shop_by_price.php file, don't working. With the modified 101 line, working fine. Quote Link to comment Share on other sites More sharing options...
♥raiwa Posted February 11, 2016 Share Posted February 11, 2016 Now have all products with tax. With the original code on the line 101 in the shop in the [catalog]shop_by_price.php file, don't working. With the modified 101 line, working fine. Then there must be something else with the tax setup. In my demo store and own store it works fine. OK. I'll think to add a configuration setting for this to the module and more specific explanation to the installation doc. Thanks for the feedback. Quote About Me: http://www.oscommerce.com/forums/user/249059-raiwa/ Need help? How To Get The Help You Need Is your version of osC up to date? You'll find the latest osC community version CE Phoenix here. Public Phoenix Change Log Cheat Set on Google Sheets Link to comment Share on other sites More sharing options...
firstbizsoft Posted February 11, 2016 Share Posted February 11, 2016 Then there must be something else with the tax setup. In my demo store and own store it works fine. OK. I'll think to add a configuration setting for this to the module and more specific explanation to the installation doc. Thanks for the feedback. Thanks to you. Costel Quote Link to comment Share on other sites More sharing options...
Guest Posted April 22, 2016 Share Posted April 22, 2016 (edited) @@raiwa Hi Just checked my error log and have found a "heap" of the following for every day [22-Apr-2016 04:46:50 Pacific/Auckland] PHP Warning: implode(): Invalid arguments passed in /home/xxxxxx/public_html/shop_by_price.php on line 193 Just wondering if Ive missed an update. Cheers Grandpa Edited April 22, 2016 by grandpaj Quote Link to comment Share on other sites More sharing options...
Guest Posted April 22, 2016 Share Posted April 22, 2016 @@raiwa Hi Further to my above post. Line 193 is as follows. $category_name = implode(',', tep_db_fetch_array(tep_db_query("select categories_name from categories_description where categories_id = '" . (int)$_GET['cPath'] . "' and language_id = '" . (int)$languages_id . "'"))); Cheers Grandpa Quote Link to comment Share on other sites More sharing options...
♥raiwa Posted April 22, 2016 Share Posted April 22, 2016 @@grandpaj, Yes, it seems you are using an outdated version, in the actual version this is line 199. Your version? rgds Rainer Quote About Me: http://www.oscommerce.com/forums/user/249059-raiwa/ Need help? How To Get The Help You Need Is your version of osC up to date? You'll find the latest osC community version CE Phoenix here. Public Phoenix Change Log Cheat Set on Google Sheets Link to comment Share on other sites More sharing options...
Guest Posted April 23, 2016 Share Posted April 23, 2016 @@raiwa Hi Rainer Just reinstalled the addon (latest) and still get the error [23-Apr-2016 12:27:33 Pacific/Auckland] PHP Warning: implode(): Invalid arguments passed in /home/XXXXXX/public_html/shop_by_price.php on line 199 hers line 199 $category_name = implode(',', tep_db_fetch_array(tep_db_query("select categories_name from categories_description where categories_id = '" . (int)$_GET['cPath'] . "' and language_id = '" . (int)$languages_id . "'"))); I guess this is no biggy but would be good to sort it. Many thanks Grandpa Quote Link to comment Share on other sites More sharing options...
♥raiwa Posted April 23, 2016 Share Posted April 23, 2016 @@grandpaj, I checked, but can not reproduce that error. Please, can you try with the setting: Use fast Tax Query: set to "False" in the shop by price module. Do you get this error also on the advanced search result page?? Please try searching for a price range, the coding is the same on that page. Thank You Rainer Quote About Me: http://www.oscommerce.com/forums/user/249059-raiwa/ Need help? How To Get The Help You Need Is your version of osC up to date? You'll find the latest osC community version CE Phoenix here. Public Phoenix Change Log Cheat Set on Google Sheets Link to comment Share on other sites More sharing options...
Guest Posted April 24, 2016 Share Posted April 24, 2016 @@raiwa Hi Rainer Thanks for that. Have set fast Tax Query: to "False" in the shop by price module. Will report back in a few days. Cheers Grndpa Quote Link to comment Share on other sites More sharing options...
♥raiwa Posted April 24, 2016 Share Posted April 24, 2016 Hello John @@grandpaj, It would be more important to try this: Do you get this error also on the advanced search result page??Please try searching for a price range, the coding is the same on that page. rgds Rainer Quote About Me: http://www.oscommerce.com/forums/user/249059-raiwa/ Need help? How To Get The Help You Need Is your version of osC up to date? You'll find the latest osC community version CE Phoenix here. Public Phoenix Change Log Cheat Set on Google Sheets Link to comment Share on other sites More sharing options...
Guest Posted April 24, 2016 Share Posted April 24, 2016 @raiwaHi Hi Rainer Had many goes using the Shop by Price. Nothing happens (the problem??), tried using advanced search, nothing. For some reason it only seems to happen spasmodically. Will report back. Many thanks Kind regards Grandpa Quote Link to comment Share on other sites More sharing options...
♥raiwa Posted April 25, 2016 Share Posted April 25, 2016 Hello John @@grandpaj, Can you please try this mod: if ( isset($_GET['cPath']) && tep_not_null($_GET['cPath']) ) $category_name = implode(',', tep_db_fetch_array(tep_db_query("select categories_name from categories_description where categories_id = '" . (int)$_GET['cPath'] . "' and language_id = '" . (int)$languages_id . "'"))); and observe if it stops generating the error. Thank you Rainer Quote About Me: http://www.oscommerce.com/forums/user/249059-raiwa/ Need help? How To Get The Help You Need Is your version of osC up to date? You'll find the latest osC community version CE Phoenix here. Public Phoenix Change Log Cheat Set on Google Sheets Link to comment Share on other sites More sharing options...
Guest Posted April 25, 2016 Share Posted April 25, 2016 @@raiwa Hi Rainer Cheers Will report back in a couple of days. Just to give it time to "work out" live. Grandpa 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.