ERP migration
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
Source
Dolibarr ERP
Destination
Compatibility
9 of 12
objects map 1:1 between Intact iQ and Dolibarr ERP.
Complexity
BStandard
Timeline
3-5 weeks
Overview
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.
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 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
Dolibarr ERP
Third Party (customer type)
1:1Intact 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
Dolibarr ERP
Third Party (supplier type)
1:1Intact 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
Dolibarr ERP
Contact (linked to Third Party)
1:1Intact 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
Dolibarr ERP
Product
1:1Intact 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
Dolibarr ERP
Order (customer order)
1:1Open 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
Dolibarr ERP
Order (supplier order)
1:1Intact 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
Dolibarr ERP
Account (Accounting module)
1:1Chart 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
Dolibarr ERP
Invoice and Credit Note (Receivables/Payables)
lossyOutstanding 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
Dolibarr ERP
User
1:1Intact 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
Dolibarr ERP
Extrafields
lossyCustom 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
Dolibarr ERP
Multi-Entity or Project/Category structure
lossyBranch 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
Dolibarr ERP
Documents directory (post-migration file copy)
1:1Document 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.
| Intact iQ | Dolibarr ERP | Compatibility | |
|---|---|---|---|
| Customer | Third Party (customer type)1:1 | Fully supported | |
| Supplier | Third Party (supplier type)1:1 | Fully supported | |
| Contact | Contact (linked to Third Party)1:1 | Fully supported | |
| Stock Item | Product1:1 | Fully supported | |
| Sales Order | Order (customer order)1:1 | Fully supported | |
| Purchase Order | Order (supplier order)1:1 | Fully supported | |
| GL Account | Account (Accounting module)1:1 | Fully supported | |
| Open AP/AR Balances | Invoice and Credit Note (Receivables/Payables)lossy | Mapping required | |
| User | User1:1 | Fully supported | |
| Custom Fields | Extrafieldslossy | Mapping required | |
| Multi-Branch Setup | Multi-Entity or Project/Category structurelossy | Fully supported | |
| Documents and Attachments | Documents directory (post-migration file copy)1:1 | Not 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.
Intact iQ gotchas
REST API requires custom definition setup per object
No public pricing or trial means scoping requires discovery calls
Performance collapses on large record sets
Document attachments are not accessible via REST API
Workflow automation rules are not API-exportable
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 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.
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.
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.
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.
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.
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
Intact iQ
Source
Strengths
Weaknesses
Dolibarr ERP
Destination
Strengths
Weaknesses
Complexity grading
Standard ERP migration. All 8 core objects map 1:1 between Intact iQ and Dolibarr ERP.
Overall complexity
Standard migration
Derived from compatibility, mapping clarity, API constraints, and data volume across Intact iQ and Dolibarr ERP.
Object compatibility
All 8 core objects map 1:1 between Intact iQ 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
Intact iQ: Not publicly documented.
Data volume sensitivity
Intact iQ 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 Intact iQ to Dolibarr ERP migration scoping. Not seeing yours? Book a call.
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 consultationAdjacent paths
Other ways to leave Intact iQ
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.