ERP migration

Migrate from Omni ERP to Dolibarr ERP

Field-level mapping, validation, and rollback between Omni ERP and Dolibarr ERP. We move data and schema; workflows are rebuilt natively in Dolibarr ERP.

Omni ERP logo

Omni ERP

Source

Dolibarr ERP

Destination

Dolibarr ERP logo

Compatibility

83%

10 of 12

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

Complexity

BStandard

Timeline

3-5 weeks

Rollback included Accuracy guarantee Field-level validation

Overview

What this migration involves

Moving from Omni ERP to Dolibarr is a cost-driven migration for SMEs that have outgrown Omni ERP's per-user pricing but do not need its manufacturing module or multi-currency consolidation depth. Omni ERP lacks a documented REST or bulk API, so all data extraction proceeds through CSV exports generated from the product UI. We sequence the export order by dependency: Chart of Accounts first (since journal lines reference account codes), then Customers and Vendors (for third-party lookups), then Inventory items, then Open AP/AR invoices, then historical journal entries. Dolibarr's accounting module handles basic double-entry bookkeeping, bank reconciliation, and VAT declarations, but multi-currency inter-company consolidation and advanced manufacturing (BOMs) have no native equivalent in Dolibarr. We flag these gaps explicitly during scoping and deliver a written inventory of migrated BOM records for the customer to rebuild via a third-party Dolistore extension or custom PHP development. We do not migrate document attachments, custom workflows, or user role configurations as code; these are documented for manual rebuild.

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

Omni ERP logo

Omni ERP

What's pushing teams away

  • The interface is described as dated, creating friction for teams accustomed to modern SaaS UX and slowing adoption during onboarding.
  • Users report that searching within the system is slow and that many features lack intuitive discoverability, increasing training overhead.
  • Processing delays occur intermittently during high-transaction periods, particularly for batch operations like large inventory exports.
  • The expenses module lacks depth compared to dedicated spend-management tools, and the roadmap for enhancements is not publicly communicated.

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 Omni ERP objects map to Dolibarr ERP

Each row shows how a Omni 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.

Omni ERP

Chart of Accounts

maps to

Dolibarr ERP

Accounting - Chart of Accounts

1:1
Fully supported

Omni ERP's Chart of Accounts maps directly to Dolibarr's Accounting module with account codes preserved as-is. We extract the fullcoa export from Omni ERP including segment structure (if multi-dimensional), then map each account code to Dolibarr's pcg_type and pcg_subtype categories. Account references in journal lines are remapped by code at import time; if Dolibarr uses a different chart of accounts numbering convention, we apply the remap during the transform step and flag any orphaned journal lines for manual correction.

Omni ERP

Customers

maps to

Dolibarr ERP

Third Parties - Customers

1:1
Fully supported

Omni ERP Customer records with contact hierarchies, addresses, and payment terms map to Dolibarr ThirdParty records with the customer flag set. We preserve parent-child relationships where the source uses a hierarchy; Dolibarr represents these as separate ThirdParty records with a parent_id link. Payment terms migrate to Dolibarr's payment condition module and are attached to the ThirdParty record. Owner/User assignments from Omni ERP are stored as a custom field on the Dolibarr record since Dolibarr's native user-permission model assigns access at the role level rather than per-record ownership.

Omni ERP

Vendors

maps to

Dolibarr ERP

Third Parties - Suppliers

1:1
Fully supported

Omni ERP Vendor records map to Dolibarr ThirdParty records with the supplier flag set. The same address, contact, and payment term mapping logic applies. Vendor-specific fields like W-9 status or tax registration numbers map to Dolibarr's extf field structure or a custom field group created during schema setup.

Omni ERP

Items (Inventory)

maps to

Dolibarr ERP

Products - Stock

1:1
Mapping required

Omni ERP Items with serial and batch tracking and multi-warehouse costing map to Dolibarr Products with stock management enabled. Serial numbers migrate to Dolibarr's lot/serial tracking if the Dolistore extension is installed; without it, serial-level detail is stored as a custom field note and batch-level lot numbers migrate as Dolibarr lot entries. Multi-warehouse costing from Omni ERP maps to Dolibarr's warehouse-level stock reporting; Dolibarr calculates weighted average cost per warehouse, which may produce small variances from Omni ERP's source costing that we flag for reconciliation. Items without active stock (service items, non-stocked parts) map to Dolibarr Products with the Stock field disabled.

Omni ERP

Bills of Materials

maps to

Dolibarr ERP

Not supported in core Dolibarr

1:1
Mapping required

Omni ERP BOMs with multi-level routing, work center assignments, and production order tracking have no native Dolibarr equivalent. Dolibarr has no built-in manufacturing module; the Dolistore marketplace offers a third-party production extension, but it is not part of the standard GPL distribution. We export the full BOM structure (finished good, component items, quantities, scrap rates, work center assignments) as a structured CSV and deliver it alongside the migration as a written BOM inventory document. The customer's admin rebuilds the BOMs in their chosen production module post-migration.

Omni ERP

Open AP (Vendor Invoices)

maps to

Dolibarr ERP

Supplier Invoices

1:1
Fully supported

Open vendor invoices from Omni ERP map to Dolibarr FactureFournisseur records. We sequence the AP import after the Chart of Accounts and Vendor records so that account code remapping and vendor lookups are satisfied at insert time. Invoice line items referencing inventory items are mapped to Dolibarr Products. Payment status (unpaid, partial) migrates with the balance amount preserved as the remaining due. If Omni ERP stores multi-currency AP, we capture the transaction-date exchange rate and record the original currency amount and converted base amount separately; Dolibarr's multi-currency AP support is basic and may require manual review of any post-migration discrepancies.

Omni ERP

Open AR (Customer Invoices)

maps to

Dolibarr ERP

Customer Invoices

1:1
Fully supported

Open customer invoices from Omni ERP map to Dolibarr Facture records. Customer lookups are resolved against the ThirdParty records imported in the vendor/customer phase. Invoice status (draft, validated, unpaid, paid) migrates with the remaining balance preserved. Multi-currency AR is handled with the same date-specific exchange rate capture as AP. Historical paid invoices (for reporting continuity) are imported as paid invoices rather than open AR to preserve the full revenue history in Dolibarr's reporting.

Omni ERP

Journal Entries (Historical)

maps to

Dolibarr ERP

Accounting - General Ledger Entries

1:1
Mapping required

Historical journal entries from Omni ERP map to Dolibarr Accounting with each debit and credit line as a separate entry row referencing the remapped account code. Multi-currency line items store the original currency amount and base currency converted amount; we capture the transaction-date exchange rate from Omni ERP and apply it at import. Entries with complex multi-currency assignments or inconsistent account references in Omni ERP are flagged in a pre-import validation report for the customer's finance team to resolve before posting. Entries that fall outside Dolibarr's fiscal year open period are held in a draft state pending period configuration.

Omni ERP

Fixed Assets

maps to

Dolibarr ERP

Assets - Fixed Assets

1:1
Mapping required

Omni ERP Fixed Asset records including acquisition cost, accumulated depreciation, depreciation method, and asset category map to Dolibarr Assets. Depreciation schedules are preserved as a series of depreciation entries in Dolibarr's asset depreciation module. If Omni ERP uses a depreciation method (declining balance, sum-of-years digits) that Dolibarr does not natively support, we store the method as a custom field on the asset record and create a manual depreciation schedule to replicate the source amortization curve. Asset category maps to Dolibarr's asset classification structure.

Omni ERP

Departments and Cost Centers

maps to

Dolibarr ERP

Projects - Projects or Custom Fields

lossy
Mapping required

Omni ERP department and cost center hierarchies referenced in journal entries, budgets, and user assignments map to Dolibarr Projects as cost center proxies, or to a custom field group if the customer prefers a dedicated cost center structure. We preserve the full department hierarchy and remap IDs against the target org structure. Circular references in department hierarchies are flagged for manual resolution before import. Projects used solely for cost center tracking in Omni ERP are imported as Projects with the is_teampm flag disabled and the cost tracking fields enabled.

Omni ERP

Users and Roles

maps to

Dolibarr ERP

Users

lossy
Mapping required

Omni ERP user records with role assignments and department affiliations map to Dolibarr User accounts. We map Omni ERP role names to Dolibarr permission groups (Admin, ReadOnly, Standard, etc.). Users whose access scope exceeds Dolibarr's permission model granularity are flagged in the user mapping output with the nearest equivalent Dolibarr permission set. The customer's admin reviews and approves the permission mapping before user records are activated in the production instance.

Omni ERP

Documents and Attachments

maps to

Dolibarr ERP

Not supported

1:1
Not supported

Documents and file attachments stored within Omni ERP's document management module cannot be exported via the documented CSV workflow. We flag all document attachment records during the scoping audit and deliver a file listing with record-level references so that the customer's IT team can execute a parallel file migration through Omni ERP's UI export or direct database access. Dolibarr's document storage is structured differently (file system under /documents by entity type), so a separate file migration engagement is required for any documents that must be accessible from within Dolibarr post-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.

Omni ERP logo

Omni ERP gotchas

High

No publicly documented bulk API endpoint

Medium

BOMs reference Items by code, not by internal ID

Medium

Multi-currency journal entries require date-specific exchange rates

Medium

Document attachment migration is unsupported

Low

Dated UI export tooling with limited field selection

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

  • Dolibarr has no native manufacturing module

    Omni ERP's Bills of Materials, multi-level routing, and production order tracking have no native Dolibarr equivalent. The Dolistore marketplace has third-party production extensions, but they are not part of the standard GPL distribution and require separate licensing. We export the full BOM structure as a structured CSV and deliver it as a written inventory document for the customer's admin to rebuild in their chosen extension. If manufacturing is a core business function, migrating to Dolibarr requires accepting either a third-party module dependency or a manual rebuild of BOM structures post-migration.

  • Omni ERP lacks a bulk API; CSV exports require manual sequencing

    All data extraction from Omni ERP must use CSV exports generated from the product UI. There is no published REST or bulk API. We automate the UI export workflow and parse the resulting CSVs, but large datasets require multiple sequential exports chunked by date range or record type. The export order matters because downstream imports depend on upstream record IDs: Chart of Accounts must export before journal entries, Customers and Vendors before AP/AR invoices. We create a dependency-ordered export checklist during scoping that the customer executes to produce the migration dataset. Budget an additional two to four days for export sequencing and field selection.

  • Multi-currency journal entries require date-specific exchange rate capture

    Omni ERP stores multi-currency journal entries with the transaction-date exchange rate, not a standard rate table. Dolibarr's multi-currency accounting is basic and does not replicate Omni ERP's inter-company consolidation or advanced multi-currency posting logic. We capture the rate at export time and apply it during import, but any post-migration adjustments to historical exchange rates require manual journal entries in Dolibarr. Entries with inconsistent currency assignments in Omni ERP (where the posted rate differs from the system rate) are flagged in a pre-import validation report.

  • Document attachments cannot be exported via CSV

    Binary documents stored in Omni ERP's attachment module are not accessible through the CSV export workflow. Teams with material document volumes (invoices with embedded PDFs, purchase orders with supporting files) must plan for a separate file migration using Omni ERP's UI-based download or a direct database export if available. Dolibarr's document storage is organized by entity type in the file system, so the file migration requires a mapping document that ties each source file to its target Dolibarr entity and document type.

  • Dolibarr's PHP/MySQL stack requires hosting configuration before import

    Dolibarr runs on PHP and MySQL/MariaDB, and common migration errors include database character set mismatches (UTF-8 vs Latin-1), PHP version incompatibilities with newer Dolibarr versions, and file permission errors that prevent Dolibarr from writing to the /documents directory during invoice validation. We validate the target Dolibarr installation (PHP version, MySQL/MariaDB version, character set, upload limits) before beginning the import phase. We also document the required PHP settings (memory_limit, max_execution_time, upload_max_filesize) for the customer's hosting provider.

Migration approach

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

  1. Scoping and export sequencing

    We audit Omni ERP across all active modules (financials, inventory, manufacturing, multi-branch) and produce an export sequencing checklist ordered by dependency. We identify which modules are active, which are unused (so they do not inflate Dolibarr's initial scope), and which require special handling (multi-currency, serial/batch, BOMs). We also document custom fields applied to the Item and Customer objects by reviewing Omni ERP's export field selection UI, since these must be explicitly added to each CSV before generation. The scoping output is a written migration plan with record counts per object, a dependency map, and a list of gap objects (BOMs, document attachments) that require separate treatment.

  2. Omni ERP CSV export coordination

    We guide the customer's Omni ERP admin through the export sequence: Chart of Accounts first, then Customers and Vendors, then Items, then Open AP and AR invoices, then historical journal entries, then Fixed Assets, then Departments and Cost Centers. Each export is generated with all available fields selected including custom fields. We parse the resulting CSVs for data quality issues (missing required fields, orphaned foreign keys, inconsistent account references) and produce a data quality report before the first import attempt. Large datasets are chunked by date range or record type to avoid export timeouts.

  3. Dolibarr schema setup and configuration

    We configure Dolibarr's core modules (ThirdParty, Product, Facture, FactureFournisseur, Accounting, Asset, Project) based on the migration scope. This includes activating the multi-warehouse stock module, setting up account categories for chart of accounts mapping, configuring VAT rules and payment terms, and creating custom fields for any Omni ERP properties that have no native Dolibarr equivalent (serial number history, original lifecycle cost, department assignment). We verify the PHP version, MySQL character set (UTF-8 required), and file permissions before importing any data.

  4. Sandbox import and reconciliation

    We run a full import into a test Dolibarr instance using the exported CSV data. We reconcile record counts against the source export totals for each object, spot-check 25-50 random records for field-level accuracy, and verify that account code remapping produced no orphaned journal lines. The customer reviews the sandbox and signs off before production migration begins. Any field mapping corrections, custom field additions, or account code adjustments are applied to the production configuration.

  5. Production migration in dependency order

    We run production import in record dependency order: Chart of Accounts first, then ThirdParty records (Customers and Suppliers), then Products with stock tracking, then Fixed Assets, then Open AP and AR invoices, then historical journal entries, then Projects and cost center assignments, then user records with permission mapping. Each phase emits a row-count reconciliation report. Multi-currency entries are imported with the transaction-date exchange rate captured from Omni ERP. Post-import, we run Dolibarr's built-in account validation checks (Compte de resultat and Bilan report generation) to confirm the accounting balance.

  6. Cutover, gap inventory, and BOM documentation

    We freeze Omni ERP writes during cutover, run a final delta migration of any records modified during the migration window, then hand off Dolibarr as the system of record. We deliver the BOM inventory document listing all Omni ERP Bills of Materials with component items, quantities, and routing for the customer's admin to rebuild in their chosen production extension. We deliver the document attachment listing for the customer's IT team to execute the parallel file migration. We provide a one-week hypercare window for reconciliation issues. We do not rebuild Omni ERP workflows or custom automations in Dolibarr; these are documented for manual rebuild or third-party Dolistore module selection.

Platform deep dives

Context on both ends of the pair

Omni ERP logo

Omni ERP

Source

Strengths

  • Serial and batch inventory tracking with multi-warehouse costing built into the core Item model.
  • Integrated BOM and manufacturing module that shares the same database as financial modules.
  • Multi-branch support allowing centralized management of geographically distributed operations.
  • Multi-currency and multi-entity accounting for regional expansion without a separate consolidation tool.
  • Integrated reporting across financial, inventory, and manufacturing domains.

Weaknesses

  • The user interface is widely described as dated compared to modern SaaS ERP aesthetics.
  • Search performance degrades with large datasets, particularly during bulk export operations.
  • The feature set is narrower than Tier-1 ERPs, requiring integration with third-party tools for advanced HR or CRM functionality.
  • No publicly documented bulk API endpoint, limiting automated migration options to CSV-based exports.
  • Roadmap communication is limited, making it difficult for customers to plan around upcoming feature additions or deprecations.
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 Omni ERP and Dolibarr ERP.

B

Overall complexity

Standard migration

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

  • Object compatibility

    A

    All 8 core objects map 1:1 between Omni 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

    Omni ERP: Not publicly documented.

  • Data volume sensitivity

    B

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

Estimator

Estimate your Omni 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 Omni ERP to Dolibarr ERP data migrations

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

Can't find your answer?

Walk through your Omni ERP to Dolibarr ERP migration with a real engineer — 30 minutes, free, written quote within 24 hours.

Book a free 30 minute consultation

Straightforward migrations under 10,000 account codes, 5,000 inventory items, and no multi-currency journal history complete in three to five weeks. Migrations with large journal entry histories, fixed asset depreciation schedules, multi-warehouse inventory costing, or open AP/AR invoices spanning multiple currencies extend to six to ten weeks because of the manual CSV export coordination on the Omni ERP side and the exchange rate capture and reconciliation work on the Dolibarr side. The absence of a manufacturing module in Dolibarr also adds time if BOM documentation requires manual cataloguing.

Adjacent paths

Related migrations to explore

Ready when you are

Move from Omni 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