Kryptronic Software Support Forum

thanks for all your help. I pasted the code as you suggested and that didn't work either.

I guess I'll just keep doing what I've been doing-- create static html pages for each product that I have. It's a pain, but I can't get the dynamic way to work for the life of me.

:-(

lake

I hate to sound stupid, but I'm assuming that if I apply this mod I do NOT need to create static HTML product pages?

I have a slight change I'd like to implement to this as some of the search engine info I've been reading is placing more and more emphasis on the title tag.

I'd like the product name or categories to appear first, then the word "at" then the site name you've entered in admin.

Currently it reads:

ItsAlreadySigned4U.com Sports Memorabilia: Mickey Mantle Autographed Baseball

I'd like it to read:

Mickey Mantle Autographed Baseball at ItsAlreadySigned4U.com Sports Memorabilia

or for a category

Baseballs at ItsAlreadySigned4U.com

No colon but with the word "at".

I believe this will help the search engine situation with the important product words first.

Brilliant mod, the business!!!

I just added a couple of extra bits so that the item price would also show up in the title bar,



$sql_statement = "

SELECT product_name,product_desclong,product_keywords
FROM product
WHERE product_id=$dbins_fd_ref

";

@title = database_call('product','SELECT',$sql_statement);

foreach $row(@title) {($page_title,$page_desc,$page_keywords) = @$row;}



$sql_statement = "

SELECT product_name,product_regprice,product_desclong,product_keywords
FROM product
WHERE product_id=$dbins_fd_ref

";

@title = database_call('product','SELECT',$sql_statement);

foreach $row(@title) {($page_title,$page_price,$page_desc,$page_keywords) = @$row;}


then towards the bottom


if ($page_title ne "") {

$html_title_bar_text = "$html_site_name\: $page_title ";
$html_title_bar_text =~ s/<[^>]*.//gs;



if ($page_title ne "") {

$html_title_bar_text = "$html_site_name\: $page_title \£$page_price";
$html_title_bar_text =~ s/<[^>]*.//gs;

maybe their is a neater way to implement this mod,

But in a competative business this will let people know we are the cheapest from the outset.

Wow.. has this mod REALLY been here since October!?! And i missed it! OMG...

Has anyone seen any improvements from a SE picking up the URL??? Does the product URL stand a chance of getting indexed?? i.e.

Great mod!  I'm getting ready to shift from static pages and couldn't ask for a better tool (will be really useful with ATS seo mod).  Made a few changes to suit my seo preferences that differ from the the above version as follows:

Merges Product Name and Product Short Description for the Page Title for product pages, truncated at 60 characters with the intention of beginning all short descriptions with " - ".

Does not merge category/product on product page descriptions, uses only the Product Long Description, still truncated at 150 characters.

Admittedly, I'm pretty ham-handed when it comes to perl so if anyone spots a mistake let me know.  Tests out okay though....

$page_title = "";

if ($fd_pg eq "ste_cat") {

$dbins_fd_ref = database_quote('category',$fd_ref);

$sql_statement = "

SELECT category_name,category_desc
FROM category
WHERE category_id=$dbins_fd_ref

";

@title = database_call('category','SELECT',$sql_statement);

foreach $row(@title) {($page_title,$page_desc) = @$row;}

} elsif ($fd_pg eq "ste_prod") {

$dbins_fd_ref = database_quote('product',$fd_ref);

$sql_statement = "

SELECT product_name,product_descshort,product_desclong,product_keywords
FROM product
WHERE product_id=$dbins_fd_ref

";

@title = database_call('product','SELECT',$sql_statement);

foreach $row(@title) {($page_title,$page_title_ext,$page_desc,$page_keywords) = @$row;}

$fd_cat = $q->param('cat');

if ($fd_cat ne "") {

$dbins_fd_cat = database_quote('product',$fd_cat);

$sql_statement = "

SELECT category_name,category_desc
FROM category
WHERE category_id=$dbins_fd_cat

";

@title = database_call('category','SELECT',$sql_statement);

foreach $row(@title) {($cat_title,$cat_desc) = @$row;}

if ($cat_title ne "") {

$page_title = "$page_title";

} ######### End of if statement.

if (($fd_pg eq "ste_cat")&&($cat_desc ne "")) {

$page_desc = "$cat_desc";

} ######### End of if statement.

} ######### End of if statement.

} else {

if ($page_name ne "") {

$page_title = "$page_name";

} ######### End of if statement.

} ######### End of if statement.

if ($page_title ne "") {

$html_title_bar_text = "$page_title$page_title_ext";
$html_title_bar_text =~ s/<[^>]*.//gs;
$html_title_bar_text = vars_truncate($html_title_bar_text,'60');

} ######### End of if statement.

if ($page_desc ne "") {

$html_desc_text = "$page_desc";
$html_desc_text =~ s/<[^>]*.//gs;
$html_desc_text = vars_truncate($html_desc_text,'150');

} ######### End of if statement.

if ($page_keywords ne "") {

$html_keywords_text = "$page_keywords";
$html_keywords_text =~ s/<[^>]*.//gs;

} ######### End of if statement.

In  right before  - same as Nick specified in the first post in this thread.  Mine is not separate mod - I just tweaked it to suit my preferences and posted it in case someone else might find it useful....

Well, I don't know if there is an approval authority, but insofar as it does what I want it to do and doesn't break anything, yes it's ready to use.

That's not what I meant. The way I asked it was : Is it really ready for everybody ? !

I've already stated that it's just a tweak to the mod posted in this thread, it works, and doesn't break anything, and I just posted it in case it might save someone else a little time & effort.  Is there a board of review or something that I've missed?

As with using any code posted in the forum,  of the file being edited and give it a whirl.

I have added the seo mod listed above. The last one I tried was by ED_H on 3/28/2004. However, after having tried all the mods posted, I still get something like:



in the browser address bar. Am I mistaken that I should get something different -- ie: no ? in the address bar?

Incidently, the meta tags on the resulting pages are all just fine. The tags part seem to be working great.

Referencing the really sweet code posted by Webmaster on 10/30/2004, I have tinkered around and we can now have keywords populate the meta tag for category pages. In the past, keywords only populated the meta tag on product description pages.

Okay, here's what we do.

Step 1:
From inside the Site Administrator Control Panel, select "Database Utilities|Manage User Defined Table Columns". In table-name "Category", click Update. Create a new column in the table with the following values -
Column Name: category_metakw
Description: Meta Tag Keywords
Number of Characters: 150
Field Required in Admin: Yes
Admin Display Type: Regular Textarea

Then click the Submit button. Now, when you create a category you will be required to enter keywords. Make sure they are comma delimited.

Step 2:
In ste_exec.pl, make the following changes to Webmaster's code -

 $sql_statement = "SELECT category_name,category_desc FROM category WHERE category_id=$dbins_fd_ref";
 @title = database_call('category','SELECT',$sql_statement);
 foreach $row(@title){($page_title,$page_desc) = @$row;}

 $sql_statement = "SELECT category_name,category_desc,category_metakw FROM category WHERE category_id=$dbins_fd_ref";
 @title = database_call('category','SELECT',$sql_statement);
 foreach $row(@title){($page_title,$page_desc,$page_kw) = @$row;}

if($page_keywords ne ""){
 $html_keywords_text = "$page_keywords";
 $html_keywords_text =~ s/<[^>]*.//gs;
 $html_keywords_text = vars_truncate($html_keywords_text,'150');
}

if($page_keywords ne ""){
 $html_keywords_text = "$page_keywords";
 $html_keywords_text =~ s/<[^>]*.//gs;
 $html_keywords_text = vars_truncate($html_keywords_text,'150');
}else{
 if($page_kw ne ""){
  $html_keywords_text = "$page_kw";
  $html_keywords_text =~ s/<[^>]*.//gs;
  $html_keywords_text = vars_truncate($html_keywords_text,'150');
 }
}

Have fun!

Roy

I believe that you can accomplish this with Marks (ATS) SEO PRO mod. It is an update to his SEO mod that allows you to specify URL, keywords, meta-tags, description, etc. It is also product specific, so you can change each product individually.