|
Posted by Simon on 10/13/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
>
>
[Back to original message]
|