Creates Title, Keyword, Description tags on each page you add the code to.
Stock shop only has Title tags and as the default page is indexed there are no other tags for this page or the categories page.
It uses the breadcrumb trail to add the category name, sub-category name, and product name to the Title tag.
Default keywords are also appended with the same.
Minimum 3 files to edit.
Legend: 
Download

Report
Small Change for multi languages product description.
Previopus versions had an SQL error. This is corrected.
Now when a category is selected the description tag will be the category description unless there is not one then the default tag will be used.
Made the description tag html 4.01 Transitional compliant for those trying to accomplish this.
Includes an update file for those updating from previous versions.
Complete package. Corrected SQL as it was missing colon and gave error.
Thanks to suhy and 20uk.net for pointing this out.
Only support thread added ... zip is empty ...
Support thread:
http://forums.oscommerce.com/index.php?showtopic=258980
Now you can add default keywords and descriptions through the admin of your shop.
Also corrected code to remove html tags in the keywords meta tag.
Complete package
This is a complete package. The syntax was incorrect.
Capitalized title, mete, and added NAME= to meta tags.
USE THIS ONE
Not an update file, just a link to show a working example. included file is originan and complete.
http://billscollections.com
Creates Title, Keyword, Description tags on each page you add the code to.
Stock shop only has Title tags and as the default page is indexed there are no other tags for this page or the categories page.
It uses the breadcrumb trail to add the category name, sub-category name, and product name to the Title tag.
Default keywords are also appended with the same.
Minimum 3 files to edit.