You are here: Re: How to import into MySql for SEO purposes? « All PHP « IT news, forums, messages
Re: How to import into MySql for SEO purposes?

Posted by Simon on 10/09/05 11:35

firstly your url's need to be Search Engine Friendly
http://www.abetterworld.co.uk/index.php/sku/KB1220

this will enable search engines to spider it. Some search engines don't like
?sku=KB1220

Then you need to ensure that when the search engines find a description of
the product and hence allow anyone searching for it to find it.

Dynamically create a description from the description in the database.
eg
7 in. Buff polished, plain edged blade with an black Epoxy powder coated
high carbon steel, made of 1095 steel Oval handles constructed of compacted
leather disks, smoothed and polished. 11.88 in. Overall length. Comes with
brown leather US Army sheath.

There are numerous ways to do this. Personally I would use the existing
description and query the database for each product and category and then
place this within the keywords, title etc.

You shouldn't need to make many changes to the existing databases in order
to do this. The changes will take place in the template or php script.

I wouldn't have thought it would be a huge task.

See http://www.weddingworld.co.uk and how each category has different
keywords and descriptions.


Simon

"Graeme" <inquires@abetterworld.co.uk> wrote in message
news:doibfq$25r2$1@custnews.inweb.co.uk...
> Here's an example of one of my webpages (which was built by a
> freelancer):
>
> http://www.abetterworld.co.uk/product_details.php?sku=KB1220
>
> Please take a quick look at the source code.
>
> You will note that this is all sadly deficient "SEO wise" e.g
> every single product has the same exact Meta keywords and
> descriptons, no alt tags or link text etc.
>
> So I was hoping to discuss how this might be remedied. That is
> from a "technical standpoint" how can I best make the changes
> within the DB (and obviously in turn them generate the
> modified/improved dynamic pages)? If anyone could post a link or a
> tutorial on the subject I'd be grateful.
>
> Obviously each item will need to be optimised individually i.e.
> one by one. This being an exceedingly long and arduous job; as
> there are over 20,000 different products available on my website.
>
> Would the changes have to made using phpMyAdmin or can I somehow
> import the data (after it has been developed locally)? I've read
> somewhere that "tables" can be used to do just this.
>
> Best Regards
>
> Graeme Nicholson
> www.abetterworld.co.uk
>
>

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация