Please see the attached file for the project. You will need to be very good manipulating URLS
The urls need to be changed so that the product name for the url
Is used instead of the current set up.
For example for the product FUJI FILM fine pix you see
[url removed, login to view]
This needs to be changed to [url removed, login to view]
The site needs to tuned for Google
Googlebot should be prevented from indexing the same URL twice or more.
If Googlebot comes along and sees a URL and notices that it is very
Similar to a previously indexed URL it will index it and the penalise the site.
So to prevent this from happening if a previously indexed url has
All the words of a subsequently found url the first one stays indexable
But the follow up URL should unindexable in google.
This can be achiived by marking the first unique URL as canonical.
Products that have no description should not be indexable in google.
If a product has the same description as one indexed before or has all
The words of a previous product as a subset the new product should
Not be indexed.
Please note non Google indexed products should still be visisble to
The human eye.
These changes should not affect the running of the database.
When a product is deleted the url should still be visible to google but
Of course not on the main site. A secondary database system should exist for these urls that can be found easily by google.
This will assist in maintaining page rank.
This secondary database should also be easily maintable by an
Application interface that it is quick and simple to use.