Skip to main content
Discuss your project Custom business systems & automation

Portfolio Business club ERP

Thousands of club members — in one base, no duplicates

A new version of a business people’s club’s internal system. The old one has been running since 2017; the new one moves members, their companies and membership history to a modern stack — and is meant to become the shared base for the club’s other services.

Project

Business club ERP

Business club ERP · project Members and companies
Client
A business people’s club in Ukraine It brings together entrepreneurs and their companies, has several membership packages and its own services for members.
System
An internal base of members, companies and membership packages The old system is running, the new one is on its way: data moves into it while keeping a link to the original record.
Our role
Old base analysis, new data structure, migration, interface Plus roles and access rights, verification of migrated data and tests.
Technologies
  • PHP
  • Laravel
  • Filament
  • Livewire
  • MariaDB
Status
The new version is in development The first stage is done: data migration, dictionaries, members, companies and membership packages. The old system keeps running while the switch goes on.

Task

A base built over years, to be moved without losses

Over the years the club gathered thousands of member and company records. Some were duplicated, addresses and cities were free text, and membership package history lived in several places.

Lose nothing

Every member, company, note and history entry must move to the new system, and the link to the old record must be kept for good.

Remove duplicates

One person or company could be recorded several times with different spelling. In the new base there must be one.

A city is not free text

Addresses and cities of activity must be matched to the official register of communities and settlements so they can be searched and filtered.

A base for other services

The new base should feed the club’s websites, so that a member has one account rather than a separate login on every site.

Solution

A new base grown out of the old one

Migration in steps

Data moves in a strict order — dictionaries, members, companies, roles, notes, photos and logos. Each step can first run without writing anything, and a separate check compares the result with the old base.

Duplicates and addresses — automatically

Members are merged by email, companies by a normalised name, and doubtful records are flagged for a person to review. Cities and communities are matched to the official codifier.

Membership apart from access

The base holds every member, while entry to the panel itself is granted separately and depends on the role. A member’s password is laid down as their future login to the club’s services — syncing with them is the next stage.

Capabilities

Members, companies and membership packages

01 · 4

Members

  • Member card in Ukrainian and English
  • Member’s companies with position and status
  • Notes on a member
  • Photos from the migrated base

02 · 4

Companies

  • Industries and business areas from dictionaries
  • Headcount and annual turnover
  • Legal address by the communities codifier
  • Company logo and contacts

03 · 3

Membership packages

  • Membership packages and their statuses
  • Package history of every member
  • Archived tariffs from the old system

04 · 5

Migration and access

  • Migration from the old base with a dry run
  • Result verification after migration
  • Roles with access rights
  • Separate permission to enter the panel
  • Automated tests and static code analysis

Result

Stage one — a base you can rely on

Members and companies from the old base move to the new one without duplicates, with cities from the official register and a link to every old record. The migration can be repeated at any time, and the check confirms nothing was lost.

The old system runs while the switch goes on. Next come the remaining sections of the old system and syncing with the club’s website.