ERP migration

Migrate from Orion ERP to Dolibarr ERP

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 logo

Orion ERP

Source

Dolibarr ERP

Destination

Dolibarr ERP logo

Compatibility

77%

10 of 13

objects map 1:1 between Orion ERP and Dolibarr ERP.

Complexity

BStandard

Timeline

4-6 weeks

Rollback included Accuracy guarantee Field-level validation

Overview

What this migration involves

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.

Field-level fidelity

Every standard and custom field arrives verified.

Schema-aware mapping

AI proposes the map; you confirm before any record moves.

Relationships preserved

Parent–child, lookups, and ownership stay linked.

Full activity history

Calls, emails, meetings — with original timestamps.

Attachments & notes

Documents, uploads, and inline notes move with the record.

Why teams make this switch

Two sides of the same decision

Leaving

Orion ERP logo

Orion ERP

What's pushing teams away

  • Frequent auto-updates arrive as disruptive pop-ups and can interrupt active workflows, frustrating users mid-task according to G2 reviews of Azentio ERP.
  • Limited visibility into upgrade schedules — updates are not pre-notified in advance, forcing users to adapt without preparation time.
  • Small review footprint (4 verified PeerSpot reviews, sparse G2/Capterra presence) makes independent due diligence difficult for prospective buyers.
  • Product was sold from 3i Infotech to Azentio in December 2020, raising concerns among some users about continuity of roadmap and support priorities.

Choosing

Dolibarr ERP logo

Dolibarr ERP

What's pulling them in

  • Free open-source core with no per-user license fee makes it the lowest-cost entry point for small teams needing ERP and CRM in one package.
  • Self-hosted deployment gives full data ownership and eliminates vendor lock-in, especially attractive to businesses with compliance requirements.
  • Modular architecture means teams enable only the features they use, keeping the interface uncluttered and reducing learning curve.
  • Fast installation with no technical knowledge required — one reviewer set up multiple businesses in minutes using their own hosting.
  • Active community forum and marketplace of third-party add-ons provide support and extension options without mandatory subscription costs.

Object mapping

How Orion ERP objects map to Dolibarr ERP

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

maps to

Dolibarr ERP

Accounting module (Account Plan)

1:1
Fully supported

Orion 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

maps to

Dolibarr ERP

Third Party (customer mode)

1:1
Fully supported

Orion 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

maps to

Dolibarr ERP

Third Party (supplier mode)

1:1
Fully supported

Orion 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

maps to

Dolibarr ERP

Accounting > Financial Accounts (Journal Entries)

1:1
Fully supported

Orion 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)

maps to

Dolibarr ERP

Supplier Invoice (Opening Balance treatment)

lossy
Mapping required

Orion 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)

maps to

Dolibarr ERP

Customer Invoice (Opening Balance treatment)

lossy
Mapping required

Orion 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

maps to

Dolibarr ERP

Products > Stock

1:1
Fully supported

Orion 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

maps to

Dolibarr ERP

Supplier Order

1:1
Fully supported

Orion 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

maps to

Dolibarr ERP

Customer Order

1:1
Fully supported

Orion 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

maps to

Dolibarr ERP

HR module (Users or Contacts)

1:1
Fully supported

Orion 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)

maps to

Dolibarr ERP

Extra Fields (Dolibarr)

lossy
Fully supported

Orion 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

maps to

Dolibarr ERP

Not Migrated

1:1
Not supported

Binary 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)

maps to

Dolibarr ERP

Not Supported

1:1
Fully supported

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

Gotchas + challenges

What specifically takes care here

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 logo

Orion ERP gotchas

High

No public bulk API — migration is report-driven

High

Multiple cloud editions with divergent schemas

Medium

Open AP/AR opening-balance treatment requires explicit scoping

Medium

Attachment and document blobs are inaccessible via standard export

Low

Ownership change from 3i Infotech to Azentio creates version ambiguity

Dolibarr ERP logo

Dolibarr ERP gotchas

High

Foreign key constraint errors on cross-distribution database restore

High

SQL injection vulnerabilities in version 9.0.1

Medium

Custom fields stored as JSON in extraoptions require field-by-field deserialization

Medium

Decimal precision and rounding configuration affects price fields

Low

No native iOS/Android app forces reliance on browser

Pair-specific challenges

  • No public bulk API on Orion requires report-engine extraction

    Orion ERP exposes no documented REST or SOAP API for bulk record extraction. All migration sourcing relies on the built-in Data Output report feature, which lets users select specific fields and export to Excel, or use a full-report Export button. This means we cannot run automated incremental syncs or high-volume batch pulls programmatically. We compensate by designing custom report templates during scoping that cover the full object schema, then running the export and staging it for transform-and-load. Any objects not visible in the standard reports require manual extraction or direct DB access coordinated with the customer's IT team. This is the primary risk factor in the migration timeline.

  • Orion multiple cloud editions have divergent schemas

    Orion ships in four cloud editions — Distribution, Contracting, Financial, and Manufacturing — and the same object (e.g., a purchase order or item master) may have different field sets or module归属 across editions. The Manufacturing Cloud edition adds BOM and work-order objects not present in the Distribution edition. We identify the customer's exact edition during scoping and build edition-specific extraction templates. Mixing up editions during scoping leads to missing fields in the destination and a partial data load that requires re-extraction from Orion before any correction.

  • Open AP and AR opening-balance treatment requires explicit scoping

    Orion stores open AP and AR as live financial records rather than separate aging snapshots. When migrating to a new ERP, open payables and receivables must be explicitly flagged as opening balances in the destination to prevent double-posting when the customer's accounting team records actual payments and receipts after go-live. We extract open AP and AR as distinct migration scope items, map due dates and amounts, and inject them as opening-balance journal entries or draft invoices in Dolibarr rather than new transactions. The customer's CFO or controller reviews and approves the opening-balance treatment before posting.

  • Dolibarr document directory requires manual transfer

    Orion document management layer binary blobs are not accessible via standard export. In Dolibarr, documents are stored on the filesystem under the dolibarr_main_data_root directory, not in the database. Migrating documents requires a separate manual step: the customer exports the document directory from Orion (coordinating with their IT team for direct filesystem or DB blob access), and we provide a mapping guide for re-associating files to the correct Dolibarr records by filename convention or record ID. We log every attachment-associated record so the customer has a complete manifest of what needs manual handling.

  • Manufacturing Cloud BOM and work orders have no Dolibarr equivalent

    If the customer runs Orion Manufacturing Cloud with bills of materials and work order data, this cannot migrate to standard Dolibarr. Dolibarr has no BOM module, no production order tracking, and no manufacturing scheduling. We scope BOM and work order data as a write-off and deliver a written inventory of all manufacturing records so the customer's operations team can evaluate alternatives (Odoo Manufacturing, ERPNext Production) or maintain a legacy spreadsheet for reference. This is a material gap that must be disclosed and agreed upon during discovery.

Migration approach

Six steps for a successful Orion ERP to Dolibarr ERP data migration

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

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

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

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

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

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

Context on both ends of the pair

Orion ERP logo

Orion ERP

Source

Strengths

  • Caters to regulated industries including BFSI with financial management depth across multi-currency and multi-entity deployments.
  • Multiple cloud editions allow vertically aligned implementations rather than monolithic ERP installs.
  • Broad geographic coverage with 800+ customers in 50 countries and Arabic, English, Thai language support.
  • Integrated analytics and dashboard layer reduces need for separate BI tooling for standard reporting needs.
  • Strong financial management lineage from 3i Infotech's banking and enterprise software history.

Weaknesses

  • Sparse public review presence (4 PeerSpot reviews, minimal G2/Capterra footprint) limits independent evaluation of real-world user experience.
  • No publicly documented bulk API — migrations rely entirely on the built-in report export engine which is manual and field-limited.
  • Ownership transition from 3i Infotech to Azentio creates uncertainty about product roadmap, upgrade cadence, and long-term support commitments.
  • Auto-update behavior is disruptive and not pre-scheduled, creating workflow interruption risks during active use.
Dolibarr ERP logo

Dolibarr ERP

Destination

Strengths

  • Free core software with AGPL license and no per-user mandatory fee for self-hosted deployments.
  • Modular architecture lets teams activate only needed features, keeping the interface focused and the database lean.
  • Self-hosted option provides full data sovereignty and avoids recurring SaaS subscription costs.
  • Built-in CSV/Excel import and export wizard with saved profiles simplifies recurring data operations.
  • Low-code Module Builder allows functional extensions without writing PHP code.

Weaknesses

  • No native documented REST API for programmatic bulk operations — all migrations depend on the import/export wizard or direct database access.
  • Reporting and analytics are weak without paid add-ons, and built-in charts are limited compared to modern SaaS platforms.
  • UI design is described as dated by multiple reviewers, with infrequent visual updates to the default theme.
  • Community-only support for self-hosted deployments means no SLA or guaranteed response time for issues.
  • Security vulnerabilities (CVE-2024-5314, CVE-2024-5315) in version 9.0.1 with no immediate patch reported.

Complexity grading

How hard is this migration?

Standard ERP migration. All 8 core objects map 1:1 between Orion ERP and Dolibarr ERP.

B

Overall complexity

Standard migration

Derived from compatibility, mapping clarity, API constraints, and data volume across Orion ERP and Dolibarr ERP.

  • Object compatibility

    A

    All 8 core objects map 1:1 between Orion ERP and Dolibarr ERP.

  • Field mapping clarity

    C

    Field mapping is derived from defaults — final spec confirmed during the sample migration.

  • Timeline complexity

    B

    8-object category — typical timelines run 2–7 days end-to-end.

  • API constraints

    B

    Orion ERP: Not publicly documented.

  • Data volume sensitivity

    B

    Orion ERP doesn't expose a bulk API — REST + parallelization used for high-volume runs.

Estimator

Estimate your Orion ERP to Dolibarr ERP migration cost

Rule-based pricing — no per-record fees, no manual quotes. Migrations over 2M records are scoped individually.

Step 1

What are you migrating?

Pick a category, then your source and destination platforms.

Category

FAQ

Frequently asked questions about Orion ERP to Dolibarr ERP data migrations

Answers to the questions buyers ask most during Orion ERP to Dolibarr ERP migration scoping. Not seeing yours? Book a call.

Can't find your answer?

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 consultation

Most migrations land between four and six weeks for accounts with fewer than 15,000 customers, 5,000 vendors, 50,000 GL transactions, and no Manufacturing Cloud edition data. Migrations with multi-entity chart of accounts, large open AP and AR aging buckets, multi-warehouse inventory, or Manufacturing edition BOM data move to eight to twelve weeks because of custom report template development, schema divergence across Orion editions, and the manual extraction coordination required with the customer's IT team.

Adjacent paths

Related migrations to explore

Ready when you are

Move from Orion ERP.
Land in Dolibarr ERP, intact.

Tell us record counts and timeline. We'll come back with a written quote inside 1 business day — no commitment, no sales pitch.

Accuracy guarantee Rollback included Quote in 1 business day