Community Add-Ons

Corrected sql;

Changed the documentation to create 5 fields that might actually be used.

Manufacturer's Part No
UPC
ISBN
EAN
Extra Field 1

The last field can be changed to any name by editing the language files.

The field only appears on the product_info page if there is something in it so the fact you are unlikely to hae an EAN/UPC/ISBN on the same product it is not a problem.

Can be used with google base feeds. http://addons.oscommerce.com/info/6531

Made 5 fields

only change the names if you want.
it is in the instruction

Marc

display error fixed in product_info.php

##old:
if (tep_not_null($product_info['products_ref_const'])) {
echo products_ref_const.' '.$product_info['products_ref_const'];
}
##new
if (tep_not_null($product_info['products_ref_const'])) {
echo PRODUCTS_REF_CONST.' '.$product_info['products_ref_const'];
}

##Full package

the new extra field in admin/categories didn't show the translated text.

There were 2 mistakes in the install file
in
catalog/admin/categories.php
and in
catalog/admin/includes/languages/english/categories.php

español:

He añadido unas instrucciones para poder poner la referencia, o lo que sea en las facturas

Saludos

English:

I add instructions to put the reference, or whatever on the invoice

Regards

Replaced any fields and vars named "products_msrp," by the true one "products_ref_const"

Bugs Fixes

Ad some comment text to help with the oscommerce code.
mentionned by :
//BOF NEWFIELD EVERYWHERE
//EOF NEWFIELD EVERYWHERE

Enjoy

The install worked exactly as expected except the new text was not showing up in my new field. After a looking for a while I found small change that was needed.

in the old instructions under the changes for the product_listing.php page

The changed code was:
$lc_text = ' ' . $listing['products_ref_const'] . ' ';

Now:
$lc_text = ' ' . $listing[$x]['products_ref_const'] . ' ';

----------
Easy populate 2.76g-MS2 also has much better support and instructions for extra fields

----------
I also changed some of the French to English in the SQL command

if you want to include this new added field in search, modify catalogadvanced_search_result

replace this

$where_str .= "(pd.products_name like '%" . tep_db_input($keyword) . "%' or p.products_model like '%" . tep_db_input($keyword) . "%' or m.manufacturers_name like '%" . tep_db_input($keyword) . "%'";

with

$where_str .= "(pd.products_name like '%" . tep_db_input($keyword) . "%' or p.products_model like '%" . tep_db_input($keyword) . "%' or p.products_ref_const like '%" . tep_db_input($keyword) . "%' or m.manufacturers_name like '%" . tep_db_input($keyword) . "%'";

I included modified files for english version of v2.2 RC1 in this contrib - just rename them and copy to path specified in the filename

Same file as before + the english install.txt

The zip contains both english and french install.txt

Add a new field in product sheet, product listing, advance search, and easypopulate if installed.

This field can be changed in admin in "Product Listing"

Install.txt is only in french, english coming soon