Importing data into Geo Theme

Tips and Tricks

This is the basic rules for all importing into databases with text.csv files not just Geo Theme.

Open office

So we understand we use Open Office right! Available for both Windows and Mac No questions asked good.

So you have you spread sheet of data you have created or exported.
If you have not then I suggest that you create one by going to GT Tools >> Import/Export and downloading one or grabbing it from here.

If this does not work for any reason check out FAQ’s at the end.

Opening for CSV

Open Office open as for GeoThemeI get asked quite a lot what are the setting meant to be when opening a comma separated value file, so I thought I would just add in a screenshot to help of the opening screen.

Select UTF8 for the Character set, Seperated by Comma (Hense CSV) Text Delimiter ” (this is default) and Quoted Field as text.

That is ready to open.

You can click on the image to the right to open a larger version.

 

Save As

Importing data into GeoTheme

The most important aspect of importing into a database is saving correctly.

Okay its not save it is file Save as!

Edit Filter Settings

Importing data into Geo Theme

Next the Dialog box, two things here Save as type will be text.csv and you have to tick the Edit Filter Settings Box.

Open Office Keep FormatFormat

Next click Keep Current Format.

 UTF8 and Quote Text Fields

Next is the below dialog box it is important to change the Character set to Unicode (UTF8) just press the U on your key board and down twice for a quick way to select it from the list.
You also want to make sure the you tick the Quote all text cells, this is important as the format we are saving is CSV Comma Separated Values, when importing with comma separated items like category1,catergory2 within a cell what we are doing is wrapping them ,”category1,catergory2″, so the data stays in that column.

Save as

 

FAQ’s

That is all you need to know, just a little FAQ below in case you have issues.

 

The trick is an apostrophe ‘ yep just add it before your date in the cell Gt has a date format like 2013-11-30 sometimes Open Office will alter these to your computers date settings so just import as ‘2013-11-30 :)
Well that is annoying, So all you need to do is highlight the column by clicking on the column letter identifier so it goes blue, then Go to the menu, Format >> Change Case >> lowercase. :)
Since Version 3.4.1 It has been a requirement that you need either 1 or 0 in the is_featured column, 1 for yes and 0 for no.
You can fix this using GT Tools >> Diagnostics >> Run and there is a under “Featured database checks” click the fix button. :)

 

Any more bits you want me to add to the FAQ or Tutorial let me know.

GeoTheme a WordPress Directory Theme

GeoTheme is a WordPress based “Yelp Clone” directory theme.

GeoTheme WordPress DirectoryWhy Geotheme?

Well believe me I had a struggle with this one, I was asked by a client to find a directory based website template, they wanted to create a directory based on places and events in London, already being familiar with WordPress I took the logical route of looking at plugins and themes that could be used as a starting point.

After many hours of deliberation and reading reviews on geo location based products I decided to recommend GeoTheme as the starting point for the project.

A few weeks later I had delivered with the support of GeoTheme and its members in creating this site, and it has worked out very well.

There were some hurdles to overcome mainly due to Geotheme’s vast array of options and setup complexity’s and the particular requirements of my client, but what was achieved was an end result that worked and looked great.

I was then approached by one of the guy’s who developed GeoTheme to assist them as a moderator on their support forum, I was pleased to join such a great team of very good developers to assist them in support queries.

This left me with a bit of a dilemma as a moderator I had to know more about this complex theme fast, so I used one of my dormant domains to create a site to be able to cross reference with when answering questions on the forum, so I quickly put together The Bathroom Directory, pretty much within a few days of the launch I had paid listings.

I did not go out to create a business which proves how well GeoTheme works.

This site is now ran by Ben Clark my nephew, he came up to London to stay with me and loved the concept behind the site and it’s design, so it is now being run as a business, and he is doing rather well with it, now he has well over a thousand listing many paid for and is quickly moving towards having a successful business.

I now have had to set up another Geotheme site on my development server as a test site for my work on the forum.

If you would like to know more about Geotheme then please feel free to contact me. You can also find more details on the Geo Theme website here.

Robots Seo Basics Part 5

Robots SEO back to part 4Robots SEO

If you have landed on this robots seo page be sure to not miss the start of the SEO basics tutorials Here.

Robots txt SEO

By robots, I mean Robots SEO file, not a robot made from text on the right, I just want to make that clear.

This is a file that is placed in the root directory of your website, it tells search engine spiders where and where not to go to index your pages.

You can also use it to tell a search engine where your site map file is.

A “robots.txt” file tells search engines whether they can access and therefore crawl parts of your site.

You really do not want search engines indexing areas of your site that are not useful to your users. And believe it or not also using your servers resources.

Restrict crawling where it’s not needed with robots.txt. You can target specific search engines with examples below of User-agent:

Not all search engine spiders obey your robots.txt file so it is not a total solution but it is a must to put in place for all the main search engines.

I have tried out this robot file generator and it works fine, there are lots more available.

SEO Basics Part 6 Coming Soon…

Feefo Benefits not just SEO

What are the Feefo benefits?

Feefo benefits are obvious to me, there are other choices to using Feefo on the market, but in my experience of using Trust Pilot, Trusted Shops and pretty much all of the other customer feedback services, I found Feefo to have the best feedback response rate by far.

When a customer buys the product or service from you, the customer then receives a request to review the product and service, it’s simple Feefo get more responses at this point.

Feefo Benefits Reviews For Your websiteBy displaying an image similar to one I have designed on the right, your customers have confidence in you straight away. This image can be displayed on the home page, category pages or product pages.

It is linkable when the user clicks on it, they will see the live reviews on you and on the products you sell.

On your product pages you can have displayed the star rating for the products and the reviews specific to that product.

Now with other Feedback services like Trustpilot you get a link to your home page not with Feefo you also get one directly to the individual product page, great for SEO.

This will help the customer to understand what they are buying and stop them from going off to another site, maybe a review site or a competitors site to find out more about that product.

Example Pages

Feefo Benefits Product Page Veiw

Click to Enlarge

Here is an example of a product page with Feefo feedback displayed.

So we can see that you have saved yourself time and energy writing your own product reviews :) not that you would do that!

Apart from giving your customers confidence in you and your products, you are keeping fresh content on your product pages, this is always good for SEO.

Search engines will always rank pages higher that have fresher content and will spider your pages more, just to make sure that they have the latest cached version.

Feefo Benefits on Google, Shopping and Natural Search Results.

Google Results Feefo Benefits

Click To Enlage..

Your reviews and stars will show up in the Google shopping results, your product rating stars will show up in Google ads and even in the natural search results as snippets (snippets not guaranteed).

As with the examples in the image to the right, you see not only do you stand out, but the customer will have confidence.

You will also get links back from Feefo’s own website, as they display a live feed, from the home page and also display your results on the your company page.

Feefo’s page on Google stars.

Contact Me About Feefo

If you are interested in trying out Feefo I can arrange a free trial, or if you can see the benefits already then contact me and I will start to get the integration in motion for you.

Feefo Customer Feedback System

Feefo feedback system

Feefo customer feedback system.

I have integrated the Feefo feedback system into several websites now and I have been so impressed that I thought I should let people know more about it. If Google loves it then you should, check it out on Google Shopping.

What is Feefo?

Feefo is a review system based purely on feedback on customer service and the product that they purchased from your E commerce store, or services that they have used.

How does it work?

When you send your customer an invoice for a purchase or service a copy is also sent to Feefo, Feefo then contacts your customer with a jointly branded email asking them for feedback on the service they received from you and the product itself.

Your customers can score you either Excellent, Good, Poor or Bad, indicating their level of satisfaction on the products they purchased and the service they received from you. There is also a comments box to add additional feedback, once published you can add a reply to their comments.

When the results are delivered to Feefo they then publish the details live on thier website, then your score is totalled and updated.

Feefo live feedHere is an example of a live feed that I have set up for my client.

Click on the image and you can see it in action.

Feefo starsFeefo have created API’s that enable you to then display the results on the product page itself. You can also display your overall score on your sites home page and indeed any category pages you wish to. You can also display the comments and written product reviews and jazz it up by adding review stars.

How much does the service cost?

Currently Feefo charges £199.00 for set up costs, I have been through this process and they are great at customer service, they hold your hand all the way, they will help with the technical integration, training, development and general support.

There are three levels of monthly costs.

Up To 200 feedback’s a month = £99
Up To 1000 feedback’s a month = £299
Bespoke package that covers 10k per month = £499
*prices are plus VAT.

Feefo Contact Me

Don’t just read this without seeing the benefits of FeefoBenefits Feefo in Part 2.

SEO Content Seo Basics Part 4

seo content part 3SEO Content  SEO Basics Part 4

With SEO content being a very important subject the words “Content is King” is a statement that I use a lot.

SEO Content is one of the most important SEO areas, websites that use relevant well written content will be ranked higher than sites that use little, poorly written content.

In this article I am going to contradict myself so please forgive me.

The correct way to use content on your website.

  • Minimum 300 words
  • Make sure that you use the keywords for your target search term.
  • Break up long sentences.
  • Do not use Sesquipedalian for the sake of sounding clever 😉
  • Make useful content for your target audience.

seo contentFlesch reading score is a great tool for content. This is available in office and outlook (instructions here) also I am sure if you search you will find some useful sites.

It will score your readability out of 100 points, The higher the score, the easier it is to understand the document. For most standard files, you want the score to be between 60 and 70, this is the score that will mean most 11 year olds wiil be able to read with ease.

This article has a score of 74.9 in the Flesch Reading Ease Test.

For information based websites this is easily achievable but for E commerce Sites this is very difficult to do. Lets imagine that you sell hats, how many times can you really describe in 300 words a hat on each page of your website with useful individual content for SEO.

Acheiving the content for SEO for E commerce.

There are two main approaches to dealing with this issue, the first is to create landing pages of useful content optimised for SEO but not stuffed with keywords for the sake of it. A good example a of way to deal with this is to create branded landing pages.

Another good solution is to have a blog set up with articles about the subject the you sell.

When you have created the content pages you will need to link to your product pages from the landing page or article using anchor text which is the clickable text that users will see as a result of a link, and is placed within the anchor tag.

This is an anchor tag optimised for red hats.

Seo Basics Part 5

Improved Responsive Menu Twenty Twelve for i Phone, Android, Mobile and Tablet Devices

The Improved Responsive Menu Twenty Twelve

Improved Responsive Menu Twenty Twelve

Click To Enlarge

Improved Responsive Menu TFor Twenty Twelve

Click To Enlarge

This menu is used on Klick Design test it out first on your device.

I have assumed that you have created a child theme for Twenty Twelve if you have not then read this first.

Right lets start to change the menu, first you need to create a new custom menu.

Klick responsive menu settings.

Click to Enlarge

Navigate in your dashboard to Appearance>Menus and create a new menu.

Name the menu ‘Klick’, add the pages you want to the menu save the menu and select it as your primary menu.

For the next bits you can download the zip at the bottom of this page.

First open the add-to-styles.css file copy the code into the bottom of your child styles.css’

Next create a folder called js in your child theme and upload the klick-nav.min.js to that folder. I have minified the js for you to load nice and fast.

If you ever need to minfy a .js file then I use this tool it is free an just does it in a browser window.

Add the code from the add-to-functions.php into your child functions.php or simply rename the add-to-functions.php to functions.php and upload this to the child theme.

What’s left well it should be working for you now, You have your improved responsive menu twenty twelve so next to style it to match your theme colors.

In the above css you can change the width, background color and color of the text, I am sure some of you will get fancy.

Klick Design Responsive menu

 

 

SEO Basics Part 3

SEO Part 2 THIS WAYSEO Part 3

Site maps for SEO

SEO Site maps are useful to humans but rarely used if you have a site map for your site for visitors it should be in html format and well laid out.

SEO XML sitemapWhere site maps for SEO come into there own, they should be in xml format (see right).

An xml site map will tell search engine  the structure of your site and the pages that are there and where they are, it will also tell the search engine the priority you give that page.

There are many good site map generator tools on the market to suit most systems.

Google have a very good tool but it is a bit complex this is great if you run multiple sites of one server.

If your site is a single site and less than 500 pages then this tool is free, I have a paid for copy and use it for many years on sites that are very large and complex.

Site map for images, you can also create a specific site map for your images if you so desire, I create a lot of images and graphics but I do not want to waste my server resources letting the search engine spider my site so I do not bother.

If you were a photographer or selling products then definitely have an xml site map for your images.

Some things to avoid.

  • Don’t let your site map to become out of date
  • Don’t have any broken links in your site map
  • Don’t create a html site map that simply lists pages, have a structure (subject or category)

You can create a site map folder in your root folder to place your site maps in and the search engines will find it, or in Google webmaster tools you can tell Google where it is.

SEO Content Part 4

SEO Basics Part 2

SEO Part 1 THIS WAYSEO Basics Part 2

URL Structure

SEO and URL structure can be a huge plus point, start with the obvious, if a searcher is looking for red hats and you own the domain red-hats.com you are very likely to be found.

You cannot buy a domain for every topic you do, but hats.com will help your SEO to sell yellow hats, red hats, and green hats.

So a great URL structure will be ‘love-your-hats.com/red-hats.html’ or if you sell  clothing in general it could be urban-clothing.com/hats/red-hats./html.

Creating descriptive categories and pages on your website can not only help you keep your site better organized, but it could also lead to better crawling of your documents by search engines.

Don’t forget your URL’s are displayed in the search engine results not just SEO.

SEO Basics Title Description and Keywords

SEO Basics the URL

Also, it can create easier, “friendlier” URLs for those that want to link to your content.

Visitors may be intimidated by extremely long and cryptic URLs that contain few recognizable words.

Things to avoid with URL’s

  • using directory names that have no relation to the content in them
  • having deep nesting of sub directories like “…/dir1/dir2/dir3/dir4/dir5/dir6/red-hats.html”
  • using excessive keywords like”red-hats/hats/lovely-hats/my-hats.html”
  • using lengthy URLs with unnecessary sub category’s
  • do not use session IDs

If you can try to provide one way of reaching a page URL that you want to be in the search engine results, there are simple ways to deal with this.

I pref ere using input rel=”canonical” link or redirect. I will be writing a separate document on these topics as they are subjects in there own right.

For the mean time here is some reference material for canonical link by Google Here.

SEO Part Three

SEO Basics

SEO Basics

Following the SEO (search engine optimisation) best practices outlined below will make it easier for search engines to crawl, index and understand your content.

Our Target for SEO

SEO Basics GoogleNatural or ‘Organic’ search engine results are displayed in certain areas on a search engine results page, by using good SEO techniques you can get to the top of the search engines, but not the very top as this space is reserved exclusively for the search engine themselves this is how they make money.

When you click on any of the greyed out areas in the image to the right you are costing someone money and lining the pockets of the search engine, in this case google.

Our main target is google as they have the lions share of the Internets searches performed in the western world, The practises that I suggest will work well for all search engines.

SEO Basics Title Description and Keywords

SEO Basics Title Description and Keywords

Page Titles

Page titles are very important to get correct, they should be accurate to the content and your target audience.

  • Create unique Titles for each page of your website.
  • Keep Titles to within 70 characters.
  • People searching for a ‘red hat’ if your title is Clothing | Red Hats for you Red Hat will be bold and stand out to the person searching.
  • Keep it simple and as descriptive as you can, if you add Hats | Cheap Red Hats | Bargin Best Hat Shop then you have mentioned hats too many times (keyword stuffing) and if you do not have the words cheap, red, bargain, best, then you are wasting words.
  • If you run out of things to add then add your location or business name.

SEO is pretty straightforward for Title tags, spend time to get them right as they hold a lot of weight with the search engines.

Description Meta Tag for SEO

A page’s description meta tag gives search engines a summary of what the page is about. A page’s description meta tag might be a sentence or two or a short paragraph.

A search engine will not always use this description that you add it might use a snippet of the wording from your page itself, but if relevant then it is more likely to be used, what it does if give a search engine the description of what the subject matter is about.

In other search engines other than Google and directory’s this will be used and when people like your page from social media then it will nearly always use the description.

SEO Go TO PART 2

* Importand recommended description length 155 characters.