Case Study

In the lens: ERP focusing full sales and logistics service

50 showrooms all over Poland, thousands of transactions a day, 200 employees using our ERP daily, and the ongoing synchronization of large amounts of data from various systems... It’s a lot, isn’t it?! Read how we improved the sale process for Twoje Soczewki.

Our client needed an effective ERP (Enterprise Resource Planning) system for full sale support, of all of their retail outlets, and comprehensive management of their logistics processes. To do it properly, we first had to get to know the client's business and understand the processes behind it. There was quite a lot to learn: invoicing, rebates, inventory control, employee schedule, and much more, but we rose to the challenges bravely and successfully!

But then… we had to face the biggest challenge..

The Challenge

Our biggest challenge was to build a centralized browser system - modern, fast, and designed precisely for specific operational needs. However, it turned out that in certain stores there were problems with access to the Internet, which at the same time made it difficult to operate the local fiscal printer.

The network infrastructure had to be first completed and modernized. That is why we decided to run centralized local servers, which communicate with the central base at specified and short time intervals. This ensures smooth data flow. In fact, we’ve created our own database cluster built of over 50 MySQL instances working in the Master-Master model.

What the implementing process looked like

As always, when designing solutions for a specific task, we started with understanding the client's business. We asked questions, we talked to employees, we left no stone unturned. We also played an advisory role, improving the already existing processes and building new ones from scratch. An interdisciplinary team was involved in the work at each stage.

We mapped the processes, then refined and polished the details, we were then able to design the system, implement it, and train employees. Of course, we also helped with the selection of the necessary hardware. We used the following technologies and solutions: Linux, MySQL, Apache, Ansible, Luks, PHP, Javascript.

Effects

The system includes over 50 retail outlets and is used by over 200 employees. It operates as a decentralized system, however, all peripheral branches communicate with the headquarters and exchange information on a regular basis.

The solution, entirely based on a Linux environment, enables:

  • Full support for individual customer orders and Point of Sales (POS) (at retail stores), and the support for a fiscal printer.
  • Support for all logistics processes, including full warehouse management. This also applies to sending, collecting, and receiving consumer goods at internal warehouses of branches.
  • E-commerce sales support.
  • Parallel work of many sellers and simultaneous work of many terminals with a single fiscal printer.
  • Independence of POS, in other words - the possibility of working and selling without internet access, and with delayed synchronization.
  • Managing rotas.
  • Creating reports illustrating work on various sections of the sales process.

In Summary

We helped our client in the transition from the old and ineffective solution to a fully consistent, synchronized, and effective one. Individual branches now have the same equipment structure and integrated online communication infrastructure to ensure data security.

How does this system work?

The solution is built exactly to the client's requirements: in addition to a set of specific functionalities, it has been adapted to the style of work in POS and the nature of the processes. It also allows for flexible expansion during its operation, depending on the needs. We also provide administrative support for the system.

Benefits for our client

The system has been in use by the customer since 2014. It allows them to manage sales and logistics in real-time at POS located all over Poland. At the same time, it also provides a structured data stream. All this opens up the possibility of faster and more effective business decisions.

Join our team

We are a boutique PHP software house based in Wrocław. Part of the team works for us remotely.

Join Us


    +48 513 047 793

    We answer our telephones from 8am to 4pm (Central European Time, UTC+01:00)

    ul. Grabiszyńska 163,
    53-439 Wrocław

    Any questions?
    Use our contact form