Showing JTL-Shop products on your Joomla website – four ways compared
Many retailers have two presences: the shop in JTL and, next to it, a Joomla website with company information, guides and news. Sooner or later products are meant to appear on the website too, for example on the home page or below a guide. Here I compare four ways and say what to watch out for.
Way 1: copy products by hand
You copy name, image, description and price from the shop into a Joomla article and add a link to the shop. That works straight away and needs no technology.
The catch: you have to repeat every change in the shop on the website. An outdated price on the website is annoying and can become a legal problem. For two or three fixed products that is enough, for more it is not.
Way 2: embed the shop
You embed a shop page in Joomla with an iframe. The content is then always current.
In return, the look rarely matches the website, the height is wrong on phones, and search engines attribute the content to the shop, not to your website. You cannot design anything inside the frame.
Way 3: import an export file
You regularly export products as a file and import them into Joomla, for example into a catalogue component.
That keeps the design in your hands but creates a second data set. Between two imports, prices and stock are out of date, and someone has to keep the import running.
Way 4: read directly from the shop database
The website reads the products directly from the shop's database while building the page. There is no copy and no synchronisation: a change in the shop is on the website with the next page request.
That is the most elegant way, but it needs care in three places:
- Read only. Create a dedicated database user that may only read. Then the website cannot change anything in the shop, not even by mistake.
- The route to the database. If shop and website are on different servers, the database must accept connections from outside. That should only apply to the website's server and be encrypted.
- Put prices and images together correctly. JTL stores net prices and image paths relative to the shop. The website has to build the gross price and the full image address from them.
What I recommend
For a handful of fixed products, way 1 is enough if you leave out the price and link to the shop. If products are to appear regularly and with prices on the website, way 4 is the only one that avoids maintaining everything twice.
For websites with YOOtheme Pro, I developed JTL Source for this. The extension turns your JTL products into a source in the YOOtheme builder. You build a grid, a slider or a single product page with the usual elements and connect the fields to name, price, description, image and the link to the shop. You can filter by categories, manufacturers and characteristics.
JTL Source only reads, checks the connection right in the settings and encrypts it if you wish. If the shop is unreachable for once, your website remains usable. It requires JTL-Shop 5.6, Joomla 6 and YOOtheme Pro. JTL Source is included in the membership.
This article is also available in German.

Related extension
A question about this topic, or an idea for the next guide? Write to me.
Norbert Graup
One membership: all Pro versions, updates and personal support.













