MSRP contrib

I have just installed this contrib and i must say its excellent......
Although i just noticed a layout issue in IE7 on my homepage i am displaying new products for.... and there seems to be an extra line in between retail price, you save, our price but this does not show up in mozilla... Anyone have a solution?

Alternatively is it possible to not display retail, you save etc on the new products page just the our price???

anyone making an upgrade to this? i need it to work with map price / wholesale price.

if map is enabled where our price needs to say map price $1.00 add to cart for sale price, and the % disabled when map is enabled.

then integrate with wholesale price, since not all our products are map enabled, users have one price, wholesalers have another price, would like this mod to know which one and adjust for it.

Hi there I was wondering if somebody would be able to go through with me step by step how to install the MSRP file to display the RRP with a line through it and then the saving etc.. as I am very new to it all and do not know where to find the products table in file manager :wacko:
Thanks
Chris

just follow the readme file that came with this module. You can also use the developer tool kit to locate the files you need to edit. But be carefull to follow the exact directions.
you can execute the sql using your admin insert sql you might need to change the ```
ALTER TABLE tableprefix_products ADD products_msrp DECIMAL( 15, 4 ) NOT NULL AFTER products_price ;

to your sql tables in my case it was ```
ALTER TABLE  `products` ADD  `products_msrp` DECIMAL( 15, 4 ) NOT NULL AFTER  `products_price` ;

I just got this mod installed today so It should work on the latest zen cart 1.38

Does anyone know why this mod doesn't calculate the % correctly. If you do the math on the difference between the MSRP and our price the dollar amount is true but the percentage is off.

Having a little trouble with displaying the MRSP on the site im doing and was wondering if anyone could tell me where i am possiblely going wrong.

Currently on the site i think its working on the admin part as i can see this

any help will be duly wanted :)

Is there anyway of removing the msrp if it is the same as the net price to stop it saying 'Saving 0%', just my xml feed imports the msrp but if theres no reduction it is the same as the selling price.

My thought is would there be an SQL query like:

if products_price = products_msrp then value = ""

this would remove the msrp therefore disabling the msrp mod for that problem.

Only problem is im not sure how to code this and get it to search all products in the database.

This shows my problem:
http://www.essentialbeautystore.com/edhardygladiatortigerwatch-p-124253.html

Glamorousshoe:

Does anyone know why this mod doesn't calculate the % correctly. If you do the math on the difference between the MSRP and our price the dollar amount is true but the percentage is off.

In includes/functions/functions_prices.php

I think this section controls the math

if ($display_normal_price == 0) {
// don't show the $0.00
if(($display_msrp_price!='')&&($display_msrp_price!='0')){
$save=$display_msrp_price-$display_normal_price;
$final_display_price = '<span class="smalltext1"><s>'.TEXT_PRODUCT_MSRP.$currencies->display_price($display_msrp_price, zen_get_tax_rate($product_check->fields['products_tax_class_id'])).'</s></span><br><span class="save">'.TEXT_PRODUCT_SAVE .$currencies->display_price($save, '').'  ('. number_format((($display_msrp_price - $display_normal_price) / $display_msrp_price), 2, '.', '') * 100 . '%)'.'</span><br><span class="norm">'.TEXT_PRODUCT_OUR.$show_special_price . $show_sale_price . $show_sale_discount.'</span>' ;
}else{
$final_display_price = $show_special_price . $show_sale_price . $show_sale_discount;
}
} else {
if(($display_msrp_price!='')&&($display_msrp_price!='0')){
$save=$display_msrp_price-$display_normal_price;
$final_display_price = '<span class="smalltext1"><s>'.TEXT_PRODUCT_MSRP.$currencies->display_price($display_msrp_price, zen_get_tax_rate($product_check->fields['products_tax_class_id'])).'</s></span><br><span class="save">'.TEXT_PRODUCT_SAVE .$currencies->display_price($save, '').'  ('. number_format((($display_msrp_price - $display_normal_price) / $display_msrp_price), 2, '.', '') * 100 . '%)'.'</span><br><span class="norm">'.TEXT_PRODUCT_OUR.$show_normal_price . $show_special_price . $show_sale_price . $show_sale_discount.'</span>' ;
}else{
$final_display_price = $show_normal_price . $show_special_price . $show_sale_price . $show_sale_discount;

I do not remember what i changed to fixed in on mine and i don't use the rem out the MSRP section however you mess with this you should find you answer test on a test site not on your live

How about getting rid of the strike through on MSRP?

Solved it! :clap:, cheers Lextechs.

For anyone who has the same problem i just created an if statement that compares the normal price with the msrp price, if its the same no saving is shown.

I nested it with the If that determines if the msrp should be run, the code below is all you need.

if ($display_normal_price == $display_msrp_price){
$final_display_price = $show_normal_price . $show_special_price . $show_sale_price . $show_sale_discount;
}
	
else{
            .....normal msrp routine}

Or just replace with the whole routine pasted below in
includes/functions/function_prices.php

if ($display_normal_price == 0) {
// don't show the $0.00
if(($display_msrp_price!='')&&($display_msrp_price!='0')){

if ($display_normal_price = $display_msrp_price){
$final_display_price = $show_normal_price . $show_special_price . $show_sale_price . $show_sale_discount;
}


else
{	  
	  
	  
  $save=$display_msrp_price-$display_normal_price;
  	$final_display_price = '<span class="smalltext1"><s>'.TEXT_PRODUCT_MSRP.$currencies->display_price($display_msrp_price, zen_get_tax_rate($product_check->fields['products_tax_class_id'])).'</s></span><br><span class="save">'.TEXT_PRODUCT_SAVE .$currencies->display_price($save, '').'  ('. number_format((($display_msrp_price -  $display_normal_price) / $display_msrp_price), 2, '.', '') * 100 . '%)'.'</span><br><span class="norm">'.TEXT_PRODUCT_OUR.$show_special_price . $show_sale_price . $show_sale_discount.'</span>' ;
  }}else{
  	$final_display_price = $show_special_price . $show_sale_price . $show_sale_discount;
  }
} else {

 if(($display_msrp_price!='')&&($display_msrp_price!='0')){
	 
	 	if ($display_normal_price == $display_msrp_price){
$final_display_price = $show_normal_price . $show_special_price . $show_sale_price . $show_sale_discount;
}
	
else{
	 
	 
 $save=$display_msrp_price-$display_normal_price;
  	$final_display_price = '<span class="smalltext1"><s>'.TEXT_PRODUCT_MSRP.$currencies->display_price($display_msrp_price, zen_get_tax_rate($product_check->fields['products_tax_class_id'])).'</s></span><br><span class="save">'.TEXT_PRODUCT_SAVE .$currencies->display_price($save, '').'  ('. number_format((($display_msrp_price -  $display_normal_price) / $display_msrp_price), 2, '.', '') * 100 . '%)'.'</span><br><span class="norm">'.TEXT_PRODUCT_OUR.$show_normal_price . $show_special_price . $show_sale_price . $show_sale_discount.'</span>' ;
  }}else{
  	$final_display_price = $show_normal_price . $show_special_price . $show_sale_price . $show_sale_discount;
  }
}

majoritywhip:

How about getting rid of the strike through on MSRP?

Why would you want to get rid of the strike through that is the reason for this mod to show your customers that they are not paying MSRP

majoritywhip:

How about getting rid of the strike through on MSRP?

bigsy85:

Solved it! :clap:, cheers Lextechs.

For anyone who has the same problem i just created an if statement that compares the normal price with the msrp price, if its the same no saving is shown.

I nested it with the If that determines if the msrp should be run, the code below is all you need.

if ($display_normal_price == $display_msrp_price){
$final_display_price = $show_normal_price . $show_special_price . $show_sale_price . $show_sale_discount;
}

else{
.....normal msrp routine}

---

Or just replace with the whole routine pasted below in
includes/functions/function_prices.php

if ($display_normal_price == 0) {
// don't show the $0.00
if(($display_msrp_price!='')&&($display_msrp_price!='0')){

if ($display_normal_price = $display_msrp_price){
$final_display_price = $show_normal_price . $show_special_price . $show_sale_price . $show_sale_discount;
}

else
{

$save=$display_msrp_price-$display_normal_price;
  	$final_display_price = '<span class="smalltext1"><s>'.TEXT_PRODUCT_MSRP.$currencies->display_price($display_msrp_price, zen_get_tax_rate($product_check->fields['products_tax_class_id'])).'</s></span><br><span class="save">'.TEXT_PRODUCT_SAVE .$currencies->display_price($save, '').'  ('. number_format((($display_msrp_price -  $display_normal_price) / $display_msrp_price), 2, '.', '') * 100 . '%)'.'</span><br><span class="norm">'.TEXT_PRODUCT_OUR.$show_special_price . $show_sale_price . $show_sale_discount.'</span>' ;
}}else{
	$final_display_price = $show_special_price . $show_sale_price . $show_sale_discount;
}
} else {

if(($display_msrp_price!='')&&($display_msrp_price!='0')){

   	if ($display_normal_price == $display_msrp_price){

$final_display_price = $show_normal_price . $show_special_price . $show_sale_price . $show_sale_discount;
}

else{

$save=$display_msrp_price-$display_normal_price;
$final_display_price = '<span class="smalltext1"><s>'.TEXT_PRODUCT_MSRP.$currencies->display_price($display_msrp_price, zen_get_tax_rate($product_check->fields['products_tax_class_id'])).'</s></span><br><span class="save">'.TEXT_PRODUCT_SAVE .$currencies->display_price($save, '').'  ('. number_format((($display_msrp_price - $display_normal_price) / $display_msrp_price), 2, '.', '') * 100 . '%)'.'</span><br><span class="norm">'.TEXT_PRODUCT_OUR.$show_normal_price . $show_special_price . $show_sale_price . $show_sale_discount.'</span>' ;
}}else{
$final_display_price = $show_normal_price . $show_special_price . $show_sale_price . $show_sale_discount;
}
}

Glad to help just being a good zenner

Hiya,
I'd like to try and use this mod in a slightly different way, but am having trouble...

My client has a 3.0% discount on all cash/bank deposit payments (courtesy of the Payment Type Discount mod), but want's to reflect that discount on the product info page, ie:

Regular price: $5.00
Cash price: $4.85

The price will be the regular price right up until checkout when the Payment Type discount kicks in, so I don't need to pass the correct value to the shopping cart.

Can anyone help with this, please?
TIA!

Hello can anyone help me with this module please?

I am getting a blank home page on my website having installed the module on 1.3.8. I have spent nearly a whole day looking into this. :frusty:

Looking at debugging the error message is:

PHP Parse error: syntax error, unexpected $end in /home/liquidat/public_html/includes/functions/functions_prices.php on line 1359

This is the code debugging refers to 1359 is the last line shown.

// BOF: flat amount discounts
      case ($discount_type_id == 20):
        // flat amount discount Sale and Special without a special
        if (!$attributes_id) {
          $sale_maker_discount = $sale_maker_discount;
        } else {

I checked this area of the file and it wasn't even an area amended by the install so I am confused.

I am also a novice in this area!

I stepped back through the install steps, and once I restored the original functions_prices.php file the site was back to normal. I have tried starting from scratch about 3 times but same error.

I can get into the admin area fine and see the new MSRP field on the product page to add the new price into. It is just this blank home page and I don't know how to go about fixing it.

Can anyone help me please?

Thanks in advance

I have had another go at installing this but still getting the same problem. I am really stuck. Can anyone offer any advice or help? I have struggled through a lot of stuff to get this far with the website and am reluctant to give up here but can't see a way forward unless I can resolve this.

Thanks for any help/advice given - even suggestions for an alternative way to solve the problem

kbalona:

Still doesn't work:(
The instructions said to change catalog/admin/modules/update_product.php but there' no such file, it's in "catalog/admin/includes/modules" I figured it was just a mistake, correct?

I'm going to go through all the steps again and make sure I didn't miss anything.

I think you are missing something a part of the file or something, because when i first loaded this mod i got the blank page as you did then i restored every modified file back to default and got the home page to work, then i went through the mod installion slowly and compared files for a site i added to and knows that it works. anyway it is working on my test site, i am sure i missed something the first time around, here is the link http://lextechs.net/shop/index.php?main_page=product_info&cPath=1_4&products_id=2

I can send you zip file with the files i have modified and work, you would have to use a compare program to compare the files i send you to the ones in your installation of zencart.

Yes that location in the instruction is a type O the file is actually located "catalog/admin/includes/modules"

majoritywhip:

How about getting rid of the strike through on MSRP?

to remove the strike through in functions functions_prices.php, find html tags <s> and</s> there should be two sets in the MSRP section remove them and the strike through is gone

Hello Lextechs

Yes - please send me the zip file for me to have a compare with - thank you.

I am so excited (sad!!) because I finally got this working all by myself!!! :clap:

For anyone else really battling my problem turned out to be in step 5. I had cut and pasted code from the 'read me' instruction file into the functions_prices.php file. On going through the install for about the 5th time line by line i just noticed a visual difference in the code. The code I had cut and pasted had no gaps around the = sign, whereas the code in the original file had gaps.

Here's what I mean

Instruction text file step 5 says:

  Find: 
  
   $display_sale_price = zen_get_products_special_price($products_id, false);
   
  After add:
  
 $display_msrp_price=zen_get_products_msrp_price($products_id);
 $display_price_save=zen_get_products_price_save($products_id);

I changed this to

  After add:
  
 $display_msrp_price = zen_get_products_msrp_price($products_id);
 $display_price_save = zen_get_products_price_save($products_id);

I hope this saves someone the headache I had. Now it is done it does work well and I am pleased so keep perservering if you are struggling!

majoritywhip:

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 'zen_products ADD products_msrp DECIMAL( 15, 4 ) NOT NULL AFTER products_price' at line 1
in:
[ALTER TABLE zen_ zen_products ADD products_msrp DECIMAL( 15, 4 ) NOT NULL AFTER products_price ;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

So then I saw the zen_zen_products statement and figured that I should just write it simply as "products" since the "zen_" was being inserted.

Nope. Here is the error message:

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 'products ADD products_msrp DECIMAL( 15, 4 ) NOT NULL AFTER products_price' at line 1
in:
[ALTER TABLE zen_ products ADD products_msrp DECIMAL( 15, 4 ) NOT NULL AFTER products_price ;]

Any ideas on step one?

Zencart 1.3.8a
I was having the same problem. I inserted in this way.

ALTER TABLE `products`
ADD  `products_msrp` DECIMAL( 15, 4 ) NOT NULL AFTER  `products_price` ;

This worked for me. I hope this help.