ERP migration
Field-level mapping, validation, and rollback between Orion ERP and Dolibarr ERP. We move data and schema; workflows are rebuilt natively in Dolibarr ERP.
Orion ERP
Source
Dolibarr ERP
Destination
Compatibility
10 of 13
objects map 1:1 between Orion ERP and Dolibarr ERP.
Complexity
BStandard
Timeline
4-6 weeks
Overview
Migrating from Orion ERP to Dolibarr is a structural shift from a commercial mid-market ERP with no public bulk API to a free, modular open-source platform that runs on PHP and MySQL or PostgreSQL. Orion exposes no REST or SOAP endpoint, so we rely on the built-in Data Output report engine to extract each object class field by field. The absence of a bulk API makes the extraction phase slower and more manual than cloud-to-cloud migrations, and we compensate by pre-designing custom report templates during scoping. Dolibarr organizes data into a module-activated model: third parties, commercial, products/stocks, accounting, HR, and projects are all optional modules that must be enabled before their corresponding records can be imported. We activate the required Dolibarr modules, configure the chart of accounts structure, and inject opening balances for AP and AR as journal entries rather than new transactions to prevent double-posting. Workflows, custom report definitions, and the document management layer in Orion do not migrate; we deliver a written inventory of automations and document-attachment manifests for the customer's admin to rebuild or re-attach post cutover.
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 Orion 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.
Orion ERP
Chart of Accounts
Dolibarr ERP
Accounting module (Account Plan)
1:1Orion stores the COA as a core master-data structure with multi-segment support. We extract account code, name, type, and currency settings via the financial report export. In Dolibarr, the accounting module must be activated before importing. We create each Orion account as a Dolibarr bank account record or general ledger account under the accounting menu, preserving the account code as the primary identifier. Multi-segment COA splits into parent and child account codes per Dolibarr's hierarchical account plan structure. Currency and type metadata map to Dolibarr account attributes.
Orion ERP
Customer / Account
Dolibarr ERP
Third Party (customer mode)
1:1Orion customer master records include contact details, billing address, payment terms, and credit limits. We extract via the standard customer listing report. Dolibarr uses a unified Third Party object with a Mode flag (Customer, Supplier, or Both). We import Orion customers as Dolibarr Third Parties with Customer mode enabled, mapping billing address to Dolibarr's address fields, payment terms to the payment condition dictionary, and credit limits to the risk management fields. Tax ID format validation is applied per country during transform.
Orion ERP
Vendor
Dolibarr ERP
Third Party (supplier mode)
1:1Orion vendor master includes name, tax ID, payment terms, and bank details. We extract through the vendor report export. In Dolibarr, vendors import as Third Parties with Supplier mode enabled. We map Orion vendor payment terms to Dolibarr's supplier payment condition dictionary, and tax registration numbers to the specific VAT/SIRET/SIREN extra fields Dolibarr supports for EU and international jurisdictions.
Orion ERP
GL Transactions
Dolibarr ERP
Accounting > Financial Accounts (Journal Entries)
1:1Orion GL entries include header metadata (date, journal number, description) and line items (account, debit, credit). We extract full GL history via the financial report export and import as journal entries into Dolibarr's accounting module. Each Orion journal type maps to a corresponding Dolibarr journal (sales, purchases, bank, miscellaneous). Debit and credit columns map directly to Dolibarr debit and credit fields. Historical GL migration requires the accounting module to be active and the fiscal year to be open in Dolibarr before entries are posted.
Orion ERP
Accounts Payable (Open/Bills)
Dolibarr ERP
Supplier Invoice (Opening Balance treatment)
lossyOrion stores open AP as live financial records rather than separate aging snapshots. We extract open invoices with vendor reference, invoice number, amount due, and due date as a distinct scope item. In Dolibarr, open AP injects as opening-balance supplier invoices or miscellaneous journal entries with an opening-balance account rather than new invoices to avoid double-posting during the go-live period. The customer's AP team reviews the opening-balance invoice list before posting.
Orion ERP
Accounts Receivable (Open/Invoices)
Dolibarr ERP
Customer Invoice (Opening Balance treatment)
lossyOrion open AR records include customer reference, invoice number, amount receivable, and due date. We extract open AR as a distinct scope item separate from historical AR. In Dolibarr, open AR maps to customer invoice records with opening-balance treatment via a dedicated AR opening-balance account, or as draft invoices that the customer's AR team validates before posting. Due dates and aging buckets are preserved as invoice due dates or migrated to Dolibarr's payment schedule feature.
Orion ERP
Inventory Items
Dolibarr ERP
Products > Stock
1:1Orion item master records include SKU, description, unit of measure, cost, and warehouse location. We extract via the inventory management report. Dolibarr's product module must be activated, and we import items as products with stock tracking enabled. Orion SKU maps to Dolibarr's ref (reference) field; description maps to the product label; unit of measure maps to the unit dictionary. Current stock quantities per warehouse import into Dolibarr stock warehouses. Note that Dolibarr's stock management is designed for simple setups and does not support advanced manufacturing or multi-level BOM tracking.
Orion ERP
Purchase Orders
Dolibarr ERP
Supplier Order
1:1Orion PO headers and lines are available through the procurement module report export. We extract PO status, vendor assignment, and line-item quantities. Open versus closed PO status is preserved: open POs import into Dolibarr as draft or validated supplier orders depending on their Orion status, and closed POs import as historical records for audit. Line items map to Dolibarr supplier order lines with product reference, quantity, and unit price resolved against the imported product catalog.
Orion ERP
Sales Orders
Dolibarr ERP
Customer Order
1:1Orion sales order records include customer reference, product lines, pricing, and order status. We map order headers and lines separately and flag fulfilled versus pending lines to align with Dolibarr's order statuses (Draft, Validated, Shipped, Closed). The customer reference from Orion becomes Dolibarr's ref_customer field. Pricing migrates with the same currency and discount treatment as the source. Pending orders import as draft or validated customer orders; fulfilled orders import as closed records for historical reporting.
Orion ERP
Employees
Dolibarr ERP
HR module (Users or Contacts)
1:1Orion employee records include name, department, job title, compensation, and employment dates. We extract through the HR management module report. Dolibarr's HR module must be enabled. Employee records map to Dolibarr users if the employee needs system access, or to contacts linked to a dedicated employee third-party structure if Dolibarr is used primarily for HR record-keeping without full system login. Effective-dated compensation history requires us to sequence records chronologically and inject as Dolibarr HR salary records if the HR module includes salary tracking.
Orion ERP
Custom Fields (Orion)
Dolibarr ERP
Extra Fields (Dolibarr)
lossyOrion allows custom fields on master and transaction records with data types that vary by edition and customer configuration. We detect all custom properties during the scoping export. In Dolibarr, custom fields are implemented via Setup > Dictionaries > Extra Fields on the target object. We pre-create the Dolibarr extra field schema before migration, mapping Orion data types to Dolibarr field types (text, varchar, int, float, date, select, checkbox). Custom field values migrate as part of the standard record import using Dolibarr's extrafields column naming convention (extrafields_keyname).
Orion ERP
Attachments / Documents
Dolibarr ERP
Not Migrated
1:1Binary attachments and uploaded documents stored within Orion's document management layer are not accessible via the standard report export. We do not migrate attachments as part of the standard migration scope. We log every record with an associated attachment and deliver a manifest to the customer's admin team identifying which records had documents in Orion. The customer coordinates a separate export of the document management directory, and we can advise on the target Dolibarr document root structure (dolibarr_main_data_root) for manual re-association post migration.
Orion ERP
BOM / Work Orders (Manufacturing Cloud)
Dolibarr ERP
Not Supported
1:1The Orion Manufacturing Cloud edition includes bill of materials and work order objects not present in Dolibarr. Dolibarr has no dedicated manufacturing module, no BOM capability, and no production order tracking. If the customer uses Orion Manufacturing Cloud with BOM data, we scope this as a write-off and deliver a written inventory of BOM records and work order statuses for the customer to evaluate Dolibarr alternatives (Odoo Manufacturing, ERPNext) or handle in a separate manufacturing-specific migration.
| Orion ERP | Dolibarr ERP | Compatibility | |
|---|---|---|---|
| Chart of Accounts | Accounting module (Account Plan)1:1 | Fully supported | |
| Customer / Account | Third Party (customer mode)1:1 | Fully supported | |
| Vendor | Third Party (supplier mode)1:1 | Fully supported | |
| GL Transactions | Accounting > Financial Accounts (Journal Entries)1:1 | Fully supported | |
| Accounts Payable (Open/Bills) | Supplier Invoice (Opening Balance treatment)lossy | Mapping required | |
| Accounts Receivable (Open/Invoices) | Customer Invoice (Opening Balance treatment)lossy | Mapping required | |
| Inventory Items | Products > Stock1:1 | Fully supported | |
| Purchase Orders | Supplier Order1:1 | Fully supported | |
| Sales Orders | Customer Order1:1 | Fully supported | |
| Employees | HR module (Users or Contacts)1:1 | Fully supported | |
| Custom Fields (Orion) | Extra Fields (Dolibarr)lossy | Fully supported | |
| Attachments / Documents | Not Migrated1:1 | Not supported | |
| BOM / Work Orders (Manufacturing Cloud) | Not Supported1:1 | Fully supported |
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.
Orion ERP gotchas
No public bulk API — migration is report-driven
Multiple cloud editions with divergent schemas
Open AP/AR opening-balance treatment requires explicit scoping
Attachment and document blobs are inaccessible via standard export
Ownership change from 3i Infotech to Azentio creates version ambiguity
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 edition confirmation
We audit the source Orion ERP instance to confirm the cloud edition (Distribution, Contracting, Financial, or Manufacturing), active modules, custom field definitions, and open versus closed transaction history. We extract a full list of objects visible in the Data Output report engine and identify any objects not accessible via standard export that require direct DB or IT-assisted extraction. We pair this with a Dolibarr hosting decision: self-hosted (customer infrastructure, full control, free) or cloud-hosted via DoliCloud (€9.00/month, managed updates). The discovery output is a written migration scope with object inventory, extraction method per object, and Dolibarr module activation plan.
Dolibarr environment setup and module activation
We set up the target Dolibarr instance on the customer's chosen hosting (self-hosted LAMP/LEMP stack or DoliCloud) and activate the required modules based on the migration scope: third party module for customers and vendors, commercial module for orders and proposals, product module for inventory, accounting module for GL and chart of accounts, HR module for employees, and project module if project-level billing is in scope. We configure multi-currency and multi-company settings, the chart of accounts structure (matching Orion segment count), and the payment term dictionary before any data is staged. Dolibarr's module activation is reversible and does not commit the customer to a module until records are posted.
Custom report template design and extraction staging
Because Orion has no bulk API, we design a set of custom Data Output report templates that cover the full field set for each migration object (Chart of Accounts, Customers, Vendors, GL Transactions, AP, AR, Inventory, POs, SOs, Employees). We run each report template in Orion, export to Excel/CSV, and stage the raw files in a migration workbench. We validate record counts per object and flag any records that appear truncated or missing from the export. Any objects not visible in the report engine are escalated to the customer's IT team for direct database extraction. This step is the most manual in the migration and drives the longest timeline risk.
Data cleansing and transform
We cleanse the extracted data: deduplication of customer and vendor records, validation of tax ID formats per country, resolution of Orion owner references to Dolibarr users (by email match or flagged for admin provisioning), and application of the open-balance treatment for AP and AR records. We map Orion custom field values into Dolibarr extra fields using the extrafields_keyname column naming convention. We apply currency rounding, date format normalization, and address parsing for multi-line fields. The transform phase produces a set of Dolibarr-ready CSV files per object, validated against Dolibarr's field type constraints before import.
Staged import in dependency order
We import records into Dolibarr in strict dependency order: accounting chart of accounts first, then third parties (customers and vendors simultaneously), then products (inventory items), then accounting opening-balance journals for AP and AR, then purchase orders, then sales orders, then GL historical transactions, then employees. Each phase emits a row-count reconciliation report. Dolibarr's built-in import tool or direct SQL injection handles the load; we prefer the import tool for standard objects to preserve Dolibarr's internal consistency checks. For large GL histories, we use batched inserts with commit intervals to avoid PHP memory limits on the Dolibarr server.
Cutover, validation, and automation handoff
We freeze Orion 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 perform a post-migration reconciliation comparing record counts and a spot-check of 25-50 random records against the Orion source. We deliver the automation and workflow inventory document listing every Orion workflow or automated process that requires manual rebuild in Dolibarr (via Dolibarr's triggers and hooks PHP interface), and the document attachment manifest for the customer's IT team to re-associate files. We support a one-week hypercare window for reconciliation issues. We do not rebuild Orion workflows as Dolibarr triggers inside the migration scope.
Platform deep dives
Orion ERP
Source
Strengths
Weaknesses
Dolibarr ERP
Destination
Strengths
Weaknesses
Complexity grading
Standard ERP migration. All 8 core objects map 1:1 between Orion ERP and Dolibarr ERP.
Overall complexity
Standard migration
Derived from compatibility, mapping clarity, API constraints, and data volume across Orion ERP and Dolibarr ERP.
Object compatibility
All 8 core objects map 1:1 between Orion ERP and Dolibarr ERP.
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
Orion ERP: Not publicly documented.
Data volume sensitivity
Orion 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 Orion ERP to Dolibarr ERP migration scoping. Not seeing yours? Book a call.
Walk through your Orion 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 Orion 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.