Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

MAP Workaround - Click For Price version 1.0


Guest

Recommended Posts

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.

Link to comment
Share on other sites

  • 6 months later...

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.

Link to comment
Share on other sites

  • 4 weeks later...
  • 1 month later...
  • 3 months later...
  • 3 months later...
  • 3 weeks later...
  • 4 weeks later...

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

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

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 by jpalbicke
Link to comment
Share on other sites

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

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

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 by jpalbicke
Link to comment
Share on other sites

  • 1 month later...

Anyone know how you can display the MSRP without it showing the sell price if its below MAP?

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

  • 4 months later...

:( 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.

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

:'( 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.

Link to comment
Share on other sites

  • 3 weeks later...

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???

Link to comment
Share on other sites

  • 2 weeks later...

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?

Link to comment
Share on other sites

  • 6 months later...

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

Link to comment
Share on other sites

  • 2 months later...

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

Link to comment
Share on other sites

  • 6 months later...

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

Link to comment
Share on other sites

  • 1 month later...

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.

Link to comment
Share on other sites

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,

Jada

 

The codes of the many, outweigh the codes of the few. Live long and Prosper.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...