Extra Product Fields 1.0

1 of 1494   Next >   Last >>   The following osCommerce contribution is a free Opensource code originated from official osCommerce website and provided for your reference only, you may download the original contribution file(s) and install it on your own; or you may request a Paid Installation Service from Agents Of Power; Agents Of Power does the "AS IS" installation on your website, we do not guarantee it will work properly on your website. Extra Paid service is available for repairing the problem from the original contribution or from your website. Bug fix on extra_fields.php where it was requiring an entry relating only to text fields when a list type field was being created. Added an install instruction for the admin/languages.php file to handle cases where a language is added or deleted after extra fields have been defined. Complete contribution is enclosed. Added Extra Product Field search functionality to the osCommerce Quick Search info box. Only drop down type extra fields marked as searchable will be listed. If you set the Quick Search In Descriptions to true then text type extra fields can be searched as well. Complete package is enclosed. To upgrade from 1.12 simply copy the search.php file to the appropriate place and (if you don't already use the Quick Search In Descriptions contribution) execute the following SQL query using a tool such as phpMyAdmin: INSERT INTO `configuration` (`configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `date_added`, `set_function`) VALUES ('QuickSearch searches in description', 'QUICKSEARCH_IN_DESCRIPTION', 'true', 'If set to TRUE the customer can quick search in descriptions otherwise the search is limited to the product name', 1, 113, now(), 'tep_cfg_select_option(array('true', 'false'),'); I discovered a problem in advanced search with extra text fields. When using advanced search on any extra field while leaving any extra text field entry empty the search would fail to find anything even though at least one product should match. The problem was that the generated sql search contained code like (extra_value1 like %%) for each empty extra text field when it should have had nothing written in it at all. To fix the problem if you already have the contribution installed open advanced_search_result.php and find around line 333 the line that reads if (isset($epf_value_keywords) && (sizeof($epf_value_keywords) > 0)) { Change it to read as follows: if (($value != '') && isset($epf_value_keywords) && (sizeof($epf_value_keywords) > 0)) { The complete package is attached with corrected installation instructions for those who haven't used this contribution before. Bugfix for editing extra fields. When editing information for a drop down field the field was getting converted to a varchar(64) in the products_description database file. Also had a person say new fields were showing up blank in catalog when they shouldn't have been displayed at all so added 'default null' when creating a new text field to try and solve the problem. Complete package is attached but only the admin/extra_fields.php file has changed. This is a simple bug fix for an error in the extra_values.php file. The complete package is attached but only the admin/extra_values.php file has changed. If you have already installed version 1.1 you only need to replace the one file. After some questions from other users who were having problems with version 1.0 I discovered that the method I had used for some of the buttons was incompatible with Internet Explorer (or at least version 8). Clicking on the buttons wouldn't do anything. After some checking I discovered that I had to create submit buttons inside a small form (containing only the button) to get them to work in Internet Explorer. All such buttons have been corrected in this version and now they work properly with Internet Explorer as well as the Safari and Firefox browsers I had previously used for testing. The complete packge is enclosed but those who have already installed the earlier version of the contribution need only replace the admin/extra_fields.php and admin/extra_values.php files. 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.    Posted on: 07/03/2009     See contribution details Request Installation with Paid service