ERP migration
Field-level mapping, validation, and rollback between proALPHA ERP and Dolibarr ERP. We move data and schema; workflows are rebuilt natively in Dolibarr ERP.
proALPHA ERP
Source
Dolibarr ERP
Destination
Compatibility
9 of 12
objects map 1:1 between proALPHA ERP and Dolibarr ERP.
Complexity
BStandard
Timeline
3-5 weeks
Overview
Migrating from proALPHA ERP to Dolibarr is a structural simplification as much as a data move. proALPHA targets mid-market discrete manufacturers with deep APS, multi-level BOMs, and work order scheduling that Dolibarr does not replicate natively. Dolibarr's open-source ERP/CRM model serves SMEs with modular finance, CRM, inventory, and project capabilities at a fraction of proALPHA's per-user cost. We extract from proALPHA through ODBC bridge, direct database reads, or community-built PAPI depending on license tier, map the source's business partner roles to Dolibarr's Third party model, and handle the BOM decomposition by flattening multi-level structures into Dolibarr products with linked sub-assemblies. Fixed asset depreciation methods, useful life data, and acquisition costs migrate as Dolibarr asset records. Historical journal entries spanning multiple fiscal years are scoped and archived selectively. Workflows, automations, and the proALPHA document management layer do not migrate as functional equivalents; we deliver a written inventory for the customer's admin to rebuild in Dolibarr's low-code Module Builder.
Every standard and custom field arrives verified.
AI proposes the map; you confirm before any record moves.
Parent–child, lookups, and ownership stay linked.
Calls, emails, meetings — with original timestamps.
Documents, uploads, and inline notes move with the record.
Why teams make this switch
Leaving
What's pushing teams away
Choosing
What's pulling them in
Object mapping
Each row shows how a proALPHA ERP object lands in Dolibarr ERP, including any object-level transformations, lookup resolution, or schema-design dependencies.
Typical mapping — final map is confirmed during the sample migration step.
proALPHA ERP
Business Partner (Customer)
Dolibarr ERP
Third Party (Customer type)
1:1proALPHA treats Customers as distinct business partner records with address, contact, classification, and payment-term data. We map these to Dolibarr Third Party records with the Type set to Customer. The proALPHA partner code becomes Dolibarr's customer code. We resolve multi-address structures by creating Dolibarr contact addresses linked to the Third Party. Payment terms, credit limits, and price level assignments from proALPHA map to Dolibarr's Term, CondReglement, and LocalTax columns on the Third Party.
proALPHA ERP
Business Partner (Vendor)
Dolibarr ERP
Third Party (Supplier type)
1:1proALPHA Vendors map to Dolibarr Third Party with Type set to Supplier. The proALPHA vendor code maps to Dolibarr's supplier code. We preserve vendor-specific payment terms and bank details from proALPHA's vendor record into Dolibarr's supplier setup. If the same partner record in proALPHA serves both customer and vendor roles, we create two Dolibarr Third Party entries (one of each type) linked by the original partner identifier.
proALPHA ERP
Item (Product Master)
Dolibarr ERP
Product
1:1proALPHA Items include the product master with BOM, routing, variant configuration, and unit-of-measure data. We map Item number to Dolibarr Product ref, description to label, and unit of measure to unit. Unit price from proALPHA's sales price or purchase price conditions map to Sell price and Buy price on the Dolibarr Product. Variants handled via proALPHA's product configurator are decomposed into individual Product variants in Dolibarr with the configuration reference stored in a custom field.
proALPHA ERP
Bill of Materials (Multi-level)
Dolibarr ERP
Product with Bill of Materials sub-products
1:manyproALPHA multi-level BOMs (parent assemblies with nested sub-assemblies and components) require decomposition for Dolibarr's flat BOM model. We flatten the hierarchy: the top-level finished good becomes a Dolibarr Product with type 'assembly', and each component at every level becomes a separate Product with type 'product' or 'assembly' as appropriate. The top-level BOM relationship is stored using Dolibarr's BOM module (if enabled) with quantities and unit-of-measure per component. We flag any BOM routing data tied to APS scheduling constraints as notes requiring manual work-center reconfiguration in Dolibarr.
proALPHA ERP
Chart of Accounts
Dolibarr ERP
Accounting accounts (Plan comptable)
1:1proALPHA maintains a structured COA with cost center and department assignments. The standard export maps cleanly to Dolibarr's accounting module account structure. We verify account types (asset, liability, equity, expense, revenue) against Dolibarr's account type taxonomy and flag any proALPHA cost-center-specific accounts that have no direct Dolibarr equivalent. The customer configures the target chart of accounts in Dolibarr before migration using the accounting module's import tool.
proALPHA ERP
Journal Entry
Dolibarr ERP
Accounting transaction (various types)
1:1proALPHA journal entries (G/L postings) map to Dolibarr accounting entries of the corresponding type (sale, purchase, payment, general). Each line in a proALPHA journal entry becomes a separate line in the Dolibarr accounting entry. We validate that debit and credit totals balance before importing into Dolibarr; entries that do not balance after mapping are held in a reconciliation queue. Historical journal entries are scoped by fiscal year during discovery, and entries older than the agreed retention cutoff are archived as flat CSV exports rather than imported into the live accounting ledger.
proALPHA ERP
Fixed Asset
Dolibarr ERP
Asset
1:1proALPHA fixed asset records include acquisition cost, depreciation schedules, useful life, location assignments, and asset class. We map these to Dolibarr's Asset module (if enabled) with acquisition date, acquisition value, and depreciation method preserved. Proalpha's depreciation method (linear, declining balance, sum-of-years-digits) maps to the corresponding Dolibarr Asset amortization type. Any proALPHA asset linked to a specific cost center or department requires the equivalent Dolibarr project or warehouse assignment to be configured before import.
proALPHA ERP
Open AP and AR
Dolibarr ERP
Invoice (Supplier or Customer)
1:1Outstanding payables and receivables in proALPHA carry payment terms, due dates, and partial allocations. We extract open items at a fixed extraction timestamp and map them to Dolibarr Supplier Invoice (unpaid) or Customer Invoice records. The open item status (partial, full) and remaining amount are preserved. We do not replicate proALPHA's payment allocation engine; the customer reconciles payments against open invoices post-migration using Dolibarr's payment recording workflow.
proALPHA ERP
Work Order / Production Order
Dolibarr ERP
Project or Manufacturing order
lossyproALPHA work orders include operation sequences, work center assignments, and scheduling constraints tied to APS. Dolibarr's manufacturing module (if enabled) supports basic production orders but lacks APS-level scheduling, bottleneck detection, and alternate resource suggestions. We extract work order status, material allocations, and backflush records, and map them to Dolibarr Project with manufacturing-linked tasks. APS-specific scheduling data is flagged as out-of-scope and documented for the customer's admin to reconfigure manually in Dolibarr or an external scheduling tool.
proALPHA ERP
Warehouse / Inventory
Dolibarr ERP
Warehouse and Stock
1:1proALPHA inventory records span multiple sites with stock quantities, locations, and lot/serial numbers. We map site-level warehouse data to Dolibarr warehouses created per proALPHA location. Stock quantities per item per warehouse migrate as Dolibarr stock movements. Lot and serial number tracking migrates if Dolibarr's lot/serial module is enabled; otherwise we store the lot reference in a custom field on the Product for traceability.
proALPHA ERP
Custom Properties / User-Defined Fields
Dolibarr ERP
Extra fields (Dolibarr Extrafields)
lossyproALPHA supports custom fields per module, but naming conventions and data types vary by customer instance. We document every custom field encountered during the discovery scan, map each to a Dolibarr Extrafield with the equivalent data type (string, integer, select, date, checkbox), and preserve the original proALPHA field name as a label note. Custom fields without a direct Dolibarr type equivalent are migrated as string and flagged for the customer to refine post-migration.
proALPHA ERP
Documents and Attachments
Dolibarr ERP
Linked file storage
1:1proALPHA's integrated document management stores binary files linked to business objects (Customers, Items, Work Orders). The documents themselves require a separate extraction operation because standard data export does not include binary attachments. We extract document metadata (filename, file type, linked object, creation date) and perform a parallel file transfer to a Dolibarr-accessible file location, then create Dolibarr document links referencing the transferred files. We flag any binary files that cannot be matched to a Dolibarr object for manual handoff.
| proALPHA ERP | Dolibarr ERP | Compatibility | |
|---|---|---|---|
| Business Partner (Customer) | Third Party (Customer type)1:1 | Fully supported | |
| Business Partner (Vendor) | Third Party (Supplier type)1:1 | Fully supported | |
| Item (Product Master) | Product1:1 | Fully supported | |
| Bill of Materials (Multi-level) | Product with Bill of Materials sub-products1:many | Fully supported | |
| Chart of Accounts | Accounting accounts (Plan comptable)1:1 | Fully supported | |
| Journal Entry | Accounting transaction (various types)1:1 | Fully supported | |
| Fixed Asset | Asset1:1 | Fully supported | |
| Open AP and AR | Invoice (Supplier or Customer)1:1 | Mapping required | |
| Work Order / Production Order | Project or Manufacturing orderlossy | Fully supported | |
| Warehouse / Inventory | Warehouse and Stock1:1 | Fully supported | |
| Custom Properties / User-Defined Fields | Extra fields (Dolibarr Extrafields)lossy | Fully supported | |
| Documents and Attachments | Linked file storage1:1 | Mapping required |
Gotchas + challenges
Platform-specific issues from each side, plus the pair-specific challenges that don't show up on either platform's page on its own.
proALPHA ERP gotchas
REST API requires paid addon not included in standard license
Historical data formats are inconsistent across long-running instances
Document attachments stored in integrated DMS require separate extraction
Multi-site license scoping may affect what data is accessible for export
Custom fields per module have inconsistent naming across customer instances
Dolibarr ERP gotchas
Foreign key constraint errors on cross-distribution database restore
SQL injection vulnerabilities in version 9.0.1
Custom fields stored as JSON in extraoptions require field-by-field deserialization
Decimal precision and rounding configuration affects price fields
No native iOS/Android app forces reliance on browser
Pair-specific challenges
Migration approach
Discovery and extraction method assessment
We audit the source proALPHA instance across module coverage, license tier (standard vs limited-access), deployment variant (on-prem vs cloud), API access method (REST addon present vs ODBC vs direct DB), custom fields per module, and the historical data scope spanning active fiscal years. We identify whether the REST API is available and, if not, confirm ODBC bridge credentials and database schema access. The discovery output is a written migration scope document that defines extraction method, record counts per object, historical year boundaries, and any module exclusions due to license visibility constraints.
Data profiling and format audit
We extract a representative sample from each proALPHA object (typically 100-500 records per entity) to profile data quality: date format variations, decimal precision inconsistencies, deprecated picklist values, orphaned foreign keys, and records with missing required fields. For historical journal entries, we audit the format changes across version upgrades to identify which transformation rules apply to which date ranges. The profiling output is a data quality report with transformation rules documented per field per object, ready for the migration engineering team to encode into the extract-transform-load pipeline.
Dolibarr environment setup and target schema design
We configure the destination Dolibarr instance: enable the relevant modules (Third Party, Product, Accounting, Asset, Warehouse, BOM, Project, HR depending on scope), create the accounting chart of accounts using the target country's template, set up warehouses per proALPHA location, and configure extrafields for any custom properties discovered in the source. We validate Dolibarr's module dependencies before migration begins (for example, the Asset module requires the Accounting module to be enabled first). The configured Dolibarr environment is validated in a staging environment before any production data import.
Sandbox migration and reconciliation
We run a full migration into a staging copy of the Dolibarr instance using production-like data volume. The customer reconciles record counts per object (Third Parties in, Products in, Accounting entries in, Assets in, Stock in), spot-checks 25-50 records per entity against the proALPHA source for field-level accuracy, and validates that account balances (trial balance from proALPHA vs trial balance from Dolibarr) agree within an agreed tolerance. Any mapping corrections are documented and applied before production migration begins. This step is mandatory because ODBC and direct database extractions require more field-level validation than API-based approaches.
Production migration in dependency order
We run production migration in record-dependency order: Third Parties (Customers and Suppliers), Products (with BOM decomposition), Accounting chart of accounts, Fixed Assets, open AP and AR invoices, warehouse and stock levels, Work Order records (mapped to Projects), and document metadata. Each phase emits a row-count reconciliation report before the next phase begins. Document binary files are transferred in parallel using a secure file transfer mechanism. Custom fields are imported as the final standard-object phase. Historical journal entries are imported last, by fiscal year, with balance verification after each year.
Cutover, validation, and workflow handoff
We freeze proALPHA writes during cutover, run a final delta migration of any records modified during the migration window, then enable Dolibarr as the system of record. We deliver a written inventory of proALPHA workflows, document management rules, and APS scheduling configurations that require rebuild in Dolibarr's low-code Module Builder or an external tool. We support a one-week hypercare window where we resolve any reconciliation issues raised by the customer's team. We do not rebuild proALPHA automations as Dolibarr configurations inside the migration scope; that is a separate engagement.
Platform deep dives
proALPHA ERP
Source
Strengths
Weaknesses
Dolibarr ERP
Destination
Strengths
Weaknesses
Complexity grading
Standard ERP migration. 1 of 8 objects need a mapping; the rest are 1:1.
Overall complexity
Standard migration
Derived from compatibility, mapping clarity, API constraints, and data volume across proALPHA ERP and Dolibarr ERP.
Object compatibility
1 of 8 objects need a mapping; the rest are 1:1.
Field mapping clarity
Field mapping is derived from defaults — final spec confirmed during the sample migration.
Timeline complexity
8-object category — typical timelines run 2–7 days end-to-end.
API constraints
proALPHA ERP: Not publicly documented.
Data volume sensitivity
proALPHA ERP doesn't expose a bulk API — REST + parallelization used for high-volume runs.
Estimator
Rule-based pricing — no per-record fees, no manual quotes. Migrations over 2M records are scoped individually.
Step 1
Pick a category, then your source and destination platforms.
Category
FAQ
Answers to the questions buyers ask most during proALPHA ERP to Dolibarr ERP migration scoping. Not seeing yours? Book a call.
Walk through your proALPHA ERP to Dolibarr ERP migration with a real engineer — 30 minutes, free, written quote within 24 hours.
Book a free 30 minute consultationAdjacent paths
Other ways to leave proALPHA ERP
Other ways to arrive at Dolibarr ERP
Ready when you are
Tell us record counts and timeline. We'll come back with a written quote inside 1 business day — no commitment, no sales pitch.