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
- 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.