MSRP contrib

micmed:

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.

I want to do the same thing. I just loaded 7,000 products with easy populate and dread going into each one for MSRP price. If you go to the easy populate thread I asked the same question.

http://www.zen-cart.com/forum/showthread.php?t=34970&goto=newpost

Here is the answer I received.

I am unfamiliar with the Dual Pricing Mod. If this mod directly changes the products database, then you can easily change Easy Populate the handle this added field. I am unfortunately (or should that be fortunately?!) involved in a large print project and 2 full eCommerce projects, so I don't have time to do this for you :(

But, this is what you need to do. If the Mod had an SQL patch, take a look at it. Did it update the products database? If so, what fields did it add? Open up easypopulate.php, and search on v_products_price. At each line reference (doing a search), add your new field, say "v_products_price_w"

Also note that the new CSV version is not quite the same as the TAB delimited version.

Wish I had time to help more, but just too busy... But this is not hard to do. Just make sure you BACKUP your databases first!

-cj

I am not good at looking at code and trying to figure out. If you are --- help would be greatly appreciated. I do not know the code where to put it. If I am not mistaken...I am using the tab delimited version.

Kim

robrem:

What file are you making these changes in?

The file is includes/functions/functions_prices.php,

However you may want to look at this thread first before making the change

http://www.zen-cart.com/forum/showthread.php?t=54857&highlight=MSRP&page=7

kburner:

I want to do the same thing. I just loaded 7,000 products with easy populate and dread going into each one for MSRP price. If you go to the easy populate thread I asked the same question.

http://www.zen-cart.com/forum/showthread.php?t=34970&goto=newpost

Here is the answer I received.

I am unfamiliar with the Dual Pricing Mod. If this mod directly changes the products database, then you can easily change Easy Populate the handle this added field. I am unfortunately (or should that be fortunately?!) involved in a large print project and 2 full eCommerce projects, so I don't have time to do this for you :(

But, this is what you need to do. If the Mod had an SQL patch, take a look at it. Did it update the products database? If so, what fields did it add? Open up easypopulate.php, and search on v_products_price. At each line reference (doing a search), add your new field, say "v_products_price_w"

Also note that the new CSV version is not quite the same as the TAB delimited version.

Wish I had time to help more, but just too busy... But this is not hard to do. Just make sure you BACKUP your databases first!

-cj

I am not good at looking at code and trying to figure out. If you are --- help would be greatly appreciated. I do not know the code where to put it. If I am not mistaken...I am using the tab delimited version.

Kim

PM me i will send you a ez-populate with the file change to allow MSRP and Cost you can change that file as needed,

micmed:

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.

I can send you a Ex-populate file that does it for you PM me

What do I need to do to get Easy Populate CSV, uploading the MSRP.

This is what I ended up doing and it has worked flawlessly for me.

Editing easypopulate.php - Everywhere that I found a line with "v_products_price" in it I made a duplicate of that line just below it changing "price" to "msrp".

In my SQL file I opened the "products" table and added a field called "products_msrp" just below "products_price" using the same parameters.

I modified the CSS a bit and ended up with what you can see on my site now. I am very happy with the mod.

Kudos to all who gave tips for this and a BUNCH of other stuff that I could not have done without help from the folks who hang out here.:clap:

Easy populated with MSRP and Cost modification, ok the file is to large sorry i was trying to attache here

micmed:

This is what I ended up doing and it has worked flawlessly for me.

Editing easypopulate.php - Everywhere that I found a line with "v_products_price" in it I made a duplicate of that line just below it changing "price" to "msrp".

In my SQL file I opened the "products" table and added a field called "products_msrp" just below "products_price" using the same parameters.

I modified the CSS a bit and ended up with what you can see on my site now. I am very happy with the mod.

Kudos to all who gave tips for this and a BUNCH of other stuff that I could not have done without help from the folks who hang out here.:clap:

I did as you said although I didn't duplicate every single "product_price" line as it appears some of them relate to specials and perhaps other things? I did duplicate the ones that seem to relate to froogle although this may result in a bug when using the froogle feature? I have successfully downloaded and uploaded a msrp value using Easy Populate CSV. If anyone would like to see the file in question easypopulate.php please PM me and I'll email it to you.

smoke133:

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?

Ok. I just solved the problem where the MSRP is equal to or LESS THAN the normal price. You can apply the change put forward by bigsy85 (see page 7 of the thread). And make one extra change.

Find this:

if ($display_normal_price == $display_msrp_price){

Replace with this:

if ($display_normal_price >= $display_msrp_price){

That will do it.

Alternatively you replace the entire routine with mine, although it is different to the one by bigsy85, I have a different strikethrough and just the percentage saving:

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

i have read almost of this thread, and searched it.

i have read the entire instructions and have done it 3 times already.

when i go into my admin after completing the install, i get this error when trying to select one of my products:

1054 Unknown column 'p.products_msrp' in 'field list'
in:
[select pd.products_name, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_msrp, p.products_virtual, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id, p.products_quantity_order_min, p.products_quantity_order_units, p.products_priced_by_attribute, p.product_is_free, p.product_is_call, p.products_quantity_mixed, p.product_is_always_free_shipping, p.products_qty_box_status, p.products_quantity_order_max, p.products_sort_order, p.products_discount_type, p.products_discount_type_from, p.products_price_sorter, p.master_categories_id from products p, products_description pd where p.products_id = '643' and p.products_id = pd.products_id and pd.language_id = '1']
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.

any help would be great. starting to get very frustrating

omg this is the stupidest thing....but i fixed it.

in my DB, i added the field product_msrp instead of products_msrp.

that sure makes me feel dumb. hahhaha

ams30gts:

i have read almost of this thread, and searched it.

i have read the entire instructions and have done it 3 times already.

when i go into my admin after completing the install, i get this error when trying to select one of my products:

1054 Unknown column 'p.products_msrp' in 'field list'
in:
[select pd.products_name, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_msrp, p.products_virtual, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id, p.products_quantity_order_min, p.products_quantity_order_units, p.products_priced_by_attribute, p.product_is_free, p.product_is_call, p.products_quantity_mixed, p.product_is_always_free_shipping, p.products_qty_box_status, p.products_quantity_order_max, p.products_sort_order, p.products_discount_type, p.products_discount_type_from, p.products_price_sorter, p.master_categories_id from products p, products_description pd where p.products_id = '643' and p.products_id = pd.products_id and pd.language_id = '1']
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.

any help would be great. starting to get very frustrating

ok for real now.

i entered a msrp price in one of my products. saved it etc.

it doesnt show up on my web site.

no errors or anything else that i can see

suggestions on where to look?

trying to edit my earlier posts because i figured it all out but cant

was there ever a fix for when the selling price is higher then the msrp? i tried adding the ">" but that did nothing

nm got it.

i need a mod to delete my last 4-5 posts. worthless

Hello, I have recently found this awsome new mod msrp and am tring to install it. I manually installed it and followed the instructions, however I found I could not log into my admin of my store.

It keeps coming up with this error:

Fatal error: Cannot redeclare zen_update_products_price_sorter() (previously declared in /home/urbvibz/public_html/admin/includes/functions/general.php:2517) in /home/urbanvibz/public_html/admin/includes/functions/functions_prices.php on line 1378

As I am new to this and coding I am not sure what to do.

I am using version 1.38. I have also tried to add a mod to changing prices all at once but that did not work, and the changes are still on. Not sure what changes they were.

I would be very greatful for anyone that can help me with this as I am only new. Thank you

Unfortunately, now the homepage is blank. Please help anybody. Just need the site to be on at least.

Sounds like a bug or version-incompatibility in the addon.
Remove the files you added, and replace them with the ones that were there before you started installing the addon.

Yep, did that and went through all the files i modified and restored them to orginal. Now admin section is displaying this message:

Parse error: syntax error, unexpected $end in /home/urbvibz/public_html/admin/includes/functions/functions_prices.php on line 1365

And homepage is still blank.

I did the MSRP mod but I haven't seen anyone reporting this issue:
I have a custom template and I'm getting the "Price:MSRP:" to show on all products when MSRP is defined.
I found a way to get rid of the "Price:" label but then it is not shown for the products that do not have an MSRP defined.

Is this a simple redefine the code or am I looking at a major issue.

Any help appreciated.

Live link:
http://www.soundsinmusic.com/index.php?main_page=products_all

Wondering how this works with attributes? If I have a product with a base-price of $59 and an MSRP of $129, but I have a few attribute options that increase the base price significantly, does it only show the % saved on the base price?

I suppose I should also mention that I have dynamic price updater installed, so the price changes as options are chosen, not after clicking checkout, like zc is by default.