MSRP contrib

[gee38l]

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

[sublime19]

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.

[chris91]

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
Thanks
Chris

[CoolCarPartsOnline]

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

[CoolCarPartsOnline]

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.

[willstyle]

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 :)

[bigsy85]

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/...-p-124253.html

[lextechs]

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, '').'&nbsp;&nbsp;('. 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, '').'&nbsp;&nbsp;('. 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

[majoritywhip]

How about getting rid of the strike through on MSRP?

[bigsy85]

Solved it! , 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, '').'&nbsp;&nbsp;('. 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, '').'&nbsp;&nbsp;('. 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;
}
}