Kohn Posted August 23, 2004 Share Posted August 23, 2004 Just a note. I was trying to set this script up for the 2.2milestone and realized that product_listing will not display "click here for price," instead just the price that we want to hide. This is due to that p.products_map was not called in the catalog/index.php so the value of listing[products_map] was always zero. After replacing: $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, with $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, p.products_map, I was able to see the product_listing displaying "click for price" instead of the MAPed price. Quote Link to comment Share on other sites More sharing options...
leorulz Posted March 15, 2005 Share Posted March 15, 2005 I am not sure if its the right post, but this is what i am looking for: I am building a travel agency website and i need a contribution that would i would email a price quote to the customer. The customer sees the package (product) and clicks on price quote link. I get the email from the customer about the price quote and then respond to the customer manually telling him the price quote. Is there such distribution available. Thank you. Quote Link to comment Share on other sites More sharing options...
shawnm Posted April 11, 2005 Share Posted April 11, 2005 Very nice contribution! I love Click For Price! I am trying to get this to work with Seperate Pricing Per Customer, this contribution: http://www.oscommerce.com/community/contributions,716 Has anyone gotten this to work? If so, how did you go about doing it? Thanks in advance, Shawn Quote Link to comment Share on other sites More sharing options...
luqi Posted May 29, 2005 Share Posted May 29, 2005 Quote Link to comment Share on other sites More sharing options...
quokka Posted September 27, 2005 Share Posted September 27, 2005 is the last version stable? Anyone please tell me...I am in desperate need of this ;-) Thanks in advance, bas Quote Link to comment Share on other sites More sharing options...
shanejackson Posted January 26, 2006 Share Posted January 26, 2006 Anyone have this up and running?? I would like to take a look at it prior to installing it. Thanks, Shane Quote Link to comment Share on other sites More sharing options...
HandLTackle Posted February 14, 2006 Share Posted February 14, 2006 How did your modifactions work Shane? I am getting ready to download and install and wanted to know if 1.4a is good to go. Thanks!!! -Chris Anyone have this up and running?? I would like to take a look at it prior to installing it. Thanks, Shane Quote Link to comment Share on other sites More sharing options...
Silverado05 Posted March 10, 2006 Share Posted March 10, 2006 I have just installed this with no problems. I would just like to add one mod to it. I would like to have the "click for price" text that is on the product info page and product listing page to be displayed in red. Can someone explain to me how this could be done. -Thanks Quote Search the forum and contributions before posting. If that doesn't work, keep looking, then post. The forum is for seeking help and advice NOT for someone to do your work for you. Try to do something on your on, if you are going to run a shop then learn how it works. Link to comment Share on other sites More sharing options...
Guest Posted March 13, 2006 Share Posted March 13, 2006 (edited) What I don't understand, is, how is it that having the price displayed in the shopping cart, is NOT a violation of MAP restrictions? I installed this assuming that the price would not be displayed in the shopping cart and/or the add to cart button would be removed. JP Edited March 13, 2006 by jpalbicke Quote Link to comment Share on other sites More sharing options...
Silverado05 Posted March 14, 2006 Share Posted March 14, 2006 What I don't understand, is, how is it that having the price displayed in the shopping cart, is NOT a violation of MAP restrictions? I installed this assuming that the price would not be displayed in the shopping cart and/or the add to cart button would be removed. JP That's because in the cart you are not intentionally advertising the price. You have display the price in order to know how much the item is you're buying when you display it in the cart. Most guidelines set byb Manufactuers state that you can not intentionally or knowingly advertise below the MAP price. Now here is the question I have. I have this installed and installed it fairly easy and it works great while on the Product info and product listing page. But what is the point of having this when it displays the below MAP price on the new, feature, and specails boxes? Is thier a fix for this? -Thanks Quote Search the forum and contributions before posting. If that doesn't work, keep looking, then post. The forum is for seeking help and advice NOT for someone to do your work for you. Try to do something on your on, if you are going to run a shop then learn how it works. Link to comment Share on other sites More sharing options...
Guest Posted March 15, 2006 Share Posted March 15, 2006 (edited) That's because in the cart you are not intentionally advertising the price. You have display the price in order to know how much the item is you're buying when you display it in the cart. No, I know, and thanks for the reply by the way, but really the question was mostly rhetorical. This solution really didn't suit my needs, as I have no interest in splitting hairs with the real intent of MAP, and MSRP, since I have good relationships with the manufacturers that I deal with in the golf industry... Anyway, it took awhile, however I was able to merge the click for price contrib., with Linda McGrath's free call for price contrib, and then basically hack both of them so that that the click for price button I created to replace the cart button at the botton of each individual product page, will initiate the 'call for price' script, the same as the text/link at the top. It wasn't an easy hack because the Click for Price contribution wasn't working well with STS Templates, and was subsequently displaying prices within each category. It isn't used quite to it's exact design since I am no programmer, but the combination of the two contributions are doing the job I that I need, quite nicely. JP Edited March 15, 2006 by jpalbicke Quote Link to comment Share on other sites More sharing options...
Silverado05 Posted April 21, 2006 Share Posted April 21, 2006 Anyone know how you can display the MSRP without it showing the sell price if its below MAP? Quote Search the forum and contributions before posting. If that doesn't work, keep looking, then post. The forum is for seeking help and advice NOT for someone to do your work for you. Try to do something on your on, if you are going to run a shop then learn how it works. Link to comment Share on other sites More sharing options...
Guest Posted September 14, 2006 Share Posted September 14, 2006 :( I just followed the instructions to copy paste and delete code as instructed in install.txt. Now when I log in to admin control panel, I get this message: "Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING, expecting ',' or ';' in /mnt/w0001/d35/s01/b028e8cb/www/humminbird987c.com/www/humminbird987c.com/catalog/admin/categories.php on line 802" There were a bunch of files that went to my PicoZip folder and I assume I only need to follow instructions on install.txt. There is also a clickforprice.sql and a bunch of other files.php, etc. Am I supposed to do something with those too or is just following the install.php enough. I seem to be stuck here. Woudl appreciate any help at all here. Quote Link to comment Share on other sites More sharing options...
Guest Posted September 14, 2006 Share Posted September 14, 2006 Am I supposed to upload all the .php files from the zip file download into my files manager? Quote Link to comment Share on other sites More sharing options...
Guest Posted September 14, 2006 Share Posted September 14, 2006 I think I figured out how to use FileZilla to upload the two new click_for_price.php files and edited all the others. I still get "Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING, expecting ',' or ';' in /mnt/w0001/d35/s01/b028e8cb/www/humminbird987c.com/www/humminbird987c.com/catalog/admin/categories.php on line 802" whenver I try to open 'Catalog' in the control panel. Can't see anything there anymore. Is it possible that something just did not copy over correctly? What does the error message mean? Quote Link to comment Share on other sites More sharing options...
Guest Posted September 14, 2006 Share Posted September 14, 2006 :'( My guess is that something did not copy over correctly and I received parse error. So I created a new oscommerce store temporarily to copy the original files into filezilla file manager and then dropped them into my active store files. Then I extracted the click for price files and dropped them into the appropriate folders in FileZilla for my store. I did a test and it works fine this time. Will report any other problems if they arise. Sometimes you just have to start over. It was my first time modifing my php files with a contribution. Learning curve drives me bonkers. Quote Link to comment Share on other sites More sharing options...
Guest Posted October 4, 2006 Share Posted October 4, 2006 What is the difference between your module = Click for Price version 1.0 and Minimum Advertised Price Module contrib As they seem the same thing. What is different??? Quote Link to comment Share on other sites More sharing options...
Guest Posted October 12, 2006 Share Posted October 12, 2006 I have click for price working in product categories. However, when a customer clicks on 'Manufacturer' link and select a manuf with MAP price, they see a list of all their products displaying the shopping cart price. So they can still see the web price rather than a MAP price or a 'Click For Price' prompt. So the module is only half working. How do I get the manuf. tabs also to show 'Click For Price' and not display the sale price? Quote Link to comment Share on other sites More sharing options...
Guest Posted May 1, 2007 Share Posted May 1, 2007 I installed this mod today and it works fine. the only problem that I have it that I use the feedmachine contrib for froogle. The feed shows the price that is supposed to be hidden. is there a way to fix this so it shows the map price instead? Thanks Quote Link to comment Share on other sites More sharing options...
analli Posted July 6, 2007 Share Posted July 6, 2007 I've just installed your great contribution and love it. I also have another contribution called FEATURED PRODUCTS and the price for my MAP protected products still appear there. Here is the code for my FEATURED_PRODUCTS.PHP file. <?php /* $Id: featured_products.php,v 1.5.8 2003/06/09 22:35:33 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_FEATURED_PRODUCTS); $breadcrumb->add(NAVBAR_TITLE, tep_href_link(FILENAME_FEATURED_PRODUCTS)); ?> <!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; ?>"> <title><?php echo TITLE; ?></title> <base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>"> <link rel="stylesheet" type="text/css" href="stylesheet.css"> </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"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="pageHeading"><?php echo HEADING_TITLE; ?></td> <td class="pageHeading" align="right"><?php echo tep_image(DIR_WS_IMAGES . 'table_background_products_new.gif', HEADING_TITLE, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php ///// To random featured products // list($usec, $sec) = explode(' ', microtime()); // srand( (float) $sec + ((float) $usec * 100000) ); // $mtm= rand(); ////// $featured_products_array = array(); $featured_products_query_raw = "select p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, m.manufacturers_name from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id left join " . TABLE_FEATURED . " f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by p.products_date_added DESC, pd.products_name"; // to random// $featured_products_query_raw = "select p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, m.manufacturers_name from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id left join " . TABLE_FEATURED . " f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by rand($mtm)"; $featured_products_split = new splitPageResults($featured_products_query_raw, MAX_DISPLAY_FEATURED_PRODUCTS); if (($featured_products_split->number_of_rows > 0) && ((PREV_NEXT_BAR_LOCATION == '1') || (PREV_NEXT_BAR_LOCATION == '3'))) { ?> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td class="smallText"><?php echo $featured_products_split->display_count(TEXT_DISPLAY_NUMBER_OF_FEATURED_PRODUCTS); ?> </td> <td align="right" class="smallText"><?php echo TEXT_RESULT_PAGE . ' ' . $featured_products_split->display_links(MAX_DISPLAY_PAGE_LINKS, tep_get_all_get_params(array('page', 'info', 'x', 'y'))); ?></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php } ?> <tr> <td> <!-- Featured Products Main Page Box --> <table bgcolor="ffffff" border="0" width="100%" cellspacing="0" cellpadding="2"> <?php if ($featured_products_split->number_of_rows > 0) { $featured_products_query = tep_db_query($featured_products_split->sql_query); while ($featured_products = tep_db_fetch_array($featured_products_query)) { if ($new_price = tep_get_products_special_price($featured_products['products_id'])) { $products_price = '<s>' . $currencies->display_price($featured_products['products_price'], tep_get_tax_rate($featured_products['products_tax_class_id'])) . '</s> <span class="productSpecialPrice">' . $currencies->display_price($new_price, tep_get_tax_rate($featured_products['products_tax_class_id'])) . '</span>'; } else { $products_price = $currencies->display_price($featured_products['products_price'], tep_get_tax_rate($featured_products['products_tax_class_id'])); } ?> <tr> <td width="<?php echo SMALL_IMAGE_WIDTH + 10; ?>" valign="top" class="main"><?php echo '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $featured_products['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $featured_products['products_image'], $featured_products['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a>'; ?></td> <td valign="top" class="main"><?php echo '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $featured_products['products_id']) . '"><b><u>' . $featured_products['products_name'] . '</u></b></a><br>' . TEXT_DATE_ADDED . ' ' . tep_date_long($featured_products['products_date_added']) . '<br>' . TEXT_MANUFACTURER . ' ' . $featured_products['manufacturers_name'] . '<br><br>' . TEXT_PRICE . ' ' . $products_price; ?></td> <td align="right" valign="middle" class="main"><?php echo '<a href="' . tep_href_link(FILENAME_FEATURED_PRODUCTS, tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $featured_products['products_id']) . '">' . tep_image_button('button_in_cart.gif', IMAGE_BUTTON_IN_CART) . '</a>'; ?></td> </tr> <tr> <td colspüan="3"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php } } else { ?> <tr> <td class="main"><?php echo TEXT_NO_NEW_PRODUCTS; ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php } ?> </table> </td> </tr> <?php if (($featured_products_split->number_of_rows > 0) && ((PREV_NEXT_BAR_LOCATION == '2') || (PREV_NEXT_BAR_LOCATION == '3'))) { ?> <tr> <td> <table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td class="smallText"><?php echo $featured_products_split->display_count(TEXT_DISPLAY_NUMBER_OF_FEATURED_PRODUCTS); ?></td> <td align="right" class="smallText"><?php echo TEXT_RESULT_PAGE . ' ' . $featured_products_split->display_links(MAX_DISPLAY_PAGE_LINKS, tep_get_all_get_params(array('page', 'info', 'x', 'y'))); ?></td> </tr> </table> </td> </tr> <?php } ?> </table></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'); ?> What needs to be edited here to not show the prices for Click For Price protected items? Many thanks in advance. Anthony Quote Link to comment Share on other sites More sharing options...
Ford Warrior Posted January 11, 2008 Share Posted January 11, 2008 I have installed this and must say great work. :thumbsup: I just need some changes to be made to the catalog/call_for_price.php file: On the email the customer receives I do not want it to display this: "EMAIL_TEXT_YOUR_PRICE . "\n" . $products_price . "\n" . "\n" . EMAIL_TEXT_PLACE_ORDER . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $products_id);" I have tried removing it, but are then faced with errors on the shop Please please help Quote Link to comment Share on other sites More sharing options...
tperkins Posted February 12, 2008 Share Posted February 12, 2008 I just installed a fresh copy of OSCommerce 2.2 rc2. This appears to work great everywhere except the catalog index page when its displaying products (/catalog/index.php?cPath=21 for example). It is coming up with an sql error: 1054 - Unknown column 'p.products_id' in 'on clause' select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '21' Anyone have any thoughts? Thanks. Quote Link to comment Share on other sites More sharing options...
Jada Posted February 15, 2008 Share Posted February 15, 2008 I have gone through many threads and I don't see an answer to this question. I have already installed MAP Price V2.0 and now I want to add click for price. Anyone know if this can be done at this point or if I need to uninstall and reinstall? Any help would be greatly appreciated. Thanks, Quote Jada The codes of the many, outweigh the codes of the few. Live long and Prosper. 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.