CASE STUDY · STEEL & CONSTRUCTION · CRM

100,000 Records.All Connected.

An industrial group in steel distribution and construction moved CRM, sales and project delivery for two businesses into one ClickUp workspace. Dtech migrated more than 100,000 records and wrote custom code to connect them and put customers on a map.

INDUSTRYSteel distribution & construction
SCOPETwo business units
SERVICEConsulting, implementation & data migration
DATA MIGRATED100,000+
CUSTOM CODENode.js + ClickUp API
STATUSHanded over to a client champion

The client is not named. Workspace screens, records and maps on this page are recreated with sample data.

01Who they are

An Industrial Group,Two Businesses, One Structure.

The client is an industrial group working in steel distribution and related construction and architectural services. Customer relationships, sales opportunities and project work ran across several businesses. Two of its business units took part in the project.

Business unit A
CRM
Customers
Contacts
Customer meetings
Sales leads
Sales pipeline
Opportunities
Project delivery
Incoming
Active
Completed
Lost
Same spaces, lists and workflows
Business unit B
CRM
Customers
Contacts
Customer meetings
Sales leads
Sales pipeline
Opportunities
Project delivery
Incoming
Active
Completed
Lost

Both business units run on the same underlying structure, so the workspace can be managed as one.

02Where they started

Separate Systems,Disconnected Records.

Reporting, customer information, sales activity and project work sat in different systems that did not talk to each other. The group wanted one consistent way to run these operations across its businesses. Moving the data was only part of it: the information had to be useful for everyday work once it arrived.

customers_export.csv48,212 rows
idname 3townpostcode 1lat,lng
ACC-1042Hartley Steel Fabrication LtdLeedsls11 5px empty
ACC-1043Northgate CladdingWakefieldWF1 2DQempty
ACC-1044Hartley Steel Fab.LeedsLS11 5PXempty
ACC-1045Pennine Roofing SuppliesHalifaxhx1 1qeempty
opportunities_export.csv21,684 rows
idcustomer 2value
OPP-2291Hartley Steel Fab£48,000
OPP-2292northgate cladding ltd£112,500
OPP-2307Hartley Steel Fabrication£23,900

1Postcodes stored as plain text, with no latitude or longitude for a map.

2Opportunities pointing to customers by typed name, not by record.

3The same customer entered more than once, spelled differently.

The kind of exports the migration started from, recreated with sample data.

WHAT THE GROUP NEEDED

Bring customer and sales information into one platform.

Create structured sales pipelines and project workflows.

See opportunities, ownership and progress clearly.

Connect customer records with related sales information.

Visualise customer locations across towns and counties.

Migrate the data without losing relationships between records.

03What we built

One Standard Workspace,Four Connected Workflows.

Instead of a different setup for each business, Dtech designed one ClickUp structure and used it for both. CRM lists hold customers, contacts, meetings and leads. A sales pipeline tracks opportunities. A project delivery structure follows work from incoming to completed or lost. Relationship fields tie it all together.

CRM/CustomersRelationship fields
CustomerTownOpportunitiesContactsAccount owner
Hartley Steel FabricationLeeds 2 3A. Patel
Northgate CladdingWakefield 1 2J. Morris
Pennine Roofing SuppliesHalifax 3 1A. Patel
Calder Valley BuildersHuddersfield 1 4R. Shaw

Each customer links to its opportunities, contacts and meetings, so related records open from one place.

Recreated with sample data. Switch tabs to see each view.

Spaces, folders and listsCustom fieldsAutomations and statusesDashboardsMap viewRelationship fieldsClickUp API and custom code

04How the data moved

Not an Import.A Rebuild.

Data migration became a large part of the engagement. Importing customers and opportunities as separate rows would have produced a list, not a connected CRM. The source records needed cleaning and restructuring first, and ClickUp’s Map view needs coordinates that the postcode text did not have.

01
Clean

Fix formats, spacing and duplicates in the source files.

02
Restructure

Reshape rows to match ClickUp lists and custom fields.

03
Geocode

Turn each postcode into latitude and longitude.

04
Link

Connect each opportunity to its customer record.

05
Import

Load into ClickUp through the API.

BEFORE
postcode"ls11 5px "
customer"Hartley Steel Fab"
lat, lngempty
Node.js + ClickUp API
IN CLICKUP
LocationLS11 5PX · 53.79, -1.55
CustomerHartley Steel Fabrication
On the mapYes
migrate.js
// Illustrative excerpt – simplified
for (const row of customers) {
  const { lat, lng } = await geocode(normalise(row.postcode));
  await clickup.updateTask(row.taskId, {
    location: { lat, lng },
    opportunities: links.get(row.accountId)
  });
}

A simplified, illustrative excerpt. Dtech’s scripts used the ClickUp API to process the data, add coordinates and link related records.

05What changed

Delivered, Migrated,Handed Over.

Dtech completed the implementation and data migration for both participating business units. After go-live, a new ClickUp champion on the client side took responsibility for the workspace.

RECORDS MIGRATED100k+

cleaned, linked and imported

BUSINESS UNITS2

on one shared structure

WORKFLOWS4

CRM, sales, delivery and mapping

CUSTOM SCRIPTSAPI

for geocoding and record linking

IMPLEMENTATION OUTCOMESHANDED OVER
  • 100,000+ records prepared and migrated
  • CRM, sales and project workflows standardised across both businesses
  • Customer and sales records connected
  • Customer coverage visible in Map view
  • Pipeline and workflow information in central dashboards
ImplementationWorkspace designed and configured
Migration100,000+ records moved and linked
HandoverA client-side ClickUp champion takes over
After handoverUsage and impact not visible to Dtech

Dtech did not have visibility into usage after handover, so long-term adoption and productivity gains could not be independently confirmed.

06Lessons learned

What Large MigrationsTeach Us.

01

Standardisation pays off

When several business units share a platform, the same workflows make administration and training simpler.

02

Migration is more than importing

Source data has to be cleaned, structured and connected. When standard imports fall short, plan for development work.

03

Handover is part of the job

A clear transition plan keeps continuity when a client-side champion takes over, and makes it easier to follow up on adoption.

IN SHORT

Bringing several businesses together takes more than shared software. Dtech set up standard CRM, sales and project workflows for two business units, migrated more than 100,000 records, and built custom code to connect customer data and map it.

NEXT CASE STUDY20 IT Teams, One Workspace

How an aviation organisation moved its IT and PMO departments off spreadsheets and into ClickUp.

Read the Story

BOOK THE FIRST HOUR

Let theResults Speak.

As a ClickUp Diamond Partner, we are measured on real adoption, not hours billed. If the first session works, your team will ask for more. If it does not, we stop there.

Book a Free Hour
Your free first hour60 minOnline
PICK A DAYRIYADH · GMT+3
AVAILABLE TIMES
Chat on WhatsApp