ERP migration

Migrate from Intact iQ to Dolibarr ERP

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

Intact iQ logo

Intact iQ

Source

Dolibarr ERP

Destination

Dolibarr ERP logo

Compatibility

75%

9 of 12

objects map 1:1 between Intact iQ and Dolibarr ERP.

Complexity

BStandard

Timeline

3-5 weeks

Rollback included Accuracy guarantee Field-level validation

Overview

What this migration involves

Moving from Intact iQ to Dolibarr is a migration from a UK and Irish distribution-focused ERP with no public REST API to an open-source modular ERP that relies on CSV-based imports. Intact iQ requires each data object to be individually defined as an API Definition within the Company Tab before programmatic extraction is possible; if these definitions have not been created, we fall back to database-level extraction which requires elevated access. Dolibarr uses a Third Party object for both customers and suppliers, and its CSV import workflow has a documented bug where product selling prices are silently corrupted after import under certain conditions. We identify and pre-validate all custom fields, multi-branch setups, and open AP/AR balances from Intact iQ during scoping, map them to Dolibarr's Third Party, Product, Order, and Accounting modules, and apply workaround logic to prevent Dolibarr's price-shift bug from affecting migrated records. Workflow automation rules, document attachments, and application-layer configurations do not migrate; we deliver a written rule-rebuild specification for the destination.

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

Intact iQ logo

Intact iQ

What's pushing teams away

  • Customer service response times frustrate users — enquiries can take weeks to resolve, creating bottlenecks during critical periods like month-end or system upgrades.
  • Performance degrades noticeably when the system handles large datasets such as 10,000+ customers with multiple properties and address records, forcing users to export to Excel to find information.
  • Post-implementation support is described as poor by some customers, with implementation teams reportedly lacking product knowledge and delivering reports that do not match demo capabilities.
  • System updates introduce glitches that disrupt daily operations, making users apprehensive about applying new releases.
  • Filtering and search within the ERP screens is insufficient for complex queries, forcing power users to build manual exports to perform analysis.

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

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

Intact iQ

Customer

maps to

Dolibarr ERP

Third Party (customer type)

1:1
Fully supported

Intact iQ Customer records (with addresses, price lists, credit limits, and account statuses) map to Dolibarr Third Party records with the Customer type enabled. The Intact iQ customer account code becomes the ref (reference) field in Dolibarr. We resolve multiple customer addresses by creating Dolibarr address records linked to the same Third Party, using the address type field to differentiate. Credit limits migrate as a custom field or into the dedicated bank and credit management module if enabled in Dolibarr.

Intact iQ

Supplier

maps to

Dolibarr ERP

Third Party (supplier type)

1:1
Fully supported

Intact iQ Supplier records (with contact details, payment terms, rebate agreements, and procurement history) map to Dolibarr Third Party records with the Supplier type enabled. Supplier payment terms migrate to the Payment Terms module in Dolibarr if that module is active. Rebate agreements require manual reconfiguration in Dolibarr's supplier pricing rules post-migration; we document the original rebate structure in the migration specification.

Intact iQ

Contact

maps to

Dolibarr ERP

Contact (linked to Third Party)

1:1
Fully supported

Intact iQ Contact records linked to Customers and Suppliers (holding roles, phone numbers, and email addresses) map to Dolibarr Contact records linked to the corresponding Third Party. The contact's role in Intact iQ maps to the Civility and Positon/Job fields in Dolibarr. We preserve the association back to the parent Customer or Supplier via Dolibarr's contact link table.

Intact iQ

Stock Item

maps to

Dolibarr ERP

Product

1:1
Fully supported

Intact iQ Stock Items carry complex relationships: BOM structures, variant codes, reorder levels, and ABC categories. We map Stock Item to Dolibarr Product with type=product for stocked items and type=service for non-stocked. Intact iQ BOM structures do not have a direct Dolibarr equivalent without the Manufacturing module; if that module is enabled, we map BOM to Dolibarr's MO (Manufacturing Order) structures. Variant codes map to Dolibarr product variants if the Variants module is active. ABC category assignments migrate as a custom field.

Intact iQ

Sales Order

maps to

Dolibarr ERP

Order (customer order)

1:1
Fully supported

Open and historical sales orders from Intact iQ map to Dolibarr ThirdPartyModule Order records. We preserve order line items, pricing, and discount structures. Intact iQ order statuses (draft, confirmed, dispatched, invoiced, closed) map to Dolibarr ORDER_CLASSIFIED_* constants. Historical orders migrate as closed records; open orders migrate with their current status so that pending fulfilment can continue in Dolibarr. Dolibarr's price migration bug (GitHub #15770) is mitigated by validating that migrated selling prices match the source total after import.

Intact iQ

Purchase Order

maps to

Dolibarr ERP

Order (supplier order)

1:1
Fully supported

Intact iQ Purchase Order records include supplier references, expected delivery dates, and line-level item assignments. They map to Dolibarr CommandesFournisseur (Supplier Order) records. Expected delivery dates migrate as the date_livraison field. Line items map to the OrderLine table with Product references resolved via SKU lookup. Closed purchase orders migrate as historical records; open POs migrate as active records requiring goods receipt in Dolibarr.

Intact iQ

GL Account

maps to

Dolibarr ERP

Account (Accounting module)

1:1
Fully supported

Chart of Accounts records carry account codes, types, and cost-centre assignments. Intact iQ's account code structure varies between configurations, so we validate the destination chart before mapping. Dolibarr's Accounting module must be enabled. If the customer uses multi-company or multi-branch accounting in Intact iQ, we map each branch's chart to a Dolibarr journal or sub-account structure and flag any accounts that require manual cost-centre configuration in Dolibarr's auxiliary accounting.

Intact iQ

Open AP/AR Balances

maps to

Dolibarr ERP

Invoice and Credit Note (Receivables/Payables)

lossy
Mapping required

Outstanding invoices and credit notes require careful sequencing. We extract current open items from Intact iQ, map them to Dolibarr Facture (customer invoice) or FactureFournisseur (supplier invoice) records with status=open. Partial payments and credit allocations migrate as Payment records linked to the invoice. Dolibarr's Open invoices must have the validated status before payments can be recorded; we validate this sequencing during migration design.

Intact iQ

User

maps to

Dolibarr ERP

User

1:1
Fully supported

Intact iQ User records include roles, branch assignments, and permissions hierarchies. We map users to Dolibarr User records by email match. Permissions require translation: Intact iQ's branch-level access controls map to Dolibarr's permission sets and per-module access flags. We flag any permissions that have no direct Dolibarr equivalent for manual admin configuration post-migration.

Intact iQ

Custom Fields

maps to

Dolibarr ERP

Extrafields

lossy
Mapping required

Custom fields added to any standard object in Intact iQ are stored in the database and require manual field mapping during scoping. We identify all custom field names, data types, and the objects they extend during discovery. Each custom field is pre-created in Dolibarr as an extrafields row before data migration begins. Multi-select or multi-value custom fields in Intact iQ map to Dolibarr's checkbox or varchar2 list types.

Intact iQ

Multi-Branch Setup

maps to

Dolibarr ERP

Multi-Entity or Project/Category structure

lossy
Fully supported

Branch and warehouse assignments on inventory, stock takes, and users require pre-migration validation. Intact iQ's multi-branch configuration has no single Dolibarr equivalent without the Multi-Entity module (commercial). If that module is not licensed, we map branches to Dolibarr Projects (for financial and project tracking), Product categories (for stock segmentation), or User teams. Mismatched branch hierarchies are resolved during scoping and documented in the mapping specification.

Intact iQ

Documents and Attachments

maps to

Dolibarr ERP

Documents directory (post-migration file copy)

1:1
Not supported

Document storage in Intact iQ uses an internal attachment layer not exposed via the REST API definition. We do not migrate attached documents programmatically. We recommend exporting them separately using Intact's native export or manual download before cutover, then copying to Dolibarr's documents directory and linking to records post-migration. We provide a file inventory listing documents by parent record type and ID to guide re-attachment.

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.

Intact iQ logo

Intact iQ gotchas

High

REST API requires custom definition setup per object

Medium

No public pricing or trial means scoping requires discovery calls

Medium

Performance collapses on large record sets

Medium

Document attachments are not accessible via REST API

Low

Workflow automation rules are not API-exportable

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 CSV import silently corrupts product selling prices

    Dolibarr GitHub issue #15770 documents a confirmed bug where, following CSV import, product selling prices change to incorrect values when the product card is first opened. The bug affects Dolibarr v12.0.3 and has not been fixed in all subsequent releases. We validate migrated selling prices after import by cross-checking unit price multiplied by quantity against the expected line total from Intact iQ. Any discrepancies are corrected in a post-import validation pass before the system goes live. This step adds one to two days to the migration timeline for product-heavy datasets.

  • Intact iQ REST API requires per-object definition before extraction

    Intact iQ does not expose a standard public REST API. Each data object (Customer, Supplier, Order, Stock, etc.) must be individually defined as an API Definition within the Company Tab. If these definitions have not been created, FlitStack AI cannot extract data programmatically and must fall back to database-level extraction, which requires elevated access and may affect live system performance. We check API definition availability during scoping and advise the customer to configure them before extraction begins if they are absent.

  • Intact iQ performance degrades during large record extraction

    Capterra reviews consistently report that Intact iQ slows noticeably when handling lists of 10,000+ customers with multiple properties and address records. During migration extraction, large record set reads can timeout or degrade application performance for live users. We throttle extraction requests, schedule bulk reads outside of business hours, and use database-level extraction (where API definitions are absent) with read-only access to minimise impact on the production system.

  • Dolibarr database key length issues on upgrade migrations

    Dolibarr GitHub issue #16315 documents a database migration error (DB_ERROR_1071: key too long) that occurs during Dolibarr version upgrades on certain MariaDB and MySQL configurations. If the destination Dolibarr instance is an upgrade from a previous version, we verify the MySQL/MariaDB configuration and character set before migration begins. If key length issues are detected, we document the required database configuration change (typically switching from utf8mb4 to utf8 or adjusting the innodb_large_prefix setting) before proceeding.

  • Workflow automation rules and application tasks do not migrate

    Intact iQ workflow rules and application-layer automation tasks live in the application layer and are not accessible via the REST API definition or database extraction. We capture the rule configuration during discovery as a text-based inventory (trigger, conditions, actions, and schedule) and produce a Dolibarr rebuild guide referencing Dolibarr's Workflow module, Cron/scheduled job configuration, and module hooks. Rebuilding these rules is a manual post-migration task for the customer's admin team.

Migration approach

Six steps for a successful Intact iQ to Dolibarr ERP data migration

  1. Discovery and API definition audit

    We audit the Intact iQ system for API Definition setup (Company Tab), record counts per object, custom field inventory, multi-branch configuration, open AP/AR balances, and any active workflow rules or application tasks. We also identify the Dolibarr version and hosting environment the customer has provisioned. If API Definitions are absent, we advise the customer on which objects need definition and the steps to configure them in Intact iQ before extraction begins. The discovery output is a written scope document with record counts, object mapping, and a pre-migration checklist for the customer.

  2. Dolibarr module activation and schema pre-creation

    We work with the customer's Dolibarr administrator to identify which modules are active (ThirdParty, Product, Order, Stock, BOM/MRP, Accounting, Project, etc.) and pre-create any missing schema. Custom fields from Intact iQ are pre-created in Dolibarr as extrafields rows before any data import begins. If the Multi-Entity module is not licensed, we agree on a branch-mapping strategy using Projects or Product categories. We also validate the MySQL/MariaDB configuration for key length compliance with Dolibarr's schema.

  3. Test migration and price validation

    We run a full test migration into the customer's Dolibarr instance using a representative data sample (typically 500-1,000 records per object type). The customer reconciles record counts, spot-checks 25-50 records against the Intact iQ source, and validates that Dolibarr's price import bug (GitHub #15770) has been mitigated by our post-import validation script. Any mapping corrections are applied before the production migration begins. This step typically takes one to two weeks depending on customer review cycles.

  4. Production migration in dependency order

    We run the production migration in record-dependency order: Third Parties (customers and suppliers), Contacts (linked to Third Parties), Products (with SKU as the dedupe key), Product stock levels (if multi-warehouse), Customer Orders, Supplier Orders, GL Account mappings, Open Invoices and Credit Notes (with payment allocations), and User accounts. Each phase emits a row-count reconciliation report before the next phase begins. Document attachment re-attachment is deferred to a post-migration manual step guided by the file inventory we deliver.

  5. Price validation and correction pass

    Immediately after the Product migration phase, we run a price validation script that reads every migrated product record's selling price and compares it to the source Intact iQ unit price. Any discrepancies caused by Dolibarr's price-shift bug (GitHub #15770) are corrected in a targeted update pass. This step is run while the migration is still in a validation state and before any orders referencing those products are imported, to avoid cascading corrections.

  6. Cutover, delta sync, and rule-rebuild handoff

    We freeze Intact iQ writes during cutover, run a final delta migration of any records created or modified during the migration window, then enable Dolibarr as the system of record. We deliver the workflow rule inventory and Dolibarr rebuild guide to the customer's admin team. We support a one-week hypercare window where we resolve any reconciliation issues. We do not rebuild Intact iQ workflow rules as Dolibarr triggers inside the migration scope; that is a separate engagement or an internal admin task.

Platform deep dives

Context on both ends of the pair

Intact iQ logo

Intact iQ

Source

Strengths

  • Integrated trade counter and EPOS unify point-of-sale with back-office financial and inventory modules.
  • Comprehensive multi-branch and multi-warehouse inventory management with ABC stock-take and aged stock reporting.
  • Workflow automation rules can be configured without developer involvement through the application layer.
  • Mobile access via the integrated app provides real-time visibility for field-based sales and warehouse teams.
  • Business intelligence dashboards offer KPI tracking and personalised reporting across the enterprise.

Weaknesses

  • Performance degrades significantly when handling large datasets exceeding approximately 10,000 customer or stock records.
  • Customer service response times are a common complaint, with resolution taking weeks for complex issues.
  • System updates have been known to introduce glitches that disrupt live operations.
  • Built-in filtering and search capabilities are insufficient for complex data queries, pushing power users to Excel exports.
  • Implementation quality is inconsistent, with some customers reporting a lack of product knowledge from the implementation team.
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 Intact iQ and Dolibarr ERP.

B

Overall complexity

Standard migration

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

  • Object compatibility

    A

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

    Intact iQ: Not publicly documented.

  • Data volume sensitivity

    B

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

Estimator

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

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

Can't find your answer?

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

Book a free 30 minute consultation

Migrations land between three and five weeks for straightforward cases with under 10,000 customers, 5,000 stock items, and pre-existing Intact iQ API Definitions. Migrations requiring database-level extraction (due to missing API Definitions), open AP/AR balance reconciliation, or Dolibarr configurations with multi-warehouse, multi-currency, and the Manufacturing module move to six to ten weeks. Dolibarr module activation and community module installation add one to three days depending on the customer's hosting setup.

Adjacent paths

Related migrations to explore

Ready when you are

Move from Intact iQ.
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