Loaded Commerce Community

Alright, my store had some freaky model numbers, and some customers just didn't understand why those were in the trail, rather than the name of the product.

I personally think it might be better to no even include the product name, since they can clearly see what product they're viewing, however the category trail is a must... in either case, and however you decide to do it, I just wanted to share a quick way to exchange the product model number for the actual name of the product in the breadcrumb trail.

This might also help with search engine optimization, as you're adding yet another link to the internet with your products' name, pointing to your products' page.

In application_top.php, around Line 622, find this:
[php]// add the products model to the breadcrumb trail
if (isset($HTTP_GET_VARS['products_id'])) {
$model_query = tep_db_query("select products_model from " . TABLE_PRODUCTS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "'");
if (tep_db_num_rows($model_query)) {
$model = tep_db_fetch_array($model_query);
$breadcrumb->add($model['products_model'], tep_href_link(FILENAME_PRODUCT_INFO, 'cPath=' . $cPath . '&products_id=' . $HTTP_GET_VARS['products_id']));
}
}[/php]

Change it to this:
[php]//4524: Display product name, instead of Product Model, in breadcrumb trail
if (isset($HTTP_GET_VARS['products_id'])) {
$name_query = tep_db_query("select products_name from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "'");
if (tep_db_num_rows($name_query)) {
$prod_name = tep_db_fetch_array($name_query);
$breadcrumb->add($prod_name['products_name'], tep_href_link(FILENAME_PRODUCT_INFO, 'cPath=' . $cPath . '&products_id=' . $HTTP_GET_VARS['products_id']));
}
}[/php]



There are other things you might think about doing, like only displaying X number of characters, in case you use long names, and appending "..." in case they do get truncated. Because you don't necessarily want the product name taking up the whole width of the page.

Not to mention that if you have lots of category depth, this might also be more annoying than helpful. But I thought I would share anyway, in case someone finds this useful.

Peaces,

Young Thomas

Hey 4524 this is a great piece of code.
It worked first time and was just what I needed...
Thanks again

Glad it helped.
= )

Just for others' clarification, what exact version of the cart are you using?

I wrote this for 6.15, I believe - and if it works in newer versions, it might help someone else out, just to know that.

I'm using ver 6.2.41 and it worked beautifully
Thanks

Great hack ... thanks!

I was wondering about that..now i don't have to look...thanks.

Running CRE Loaded v 6.2[10.1] here.
Blokes And Sheilas Dot Com

thank you! This didn't work out of the box on 6.4.1a but just had to do a little updating to make it work

Replace this


With this