SEO (Search Engine Optimization) with FWH

[Marc Venken]

Has anyone created SEO's words, sentences from products in a database ?

In a webshop, filled with products names, descriptions, options there is a lot of info that Google search can index, if provided the right way.

In Prestashop (webshop) you can give each products the folowing info :

Meta Title (70 chars)
Meta description (160 chars)
and TAGS (as many as you want)

The trick is to change common words, delete words, replace words in the Product Name, or Product description from the database.

Sample (As I think thats the way I need to go)

Product ID : 22150
Products Name : Safety Shoe Dassy Jupiter S3 Low model SP1
Description :
Veiligheidsschoen Dassy Jupiter S1P
- stalen neus en composiet zool
- ademend bovenleder
- voering plasmafeel
- lichtgewicht en grote flexibiliteit

I need to extract every word from description, mayby also in the Name, BUT i also need to eliminate not usefull words like (en, grote, voering, ...)
There are some functions in FWH that can do this easely (I believe transpose) not chequet. and put it in a array.
I could create a array from a list (file) that has the words to eliminate, and check if it exist.

Now the tricky part : I would like to see all the individuale words, and make a composition of 2 or 3 words.

Sample : selected list words : Dassy, Jupiter, S1P, Neus, Composiet, Zool, bovenleder, plasmafeel

I need a quick way to select : Dassy Composiet or Composiet zool or jupiter composiet, ....

Any ideas to get me started or has anyone started something like this?

Marc

[Antonio Linares]

You may do a SQL query

[Marc Venken]

It's a normal FWH program with dbf files that I use to upload in Prestashop. No SQL involved.

I'm thinking of using a 2 Xbrowse's, left where all the individual words are listed, and write the xbrowse with the resolt combination of words.

I the left listbox I can select the words with the selector tool inside xbrowse, hit a button and the function will join the words selected and put in browse 2

Thats the plan....

Any alternative may be great, before I start programming it.

Marc

[nageswaragunupudi]

You can use SQL with DBF also

[Otto]

Changes in Google search

While Google is still the undisputed leader of traffic generation, recent changes in their search results page layout have changed the balance between paid and non paid real estate on the page, which means a reliance on Google for website traffic has now become more expensive than ever.


Expanded ads and sitelinks - bigger ads mean more of the page is dominated by ads and less by organic
More ads at the top of the page - up to 4 ads at the top compared to 2 or 3 in the past is pushing organic results further down the page
Increased number of ad extensions - these are the text additions below the main ad body which include everything from sitelinks to a list of facilities and unique selling points (USPs).

This leads to your organic listing being pushed further down the page and an increase in the likelihood that a user will click on an ad rather than the organic result.

[thefull]

Well, using regexp and index custom, ey now in memory, not is very dificult.
Remenber , regexp is your friend

Regards