http://doc.silverstripe.org/en/developer_guides/customising_the_admin_interface/modeladmin/

So this tutorial is simple and great but seems to miss the vital ending of displaying the data on the site in your template?
The point of me using this method would be like extending SiteConfig which allows you to pull the information into any template page i.e. $SiteConfig.Title.
I want to loop the Products on any page? for example in the footer on every page.. not just a Product.ss page. I could extend SiteConfig but I want its own window / tab not to be bundled in the Settings tab.

Same as any other data object collection.

http://doc.silverstripe.org/en/developer_guides/model/data_model_and_orm/#querying-data
http://doc.silverstripe.org/en/developer_guides/model/lists/#iterating-over-the-list

Make a controller function to access it.

class Page_Controller extends ContentController {
	public function Products() { return Products::get(); }
}

<% loop Products %> ... <% end_loop %>

You will need to place a method in your Page class for querying the data.

Something like:

// Page.php
class Page extends SiteTree {
	public function Products() {
		return MyDataObject::get();
	}
}
// Page.ss
<% loop $Products %>
$Title
<% end_loop %>

Great thanks! Both worked except in your example Pyromanik "return Products" needed to be "Product"

Yeah, it needs to match whatever your DataObject is named of course :)