Manage your product inventory in one place
Every discrete item can be described by its attributes. There are approximately 30 to 40 attributes of any object. Some attributes are important to buyers, others to sellers, installers, maintainers, couriers, repairers, stockers, retailers, to HMRC and the VAT.

Not all attributes are relevant to all circumstances, processes or downstream applications. The weight of an item may be important to the courier who is selected to deliver it but not necessarily to the buyer who wishes to use it. The fitting type of a light bulb may not be important to the purchase price of the bulb but it will be to the electrician employed to install it.

A key issue for businesses is the fact that most product attributes are recorded and listed by the companies that manufacture and sell them. As a result, product data available to customers and users is biased towards the vendor, is seen from the vendor’s perspective, and customers and users require different information. In summary the information needed to support a sale is different from the information needed to support a purchase, albeit there are many common attributes to both.

With myCatalogues you can build a master product catalogue of products and services you buy and sell in a single, manageable master data set making your business more efficient and effective


So many businesses record a variety of data attributes on products in disparate systems in a chaotic fashion with no master single database or single version of the truth. Product data finds its way into quotes, purchase orders, websites, brochures, marketing material, sales orders, warranty documents, installation and maintenance manuals. Often these elements are maintained discretely by a cross-section of users in a business all creating a great deal of duplicated work and effort.

An efficient business ought to look to build a master product catalogue of products they buy and sell in a single manageable master data set.

RFQ and POP processes involve describing the items a business wants to buy such that suppliers can quote upon them. This is acceptable for buying services as rarely do services repeat themselves in a systematic fashion. Products differ. Products can be defined and are often bought frequently. Building a catalogue of products that can be bought and sold will save valuable time in populating a RFQ or PO document and all the downstream applications that rely on this data.

An example
Every discrete item can be described by its attributes. There are approximately 30 to 40 attributes of any object. Some attributes are important to buyers, others to sellers, installers, maintainers, couriers, repairers, stockers, retailers, to HMRC and the VAT.

Let’s pick a standard product in use in most office buildings, a 2-foot fluorescent tube light.

There are tens of manufacturers of such a product and thousands of re-sellers and suppliers from retail outlets, discount electrical stores, electrical wholesalers and online platforms.


What is the industry recognised term for this product?

It is a F18W/T8/835, something all electricians would instantly recognise, but not necessarily an office administrator looking to purchase one.

The nomenclature comes from how the product is manufactured and listed by the suppliers that sell it namely:

18 Watts power consumption
Eight one eighth’s of an inch in diameter, equivalent to one inch (a legacy measurement!)
Colour temperature – Cool white

There is an industry standard naming convention catalogue to aid manufacturers and re-sellers catalogue their products, it is called Luckins.

Luckins has a standard ID for this product comprising 4 codes and it is defined as follows:

These ID's mean nothing to a buyer. There is nothing in the description that allows a buyer to recognise this item.

Cat 1 - F18W/835

Cat 2 - 62534

TSI Code - 380186372

EAN Code - 43168376136

It would be simple if all re-sellers used this ID in their offers to customers but this would not be in their interests. It would allow prospective customers to compare their offering with others. As a results, suppliers mask their product descriptions so they cannot be competitively compared.

Let’s take four significant UK electrical wholesalers, what do they call this product?

Yesss Electrical – 63171840 – Manufacturer Philips

CEF – F18/940 – Manufacturer not disclosed

Edmundsons – Polylux835 – Manufacturer GE

Medlock – Tube218840 – Manufacturer not disclosed

So, although these are identical products, they are not instantly recognisable as being so.

If I were a buyer and wished to place an order upon each of these suppliers for this particular product, for the sake of accuracy, I ought to use the vendor’s product code in the line item field of my RFQ or PO. This would be time-consuming so it invariably does not happen. Most buyers might write “2-Foot Tube” at best rather than “2-foot fluorescent tube, 18 Watt, 1-inch diameter, Cool White”. Would they enter the vendor’s product code? Unlikely. As a result the attribute data of the product bought is lost for future visibility.

What about pricing?
Each of the 4 vendors listed has multiple routes to market – trade counters, branches, websites etc. It can be guaranteed that asking for a price on a product will result in a myriad of disparate offers even from the same company. Headline pricing varied from £2.21 to £3.16 on this product from the vendors listed. Most branch managers within the same wholesaler will compete with one another for trade and pricing is influenced by individual local targets, circumstances and stock levels. This complexity means that often getting a competitive quote is too time-consuming and buyers tend to buy from the same known source at the same price for long periods of time in between negotiations.
How to gain control over purchasing using product attribute data?
As long as a buyer “buys from” suppliers they have little control or visibility over the products offered or the means to compare with other vendors. Datapool offers buyers the chance to reverse this paradigm. If a buyer manages its own catalogue of products they can offer suppliers the opportunity to trade based on a single common product description, a single version of the truth.
How many attributes is it necessary to record?

In our view a client can never have enough information about a product. If they do not have to compile it why would they want to limit it?

In the above example we have used five of the attributes of the fluorescent tube in its selection to purchase it but what about all the other elements in the downstream process that may require supplemental or different attribute data?

What do our clients say about product catalogue management? How will it potentially benefit your business?
"I never imagined one company would have so much rich attribute data across so many products and markets. OCG Software really surprised us. We are doing things I thought were impossible beforehand."
"Our Datapool solution frees up our time to spend on strategic relationships with key suppliers rather than the noise of our tail spend with ‘me too’ suppliers which frankly had always been chaotic and time consuming."
"Our Datapool solution gives us peace of mind that we always spend the minimum possible on commodity goods."

For a small off investment in time, you now have a fully functioning catalogue management system that will populate all the downstream applications in your business, that require it. This includes websites, brochures, documents, marketing collateral purchase orders, sales orders and ERP systems.

Since 2001 OCG Software has been building master data solutions. Over many years the scope and breadth of the data we have collated cover hundreds of disciples and fields across multiple countries and continents and in multiple languages and across multiple applications. As a business the master data you will need to record and keep current will be specific to you and your business.

More modules, more choice
Datapool comprises a series of applications that operate seamlessly together, within a master data architecture. Contact us if you would like to know more about how these are delivered and how they could save your company valuable time and money.
.mySupplier .myCatalogues .myMasterData
Data held within your dedicated Datapool is under your exclusive ownership at all times and is highly secure to your organisation only. Data is never shared with or accessible from any other organisation. Upon termination of a service contract, all data is returned safely to a client, in its entirety.
OCG Software operates an ISO 27001 compliant ISMS system for complete data security and GDPR compliance.