Identifying Theme Template Or Plugin?

You can see the information about the theme and its author in the theme’s style.css file: http://www.associatedforklifts.com.au/wp/wp-content/themes/eleven/style.css

You’ll find this:

/*
Theme Name: Associated Forklifts
Theme URI: http://www.elevenmedia.com.au
Description: WordPress theme
Author: Eleven Media
Author URI: http://www.elevenmedia.com.au
Version: 2013
*/

It appears the theme is custom-built by Eleven Media, a web development agency based in Australia.

——

It’s not that complex either. If you have a few hundred dollars on hand, any professional WordPress developer will be able to give you a similar theme–even better, actually.

Do you know of any paid prebuilt themes I could purchase that has that functionality and customise from there?

I don’t think I can recommend such themes because that could be consider as advertising, which would get me banned from this site.

But most likely you’ll need more than just a theme. You’ll need:

• WordPress as the CMS,
• a WordPress theme (preferrable one that support e-commerce plugins),
• an e-commerce plugin (such as WooCommerce),
• a few other WordPress plugins to ensure speed and extra functionalities (such as checkout gateways, handling the minify process, cache, etc.)

Is this whats called a CMS? so the theme uses database for retrieve details about the products and associated pictures.

WordPress is the CMS, not the theme. But you get the other general idea right.

Also can I add responsive feature (for phones/tablets) to a wordpress site or does that have to be part of the theme I choose?

Nowadays responsiveness is built-in for almost every good themes; it is the current standard. But if the theme lack that feature, you can add a separate mobile layout via a redirect setup or a plugin.

So if I’m not to build a theme which accesses a database, with tables and all, am I going to be limited by how the product data as is site above would be displayed on my site.

As mentioned earlier, WordPress is the CMS. Your theme does interact with the database with PHP and the likes, but it’s not the CMS.

what does it take to create a theme with this functionality,

If you’re asking what knowledge, then you would need to know HTML, CSS, javascript, PHP at the very least.

If you mean the time, then developing from scratch would be about 2 to 3 weeks (that’s for an experienced developer, obviously it would be faster if there’s a team working on it or slower for someone who’s new); If we use a template then customize it to the needs, then it’s about a week or so.

If you mean the cost to hire someone or agency, then it could be anywhere from $20-$40 per hour to a few hundreds dollars per hour. The flat rate could be anything around $800 to a few thousands dollars.

is there a youtube video that comes close to creating one step by step?

I’m sorry to say but unless the person is exceptionally talented, no one is going to be able to just code a WordPress theme without any prior experience or knowledge in web development.