ERP migration
Field-level mapping, validation, and rollback between Blue Link ERP and Dolibarr ERP. We move data and schema; workflows are rebuilt natively in Dolibarr ERP.
Blue Link ERP
Source
Dolibarr ERP
Destination
Compatibility
11 of 12
objects map 1:1 between Blue Link ERP and Dolibarr ERP.
Complexity
BStandard
Timeline
4-6 weeks
Overview
Blue Link ERP and Dolibarr are architecturally different platforms serving different deployment philosophies. Blue Link is a North American hosted ERP for wholesalers and distributors with deep inventory lot tracking, multi-currency customer and vendor records, and built-in Amazon, eBay, and Shopify integrations. Dolibarr is an open-source PHP/MySQL modular ERP and CRM that runs on self-hosted infrastructure with a much lower total cost of ownership but a shallower native feature set for regulated distribution. We extract Blue Link data directly from its database since the platform does not expose a public REST API for bulk extraction. We resolve the multi-UOM duplication problem (a common Blue Link pattern where the same product exists as multiple inventory SKUs to represent different units of measure) before writing to Dolibarr, and we sequence open Sales Orders and Purchase Orders as the final migration phase to prevent fulfillment gaps during cutover. Dolibarr does not natively support cost-centre accounting; if Blue Link's Chart of Accounts uses departmental cost-centre segments, we flag this as a structural gap and document a recommended third-party module or manual workaround. Document attachments attached to Blue Link records do not migrate because the platform stores them in a proprietary format with no documented export path.
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 Blue Link 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.
Blue Link ERP
Customer
Dolibarr ERP
Third-Party (client type)
1:1Blue Link Customer records map to Dolibarr Third-Party (societe) records with the client checkbox enabled. We preserve customer contact details, multi-currency flags, credit status, payment terms, and sales rep assignment. Blue Link's credit limit maps to a custom field on the Dolibarr Third-Party record. Address records (shipping and billing) map to Dolibarr address contacts (contact object with type = invoice address or delivery address). Multi-currency flags in Blue Link require a check that the Dolibarr installation has the multi-currency module (multicurrency) enabled, which is a standard module but must be activated during Dolibarr setup before migration begins.
Blue Link ERP
Vendor
Dolibarr ERP
Third-Party (supplier type)
1:1Blue Link Vendor records map to Dolibarr Third-Party records with the supplier checkbox enabled. Payment terms, multi-currency flags, and address records migrate in the same pattern as Customer records. We flag any vendor-to-PO linkage that requires re-establishment in Dolibarr because the parent PO record is not yet migrated at the time of vendor resolution. A cross-reference table linking Blue Link vendor IDs to Dolibarr Third-Party IDs is maintained throughout migration to support downstream PO linkage resolution.
Blue Link ERP
Inventory Item (single UOM)
Dolibarr ERP
Product
1:1Blue Link inventory items with a single unit-of-measure map directly to Dolibarr Product records. We map Blue Link item fields including SKU (ref), item description (label), item type (product or service), cost price (cost_price), selling price (price level mapping), reorder point, and weight or dimensions where present. The product type in Blue Link (stockable, service, kit) maps to Dolibarr's typent (0 = product, 1 = service). For lot-tracked Blue Link items, the lot numbers migrate as separate stock_lot records in Dolibarr if the third-party lot module is installed; we note this as a prerequisite module activation during scoping.
Blue Link ERP
Inventory Item (multi-UOM duplicate)
Dolibarr ERP
Product + Product Combination
1:manyBlue Link customers commonly maintain duplicate inventory items to represent the same physical product with different UOMs (e.g., one SKU for each-of and one for case). We surface all duplicate UOM items during the data audit, present a consolidation strategy, and agree on an approach before migration: either consolidate to a single primary SKU and document the secondary UOMs for manual re-entry in Dolibarr, or if Dolibarr's product combination module (productbatch variant or a custom module) is available, we map the secondary UOM to a product combination attached to the primary product. This is the highest-risk mapping for data completeness on this pair and must be resolved before any inventory records are written to Dolibarr.
Blue Link ERP
Sales Order (open)
Dolibarr ERP
Order (customer order)
1:1Open Sales Order headers and line items map to Dolibarr Commande records (type = 0 for customer order). We extract order header fields including order number, order date, customer reference, and sales rep assignment. Line items map to order lines with product reference resolution, quantity, unit price, and tax mapping. Open orders are sequenced as the final migration phase, extracted as close to Go-Live as possible to avoid the gap where an order ships between extraction and cutover. We run a delta validation check within 24 hours of Go-Live to catch any orders placed in the brief overlap window. Closed historical sales orders migrate as archived records if scope includes historical order data.
Blue Link ERP
Purchase Order (open)
Dolibarr ERP
Order (supplier order)
1:1Open Purchase Order headers and line items map to Dolibarr Commande records (type = 1 for supplier order). We resolve the vendor reference via the cross-reference table built during vendor migration. Line items map with product reference, quantity, and cost price. PO-to-receipt linkage (partial receiving against a PO) does not carry forward automatically; we document each partially-received PO and advise the customer to receive remaining goods against the PO in Dolibarr post-migration. As with Sales Orders, open POs are migrated last, just before Go-Live, and a delta check is run within 24 hours of cutover.
Blue Link ERP
Lot Number
Dolibarr ERP
Stock Lot (via stock_lot module)
1:1Blue Link lot numbers associated with inventory items and shipment lines migrate to Dolibarr stock_lot records if the Dolibarr stock_lot module is installed and activated. We map the lot number, lot expiry date, and the linking stock movement records. If the customer does not have the stock_lot module installed, we flag this as a prerequisite and document the module activation steps; lot traceability cannot be preserved without it. Lot numbers tied to specific shipment lines require a separate stock movement record import to establish the lot-to-location linkage in Dolibarr.
Blue Link ERP
Accounts Receivable
Dolibarr ERP
Invoice (customer) + Payment
1:1Blue Link AR records (invoices, credit memos, and cash applications) map to Dolibarr Facture records (type = 0 for customer invoice, type = 2 for credit note). Open invoices retain their payment status (paid, unpaid, partially paid) as migrated to Dolibarr's PaiementFacture table. Collections history that exists in Blue Link as activity log entries does not migrate as discrete records; we document the collections notes as a custom field on the invoice record and advise the customer that collections activity history requires manual note entry or a separate process to re-establish in Dolibarr.
Blue Link ERP
Accounts Payable
Dolibarr ERP
Invoice (supplier) + Payment
1:1Blue Link AP records (vendor invoices, credit memos, and payment applications) map to Dolibarr Facture records (type = 1 for supplier invoice, type = 2 for credit note). Unpaid and partially paid invoices are flagged during migration so that open payables can be reconciled against the bank and paid in Dolibarr post-Go-Live. Blue Link's cash requirements and aging reporting is not a native Dolibarr standard report; we document the equivalent Dolibarr aged-receivable report (Comptabilite > Customers > Aged Creditors / Aged Debtors) and note that a third-party accounting module may be needed for the specific aging format the customer used in Blue Link.
Blue Link ERP
Chart of Accounts
Dolibarr ERP
Accounting Account
1:1Blue Link's Chart of Accounts structure migrates to Dolibarr's Accounting Account table (plan_comptable). Blue Link accounts flagged as expense, income, asset, liability, or equity map to Dolibarr account type fields (ptype). Custom account segments or departmental cost-centre dimensions in Blue Link do not map to a native Dolibarr equivalent in the base accounting module; if cost-centre reporting is business-critical, we flag this as a structural gap and recommend the third-party cost control module or a manual reporting workaround. Account numbers are validated against Dolibarr's allowed character set during transform; any non-conformant characters are replaced or flagged for manual correction before import.
Blue Link ERP
Warehouse Location
Dolibarr ERP
Warehouse
1:1Blue Link multi-warehouse and bin-level locations map to Dolibarr Entrepot records. Bin-level assignments (shelf, rack, location within a warehouse) do not have a native Dolibarr equivalent; if the customer relies on bin-level picking, we document the current bin assignments as a reference file and advise that a third-party warehouse management module or manual bin assignment workflow is required in Dolibarr. We also map the default warehouse assignment on each inventory item so that stock quantities associate with the correct warehouse immediately after migration.
Blue Link ERP
eCommerce Orders (Shopify, Amazon, eBay)
Dolibarr ERP
Order (via eCommerce integration module)
1:1Blue Link pulls orders from Shopify, Amazon, and eBay channels into its order management system. Historical eCommerce orders in Blue Link carry channel metadata (channel name, channel order ID, channel timestamp) that we preserve in custom fields on the migrated Dolibarr order record. Active channel integrations do not migrate; the customer must reconnect Shopify, Amazon, or eBay to Dolibarr post-migration using Dolibarr's eCommerce connectors or the DoliStore WooCommerce/PrestaShop modules. We deliver a written guide for reconnecting each channel with the correct webhook and API configuration.
| Blue Link ERP | Dolibarr ERP | Compatibility | |
|---|---|---|---|
| Customer | Third-Party (client type)1:1 | Fully supported | |
| Vendor | Third-Party (supplier type)1:1 | Fully supported | |
| Inventory Item (single UOM) | Product1:1 | Fully supported | |
| Inventory Item (multi-UOM duplicate) | Product + Product Combination1:many | Fully supported | |
| Sales Order (open) | Order (customer order)1:1 | Fully supported | |
| Purchase Order (open) | Order (supplier order)1:1 | Fully supported | |
| Lot Number | Stock Lot (via stock_lot module)1:1 | Fully supported | |
| Accounts Receivable | Invoice (customer) + Payment1:1 | Fully supported | |
| Accounts Payable | Invoice (supplier) + Payment1:1 | Fully supported | |
| Chart of Accounts | Accounting Account1:1 | Mapping required | |
| Warehouse Location | Warehouse1:1 | Fully supported | |
| eCommerce Orders (Shopify, Amazon, eBay) | Order (via eCommerce integration module)1: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.
Blue Link ERP gotchas
Dated interface causes navigation friction for daily users
Open order handling during migration requires sequencing
Document attachments are not accessible via documented export path
SKU consolidation is required when duplicate UOM items exist
Pricing requires a consult call with no published public tiers
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
Blue Link database access and data audit
We coordinate with the customer's Blue Link account manager to obtain read-only database credentials for the Blue Link SQL Server or cloud-hosted instance. We run a full data audit across all supported object tables (customers, vendors, inventory items, sales orders, purchase orders, AR invoices, AP invoices, lots, warehouse locations, chart of accounts, eCommerce orders) and produce a record-count summary, a data-quality report (duplicate customers, duplicate SKUs, null required fields), and an object dependency graph. We specifically flag the multi-UOM duplicate SKU pattern, any inventory items with missing lot assignments, and open order volume at audit time to scope the final migration phasing.
Dolibarr installation and module activation
We validate that the target Dolibarr installation has all required modules activated: the multi-currency module (required for Blue Link's multi-currency customer and vendor records), the stock_lot module (required to preserve Blue Link's lot traceability), and the accounting module. We also configure the Dolibarr chart of accounts structure to receive the Blue Link COA, validate that account number formats conform to Dolibarr's allowed character set, and install any third-party modules (cost control for cost-centre accounting if required) before the migration begins. This step can run in parallel with the Blue Link data extraction.
Schema design and transformation rule definition
We define the transformation rules for each Blue Link object before any data is written to Dolibarr. Key design decisions include the multi-UOM consolidation strategy (per the audit output), the lot module activation decision, the cost-centre accounting workaround if applicable, and the customer/vendor split between Third-Party records in Dolibarr. We produce a written mapping matrix with source field, target field, transformation logic, and validation rule for each migrated object. The mapping matrix is reviewed and signed off by the customer's project owner before the sandbox migration begins.
Sandbox migration and reconciliation
We run a full migration into a Dolibarr sandbox instance (a fresh install or a cloned copy) using production-like data volume from Blue Link. The customer's operations lead reconciles record counts against Blue Link (customer count, vendor count, product count, open order count, open invoice count, lot count), spot-checks 25-50 randomly selected records for field-level accuracy, and validates that inventory on-hand quantities match between Blue Link and the Dolibarr sandbox. Any mapping corrections, UOM consolidation issues, or missing required fields are resolved in the transformation scripts before the production migration begins.
Production migration in dependency order
We run production migration in the following dependency sequence: Third-Party records (all customers and vendors, with the client and supplier flags set appropriately), Products (single-UOM items first, then the consolidated multi-UOM items per the agreed strategy), stock_lot records (if the module is activated), warehouse locations, chart of accounts, AR and AP opening balances, inventory on-hand quantities by warehouse, eCommerce historical orders, then Sales Orders and Purchase Orders as the final phase. Each phase emits a row-count reconciliation report before the next phase begins. Document attachments are documented but not migrated; we produce a file manifest listing every Blue Link record with attachments for the customer to retrieve before decommissioning.
Cutover, delta validation, and channel reconnection handoff
We freeze Blue Link writes during the cutover window, run a final delta migration for any orders or invoices placed in the window between final extraction and cutover, then mark Dolibarr as the system of record. We deliver the eCommerce reconnection guide (with webhook and API steps for Shopify, Amazon, and eBay), the workflow and automation inventory (noting that Dolibarr does not have a native workflow engine equivalent to Blue Link's built-in order processing rules, so manual process documentation is provided for the customer's admin team to rebuild), and the document attachment manifest for manual retrieval. We support a one-week hypercare window for reconciliation issues and explicitly do not rebuild automations, forms, or reporting definitions as those are outside standard migration scope.
Platform deep dives
Blue Link ERP
Source
Strengths
Weaknesses
Dolibarr ERP
Destination
Strengths
Weaknesses
Complexity grading
Standard ERP migration. 2 of 8 objects need a mapping; the rest are 1:1.
Overall complexity
Standard migration
Derived from compatibility, mapping clarity, API constraints, and data volume across Blue Link ERP and Dolibarr ERP.
Object compatibility
2 of 8 objects need a mapping; the rest are 1:1.
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
Blue Link ERP: Rate limits are not publicly documented for Blue Link's API.
Data volume sensitivity
Blue Link 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 Blue Link ERP to Dolibarr ERP migration scoping. Not seeing yours? Book a call.
Walk through your Blue Link 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 Blue Link 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.