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') . ' ' . 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') . ' ' . 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




Reply With Quote
