MSRP contrib

backinthesaddle:

Hello Lextechs

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

Sent to you email i have attached it here also for any one else

backinthesaddle:

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!

That make sense however is you copied and pasted from the text file there should not have been any gaps when you pasted it over, I am glad you got it working. a good text editor is Notepad++ good for editing almost any file just FYI.

Hi Lextechs - I was using Notepad++. But hey, ho - it is working now, that is the main thing.

I have this loaded on zencart 1.3.8a. Everything looks fine, but I'm having a problem. When my price is higher than the MSRP, the function is still showing. So when people just the page it's showing savings as a negative. So if my price is $4.00 and the MSRP is $3.75. It show my customer that they are saving $-0.25. I thought that is module was to show just my price if it was higher than the MSRP. Why is this showing up?

http://www.jhelectronics.com

smoke133:

I have this loaded on zencart 1.3.8a. Everything looks fine, but I'm having a problem. When my price is higher than the MSRP, the function is still showing. So when people just the page it's showing savings as a negative. So if my price is $4.00 and the MSRP is $3.75. It show my customer that they are saving $-0.25. I thought that is module was to show just my price if it was higher than the MSRP. Why is this showing up?

http://www.jhelectronics.com

Scroll down to bigsy85 that post shows what to do to fix that.

lextechs:

Scroll down to bigsy85 that post shows what to do to fix that.

lextechs, this worked to fix the problem if the MSRP is the same as my price, but it didn't fix it if my price was more than the MSRP.

Here is an example.
http://www.jhelectronics.com/4outlet-ac-conditioned-surge-suppressor-p-34060.html

smoke133:

lextechs, this worked to fix the problem if the MSRP is the same as my price, but it didn't fix it if my price was more than the MSRP.

Here is an example.
http://www.jhelectronics.com/4outlet-ac-conditioned-surge-suppressor-p-34060.html

I would think you could use that section and change to compare for greater than or less than.

I'm not sure I know where your talking about to do that.

I have NO sql and very little php knowledge, though I do manage to kludge my way through.

Building on the MSRP mod idea, I would like to add a couple of fields to the collect_info.php page. I want to add an entry for my cost and an entry for map (Minimum Advertised Price).

IE:
Products Price (Net): 10
Products MSRP: 15
Products MAP: 10
Our Cost: 5
Products Price (Gross):

Then I would like those new values saved into the products table under products_cost and products_map. I was able to create the fields in the DB. But now I don't know how to populate those fields.

Then in my categories list I want to display the cost price next to/under the current product price. This will help me in creating sales and specials without having to look through spreadsheets, web sites and catalogs to make sure I'm not pricing under my own costs.

sonjamichelle:

I have NO sql and very little php knowledge, though I do manage to kludge my way through.

Building on the MSRP mod idea, I would like to add a couple of fields to the collect_info.php page. I want to add an entry for my cost and an entry for map (Minimum Advertised Price).

IE:
Products Price (Net): 10
Products MSRP: 15
Products MAP: 10
Our Cost: 5
Products Price (Gross):

Then I would like those new values saved into the products table under products_cost and products_map. I was able to create the fields in the DB. But now I don't know how to populate those fields.

Then in my categories list I want to display the cost price next to/under the current product price. This will help me in creating sales and specials without having to look through spreadsheets, web sites and catalogs to make sure I'm not pricing under my own costs.

There are two modules that does that one is called MAP pricing and one is cost +profit look in the download section

The MAP mod doesn't do what I want it to do. I don't want to replace my prices with an "add to cart to see price" I personally find that to be a real turn off and will not shop at such a store. I just want the MAP price to be collected in collect_info.php and stored in the db. SO when I add/update products the MAP is in the box for MY reference only.

Basically I want to replicate the existing price box, rename it, and have it store it in the db for me. I guess I can stare at the php files and eventually locate the code to replicate.

The cost + profit mod replaces waaay too many files that I have already modified so I'd have to do an install manually by hand. I really dont have the time for that. Since I don't need a profit report and the list of known issues doesn't allow me to justify taking that time to do a manual install.

So again, I just need to find the price code, replicate it, change the right functions to store it in the DB. Then additionally to list it next to the price in my product listing under admin.

sonjamichelle:

The MAP mod doesn't do what I want it to do. I don't want to replace my prices with an "add to cart to see price" I personally find that to be a real turn off and will not shop at such a store. I just want the MAP price to be collected in collect_info.php and stored in the db. SO when I add/update products the MAP is in the box for MY reference only.

Basically I want to replicate the existing price box, rename it, and have it store it in the db for me. I guess I can stare at the php files and eventually locate the code to replicate.

The cost + profit mod replaces waaay too many files that I have already modified so I'd have to do an install manually by hand. I really dont have the time for that. Since I don't need a profit report and the list of known issues doesn't allow me to justify taking that time to do a manual install.

So again, I just need to find the price code, replicate it, change the right functions to store it in the DB. Then additionally to list it next to the price in my product listing under admin.

Currently with the MSRP mod you get this in your admin product page

Tax Class:
Products Price (Net):
Products MSRP:
Products Price (Gross)

So what i would do is in the first have of the code find reference to MSRP and change it MAP or Cost, the data base line would have to be changed as well. I haven't tried this but i think this code is small enough to manual go through find those tags and change them. If you give me a bit of time i will test this on my test site and post the result here, how fast do you need this?

After staring at the pages, I figured out where the page was storing the data and where it was pulling it out. So now my collect_info.php will store and retrieve values for product map and product cost.

Next I modified my category table with a new column for "cost" Now the raw value shoes up, but it's not formated in currency.

ie:

Instead of showing

Cost:
$5.00

it shows

Cost:
5.0000

It's working the way I want it for the most part. I'd just like to have that extra formating now.

sonjamichelle:

After staring at the pages, I figured out where the page was storing the data and where it was pulling it out. So now my collect_info.php will store and retrieve values for product map and product cost.

Next I modified my category table with a new column for "cost" Now the raw value shoes up, but it's not formated in currency.

ie:

Instead of showing

Cost:
$5.00

it shows

Cost:
5.0000

It's working the way I want it for the most part. I'd just like to have that extra formating now.

Can you post a link or post the file so others who want it might have access to it , and maybe i can help with the formatting

Ok, for some weird reason I can only edit a post within 7 minutes. So now I get to commit the etiquette error of double posting.

Problem solved.

I used the php number_format() tag to format my values. Everything is good to go.

lextechs:

I would think you could use that section and change to compare for greater than or less than.

I still can't get this to work. I tried adding greater than or less than into it, but nothing changed. It still shows all the MSRP even if my price is higher. Where should I be changing this at?

After going through this installation a few times I finally got the MSRP box to show up in the Products editing page but when I put a price in and save the edit it clears the MSRP back to 0.0000. Any ideas on why this is happening.
I added the table manually through phpMyadmin and all looked OK there. Should I delete the line and reenter it through the Install SQL Patches tool?

robrem:

After going through this installation a few times I finally got the MSRP box to show up in the Products editing page but when I put a price in and save the edit it clears the MSRP back to 0.0000. Any ideas on why this is happening.
I added the table manually through phpMyadmin and all looked OK there. Should I delete the line and reenter it through the Install SQL Patches tool?
I solved this problem. For some reason there were no files in the folder Admin/modules that came in my download, and actually the file location for catalog/admin/modules/update_product.php was wrong. /update_product.php is located in catalog/admin/includes/modules in the version I have - v1.3.8a. Once I used the manual installation instructions and placed the changes into the correct file and locations MSRP worked.
Anybody else encountered this?

iZilla_Pod:

I messed around with the code for awhile. Hopefully this will help someone.

Heres the original piece of code for the contribution you will be replacing:

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">' . TEXT_PRODUCT_MSRP . '<s>' . $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">'.TEXT_PRODUCT_MSRP.'<s>'.$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;
  }
}

> This will show the "You Save" with dollar amount only:
> ```php
    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">' . TEXT_PRODUCT_MSRP . '<s>' . $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, '') . '</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">'.TEXT_PRODUCT_MSRP.'<s>'.$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, '') . '</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;
      }
    }

This will show the "You Save" as a percentage only:

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">' . TEXT_PRODUCT_MSRP . '<s>' . $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 . number_format((($display_msrp_price -  $display_normal_price)), 2, '.', '') . '%' . '</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">'.TEXT_PRODUCT_MSRP.'<s>'.$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 . number_format((($display_msrp_price -  $display_normal_price)), 2, '.', '') . '%' . '</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;
  }
}

> This will remove the "You Save" line completely:
> ```php
    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">' . TEXT_PRODUCT_MSRP . '<s>' . $currencies->display_price($display_msrp_price, zen_get_tax_rate($product_check->fields['products_tax_class_id'])) . '</s></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">'.TEXT_PRODUCT_MSRP.'<s>'.$currencies->display_price($display_msrp_price, zen_get_tax_rate($product_check->fields['products_tax_class_id'])).'</s></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'm also looking at moving the "You Save" line below the "MSRP Price" and "Our Price" so that it's in a more logical order. I need to get some rest right now though.
What file are you making these changes in?

Okay, I got it installed and working thanks to the posters here. Now I want to be able to fill the MSRP field using Easy Populate. I set up a column in my .csv file that matches the database field name but no data shows up in ZC when I upload the file. I get no errors.
I can manually enter a price and then it shows up okay on the product info page. Here is the one that I entered manually.
http://www.thecablestation.com/index.php?main_page=product_info&products_id=4936

As you can see it is working, I just don't want to have to add 5000+ the hard way.