MSRP contrib

Printable View

Show 100 post(s) from this thread on one page

3 Jan 2007, 12:21 AM
hbtrading

1 Attachment(s)

MSRP contrib

here is an MSRP MOD ported from Oscommerce.

I do not offer any support for this MOD as I had someone else install it on my web site and it seems to be working.

What it does:
-adds MSRP field in to the admin side product description.
-displays in the following format Retail Price: $100.00 (this is crossed out)
You Save: $25.00 (25%)
Your Price: $75.00
-CSS additions
-If no MSRP is entered than the MSRP will not show up.

I don't offer any support for this mod as I got someone to convert it from oscommerce to zen and install it on my website.

Please see attached file for mod
30 Jan 2007, 07:26 PM
lextechs

Re: MSRP contrib

Quote:

Originally Posted by hbtrading

here is an MSRP MOD ported from Oscommerce.

I do not offer any support for this MOD as I had someone else install it on my web site and it seems to be working.

What it does:
-adds MSRP field in to the admin side product description.
-displays in the following format Retail Price: $100.00 (this is crossed out)
You Save: $25.00 (25%)
Your Price: $75.00
-CSS additions
-If no MSRP is entered than the MSRP will not show up.

I don't offer any support for this mod as I got someone to convert it from oscommerce to zen and install it on my website.

Please see attached file for mod

What version of Zen cart does this work on?
9 Feb 2007, 01:54 AM
hbtrading

Re: MSRP contrib

I have it working on version 1.3.7 ..probably would work for other versions as well
10 Apr 2007, 10:40 PM
lextechs

Re: MSRP contrib

Same here is works well on Version 1.3.7
17 Apr 2007, 03:07 PM
notset4life

Re: MSRP contrib

It looked like it was working well. However, I launched a sale and found that somehow, the sale prices are now overwridden - on any product, even one without using the MSRP mod.

On the first page, it shows the sale price, but when clicking info on the product, is just shows the regular price and process that to checkout.
17 Apr 2007, 08:29 PM
hbtrading

Re: MSRP contrib

I was not able to replicate the problem you are describing see here:
http://www.hbwatches.com/paw-1300t-7...tch-p-328.html
8 May 2007, 02:32 PM
kalu-desi

Re: MSRP contrib

Besides hbtrading, I see others have gotten this to work. I was trying to implement the changes in ZenCart 1.3.7 and can see the MSRP/PRICE when I administer the shopping cart from domain/store/login in the Catalogs/Products section. But I don't see the MSRP and information on the actual site pages. There is one or two sections in the MSRP contrib text file that don't coincide with my setup.

Step 3: catalog/admin/modules/update_product.php... On my install I have the install folder which I assume is catalog then /admin/includes/modules/update_php... Is that right?

Step 4: has the same setup as above except using the file -- collect_info.php

Any help would be appreciated if somebody could point me in the right direction. :(
8 May 2007, 02:54 PM
kalu-desi

Re: MSRP contrib

Nevermind!!!

I got it working :laugh:

I was working late last night and must have fubarred the function_prices page. When I went back this morning and looked at line by line I noticed I was missing a couple sections of code. :oops:

Thanks for contributing the mod HBTrading. I needed this one badly for a client's site.
9 May 2007, 07:55 AM
hbtrading

Re: MSRP contrib

You welcome!
I actually paid someone to port it from Oscommerce :)
27 May 2007, 02:45 PM
kitten091182

Re: MSRP contrib

hi, i am having trouble with step one of this, was wondering if anyone can help? i dont understand what i have to do when it says add new field to products table? there is a line of code after that contains ' tableprefix_products' but this is nowhere in my zen cart files.
i know how to do the rest, just need to get past this part. thanks in advance.
27 May 2007, 03:15 PM
azrahn

Re: MSRP contrib

Hi,

Quote:

there is a line of code after that contains ' tableprefix_products' but this is nowhere in my zen cart files.

You need to copy that line into the sql tool in the admin panel.

Ronald.
27 May 2007, 05:45 PM
kitten091182

Re: MSRP contrib

its ok thanks. thanks for responding to my question, but i managed to work out how to add it through phpmyadmin. it didnt work when i tried to use the sql tool. its all done now though and working very well.
Although, i cant quite figure out how to change the font sizes on the product listing pages only. I have done it for the product info pages, but cant work out the css codes for the product listing pages.

looking at the css classes, it says .boldPrice, but for each individual price it says .save .norm and .smalltext1. but dont know how to assign it specifically to product listing page.

Any help would be gratefully appreciated. Thanks
19 Jul 2007, 06:34 PM
kbalona

Re: MSRP contrib

After installing this contrib, I'm trying to update a product and I'm getting this error when I click "Update":
Parse error: syntax error, unexpected ')' in /home/********/public_html/store/*****/includes/modules/update_product.php on line 26

This is line 26 of that file:
$tmp_value = zen_db_prepare_input($_POST['products_msrp']);

Anyone see why there should be a problem with that line?
19 Jul 2007, 11:56 PM
lextechs

Re: MSRP contrib

Quote:

Originally Posted by kbalona

After installing this contrib, I'm trying to update a product and I'm getting this error when I click "Update":
Parse error: syntax error, unexpected ')' in /home/********/public_html/store/*****/includes/modules/update_product.php on line 26

This is line 26 of that file:
$tmp_value = zen_db_prepare_input($_POST['products_msrp']);

Anyone see why there should be a problem with that line?

Some time the error maybe above or below the line that it actual says it on.
This is line 23 and 24 for me hope this helps it works on my site

$tmp_value = zen_db_prepare_input($_POST['products_msrp']);

$products_msrp = (!zen_not_null($tmp_value) || $tmp_value=='' || $tmp_value == 0) ? 0 : $tmp_value;
20 Jul 2007, 12:52 PM
kbalona

Re: MSRP contrib

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.
20 Jul 2007, 03:20 PM
kbalona

Re: MSRP contrib

OK, I re-did changing the Admin files and it works now:)
Thanks for the help.
20 Jul 2007, 03:35 PM
kbalona

Re: MSRP contrib

The only thing is, I wish I could take out the percentage that you save. I want it to say "You save $x.xx", instead of "You save $x.xx (xx%)".
But I'm not good enough with php to find the right places to edit, nor do I know if it's possible.
21 Jul 2007, 06:09 PM
kbalona

Re: MSRP contrib

After a couple hours of messing around, I changed it to like I want, except it doesn't say You Save. All it has now is Retail price crossed out, and our price.
23 Jul 2007, 09:50 PM
lextechs

Re: MSRP contrib

Quote:

Originally Posted by kbalona

After a couple hours of messing around, I changed it to like I want, except it doesn't say You Save. All it has now is Retail price crossed out, and our price.

I like what you did, i didn't write the code so i was trying to help the best i could. how did you change it so $ instead of %
24 Jul 2007, 06:35 PM
MSGOK

Re: MSRP contrib

I have been looking for this mod for months. Now since I have found it, I can't seem to install it. I am having problem with step one. I have Zen. 1.3.7, I have tried going through the Zen-Cart Admin Panel and the phpmyadmin, still no sucess.

The error kept telling me it can't find "tableprefix_products".
24 Jul 2007, 09:00 PM
kbalona

Re: MSRP contrib

Change where it says "table_prefix" to whatever your table prefix is. On my database, the prefix is "zen_". So in my case, I changed it to "zen_products"

Lextechs, I snipped code here and there, I can't even remember where all I modified, lol. I'll post the file in a little bit:)
25 Jul 2007, 01:48 AM
MSGOK

Re: MSRP contrib

Thanks so much, kbalona. I finally got it to work.
25 Jul 2007, 06:35 PM
lextechs

Re: MSRP contrib

Quote:

Originally Posted by kbalona

Change where it says "table_prefix" to whatever your table prefix is. On my database, the prefix is "zen_". So in my case, I changed it to "zen_products"

Lextechs, I snipped code here and there, I can't even remember where all I modified, lol. I'll post the file in a little bit:)

No rush whenever you get a chance i like that $ look better than the %. But like most retailers they use % so the market would show % is a better way to appeal to customers. However i still want to test out the two between $ and % see which picks up sales
11 Aug 2007, 11:05 PM
Spdster

Re: MSRP contrib

Im willing to pya someone to add this mod to my website. Email me if you can?

[email protected]
25 Sep 2007, 10:03 AM
narodk

Re: MSRP contrib

I tried to do this 3 times and everytime i go to the Product to edit it, it gives me the same parse error at line 65.

Can ANYONE?? Please help?
25 Sep 2007, 11:06 AM
kbalona

Re: MSRP contrib

I re-uploaded all the files, and then carefully re-configured all of them. That did the trick for me.
26 Sep 2007, 10:02 AM
narodk

Re: MSRP contrib

this is the error I keep getting:

Parse error: parse error, unexpected ':' in /home/content/i/n/s/installer**/html/store/admin/includes/modules/product/collect_info.php on line 66
26 Sep 2007, 10:30 AM
narodk

Re: MSRP contrib

Nevermind I got it to work. Had to really look carefully.
10 Dec 2007, 06:59 PM
PastelBlack

Re: MSRP contrib

Simply amazing!!!! This is exactly what I was looking for!
28 Jan 2008, 07:38 PM
lankeeyankee

1 Attachment(s)

Re: MSRP contrib

When you put a product on special, you get the msrp, our price crossed out with the new special price next to it, the savings from "our price" to the specials price in %, and then the original % off. See the screenshot.

I've been fooling around with functions_prices.php to try to get it to show just the msrp, specials price, and total % discount, when an item in on special. But so far, I haven't gotten it.

Does anyone have any idea how to make it work like that?

Thanks!

Matt
8 Jun 2008, 09:49 AM
knighs2

Re: MSRP contrib

Hi Guys,

I have a question for those who have installed this mod. Does the msrp price show in the cart n checkout screens ?so you can see the original price throughout?
thanks
shane
9 Jun 2008, 06:18 AM
iZilla_Pod

Re: MSRP contrib

Quote:

Originally Posted by knighs2

Hi Guys,

I have a question for those who have installed this mod. Does the msrp price show in the cart n checkout screens ?so you can see the original price throughout?
thanks
shane

No it does not for me. Only the actual price is displayed in the shopping cart and checkout pages, not the MSRP price.
9 Jun 2008, 07:07 AM
iZilla_Pod

Re: MSRP contrib

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:

PHP Code:

 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 = '' . TEXT_PRODUCT_MSRP . '<s>' . $currencies->display_price($display_msrp_price, zen_get_tax_rate($product_check->fields['products_tax_class_id'])) . '</s> ' . TEXT_PRODUCT_SAVE .$currencies->display_price($save, '') . '  ('. number_format((($display_msrp_price - $display_normal_price) / $display_msrp_price), 2, '.', '') * 100 . '%)' . ' ' . TEXT_PRODUCT_OUR.$show_special_price . $show_sale_price . $show_sale_discount.'' ; }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 = ''.TEXT_PRODUCT_MSRP.'<s>'.$currencies->display_price($display_msrp_price, zen_get_tax_rate($product_check->fields['products_tax_class_id'])).'</s> '.TEXT_PRODUCT_SAVE .$currencies->display_price($save, '').'  ('. number_format((($display_msrp_price - $display_normal_price) / $display_msrp_price), 2, '.', '') * 100 . '%)'.' '.TEXT_PRODUCT_OUR.$show_normal_price . $show_special_price . $show_sale_price . $show_sale_discount.'' ; }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 Code:

 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 = '' . TEXT_PRODUCT_MSRP . '<s>' . $currencies->display_price($display_msrp_price, zen_get_tax_rate($product_check->fields['products_tax_class_id'])) . '</s> ' . TEXT_PRODUCT_SAVE . $currencies->display_price($save, '') . ' ' . TEXT_PRODUCT_OUR.$show_special_price . $show_sale_price . $show_sale_discount.'' ; }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 = ''.TEXT_PRODUCT_MSRP.'<s>'.$currencies->display_price($display_msrp_price, zen_get_tax_rate($product_check->fields['products_tax_class_id'])).'</s> '.TEXT_PRODUCT_SAVE . $currencies->display_price($save, '') . ' '.TEXT_PRODUCT_OUR.$show_normal_price . $show_special_price . $show_sale_price . $show_sale_discount.'' ; }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:

PHP Code:

 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 = '' . TEXT_PRODUCT_MSRP . '<s>' . $currencies->display_price($display_msrp_price, zen_get_tax_rate($product_check->fields['products_tax_class_id'])) . '</s> ' . TEXT_PRODUCT_SAVE . number_format((($display_msrp_price - $display_normal_price)), 2, '.', '') . '%' . ' ' . TEXT_PRODUCT_OUR.$show_special_price . $show_sale_price . $show_sale_discount.'' ; }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 = ''.TEXT_PRODUCT_MSRP.'<s>'.$currencies->display_price($display_msrp_price, zen_get_tax_rate($product_check->fields['products_tax_class_id'])).'</s> '.TEXT_PRODUCT_SAVE . number_format((($display_msrp_price - $display_normal_price)), 2, '.', '') . '%' . ' '.TEXT_PRODUCT_OUR.$show_normal_price . $show_special_price . $show_sale_price . $show_sale_discount.'' ; }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 Code:

 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 = '' . TEXT_PRODUCT_MSRP . '<s>' . $currencies->display_price($display_msrp_price, zen_get_tax_rate($product_check->fields['products_tax_class_id'])) . '</s> ' . '' . TEXT_PRODUCT_OUR.$show_special_price . $show_sale_price . $show_sale_discount.'' ; }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 = ''.TEXT_PRODUCT_MSRP.'<s>'.$currencies->display_price($display_msrp_price, zen_get_tax_rate($product_check->fields['products_tax_class_id'])).'</s> ' . ''.TEXT_PRODUCT_OUR.$show_normal_price . $show_special_price . $show_sale_price . $show_sale_discount.'' ; }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.
19 Jun 2008, 01:41 PM
bettysue

Re: MSRP contrib

Does anyone know if this works on v1.38a?

thank you,

betty
20 Jun 2008, 05:45 PM
snowy2008

Re: MSRP contrib

Quote:

Originally Posted by bettysue

Does anyone know if this works on v1.38a?

thank you,

betty

I have just installed it on v1.38a and it appears to work just fine. Just made a quick mod to it so that the savings shown include tax.
25 Jun 2008, 02:05 PM
boykor

Re: MSRP contrib

Did you ever get the first step? tableprefix_products?
15 Jul 2008, 05:46 AM
bx1

Desperate need of help...cannot log into admin

Hi All,

I'm in desperate need of help. I cannot log into my admin and I believe it has something to do with this contribution. I have uninstalled and reinstalled and drop tables and added tables and nothing I do seems to work. When I go to my admin log in page I get this error...

Fatal error: Cannot redeclare zen_update_products_price_sorter() (previously declared in /store/admin/includes/functions/general.php:2512) in /store/admin/includes/functions/functions_prices.php on line 2672

Please help!!!!
25 Jul 2008, 11:02 PM
mehmehmeh

Re: Desperate need of help...cannot log into admin

I just installed this mod, and had the same problem as bx1. in case you haven't figured out the error here is the solution

for step 5 the file asks you to modify this file
in includes/functions/functions_prices.php

but it should be admin/includes/functions/functions_prices.php

this was a bit confusing since all the text to find and edit seems to be in both files.
26 Jul 2008, 07:20 PM
mehmehmeh

Re: Desperate need of help...cannot log into admin

Quote:

Originally Posted by mehmehmeh

I just installed this mod, and had the same problem as bx1. in case you haven't figured out the error here is the solution

for step 5 the file asks you to modify this file
in includes/functions/functions_prices.php

but it should be admin/includes/functions/functions_prices.php

this was a bit confusing since all the text to find and edit seems to be in both files.

seems I can't edit my post. I was wrong, step 5 is still editing the file includes/functions/functions_prices.php NOT the admin one I posted earlier.

I had tried to install the mod twice before and got the same error so I tried editing the other file and it didn't throw the error at the admin console but then I noticed the msrp was not showing up in the store. Carefully editing includes/functions/functions_prices.php
for the third time got me the desired results.
27 Jul 2008, 07:25 AM
fightthefourwalls

Re: MSRP contrib

Wicked contribution thanks!!!

I was just wondering if anyone had any luck modifying the code so that it shows pricing as usual on the product listings under your categories, then shows all pricing on the product info page?

Anyone who figures this out would be a hero!

I tried this approach too as it seems to do what I want but couldnt get it working
http://forum.zen-cart.com/showthread.php?t=77819

Thanks in advance,
Nick.
1 Aug 2008, 01:23 AM
lextechs

Re: MSRP contrib

Quote:

Originally Posted by 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:

PHP Code:

 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 = '' . TEXT_PRODUCT_MSRP . '<s>' . $currencies->display_price($display_msrp_price, zen_get_tax_rate($product_check->fields['products_tax_class_id'])) . '</s> ' . TEXT_PRODUCT_SAVE .$currencies->display_price($save, '') . '  ('. number_format((($display_msrp_price - $display_normal_price) / $display_msrp_price), 2, '.', '') * 100 . '%)' . ' ' . TEXT_PRODUCT_OUR.$show_special_price . $show_sale_price . $show_sale_discount.'' ; }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 = ''.TEXT_PRODUCT_MSRP.'<s>'.$currencies->display_price($display_msrp_price, zen_get_tax_rate($product_check->fields['products_tax_class_id'])).'</s> '.TEXT_PRODUCT_SAVE .$currencies->display_price($save, '').'  ('. number_format((($display_msrp_price - $display_normal_price) / $display_msrp_price), 2, '.', '') * 100 . '%)'.' '.TEXT_PRODUCT_OUR.$show_normal_price . $show_special_price . $show_sale_price . $show_sale_discount.'' ; }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 Code:

 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 = '' . TEXT_PRODUCT_MSRP . '<s>' . $currencies->display_price($display_msrp_price, zen_get_tax_rate($product_check->fields['products_tax_class_id'])) . '</s> ' . TEXT_PRODUCT_SAVE . $currencies->display_price($save, '') . ' ' . TEXT_PRODUCT_OUR.$show_special_price . $show_sale_price . $show_sale_discount.'' ; }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 = ''.TEXT_PRODUCT_MSRP.'<s>'.$currencies->display_price($display_msrp_price, zen_get_tax_rate($product_check->fields['products_tax_class_id'])).'</s> '.TEXT_PRODUCT_SAVE . $currencies->display_price($save, '') . ' '.TEXT_PRODUCT_OUR.$show_normal_price . $show_special_price . $show_sale_price . $show_sale_discount.'' ; }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:

PHP Code:

 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 = '' . TEXT_PRODUCT_MSRP . '<s>' . $currencies->display_price($display_msrp_price, zen_get_tax_rate($product_check->fields['products_tax_class_id'])) . '</s> ' . TEXT_PRODUCT_SAVE . number_format((($display_msrp_price - $display_normal_price)), 2, '.', '') . '%' . ' ' . TEXT_PRODUCT_OUR.$show_special_price . $show_sale_price . $show_sale_discount.'' ; }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 = ''.TEXT_PRODUCT_MSRP.'<s>'.$currencies->display_price($display_msrp_price, zen_get_tax_rate($product_check->fields['products_tax_class_id'])).'</s> '.TEXT_PRODUCT_SAVE . number_format((($display_msrp_price - $display_normal_price)), 2, '.', '') . '%' . ' '.TEXT_PRODUCT_OUR.$show_normal_price . $show_special_price . $show_sale_price . $show_sale_discount.'' ; }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 Code:

 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 = '' . TEXT_PRODUCT_MSRP . '<s>' . $currencies->display_price($display_msrp_price, zen_get_tax_rate($product_check->fields['products_tax_class_id'])) . '</s> ' . '' . TEXT_PRODUCT_OUR.$show_special_price . $show_sale_price . $show_sale_discount.'' ; }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 = ''.TEXT_PRODUCT_MSRP.'<s>'.$currencies->display_price($display_msrp_price, zen_get_tax_rate($product_check->fields['products_tax_class_id'])).'</s> ' . ''.TEXT_PRODUCT_OUR.$show_normal_price . $show_special_price . $show_sale_price . $show_sale_discount.'' ; }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.

Thanks for sharing that info but i am not sure if you notice that the percent is the dollar amount saved in percent, for example if your saving 500.00 is will look like this 500% and the value is not the true percent of saving. To get the true percent all you have to is remove this section of the code

.$currencies->display_price($save, '')

In both lines as you shown

it should then look like this

.'  ('. number_format((($display_msrp_price - $display_normal_price) / $display_msrp_price), 2, '.', '') * 100 . '%)'.' '.TEXT_PRODUCT_OUR.$show_special_price . $show_sale_price . $show_sale_discount.'' ;

You can view it in action at www.lextechs.com
22 Sep 2008, 04:59 PM
kburner

Re: MSRP contrib

Is this the latest file? Somewhere I thought I read that you wanted to change some files....

I noticed in the reading of the posts you have an area to show php code for %, $ only not Both. What file is that located in?

For step #1 - Do I insert the entire line starting from Alter table.....to products_price; into my SQL file?

Great job with this mod! Thank you.
23 Sep 2008, 11:03 PM
kburner

Re: MSRP contrib

Ok I figured out how to do #1. Or at least there are no errors.

But, My right sideboxes are gone. I made first mistake with instruction #5 and loaded to wrong file. Fixed that. But does anyone know which file would effect the right sideboxes only???

Thanks,
Kim
23 Sep 2008, 11:15 PM
kburner

Re: MSRP contrib

Quote:

Originally Posted by kalu-desi

Besides hbtrading, I see others have gotten this to work. I was trying to implement the changes in ZenCart 1.3.7 and can see the MSRP/PRICE when I administer the shopping cart from domain/store/login in the Catalogs/Products section. But I don't see the MSRP and information on the actual site pages. There is one or two sections in the MSRP contrib text file that don't coincide with my setup.

Step 3: catalog/admin/modules/update_product.php... On my install I have the install folder which I assume is catalog then /admin/includes/modules/update_php... Is that right?

Step 4: has the same setup as above except using the file -- collect_info.php

Any help would be appreciated if somebody could point me in the right direction. :(

I have the same setup with Step 3 & 4. Did you use the /admin/includes/modules/....? I tried it and my right sidebox is gone??

I have version1.3.8a.

Any help is greatly appreciated! Kim
24 Sep 2008, 04:47 PM
kburner

Re: MSRP contrib

Quote:

Originally Posted by kbalona

OK, I re-did changing the Admin files and it works now:)
Thanks for the help.

What did you do? My files are located the same way with admin/includes/modules not admin/modules. Did you re-locate the file or just go the one in admin/includes/modules?

Thanks,
Kim
25 Sep 2008, 06:14 PM
kburner

Re: MSRP contrib

Hello...I am still trying to get this contri to work. I made sure the SQL (#1 in directions) is on my table.

When I go into a product from the admin area, I preview the MSRP price, etc and when I hit save. I keep getting this error. I have gone through the coding and can't seem to find the problem. I copied some before and after line 178. It is right at the end of the file.

error: Parse error: syntax error, unexpected '}' in /home/####/####/admin/includes/modules/update_product.php on line 178

exec(DIR_IMAGEMAGICK . "mogrify -geometry " . $small_width . " " . $filename_small);
}
}

zen_redirect(zen_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&pID=' . $products_id . (isset($_GET['page']) ? '&page=' . $_GET['page'] : '')));
}
?>
25 Sep 2008, 08:46 PM
kburner

Re: MSRP contrib

YAH! Finally got this contri to work.

Does anyone know how to do a mass 10% without using other regular discount??

It looks really good! Thank you!:clap:
1 Oct 2008, 03:40 PM
lextechs

Re: MSRP contrib

Quote:

Originally Posted by kburner

YAH! Finally got this contri to work.

Does anyone know how to do a mass 10% without using other regular discount??

It looks really good! Thank you!:clap:

you might want the try the mod call quick update, you can do mass price changes
2 Oct 2008, 04:43 PM
kburner

Re: MSRP contrib

hbtrading,

I really like your product display for www.hbwatches.com.

Did you use the tab products pro mod? What mod?

Thanks, Kim
2 Oct 2008, 08:58 PM
jasonk

Re: MSRP contrib

There is no such directory structure as

catalog/admin/modules/update_product.php
3 Oct 2008, 12:24 PM
kburner

Re: MSRP contrib

hbtrading,

I really like your product display for www.hbwatches.com.

Did you use the tab products pro mod? What mod?

Thanks, Kim
##############################___
kburner
www.burnerbooks.com

I accidently put this post in the wrong area....can someone please move it? Thanks, Kim
15 Oct 2008, 12:33 AM
majoritywhip

Re: MSRP contrib

I have the same question as Kitteh
28 Oct 2008, 07:12 PM
ceegeeaar

Re: MSRP contrib

I have a site with 16000 products already on it I'd like to add this mod to. What is the best way to get the RRP pricing into the database?

I can create a csv with product id and rrp but no idea how to get that data into the database in the right place and in the right order. I could use vlookup in a spreadsheet if I can get the products table into a csv or something similar and be able to reimport it but im sure there must be an easier way to do it.

Can anybody help?

Thankyou
Claire
30 Oct 2008, 12:39 PM
ceegeeaar

Re: MSRP contrib

I've created a table zen_products_rrp with products_model and rrp in it and imported a csv with the relevant information.

Ive created products_msrp in zen_products and am trying to update it with the correct rrp's.

Can anyone tell me what is wrong with this sql query in phpmyadmin..

UPDATE 'zen_products' SET `products_msrp` = ( SELECT 'rrp'
FROM 'zen_products_rrp'
WHERE 'zen_products_rrp.products_model' = `zen_products.products_model` )

It returns an error..

#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' SET `products_msrp` = ( SELECT 'rrp'
FROM 'zen_products_rrp'
WH' at line 1

Im picking this up as I go along so syntax could be completely wrong!

Thankyou
Claire
30 Oct 2008, 01:03 PM
ceegeeaar

Re: MSRP contrib

Worked it out, thanks anyway. It works if you remove the 's
30 Oct 2008, 01:15 PM
ceegeeaar

Re: MSRP contrib

Hmm the problem now is that leading 0's have been stripped from my model numbers in zen_products so dont match the rrp ones. :ohmy:
10 Nov 2008, 11:56 PM
majoritywhip

Re: MSRP contrib

Trying to get this to work for me but I can't seem to add the table to my DB. I have no idea how to do this with phpMyadmin, so I tried the script using the SQL patches tool in admin.

Here is the code that I submitted:

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

And here is the error that I received:

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?
11 Nov 2008, 01:20 PM
ceegeeaar

Re: MSRP contrib

make sure you are using the slanty quotes next to number 1 and not single quotes next to semi-colon on your keyboard. It is usually Ok to ommit them if in any doubt.

Always make a backup of your database before messing with it though.
12 Nov 2008, 07:09 PM
melvin41bet

Re: MSRP contrib

Hi,

I did everything it said but my store still shows just my regular prices. I do not see any error messages to why it want show the MSRP prices and YOU SAVE percentage.

http://lazywebprofits.com/cstore/
19 Nov 2008, 10:12 AM
majoritywhip

Re: MSRP contrib

OK. I discovered that the script doesn't work in the SQL Patches tool and I got it to work using MyPHPadmin. What a great Contrib!

I have one more request, if y'all don't mind...

I would like to get rid of the strike through in "Retail Price" while still leaving it in the dollar amount.

I find it unreadable when it spans the entire line.

Any help would be exceptionally appreciated.
29 Nov 2008, 06:55 AM
gee38l

Re: 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???
29 Nov 2008, 08:07 AM
sublime19

Re: MSRP contrib

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.
29 Dec 2008, 08:31 PM
chris91

Re: MSRP contrib

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
31 Dec 2008, 12:45 AM
CoolCarPartsOnline

Re: MSRP contrib

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

Code:

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

to your sql tables in my case it was

Code:

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
31 Dec 2008, 12:49 AM
CoolCarPartsOnline

Re: MSRP contrib

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.
3 Jan 2009, 02:16 PM
willstyle

Re: MSRP contrib

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

http://img.photobucket.com/albums/v4...e/untitled.jpg

any help will be duly wanted :)
11 Feb 2009, 06:27 PM
bigsy85

Re: MSRP contrib

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
11 Feb 2009, 09:08 PM
lextechs

Re: MSRP contrib

Quote:

Originally Posted by 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 = '<s>'.TEXT_PRODUCT_MSRP.$currencies->display_price($display_msrp_price, zen_get_tax_rate($product_check->fields['products_tax_class_id'])).'</s> '.TEXT_PRODUCT_SAVE .$currencies->display_price($save, '').'  ('. number_format((($display_msrp_price - $display_normal_price) / $display_msrp_price), 2, '.', '') * 100 . '%)'.' '.TEXT_PRODUCT_OUR.$show_special_price . $show_sale_price . $show_sale_discount.'' ;
}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 = '<s>'.TEXT_PRODUCT_MSRP.$currencies->display_price($display_msrp_price, zen_get_tax_rate($product_check->fields['products_tax_class_id'])).'</s> '.TEXT_PRODUCT_SAVE .$currencies->display_price($save, '').'  ('. number_format((($display_msrp_price - $display_normal_price) / $display_msrp_price), 2, '.', '') * 100 . '%)'.' '.TEXT_PRODUCT_OUR.$show_normal_price . $show_special_price . $show_sale_price . $show_sale_discount.'' ;
}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
12 Feb 2009, 06:52 AM
majoritywhip

Strike Through - MSRP

How about getting rid of the strike through on MSRP?
12 Feb 2009, 06:27 PM
bigsy85

Re: MSRP contrib

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 = '<s>'.TEXT_PRODUCT_MSRP.$currencies->display_price($display_msrp_price, zen_get_tax_rate($product_check->fields['products_tax_class_id'])).'</s> '.TEXT_PRODUCT_SAVE .$currencies->display_price($save, '').'  ('. number_format((($display_msrp_price - $display_normal_price) / $display_msrp_price), 2, '.', '') * 100 . '%)'.' '.TEXT_PRODUCT_OUR.$show_special_price . $show_sale_price . $show_sale_discount.'' ;
}}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 = '<s>'.TEXT_PRODUCT_MSRP.$currencies->display_price($display_msrp_price, zen_get_tax_rate($product_check->fields['products_tax_class_id'])).'</s> '.TEXT_PRODUCT_SAVE .$currencies->display_price($save, '').'  ('. number_format((($display_msrp_price - $display_normal_price) / $display_msrp_price), 2, '.', '') * 100 . '%)'.' '.TEXT_PRODUCT_OUR.$show_normal_price . $show_special_price . $show_sale_price . $show_sale_discount.'' ;
}}else{
$final_display_price = $show_normal_price . $show_special_price . $show_sale_price . $show_sale_discount;
}
}
15 Feb 2009, 09:42 AM
lextechs

Re: Strike Through - MSRP

Quote:

Originally Posted by 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
15 Feb 2009, 09:43 AM
lextechs

Re: MSRP contrib

Quote:

Originally Posted by majoritywhip

How about getting rid of the strike through on MSRP?

Quote:

Originally Posted by 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 = '<s>'.TEXT_PRODUCT_MSRP.$currencies->display_price($display_msrp_price, zen_get_tax_rate($product_check->fields['products_tax_class_id'])).'</s> '.TEXT_PRODUCT_SAVE .$currencies->display_price($save, '').'  ('. number_format((($display_msrp_price - $display_normal_price) / $display_msrp_price), 2, '.', '') * 100 . '%)'.' '.TEXT_PRODUCT_OUR.$show_special_price . $show_sale_price . $show_sale_discount.'' ;
}}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 = '<s>'.TEXT_PRODUCT_MSRP.$currencies->display_price($display_msrp_price, zen_get_tax_rate($product_check->fields['products_tax_class_id'])).'</s> '.TEXT_PRODUCT_SAVE .$currencies->display_price($save, '').'  ('. number_format((($display_msrp_price - $display_normal_price) / $display_msrp_price), 2, '.', '') * 100 . '%)'.' '.TEXT_PRODUCT_OUR.$show_normal_price . $show_special_price . $show_sale_price . $show_sale_discount.'' ;
}}else{
$final_display_price = $show_normal_price . $show_special_price . $show_sale_price . $show_sale_discount;
}
}

Glad to help just being a good zenner
23 Feb 2009, 08:28 PM
nsanford

Re: MSRP contrib

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!
6 Mar 2009, 05:16 PM
backinthesaddle

Re: MSRP contrib

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.

Code:

// 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
8 Mar 2009, 07:09 PM
backinthesaddle

Re: MSRP contrib

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
9 Mar 2009, 06:16 PM
lextechs

Re: MSRP contrib

Quote:

Originally Posted by 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?m...&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"
9 Mar 2009, 06:25 PM
lextechs

Re: Strike Through - MSRP

Quote:

Originally Posted by 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
10 Mar 2009, 11:37 AM
backinthesaddle

Re: MSRP contrib

Hello Lextechs

Yes - please send me the zip file for me to have a compare with - thank you.
10 Mar 2009, 01:06 PM
backinthesaddle

Re: MSRP contrib

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:

Code:

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

Code:

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!
10 Mar 2009, 01:50 PM
smoke133

Re: MSRP contrib

Quote:

Originally Posted by 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.

Code:

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

This worked for me. I hope this help.
10 Mar 2009, 03:39 PM
lextechs

1 Attachment(s)

Re: MSRP contrib

Quote:

Originally Posted by 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
10 Mar 2009, 03:43 PM
lextechs

Re: MSRP contrib

Quote:

Originally Posted by 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:

Code:

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

Code:

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.
10 Mar 2009, 09:24 PM
backinthesaddle

Re: MSRP contrib

Hi Lextechs - I was using Notepad++. But hey, ho - it is working now, that is the main thing.
12 Mar 2009, 09:11 PM
smoke133

Re: MSRP contrib

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
13 Mar 2009, 04:16 AM
lextechs

Re: MSRP contrib

Quote:

Originally Posted by 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.
13 Mar 2009, 04:36 AM
smoke133

Re: MSRP contrib

Quote:

Originally Posted by 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...r-p-34060.html
13 Mar 2009, 05:01 AM
lextechs

Re: MSRP contrib

Quote:

Originally Posted by 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...r-p-34060.html

I would think you could use that section and change to compare for greater than or less than.
13 Mar 2009, 05:03 AM
smoke133

Re: MSRP contrib

I'm not sure I know where your talking about to do that.
19 Mar 2009, 11:14 PM
sonjamichelle

Re: MSRP contrib

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.
20 Mar 2009, 01:25 AM
lextechs

Re: MSRP contrib

Quote:

Originally Posted by 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
20 Mar 2009, 01:39 AM
sonjamichelle

Re: MSRP contrib

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.
20 Mar 2009, 02:29 AM
lextechs

Re: MSRP contrib

Quote:

Originally Posted by 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?
20 Mar 2009, 03:25 AM
sonjamichelle

Re: MSRP contrib

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.
20 Mar 2009, 03:56 AM
lextechs

Re: MSRP contrib

Quote:

Originally Posted by 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
20 Mar 2009, 04:19 AM
sonjamichelle

Re: MSRP contrib

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.
20 Mar 2009, 01:45 PM
smoke133

Re: MSRP contrib

Quote:

Originally Posted by 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?
22 Mar 2009, 05:50 PM
robrem

Re: MSRP contrib

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?
23 Mar 2009, 04:57 AM
robrem

Re: MSRP contrib

Quote:

Originally Posted by 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?
23 Mar 2009, 05:35 PM
robrem

Re: MSRP contrib

Quote:

Originally Posted by 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:

PHP Code:

 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 = '' . TEXT_PRODUCT_MSRP . '<s>' . $currencies->display_price($display_msrp_price, zen_get_tax_rate($product_check->fields['products_tax_class_id'])) . '</s> ' . TEXT_PRODUCT_SAVE .$currencies->display_price($save, '') . '  ('. number_format((($display_msrp_price - $display_normal_price) / $display_msrp_price), 2, '.', '') * 100 . '%)' . ' ' . TEXT_PRODUCT_OUR.$show_special_price . $show_sale_price . $show_sale_discount.'' ; }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 = ''.TEXT_PRODUCT_MSRP.'<s>'.$currencies->display_price($display_msrp_price, zen_get_tax_rate($product_check->fields['products_tax_class_id'])).'</s> '.TEXT_PRODUCT_SAVE .$currencies->display_price($save, '').'  ('. number_format((($display_msrp_price - $display_normal_price) / $display_msrp_price), 2, '.', '') * 100 . '%)'.' '.TEXT_PRODUCT_OUR.$show_normal_price . $show_special_price . $show_sale_price . $show_sale_discount.'' ; }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 Code:

 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 = '' . TEXT_PRODUCT_MSRP . '<s>' . $currencies->display_price($display_msrp_price, zen_get_tax_rate($product_check->fields['products_tax_class_id'])) . '</s> ' . TEXT_PRODUCT_SAVE . $currencies->display_price($save, '') . ' ' . TEXT_PRODUCT_OUR.$show_special_price . $show_sale_price . $show_sale_discount.'' ; }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 = ''.TEXT_PRODUCT_MSRP.'<s>'.$currencies->display_price($display_msrp_price, zen_get_tax_rate($product_check->fields['products_tax_class_id'])).'</s> '.TEXT_PRODUCT_SAVE . $currencies->display_price($save, '') . ' '.TEXT_PRODUCT_OUR.$show_normal_price . $show_special_price . $show_sale_price . $show_sale_discount.'' ; }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:

PHP Code:

 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 = '' . TEXT_PRODUCT_MSRP . '<s>' . $currencies->display_price($display_msrp_price, zen_get_tax_rate($product_check->fields['products_tax_class_id'])) . '</s> ' . TEXT_PRODUCT_SAVE . number_format((($display_msrp_price - $display_normal_price)), 2, '.', '') . '%' . ' ' . TEXT_PRODUCT_OUR.$show_special_price . $show_sale_price . $show_sale_discount.'' ; }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 = ''.TEXT_PRODUCT_MSRP.'<s>'.$currencies->display_price($display_msrp_price, zen_get_tax_rate($product_check->fields['products_tax_class_id'])).'</s> '.TEXT_PRODUCT_SAVE . number_format((($display_msrp_price - $display_normal_price)), 2, '.', '') . '%' . ' '.TEXT_PRODUCT_OUR.$show_normal_price . $show_special_price . $show_sale_price . $show_sale_discount.'' ; }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 Code:

 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 = '' . TEXT_PRODUCT_MSRP . '<s>' . $currencies->display_price($display_msrp_price, zen_get_tax_rate($product_check->fields['products_tax_class_id'])) . '</s> ' . '' . TEXT_PRODUCT_OUR.$show_special_price . $show_sale_price . $show_sale_discount.'' ; }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 = ''.TEXT_PRODUCT_MSRP.'<s>'.$currencies->display_price($display_msrp_price, zen_get_tax_rate($product_check->fields['products_tax_class_id'])).'</s> ' . ''.TEXT_PRODUCT_OUR.$show_normal_price . $show_special_price . $show_sale_price . $show_sale_discount.'' ; }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?
16 Apr 2009, 09:38 PM
micmed

Re: MSRP contrib

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...oducts_id=4936

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

Show 100 post(s) from this thread on one page

All times are GMT +1. The time now is 08:52 PM.