Quote Originally Posted by kburner View Post
I am still trying to get this working with Book product. Anyone know what file to modify?
I took this on with my test store. I followed the readme file for MRSP and tried to apply to product-book files.
Made these changes to get MSRP to work with product - book.

Sql file:

Originally added with product - general. I did not make any changes or additions to sql.

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


1. admin/includes/lang/english/product_book. manually installed to end of file...

define('TEXT_PRODUCTS_MSRP', ' MSRP: ');
define('TEXT_PRODUCTS_OUR_PRICE', ' Our Price: ');
define('TEXT_PRODUCTS_SALE', ' Sale Price: ');
define('TEXT_PRODUCTS_SAVINGS', ' You Save: ');
define('TEXT_PRODUCTS_PRICE_MSRP', 'Products MSRP:');

2. admin/modules/update_product.php
This file does not have product_book one. Made changes to
admin/includes/modules/update_product.php

Added:
$tmp_value = zen_db_prepare_input($_POST['products_msrp']);
$products_msrp = (!zen_not_null($tmp_value) || $tmp_value=='' || $tmp_value == 0) ? 0 : $tmp_value;
$tmp_value = zen_db_prepare_input($_POST['products_price']);
$products_price = (!zen_not_null($tmp_value) || $tmp_value=='' || $tmp_value == 0) ? 0 : $tmp_value;

Added:
'products_msrp' => $products_msrp,


3. admin/modules/product/collect_info.php This file does not have product_book one. Changes made to
admin/includes/modules/product/collect_info.php

Added:
'products_msrp' => '',

and added:
p.products_image, p.products_price, p.products_msrp, p.products_virtual, p.products_weight,

Could not find...
<tr bgcolor="#ebebff">
<td class="main"><?php echo TEXT_PRODUCTS_PRICE_GROSS; ?></td>
<td class="main"><?php echo zen_draw_separator('pixel_trans.gif', '24', '15') . '&nbsp;' . zen_draw_input_field('products_price_gross', $pInfo->products_price, 'OnKeyUp="updateNet()"'); ?></td>
</tr>

Therefore...did NOT add
and add immediately above it:

<tr bgcolor="#ebebff">
<td class="main"><?php echo TEXT_PRODUCTS_PRICE_MSRP; ?></td>
<td class="main"><?php echo zen_draw_separator('pixel_trans.gif', '24', '15') . '&nbsp;' . zen_draw_input_field('products_msrp', $pInfo->products_msrp, ''); ?></td>
</tr>

4. includes/functions/functions_prices.php
Did not make any changes to file and did not see one for product_book

5. includes/languages/english/product_book.php
Added:
define('TEXT_PRODUCT_MSRP', 'Retail Price: ');
define('TEXT_PRODUCT_SAVE', 'You save: ');
define('TEXT_PRODUCT_OUR', 'Our Price: ');

6. includes/languages/english.php
No other files modified.

I can see MRSP when I choose product - book and can add price. But, price does not remain when I click on preview. And I do not see it on site.

I am no expert at this. Is there anyone that can give suggestions on how to get to work?

Thanks, Kim