Orders were managed in Excel
There was no centralized management of B2B and B2C orders. Data was distributed across tables and employees.
ERP · production · CRM · analytics
Full automation of a window factory — RayGroup
We connected window calculations, B2B and B2C orders, procurement, inventory, finance and customer processing in one digital ecosystem.
PVC window productionAlmaty, KazakhstanLarge Business
B2B orders
B2C orders
Window calculation
Warehouse
Finance
SI
StroyInvest · Aurora residential complex
B2B · window structures
On time
Responsible: Production Department · Stage 'Procurement'
Structure calculation
86.4 m²
Materials
Calculated
Manufacturing
Scheduled
ClientRayGroup LLP
GeographyAlmaty, Kazakhstan
TaskFactory automation
SolutionERP, CRM and process digitalization
About the project
The window factory needs a unified management system
RayGroup manufactures PVC plastic windows and works simultaneously with developers and private clients. Each order involves sales, structure calculation, materials, procurement, warehouse, production, and finance.
Before digitalization, processes were fragmented, a significant portion of data was stored in Excel, and management lacked a holistic view of the business.
Before implementation
The factory grew, but management remained fragmented
Orders, materials, calculations, and finances were kept in separate tables and manual operations. This hindered control over cost price, production load, and project profitability.
No accurate cost price
Employees did not know the actual cost per square meter of a window and calculated offers without a unified pricing model.
Warehouse and procurement were uncontrolled
There was a lack of transparency regarding material balances, deliveries, procurement enquiries, and component write-offs.
Management could not see the full picture
Data on production load, cash flow, project profitability, and sales efficiency was missing.
Solution
Built a unified digital loop for the factory
Linked sales, structure calculation, orders, warehouse, procurement, finance, and management analytics in a single architecture.
Before implementation
Excel spreadsheetsFragmented B2B and B2C ordersManual cost calculationNo warehouse controlManual procurementNo unified analytics
WDAERP-
ERP-
ecosystem
Unified framework
After implementation
Unified ERP systemB2B and B2C in one databaseWindow and material calculationWarehouse accountingProcurement and approvalsCash flow and profitabilityCRM and lead generation
Unified perimeter · integrated system stack
B2B orders
B2C orders
Window calculation
Warehouse
Procurement
Finance
CRM
Website
01 · Process audit
Conducted a full factory audit
Studied the order path from the first enquiry to production and payment. Identified bottlenecks in order management, calculations, warehouse, procurement, and finance, then prepared a digitalization strategy.
- Map of current processes
- Production and accounting bottlenecks
- Digitalization architecture
- Priority implementation plan
Orders B2B · B2CDisparate spreadsheets and manual data transfer01Audit
Warehouse and procurement MaterialsBalances, deliveries, enquiries and write-offs02Audit
Finance Cash flow · ProfitabilityNo unified management analytics03Audit
02 · Window calculation
Implemented professional software for structure calculation
Configured specialized software for RayGroup processes: equipment and components catalog, cost calculator and automatic material consumption calculation.
- Equipment and components catalog
- Cost calculator
- Material consumption calculation
- Unified pricing rules
Structure typePVC window
Area86.4 m²
ProfilePVC · 70 mm
Double-glazed unit2-chamber
Material consumptioncalculated
Cost and specification formed
03 · ERP system
Developed a unified order management system
Created a proprietary ERP system with the 'Project' entity. The card contains order history, client, calculations, deadlines and statuses. B2B and B2C directions work in a common database, but according to separate scenarios.
- Unified 'Project' entity
- Separate B2B and B2C scenarios
- Client interaction history
- Deadline control
New 12
B2C · siteApartment · 6 windows
Calculation 7
B2B · Aurora residential complex86.4 m²
Set. 5
Materials · ready
Prod. 9
Workshop · in progress
04 · Warehouse and procurement
Automated material movement
Developed procurement and warehouse modules. Now the team tracks deliveries, creates enquiries, approves orders, controls balances and records material write-offs.
- Procurement enquiries
- Order approval
- Balance control
- Material write-off accounting
SPVC profileApproved
Need calculatedautomatically by specification
Enquiry approvedprocurement department
Materials accepted to warehousebalances updated
05 · Finance
Established control over cash flows and profitability
Integrated the financial circuit: payment tracking, cost allocation, cash flow management, and an analytics dashboard with order profitability reports.
- Payment tracking
- Cost allocation
- Cash flow and cash control
- Project profitability
Cash flow movement
Cash flow · Under control
Active projects
ERP · Unified database
Project profitability
AAurora Residential Complexvisible
BB2C ordersvisible
CCorporate projectsvisible
06 · CRM and marketing
Automated processing of incoming clients
Moved B2C orders to CRM, configured enquiry distribution, source tracking, and sales pipeline control. Developed a website with online enquiries, SEO content, and integration with marketing tools.
- Automatic enquiry distribution
- Client source tracking
- Website with online enquiries
- SEO and advertising funnel
RayGroup websiteonline enquiry
Transfer
CRMlead created
Client source tracked automatically
Result
From scattered spreadsheets to a controlled factory system
Before implementation
- Orders were managed in Excel
- B2B and B2C processes were separated
- Cost was calculated manually
- Material balances were not controlled
- Purchases and write-offs were opaque
- There was no cash flow or profitability analytics
- Incoming enquiries were processed manually
After implementation
- Orders consolidated in a single ERP
- B2B and B2C operate under controlled scenarios
- Structures and materials are calculated automatically
- Warehouse shows actual balances
- Purchases and write-offs are recorded in the system
- Management sees cash flow and profitability
- Website enquiries automatically enter CRM
Order path
From incoming enquiry to management analytics
The order passes through an integrated circuit without scattered spreadsheets or repeated manual entry.
- 01
Order received
A B2B project or a private client enquiry is recorded in the system.
- 02
ERP creates a project
The card collects the client, deadlines, statuses, and work history.
- 03
Windows are calculated
Cost, specification, and material consumption are formed.
- 04
Warehouse checked
The system accounts for balances and forms procurement needs.
- 05
Production starts
The project is handed over for work with execution deadline control.
- 06
Finances are recorded
Payments and costs are reflected in the financial circuit.
- 07
Management sees the result
Cash flow, profitability, and the status of each project are available.
order segments: B2B and B2C
digitalization circuits are interconnected
implementation stages from audit to marketing
unified ERP ecosystem instead of spreadsheets
Solution Architecture
All key factory processes are interconnected
Order sources
B2B ordersdevelopers and projects
B2C enquirieswebsite and marketing
ERP RayGroupcentral management system
ProjectsCalculationsWarehouseProcurementFinanceCRM
Services and modules
Window calculationcost and materials
Warehouse and procurementinventory and supplies
Financial analyticsCash flow and profitability
Order flow in ERPCalculations and materialsData synchronization
Business Impact
Management received a transparent control system
All orders in one system
B2B and B2C projects are consolidated in ERP with history, statuses, and deadline control.
Accurate structure calculation
Cost and material consumption are calculated according to unified rules.
Warehouse and procurement control
The team sees inventory, supplies, enquiries, and material write-offs.
Finance and sales are transparent
Management controls cash flow, project profitability, and incoming enquiries.
Project Stages
From factory audit to launching the digital ecosystem
1
About 3 daysAnalysis and design
We conducted an audit of production, warehouse, orders, and finances. Prepared the technical specification and ERP architecture.
2
From 1 to 3 weeksWindow calculation implementation
We configured specialized software for the factory and trained employees to work with the cost calculator.
3
From 1 to 2 weeksERP system development
Implemented orders, warehouse, procurement, finance, and management analytics.
4
From 1 to 2 weeksCRM and B2C automation
Set up lead generation, request distribution, and sales pipeline control.
5
From 1 to 2 weeksWebsite and marketing system
Launched an SEO-optimized website, online enquiries, and advertising funnel.
Need similar production automation?
We will analyze the enterprise processes, find bottlenecks, and propose a clear digitalization plan.
Other projects
Other automation projects
Free audit
Let's find what can be automated in your business
We will conduct a free process audit, identify priority tasks, and propose a clear implementation plan.
No complex jargon or upselling. First — business tasks.
Enquiry sent
We will contact you to clarify project details.