Distribution Centers Automation

The client is a worldwide renowned manufacturer of premium products, including design-centric preparation, storage, and serving solutions for the kitchen and home. The company was founded in the USA in 1946.

Our client was one of the first companies that introduced a direct sales strategy in business. They won a well-known name thanks to famous Home Demonstrations. The products are distributed by independent consultants numbering 2.2 million persons worldwide. The client started its Tupperware distribution in Eastern Europe in 1997. 

The company operates in the direct sales market. The products are sold via Home Demonstrations arranged by independent consultants for their potential clients. The number of consultants is huge: the client keeps a database for hundreds of thousands of data accounts. In addition, the consultants also operate in many different cities where the distribution centers exist.

The Task 

Previously, the client specialists used an MS Access-based desktop application for management and accounting. But as time went on the application no longer satisfied the customer’s demand for processing increasing database volumes. Also, as the branch network expanded and the number of consultants grew, it became hard to provide process transparency in order to receive the information on time for quick stock replenishment and financial analysis. To minimize expenses, the company management made the decision to develop and implement a new system that would automate the operation of the retail sales centers and have a wider range of functionalities based on advanced technologies. Apart from servicing the multi-divisional network of the company, the system had to gather statistical data quickly and streamline interactions with the supply center. 

The task allotted by the client to First Line Software was to create an internal application for efficient control of all the activities. The new system, based on C# and MS SQL, was meant to integrate all the tasks – from adding the consultant’s new personal account, to follow-up of sales volumes and bonus accruals. In addition, it had to ensure that consultants are in compliance with the business rules of multi-level marketing (MLM) principles. 

A DINA application (Distributional National Accounts) keeps the information about consultants’ personal accounts and groups on track. It also records List and Labels selection and generation, compiles order carts and generates invoices, payments, and delivery documents. Tracks accruing commissions to managers and discounts to consultants based on work results. In addition, it gathers sales statistics and generates reports and data selections, and performs forecasts based on the gathered statistics. 

The DINA application includes a front-end application installed on a PC, database-driven by MS SQL. 

This system, installed in a distribution center on several personal computers linked in a local network connected to the central server, already functions in two hundred cities in Eastern Europe, Ukraine, Kazakhstan, and Azerbaijan. All the data is transferred and cumulated in the central repository daily. 

The client addressed us with a problem: a huge amount of data on the production process was accumulated at the plant and was not used. The data had been prepared for analysis within the parameters of the system and implementation in a user-friendly presentation.

The Project Result 

The system was developed within the shortest time possible – three months. The solution was commissioned in several stages. When the production structure was developed, staff training was performed, and after that, the data was inserted into the system. As it stands, the solution is actively utilized and it meets the highest standards in productivity and corporation security. 

Apart from its productivity, the new DINA version provides for automatic data packet transfer between the central office and distribution centers, while generating statistics, and creating reports on the distributors’ operation. 

After conversion to the .NET platform, the system while keeping the same scope of functions, gained a new look and feel and became more flexible, scalable, and easier to support. 

Currently, an option of applying MOM/SOA technologies for efficiently connecting distribution centers and the central office is under consideration. After the client commissioned the system, CIS grew several times and it became the second-largest center in Europe in terms of sales volume. 

The Technical Stack 

  • Client: C#, Windows Forms, MS SQL Server Express Edition, BITS
  • Server: Windows Server x64, MS SQL Server Enterprise Edition
Learn more:

Want to know more details about this case study?

Get in touch

Related work

Interested in talking?

Whether you have a problem that needs solving or a great idea you’d like to explore, our team is always on hand to help you.