FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour SEO (Search Engine Optimization) with FWH
Posts: 1487
Joined: Tue Jun 14, 2016 07:51 AM
SEO (Search Engine Optimization) with FWH
Posted: Sat Feb 04, 2017 10:53 PM
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
Marc Venken

Using: FWH 23.08 with Harbour
Posts: 44162
Joined: Thu Oct 06, 2005 05:47 PM
Re: SEO (Search Engine Optimization) with FWH
Posted: Sun Feb 05, 2017 07:41 AM

You may do a SQL query

regards, saludos

Antonio Linares
www.fivetechsoft.com
Posts: 1487
Joined: Tue Jun 14, 2016 07:51 AM
Re: SEO (Search Engine Optimization) with FWH
Posted: Sun Feb 05, 2017 10:32 AM

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

Marc Venken

Using: FWH 23.08 with Harbour
Posts: 10733
Joined: Sun Nov 19, 2006 05:22 AM
Re: SEO (Search Engine Optimization) with FWH
Posted: Mon Feb 06, 2017 12:15 AM

You can use SQL with DBF also

Regards



G. N. Rao.

Hyderabad, India
Posts: 6984
Joined: Fri Oct 07, 2005 07:07 PM
Re: SEO (Search Engine Optimization) with FWH
Posted: Mon Feb 06, 2017 10:42 AM

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.


Posts: 731
Joined: Fri Oct 07, 2005 07:42 AM
Re: SEO (Search Engine Optimization) with FWH
Posted: Mon Feb 06, 2017 11:12 PM

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

Regards

Saludos

Rafa Carmona ( rafa.thefullARROBAgmail.com___quitalineas__)

Continue the discussion