Streamlining Delivery via AG grid

Building Logistic interface with pre-Built Data Grids

In the dynamic world of logistics, accurate and accessible data is essential. This concept is the backbone of OPTISTOCK, an advanced decision support tool. Crafted to combine ERP data from sales, stores, and warehouse stocks, OPTISTOCK aids supply managers in day-to-day tasks. Its main goal? To optimize daily stock distribution strategies and ensure the greatest sales.

Project Background

The client's goal was to transform the existing, on-premise solution, into a cloud-based multi-tenant SaaS platform. This evolution was not only for modernizing the tool but also accommodating an ever-growing user base.

OPTISTOCK's main feature for users is suggesting daily stock levels based on sales and what's in the warehouse. It shows, detailed insights, displayed in extensive tables with vast rows and columns in a coherent manner. Furthermore, it offers a meticulous customization feature for every product attribute. The dilemma? Determining the optimal method to present such complex data to the end-users without overwhelming them. Our solution? Leveraging the power of pre-built data grids.

Factors We Considered When Choosing a Spreadsheets Component Library

Before diving into the specifics of our chosen solution, it's worth highlighting the criteria that guided our selection:

  • Performance & Scalability
    The ability to handle vast amounts of data without compromising speed or responsiveness was a top priority.

  • Customizability & Flexibility
    We needed a solution that would allow us to tailor components to our unique requirements, given the intricate nature of OPTISTOCK's functionalities.

  • Ease of Integration
    A smooth integration process with our existing systems was crucial to ensure continuity and reduce development time.

  • User Experience
    The library had to support the creation of intuitive, user-friendly interfaces to ensure that OPTISTOCK users could effortlessly navigate and interact with the platform.

  • Reliability & Support
    Given the mission-critical nature of logistics operations, we sought a library with a proven track record and robust community or official support.

  • Out of the box analytical capabilities
    In addition to the above criteria, we considered the library's ability to provide out-of-the-box analytical capabilities. This was important to empower our users with advanced data analysis features without the need for extensive custom development.

AG GRID: Revolutionizing Optistock's Data Display

For a tool like OPTISTOCK, presenting data effectively is as crucial as the data itself. This is where AG GRID stands out, to maximise outcomes we use the Enterprise version:

  • Efficiency & Speed
    Integrating AG GRID ensures rapid deployment, enabling OPTISTOCK users to dive into decision-making without delay.

  • Tailored Presentation
    While AG GRID offers a comprehensive suite of features out-of-the-box, its true strength lies in its adaptability. It can be customized to fit the specific needs and nuances of each logistics operation—aligning perfectly with OPTISTOCK's emphasis on detailed product customization.

  • Enhanced User Experience
    In logistics, clarity is paramount. An organized grid, like the one provided by AG GRID, offers a clear, concise data presentation, facilitating the decision-making process for supply managers.

  • React.js Integration
    Combining the dynamic capabilities of React.js with AG GRID's robust features further augments OPTISTOCK's front-end. Real-time data updates and functionalities like sorting and filtering become invaluable tools for analysing logistics data.

​​Front-End Development Challenges while Integrating AG GRID

While AG GRID has been a game-changer for Optistock's front-end development efficiency, integrating such a robust component library wasn't without its challenges:

Complex configuration and documentation

AG Grid offers extensive customization options, which can be overwhelming for new users. Configuring the grid to meet our specific requirements required a deep understanding of the library and its numerous features and involved a considerable learning curve for our development team. This process has been helped by the extensive documentation - as well as some additional training courses -

Performance Optimization

Мanaging large datasets, a common occurrence in stock optimization software tools such as Optistock, presented performance challenges. Our application's real-time data rendering capabilities were put to the test. We had to fine-tune data loading and rendering mechanisms to ensure smooth user experiences even with significant data volumes.

Cross-Browser and Cross-Platform Compatibility

Еnsuring seamless functionality across various web browsers and OS was a crucial aspect of our integration process. Compatibility issues arose, requiring additional testing and adjustments to guarantee a consistent user experience for all Optistock's clients.

Customization vs. Out-of-the-Box Features

Balancing customisation with out-of-the-box functionality was a constant challenge. While AG Grid offered many features, especially in its enterprise version, we sometimes had to choose between leveraging these built-in capabilities and crafting custom solutions tailored to our exact requirements.

Take, for instance, our Product Performance table which is one of the most valuable parts of the software. This table was intricate, having numerous columns. We initially opted for a custom solution, splitting the information across three tables to achieve our desired layout and functionality.

However, as we sought to optimise performance, we realised the potential of AG Grid's existing functionalities. We consolidated our data into a singular table and by using AG Grid's pinned columns feature, we fixed the positioning of certain columns while making the remainder scrollable. This decision represented a trade-off: choosing between our custom solution, which perfectly met our design needs but had certain limitations, and AG Grid's built-in solution, which, while not visually perfect, offered enhanced speed and performance.

Your Custom-Built App with Our Expertise

When it comes to tailoring solutions to fit intricate needs, Plan A has demonstrated excellence in the retail industry. Just as we helped RetailAPPS reimagine stock distribution with OPTISTOCK, we can partner with you to craft an application tailored to your unique challenges and ambitions. We've got the tools, team, and persistence to turn your vision into a powerful, efficient reality. Let's co-create your success story.

Contact us

Continue reading

Mastering QA Series #1: Leadership in high-growth startups

It's been less than a year since Elena Zhekova joined Plan A's team for our Client Regate, and her impact has been profound. Elena, with over 11 years of experience gained in companies like Merkle and Proxiad, quickly established herself as a key person in her role as QA Manager. Her strategic approach to refining quality assurance processes has paved the way for significant improvements.

Digitalising distribution channel management

Kamenitza is among the leading brewing companies in Bulgaria, founded in 1881, and owns the first beer in Bulgaria that is still produced today – Kamenitza. The company combines the beer expertise of the four world's most famous brewing traditions – the Czech, the German, the Belgian, and the Irish – with loved brands such as Burgasko, Staropramen, Stella Artois, Guinness, Corona, and more.

Committed to maintaining its market leadership, the company focuses on digital transformation to modernize operations for greater efficiency and responsiveness. One such solution, 'Beersteam' developed by Plan A, is part of a suite of software solutions exemplifying Kamenitsa's dedication to operational excellence and strategic innovation.

Agile vs Lean.

In project management, two huge value-driven methodologies have been imposed: Lean and Agile. Although incomparable, both often find their names in the debate of project management professionals trying to optimize their process efficiency, improve its outcomes, and adapt to changing demands. Below is a comparison of these two well-used frameworks.


Stay up to date, subscribe to our newsletter !