Community Add-Ons

Maintainers: wdepot
Add file to this package
Top » Features

Common Product Notes for osCommerce 2.3
for osCommerce Online Merchant v2.3

This contribution provides an easy way to add footnotes to products such as "discontinued when sold out" or "limited to stock on hand". The contribution is multi-language capable with a separate translation of the note for each installed language. Notes are displayed like they would be in a book with superscript numbers behind the product name indicating applicable notes and the actual note explanations at the bottom of the page.

Legend:  Download   Report

Expand All / Collapse All

Common Product Notes for osCommerce 2.3 wdepot 8 Apr 2015  

This contribution provides an easy way to add footnotes to products such as "discontinued when sold out" or "limited to stock on hand". The contribution is multi-language capable with a separate translation of the note for each installed language. Notes are displayed like they would be in a book with superscript numbers behind the product name indicating applicable notes and the actual note explanations at the bottom of the page.

Minor changes were made the to install instructions to improve the contribution.

The most important improvement is an added index on the products_to_notes table. Adding this index will speed search queries by allowing SQL to use an index rather than a row by row merge even if no searching is actually done on notes. If you have already installed this contribution you should perform the following SQL query using phpMyAdmin or similar utility:

alter table products_to_notes add index idx_pid_nid (products_id, note_id);

In install instruction 20a the strpos on strtolower was changed to stripos.

In install instruction 20f the !empty was changed to a comparison instead to validate the entry.

Complete contribution attached but only the install instructions have changed as noted above.

Common Product Notes for osCommerce 2.3 wdepot 25 Apr 2014