After discovering that the way Product Extra Fields was written prevents searching multiple fields for multiple search terms I wrote my own contribution which will do everything that Product Extra Fields does and more. You may find this new contribution at:

http://addons.oscommerce.com/info/6856

Included in the package is a file that converts all of your old Product Extra Fields into the new format used by my contribution so you can convert without losing the data you have already entered.

The attachment here is just a copy of the user guide for my contribution and is here only because a file is required to post this note.

Our store has happily used the Product Extra Fields 2.0j contribution until someone asked why a search wasn't working when looking for two values, each contained in a different extra field for the product. Upon examining the search code I suddenly realized that it would be impossible to do a simple search on more than one field since only one field at a time could be linked to a product. Searching more than one extra field would require code that is much more complicated than I wanted to attempt writing. I thus decided that writing a completely new contribution would be easier.

Extra Product Fields creates its new fields in the products_descriptions database file which makes searching multiple fields easier, especially when searching using multiple terms that may be divided among several fields.

This contribution is completely multi-language compatible. Unlike Product Extra Fields which allowed a field to only be either for one language or for all languages and used the same field label for all languages, Extra Product Fields allows a field to apply to any number of languages and stores a separate label for each language so you can translate the label as appropriate.

Field entry during product maintenance can be either as standard text, or selected from a list of drop down values that you define after creating the field, and can be different for each field. The drop down values are set separately for each language so they can be appropriate to the language. You can set the maximum size for each standard text field individually anywhere from 1 character up to 255 and change the size later if needed. As with Product Extra Fields, fields that are left blank during product entry are not displayed in the catalog.

Other features include:

A Sort Order to determine the order in which fields are displayed.

Advanced Search control to determine whether or not the catalog user can search on a field individually when using Avanced Search. This search control applies to each field separately so you can make some fields searchable and some not.

Product Listing control to determine whether or not the contents of a field get displayed in the product listings underneath the product name. Again this applies to each field individually so this is not an all fields or none choice as it is with Product Extra Fields.

META Keyword control to determine whether or not the value of a field will be used in a META Keyword tag on the product information page.

Options for for fields that are defined to use a list of values are:

Restrict Product Listings which allows users to restrict the results of a product listing in index.php. It operates similar to the way osCommerce works when you view a category containing products from multiple manufacturers, or a manufacturer with products in multiple categories.

Show Chain of Parent Values: Much as categories can contain other categories, this contribution allows values in the drop down lists to contain other values. For instance, if you created a drop down list field for Product Type and one of the values for that field was Movies then you could create values under Movies of VHS, DVD and BluRay. If a product then had the value set to DVD, with Show Chain enabled the value would display as Movies | DVD. Otherwise the value would display as just DVD.

(complete install package). Only replaced the cc/ck modules. New modules will support cURL and utilize the MerchantPIN security feature.

With this update you will get properly resized thumbnails for your newsletter just in 3 steps.

English_____________

-Added 2 functions in includes/classes/seo.class.php to disconnect MySQL

-Added a function's call in includes/application_bottom.php to disconnect MySQL's session of SEO_DataBase

We had problems with a shop with a lot of customers online without this functions

Español_____________

-Añadidas 2 funciones en includes/classes/seo.class.php para desconectar MySQL

-Añadida una llamada a una función en includes/application_bottom.php para desconectar la sesión MySQL creada por SEO_DataBase

Tuvimos problemas en una tienda con bastantes clientes online sin estas funciones

Better Product listings & Display. Ultra pics, J query, Image Controller, Product listing as list or Grid + More!

This contribution brings together a lot of work!
* J query with ultra pics,
* Product review pages have J query
* Better product listing and product display,
* Images controller,
* Product short description
* Now Admin controllable product listing

Admin control for the sort order on the product_listing page either by Price or Name
Admin control over the amount of characters to show on the short descriptions
Admin control over Product style, list or Grid


Random new_products page with buy now and view buttons


Made for the 2.2 family versions

Despite its size, its a 10 minute install,
upload the files and overwrite existing ones
run 1 x installer
run 1 x SQL file
DELETE installer file

Check admin (admin / configuration / product listing) settings

Now multi language, there are defines to add the language product_info.php
to enable this to work in any language.

You can view the contribution here
http://www.development-server.net/catalog/ use the Test product to see the ultra pics and J Query
product listing is better viewed by selecting DVD movies / action (sorting set to price)

INSTRUCTIONS INCLUDED IN THE PACKAGE

THIS CONTRIBUTION IS FOR A VANILLA INSTALL OF osCOMMECE