A Single Source Database Implementation for Q8Oils to Improve Product Data Performance

Q8Oils a lubricants manufacturing company and is part of the Kuwait Petroleum Corporation (KPC), one of the world’s largest oil companies. They have over 3 600 employees and a turnover of over USD 10 billion per year. The company develops, blends, and delivers a comprehensive range of lubricants, with a portfolio of more than 1 000 products to suit every application, from the smallest engine to the largest machine.

Business Needs

The client was facing data inconsistency between various systems that led to inaccurate data input and differing usage instructions between the main product lines. The existing database was not seen as a reliable and accurate source for feeding up-to-the-minute information to their website.

After a thorough analysis of existing processes and data,  the client zeroed on defining a new single-source database structure that would (also) precisely cater to their functional business requirements.

The solution is going to be not only a single-source database but also a single structure database that unites 4 business lines having very divergent data processing needs.

Pimcore Solution

Leveraging the flexibility of the Pimcore platform, Pimcore partner Tetrasoft implemented the solution as per the client’s requirements, adding or broadening specific user interface controls for efficient data input (favoring and selecting standard text instead of free text input over all products). The solution includes:

  • The Dynamic Dropdown Tag: A Combo box was created, made of a list of entries defined as external objects. It’s a smart combo, and typing a few characters filters the list interactively.
  • The Multiselect Dynamic Dropdown Tag: It gives the ability to select multiple values in one field.
  • The Dynamic Dropdown Tag (cascade): The same, but several levels of the combo are dynamically interconnected: the list of the child combo is determined by the choice made in the parent.
  • Calculated fields are updated in real-time when input elements are updated in the form. No need to manually save the data.

With the implemented solution, the client is now able to improve response times from several minutes to 5 seconds for pages with extensive collections of blocks (70+). This was achieved with some clever “under the hood” code reengineering by the Pimcore partner Tetrasoft.

Business Results

The solution now provides a single source database for all product data input activities throughout Europe, improving operational efficiency and reliability of the product data across different business units.

Pimcore Silver Partner
Customer
  • Q8Oils
Solution Partner
Products Used

Read more Pimcore success stories

Simplon

Austrian bike manufacturer Simplon produces customized premium bicycles. What began in 1930 as a specialist bicycle shop is now a best-practice example for the production of innovative high-end bikes.
DXP/CMS, PIM/MDM, Digital Commerce, DAM, Manufacturing

Stanley Black & Decker

STANLEY BLACK & DECKER France is the French subsidiary of the #1 tooling company in the world. Established in 1961, it operates through major brands like Stanley, DeWalt, Black & Decker and Facom.
PIM/MDM, DAM, Manufacturing

Product Chatbot For Liebherr Cooling Appliances

Liebherr-Hausgeräte is part of the Liebherr Group, which employs more than 46,000 people worldwide. A chatbot offers online product advice and supports customers in choosing the right refrigerators and freezers.
DXP/CMS, CDP, Manufacturing

Digitization of Automotive Brand by Pimcore and Magento

Harald A. Møller is Norway's largest car importer and stands for the import of Volkswagen, Audi, ŠKODA and now SEAT in Norway. SEAT is today Europe's fastest growing car brand.
PIM/MDM, Automotive & Vehicles

100 000+ businesses trust Pimcore. Discover our 250+ favorite success stories.