I am not sure about copyrights either.
To add the msrp for the easypopulate all I did was edit the easypopulate_export.php code listed below. Please note I only included the codes for the store and ex-store template due to the length of the code.
The msrp tables where located inside the product_table so that was easy to do. My mod created 3 tables in the database which are called maker_name, model_name and maker_model. They are located in the database just like the product_table or any other database table. Do you think you can figure out something from the code if not I will be happy to email you the EP files. ```php
<?php
/*
Easy Populate for Zen Cart Copyright 2005 & 2006 Nicholas Keown -
[email protected]
Portions Copyright Zen Cart Developers, osCommerce, Tim Kroger, and numerous OsC contributors (see changelog/history
Released under GPL v2.0
*/
if (isset($ep_debug)) $sdltimer = ep_timer();
$export_error = array();
$fieldmap = array();
switch ($_GET['export'])
{
case 'store':
$ep_file_types = array();
$result = ep_query('SELECT type_id, type_name FROM ' . TABLE_PRODUCT_TYPES);
for ($i = 0; $product_type_row = $result->getRow($i, ECLIPSE_DB_ASSOC); $i++)
{
$ep_file_types[$product_type_row['type_id']] = $product_type_row['type_name'];
}
$iii = 0;
$filelayout = array(
'v_products_id' => $iii++,
'v_products_model' => $iii++,
'v_products_type' => $iii++,
'v_products_image' => $iii++,
);
foreach ($ep_languages as $lang)
{
$filelayout = array_merge($filelayout , array(
'v_products_name_' . $lang['code'] => $iii++,
'v_products_description_' . $lang['code'] => $iii++,
));
if (isset($ep_supported_mods['psd']))
{
$filelayout = array_merge($filelayout , array(
'v_products_short_desc_' . $lang['code'] => $iii++,
));
}
$filelayout = array_merge($filelayout , array(
'v_products_url_' . $lang['code'] => $iii++,
));
}
$header_array = array(
'v_products_msrp' => $iii++,
'v_specials_price' => $iii++,
'v_specials_date_available' => $iii++,
'v_specials_expires_date' => $iii++,
'v_products_price' => $iii++,
'v_products_weight' => $iii++,
'v_products_date_available' => $iii++,
'v_products_date_added' => $iii++,
'v_products_quantity' => $iii++,
);
$header_array['v_manufacturers_name'] = $iii++;
$filelayout = array_merge($filelayout, $header_array);
$filelayout['ptc_categories_index_path'] = $iii++;
$filelayout['ptc_categories_destination_path'] = $iii++;
$filelayout['ptc_categories_linked_path'] = $iii++;
$filelayout = array_merge($filelayout, array(
'v_tax_class_title' => $iii++,
'v_products_status' => $iii++,
));
$filelayout_sql = 'SELECT
p.products_id as v_products_id,
p.products_type as v_products_type,
p.products_model as v_products_model,
p.products_image as v_products_image,
p.products_msrp as v_products_msrp,
p.products_price as v_products_price,
p.products_weight as v_products_weight,
p.products_date_available as v_products_date_available,
p.products_date_added as v_products_date_added,
p.products_tax_class_id as v_products_tax_class_id,
p.products_quantity as v_products_quantity,
p.manufacturers_id as v_manufacturers_id,
p.master_categories_id as v_master_categories_id,
c.categories_id as v_categories_id,
p.products_status as v_products_status
FROM
(' . TABLE_PRODUCTS . ' as p LEFT JOIN
' . TABLE_PRODUCTS_TO_CATEGORIES . ' as ptc ON p.products_id = ptc.products_id) LEFT JOIN
' . TABLE_CATEGORIES . ' as c ON ptc.categories_id = c.categories_id';
$dl_filename = EASYPOPULATE_EXPORT_PREFIX_STORE;
break;
case 'extstore':
$ep_file_types = array();
$result = ep_query('SELECT type_id, type_name FROM ' . TABLE_PRODUCT_TYPES);
for ($i = 0; $product_type_row = $result->getRow($i, ECLIPSE_DB_ASSOC); $i++)
{
$ep_file_types[$product_type_row['type_id']] = $product_type_row['type_name'];
}
$iii = 0;
$filelayout = array(
'v_products_id' => $iii++,
'v_products_model' => $iii++,
'v_products_type' => $iii++,
'v_products_image' => $iii++
);
$filelayout['v_manufacturers_name'] = $iii++;
foreach ($ep_languages as $lang)
{
$filelayout['v_products_name_' . $lang['code']] = $iii++;
$filelayout['v_products_description_' . $lang['code']] = $iii++;
if (isset($ep_supported_mods['psd']))
{
$filelayout['v_products_short_desc_' . $lang['code']] = $iii++;
}
$filelayout['v_products_url_' . $lang['code']] = $iii++;
}
$filelayout = array_merge($filelayout, array(
'v_specials_price' => $iii++,
'v_specials_date_available' => $iii++,
'v_specials_expires_date' => $iii++,
'v_products_msrp' => $iii++,
'v_products_price' => $iii++,
'v_products_virtual' => $iii++,
'v_products_weight' => $iii++,
'v_products_date_available' => $iii++,
'v_products_date_added' => $iii++,
'v_products_quantity' => $iii++,
'v_products_ordered' => $iii++,
'v_products_quantity_order_min' => $iii++,
'v_products_quantity_order_units' => $iii++,
'v_products_priced_by_attribute' => $iii++,
'v_product_is_free' => $iii++,
'v_product_is_call' => $iii++,
'v_products_quantity_mixed' => $iii++,
'v_product_is_always_free_shipping' => $iii++,
'v_products_qty_box_status' => $iii++,
'v_products_quantity_order_max' => $iii++,
'v_products_sort_order' => $iii++,
'v_products_discount_type' => $iii++,
'v_products_discount_type_from' => $iii++,
'v_products_price_sorter' => $iii++,
'v_master_categories_id' => $iii++,
'v_products_mixed_discount_quantity' => $iii++,
'v_metatags_title_status' => $iii++,
'v_metatags_products_name_status' => $iii++,
'v_metatags_model_status' => $iii++,
'v_metatags_price_status' => $iii++,
'v_metatags_title_tagline_status' => $iii++
));
foreach ($ep_languages as $lang)
{
$filelayout = array_merge($filelayout, array(
'v_metatags_title_' . $lang['code'] => $iii++,
'v_metatags_keywords_' . $lang['code'] => $iii++,
'v_metatags_description_' . $lang['code'] => $iii++
));
}
$filelayout['ptc_categories_index_path'] = $iii++;
$filelayout['ptc_categories_destination_path'] = $iii++;
$filelayout['ptc_categories_linked_path'] = $iii++;
$filelayout['v_tax_class_title'] = $iii++;
$filelayout['v_products_status'] = $iii++;
$filelayout_sql = 'SELECT
p.products_id as v_products_id,
p.products_type as v_products_type,
p.products_quantity as v_products_quantity,
p.products_model as v_products_model,
p.products_image as v_products_image,
p.products_msrp as v_products_msrp,
p.products_price as v_products_price,
p.products_virtual as v_products_virtual,
p.products_date_added as v_products_date_added,
p.products_date_available as v_products_date_available,
p.products_weight as v_products_weight,
p.products_status as v_products_status,
p.products_tax_class_id as v_products_tax_class_id,
p.manufacturers_id as v_manufacturers_id,
p.products_ordered as v_products_ordered,
p.products_quantity_order_min as v_products_quantity_order_min,
p.products_quantity_order_units as v_products_quantity_order_units,
p.products_priced_by_attribute as v_products_priced_by_attribute,
p.product_is_free as v_product_is_free,
p.product_is_call as v_product_is_call,
p.products_quantity_mixed as v_products_quantity_mixed,
p.product_is_always_free_shipping as v_product_is_always_free_shipping,
p.products_qty_box_status as v_products_qty_box_status,
p.products_quantity_order_max as v_products_quantity_order_max,
p.products_sort_order as v_products_sort_order,
p.products_discount_type as v_products_discount_type,
p.products_discount_type_from as v_products_discount_type_from,
p.products_price_sorter as v_products_price_sorter,
p.master_categories_id as v_master_categories_id,
p.products_mixed_discount_quantity as v_products_mixed_discount_quantity,
p.metatags_title_status as v_metatags_title_status,
p.metatags_products_name_status as v_metatags_products_name_status,
p.metatags_model_status as v_metatags_model_status,
p.metatags_price_status as v_metatags_price_status,
p.metatags_title_tagline_status as v_metatags_title_tagline_status,
c.categories_id as v_categories_id
FROM
(' . TABLE_PRODUCTS . ' as p LEFT JOIN
' . TABLE_PRODUCTS_TO_CATEGORIES . ' as ptc ON p.products_id = ptc.products_id) LEFT JOIN
' . TABLE_CATEGORIES . ' as c ON ptc.categories_id = c.categories_id';
$dl_filename = EASYPOPULATE_EXPORT_PREFIX_EXTENDED_STORE;
break;
```
