Loaded Commerce Community

Hi All,

I'm looking around to see if it's possible to turn caps lock off within ANY Category naming and Product Listing Description / Product Name within my store / database. I am sure I have seen one before by accident on my net travels but can I track it down now I want it, can I heck like lol grrrr!

To see what I mean, please go to my store http://www.shopfullstop.co.uk and look how the Categories to the left hand side are capitalised.

Then also take a look at the product listing boxes (descriptions again fully capitalised) instead of the following;

a. COMMUNICATION main category should be viewed / read as “Communication”
b. 2 WAY RADIO sub category should be viewed / read as “2 Way Radio”
c. 4.8MM X 200MM RELEASABLE CABLE TIES PACK OF 100 product listing box description should be viewed / read as “4.8mm X 200mm Releaseable Cable Ties Pack of 100”

I appreciate this is in part due to that's the way my product data feeds are pulled in from the distributor I use but I'd like to see if anybody has heard of a contribution / extension to solve this kind of issue.

look in your templates infobox css file



see this part??



text transform to uppercase

** that may not be the exact spot, but you can see what I mean about the text transform to upper case

I think in this case you could try the following:

Open up the categories file you are using, it may be in the templates/default folder or templates/maintemplate/boxes/ folder in your case.

Find the following:

<?php
$aa = 0;
$info_box_contents = array();
$info_box_contents[] = array('text' => '<font color="' . $font_color . '">' . BOX_HEADING_CATEGORIES4 . '</font>');
new $infobox_template_heading($info_box_contents, '', $column_location);
$categories_string4 = '';
$categories_query = tep_db_query("SELECT c.categories_id, cd.categories_name, c.parent_id
from " . TABLE_CATEGORIES . " c,
" . TABLE_CATEGORIES_DESCRIPTION . " cd
WHERE c.parent_id = '0'
and c.categories_id = cd.categories_id
and cd.language_id='" . $languages_id ."'
ORDER BY sort_order, cd.categories_name");
while ($categories = tep_db_fetch_array($categories_query)) {
$foo[$categories['categories_id']] = array('name' => ($categories['categories_name'])),
'parent' => $categories['parent_id'],
'level' => 0,
'path' => $categories['categories_id'],
'next_id' => false
);

and add change to this:

<?php
$aa = 0;
$info_box_contents = array();
$info_box_contents[] = array('text' => '<font color="' . $font_color . '">' . BOX_HEADING_CATEGORIES4 . '</font>');
new $infobox_template_heading($info_box_contents, '', $column_location);
$categories_string4 = '';
$categories_query = tep_db_query("SELECT c.categories_id, cd.categories_name, c.parent_id
from " . TABLE_CATEGORIES . " c,
" . TABLE_CATEGORIES_DESCRIPTION . " cd
WHERE c.parent_id = '0'
and c.categories_id = cd.categories_id
and cd.language_id='" . $languages_id ."'
ORDER BY sort_order, cd.categories_name");
while ($categories = tep_db_fetch_array($categories_query)) {
$foo[$categories['categories_id']] = array('name' => ucwords(strtolower($categories['categories_name'])),
'parent' => $categories['parent_id'],
'level' => 0,
'path' => $categories['categories_id'],
'next_id' => false
);

That will sort out your Main Catergory names to Capital First Letter and the rest Lowercase..


Now.. look a little further down the code and find this:

if ($cPath) {
$new_path = '';
$id = split('_', $cPath);
reset($id);
while (list($key, $value) = each($id)) {
unset($prev_id);
unset($first_id);
$categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . $value . "' and c.categories_id = cd.categories_id and cd.language_id='" . $languages_id ."' order by sort_order, cd.categories_name");
$category_check = tep_db_num_rows($categories_query);
if ($category_check > 0) {
$new_path .= $value;
while ($row = tep_db_fetch_array($categories_query)) {
$foo[$row['categories_id']] = array('name' => $row['categories_name'])),
'parent' => $row['parent_id'],
'level' => $key+1,
'path' => $new_path . '_' . $row['categories_id'],
'next_id' => false
);


And replace with this:

if ($cPath) {
$new_path = '';
$id = split('_', $cPath);
reset($id);
while (list($key, $value) = each($id)) {
unset($prev_id);
unset($first_id);
$categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . $value . "' and c.categories_id = cd.categories_id and cd.language_id='" . $languages_id ."' order by sort_order, cd.categories_name");
$category_check = tep_db_num_rows($categories_query);
if ($category_check > 0) {
$new_path .= $value;
while ($row = tep_db_fetch_array($categories_query)) {
$foo[$row['categories_id']] = array('name' => ucwords(strtolower($row['categories_name'])),
'parent' => $row['parent_id'],
'level' => $key+1,
'path' => $new_path . '_' . $row['categories_id'],
'next_id' => false
);


That will do the same for the sub_categories...