Vocabulary – ERP Content Classification and tags

This post describes a concept called VOCABULARY. It helps iDempiere admins to categorise records from simple classification to  awesome multi-perspective catalogisation  or  modern  CMS tagging solution.


After I analyzed our customers´ requirements about implementing multiple stores into Magento and iDempiere, the first important question was how should we categorise our products in a modern way. I’ve also asked some other people about their experiences on iDempiere´s forum thread. The top contributor Deepak from Logilite has recommended us to use Product Category for Accounting and Legacy categorization and  implement another solution for better categorisation. For better understanding: Product Category has one perspective to categorise products and it also has a Parent Category, which means that it is able  to implement a tree structure, but we can only define one structure. To make a long story short – we can´t implement multiple stores in this way.

Our requirements about the project

We´ve  made a requirement analysis and the following tools were classified as “must have”.

  • For eCommerce usage – each webstore should have its own tree category – so 1 product must be categorised into multiple trees
  • The solution should be implemented for feature usage by creating a so called “independent product”, which has to support any further database table.
  • Users want to assign products in batches – like “Mass Update”

Collect motivations

Some years ago my company implemented Alfresco (an open platform for business software) and Liferay (a free and open source enterprise portal software product). We also use WordPress, which works very well. My experiences from the world of CMS gave me a good starting point. However, there are the standards  – with the similar concept – where the content can be assigned to categories, which are organised into the tree structure.

The proof about the efficiency of the concept

We´ve designed 3 main new objects: Vocabulary and Classification and Classification Instance. Vocabulary defines new classification perspective  and then creates the root and the tree structure.




Example structure

Website Catalog 2015 Website Catalog 2016
  • cat11
    • cat 11A
    • cat 11B
  • cat12
  • cat13
  • cat 21
    • cat 21A
    • cat 21B
  • cat 22
  • cat 23

How to improve the usage of the Vocabulary by iDempiere

The application can be used in any possible way,  because it was designed for common usage. Common usage means: Simply create a new vocabulary, select the table you want, define classification entries and organise them into the tree.

Price Schema – to create a new price list schema, you just have to add a new line, enter sequence and select between Product Category, Vocabulary and the tree.

New Module tree for DMS – We are working on a DMS plugin (with Deepak from Logilite) – Yesterday we had a review about our concept and – in context of massive content classification –  we´ve found out that it could be applied with a high potential. Of course we need to some other requirement Analysis as well. It´s quite plausible that we don’t need to implement other new features here.

Mass Update Classifications –  hundreds or thousands of products can be classified and later searched by only a few clicks.


Select Classification Tree – As Vocabulary included hundreds of records we have made an another improvement – with custom field type – available here. To the users:  if you are searching a product then first select vocabulary named “Product Catalog 2015”,  then select the value and the exact category you want.


When will it be available for the community?

The project is on its good way to publish it to the public, but it needs time and work.  By sponsorship/supported development we are able to make it available as a plugin or to apply further development. If you have got any questions about the commercial availability of the project, feel free to check my website www.cloudempiere.com

Why I write this blog?

During my studies of Sound Composition in Budapest, Hungary, I was fascinated by the laws of music composing and the rules of making the composition of tones to sound right. Although, we had been using some simple software systems for sound arrangements and production (cut, dramatics, effects…) in the university, it was millions of miles far from anything called business management or enterprise resource planning software.

However, when I started to think about opening my own business (that time a sound engineering studio) I started to look for and test various different, mostly CRM software systems (for managing my own clients) in combination with accounting for a small business.
The world of software was growing significantly day by day and while I was experiencing very often that many companies around me were failing to manage their operations, processes and documents, I started to think to focus rather on software consultacy services to help them out.

Marginally, I had also a chance to see presentations of the top notch CRM systems as Salesforce, SugarCRM, and DMS systems – e.g.Alfresco… and, of course, I first heared about big ERP players like SAP and Oracle.

Maybe it sounds little bit strange to someone, but the complexity and harmony of all the processes operating in one time within these software systems trully impressed me…

And then, back in 2004 I met with the Swedish ERP software system (HansaWorld Enterprise) Sales Representative, who presented me this flagship system of their company and showed me what it worth. „The nordic simplicity“ seemed really reasonably to me! So I decided to cooperate with HansaWorld Enterprise as a partner, supplier of their services, implementor and consultant and I did it for whole 10 years. Firstly, we operated in Budapest, Hungary and then we opened our premisses also in Czech Republic and Slovakia were I come from. I was lucky to work within international team of Hansa World Enterprise, to join them first time in Grand Canaria, Spain.

Before Apple won the world with his iMac in 2001…

One important thing I also appreciated with HansaWorld Enterprise was that it operates well on Apple computers.

You know, already in early 90´s I became a total fan of the Macintosh world and Steve Jobs. My personal experience with using Macintosh technologies started in 1995 when I started to use Apple Performa 5200. I started to study more and more and gone to the very botom spheres of software consultacy and implementation, having long and deep discussions with professionals throughout the world. The more deep and wide I got, the more active I was meeting people from the wide open source community.

I spoke with developers, implementators, software testers, users… And I was fascinated increasingly by the way these people think and work.
I met the fact that the freedom is the most important value for me and although great experience with stable proprietary business system I decided to bring something and participate for the open source community, I met lot of new friends ….Well, today, 9 years later, it is just natural for me to say, I am one of the evangelists of open source life style and that with open source I simply found my way… And,all the experience I gained and which I write about, are commercially used by company based by me and successfully sold to our customers .

And thanks to many great people from the open source community around the world and my company team members´enjoyment from saving resources, process optimization and putting things into the right order flows from me to everyone…