How to auto generate just product keywords from product page?

I see that this conversation has continued without me (I thought I was getting email updates to this thread).

**moosesoom, **can you keep me posted on what you are working on? I wouldn't mind testing it on a demo site if you want to share.

schoolboy, I joined the forum about 2 years ago when I first started using ZC. At that time I intensively studied pretty much any SEO thread I could find up here. I encountered your posts many times, recall clearly that you are very skeptical of the use of meta tags.

The use of meta tags is not extremely critical in helping a page get to the top. However, intelligent use of meta title/description is the SINGLE BEST TOOL for controlling how you get listed in search engines. Anybody who does not know this by now... well, should not claim to be an SEO expert.

I mean no disrespect, especially if you agree that meta title/desc is significant. I have benefited numerous times from you ZC advice, sometimes from your direct help, many other times from just reading answers you have given others. But if you disagree that a person can control how they appear on SE's using meta title/tag, I would be delighted to school the schoolboy! :D

With regard to keywords specifically, I tend to agree with you. I have never had any quantitative proof either way. For keywords to matter, they must be imbedded in content anyway. So do the SE's scoop them up without your help? Definitely. Does it help to emphasize which words are important by adding them to meta keywords? Maybe, though I lean toward skeptical.

But my daddy always said, any job worth doing is worth doing right. There is an automated keyword generator, why not use it? Cuz it sucks. So why not fix it?

I don't build a site to take it down tomorrow. I'm putting finishing touches on 3 sites right now, one that has 11,600 products. To get keywords right, it took me 2 days of manually weeding through crap. But once it's done, it's done.

If the keywords help, super. If not, I wasted two days. Man, I sure wish there was an automatic way to do it. Oh wait, there is and it bites the biggun! :blink:

moosesoom:

I'm sorry for insisting, but my idea was not just to use breadcrumbs, but a modified clone of breadcrumbs class (i.e., breadcrumbs class is just a starting point) to produce as output the branch of categories tree , with elements separated by commas, relative to a given category or a product, so to use it in meta-tags keywords building.

This is what Feznizzle desired at the start of the thread (but he has not programming knowledge to accomplish that). He said: > What I would REALLY like to do is rewrite that script to pick up top level categories and sub categories that lead to the product. But I am nowhere near smart enough to figure that out!

Sure we took two different ways, your advice is to eliminate top level categories from keywords, my way is to subsitute them with correct categories branch.

So the way I choose to follow is not your way for sure, but it's what user Feznizzle asked for...

I already created the new class, what I need is learning how to use classes in Zen Cart...that's why I wrote my initial (and following) post(s); could you please give me some pointer to that? Thanks

Okay, I've moved your post back into this thread. I still think it's a different topic (categories, not product keywords like the thread title), but clearly you don't.

I also believe that modeling your changes after the breadcrumb class is also pointless. These aren't breadcrumbs you're talking about, and the breadcrumb class is specifically just receiving inputs for the sake of preparing outputs later. It has nothing to do with calculating categories or hierarchies, etc. The only semblance of similarity with breadcrumbs is that the things needed for what you're after are fed TO the breadcrumb class after they're calculated.

So instead, something like this would get you far closer to the results you seem to be looking for:```
$mystring = '';
$myarray = zen_get_generated_category_path_rev(zen_get_products_category_id($_GET['products_id']));
for ($i=0, $n=sizeof($myarray); $i<$n; $i++) {
$query = "select categories_name
from " . TABLE_CATEGORIES_DESCRIPTION . "
where categories_id = '" . (int)$myarray[$i] . "'
and language_id = '" . (int)$_SESSION['languages_id'] . "'";

$result = $db->Execute($categories_query);
if ($result->RecordCount() > 0) {
  $mystring .= $result->fields['categories_name'] . METATAGS_DIVIDER;
}

}