Managing product information in your CMS is always a big topic for discussion. Typically a CMS is not suited for managing product data like price and stock, on the other hand not every PIM system has the ability to manage multilingual descriptions of your products that you might want to display on your website or product catalog. So combining two systems is obviously the thing to do here. Nothing new under the sun there, but with the release of SDL Tridion 2013 we have ECL which can shed a complete new light on this topic.
The External Content Library is an API for developing Providers, Template Building Blocks and Event Handlers that communicate with an external system and expose its multimedia content in SDL Tridion. But that does not mean it is limited to only multimedia content, because we have the option to expose external metadata as well. So when I was trying to find the limits of what I could do with ECL (and what I shouldn’t try), I came up with an ideal scenario, being the realm of product information.
Let’s take a look at what we have in a typical PIM system, it will contain all your product related information like SKU, dimensions, price, stock and a whole lot more information which should never have to be translated. Typical stuff, which we don’t want to copy over to our CMS, but we do need to have it available on our product catalog on the web. Now if you also have an image or icon available for every product in your PIM system, then we could use that as the basis for our ECL integration (together with the unique id of the product of course). Through the ECL provider you will now have the ability to show a complete list of all your products in your PIM system, visualizing that using the image or icon. It can even be made searchable and can sort your products in a structure similar as the one you have in your PIM system. 
The ECL provider will make all the product information from the PIM system available in the External Metadata tab of the ECL Component, which will make it directly available for use in templates (i.e. on your Page). Now for the marketing information that needs to be added to this product (which we want managed in SDL Tridion so it can easily be translated in our BluePrints) we can use the normal Metadata of the ECL Component. This basically is the same as adding Metadata to a Multimedia Component and it will be directly available when you open your ECL Component (allowing you to localize and translate in BluePrinted Publications). We can then also start tagging our products with SDL Tridion keywords, so we can add relations between our (marketing) information in our CMS (i.e. articles, blog posts etc.).



So with a relatively simple ECL provider we have completely integrated our PIM system and made all its data directly available for use in our CMS managed product catalog. And the marketing information in our product catalog is manageable from our CMS and can be translated using our integrated translation technology.


