How to create a large Hotel WordPress Database that is SEO Friendly.
On my previous post, WordPress Hotel Datafeed explains how to create a WordPress Hotel Datafeed using late rooms CSV files and editing them ready for import using WP ALL IMPORT. So this post “How to create a large Hotel WordPress Database” will show you how to actually create the database and after many weeks of working through my Database, I finally found a working solution. This is so I could break down the database into categories and tag images and essentially make each post SEO friendly with enhanced SEO attributions like Schema Reviews.
I know that to compete with the large websites like Trivago, booking.com and so on that, I needed to be SEO friendly with Schema reviews and Local Business tagging. The problem I had was once again the database supplied from Laterooms.com. The database does have the relevant information to enhance a listing so I started my work. Websites like Trivago have enhanced SEO listings with many thousands of entries, hence this is why they are so popular for Organic search terms.
Further to add, I had chosen to go down the route of Hotel Reviews in the United Kingdom. The reason behind this is so I can create a user database of enhanced reviews, and leverage organic search hotel listings.
To prepare your WordPress installation you must do it in this order:
1. Install your Template/Design and Configure accordingly
2. Install Yoast SEO and configure.
3. Install any other plugin that you feel is relevant to enhance your listings. I have a license of WP Rich Snippets that can enhance SEO listing whether it being a review or local business information.
So we now have the template configured, top-level categories (more to add later) and plugins installed and configured. Please make sure you have WP ALL IMPORT installed too.
Preparation (Step 2)
To create an SEO Friendly archive of posts on a mass scale we must create a test post. An example is that I use Listable from Themeforest, so all the posts and hotel Listings are under “Listings”. The test post must be as specific as possible. The first steps are the Title and Content, named as “Main-Title” & “Main Content”. The SEO Elements are pretty much the same for Yoast SEO. I would advise naming as “Hotel Review”, “Hotel Description”, “SEO Keyword” and the Social elements like “Facebook Title”, “Facebook Main Image” and so on
I have also added screenshots below that show a test post scenario. The more details you fill in at this stage the easier the import. As Listable and most other themes have custom options like Geolocation all these need to have the relevant information. try not to miss any elements. you can also notice the review screenshot by WP RICH SNIPPETS. These much be fully configured and tagged appropriately to make sure the import actually works.
I also, in this case, made 2 top-level categories being Hotels and UK. After analysing the CSV database I noticed that the counties were under the UK, so rather than having one category I could break these down into each region i.e London, Yorkshire, Cumbria, etc..
OK, so we have a full test post created, now publish the test post.
Please do not forget to add images. Use Alt tags, and name these as “Main Image Alt Tag” or whatever is easier so you know what is what when using the import.
We now have a fully working template for WP ALL IMPORT. This will ensure the import will be SEO Friendly whilst building a post and structure for each post.
WordPress hotel Datafeed explains in depth how to import a database. This will work on any type of database, however, you must format the test post correctly. If you miss any elements you are likely (like I did) go back delete posts and start again. Trust me on this it is a pain in the backside, hence this post!
WP ALL IMPORT & CSV
This plugin WP ALL IMPORT is fantastic. Once you have your CSV file ready for upload it is quite easy to create a good archive of posts. I would advise to take your CSV file and create an additional CSV with only 30 entries before uploading the large database, and in my case, my first database had over 12,000 hotels. if you use a smaller database and the format looks wrong or you have missed elements from your test post it will be easier to go back and delete 30 entries rather than 12,000 right?
Your CSV file should be split into relevant entries. In most cases, the CSV file will be broken down into Titles, Descriptions, Links and Images. In my case the images (19 in total) were all in 1 line, so after a few excel commands, I have split each image into a column and named the Columns into “Main image”, “Hotel Image 1”, “Hotel Image 2” and so on.
As you can identify below are the Custom Fields. this will change depending on your Template/Design. Just make sure these are fully configured in your test post.
OK once all is completed and filled in it is time for import.
You can view my imports here:
Category View – UK – Hotels – Greater London
Don’t forget to test your code. Your source code should look similar to mine. Don’t worry about warnings.
You can test your code here “Structured Data Testing Tool“.
Eventually, you will have a page like this.
Google shows this for each entry on my website:
Please visit my My Hotel Experience and please leave comments below if you have any questions or need help with your Database. So this is How to create a large Hotel WordPress Database.