Migrate from Brightpearl to Dolibarr ERP

Brightpearl stores both customers and vendors as Contact records differentiated by a contact role flag. We split these into Dolibarr Societe records with the Tiers client (customer) and Tiers fournisseur (supplier) flags set accordingly. Each Societe gets the contact's primary address, email, phone, and any PCF_* custom fields mapped to Dolibarr ExtraFields on the Societe object. Contacts without company affiliation become Dolibarr Contact records linked to the parent Societe via llx_element_contact. The Brightpearl contact's owner assignment maps to a Dolibarr User reference if the recipient environment has the User module enabled.

Brightpearl Products map directly to Dolibarr Products. We preserve SKU as ref, product name as label, product type as fk_product_type (0 for goods, 1 for services), and the sales price as price. PCF_* custom fields migrate to Dolibarr ExtraFields on the Product object. Multiple Brightpearl price lists per product require a price list mapping strategy: if the customer uses two to three price lists, we create corresponding Dolibarr Customer Specific Prices on each Societe; for complex multi-list structures, we document the full mapping for manual configuration post-migration.

Brightpearl's four-level location hierarchy (Aisle / Bay / Shelf / Bin) under Zones has no direct Dolibarr equivalent. Dolibarr's Entrepot object represents a single warehouse without nested location sub-levels. We flatten the hierarchy into a Dolibarr Warehouse label that encodes the full path (e.g., 'Zone-A / Aisle-03 / Bay-B / Shelf-02 / Bin-07') as the Entrepot description. Stock quantities transfer as on-hand totals per product per location into Dolibarr's stock product批次 (stock product lines). Customers requiring granular pick-location management document this as a post-migration configuration of a third-party Dolibarr warehouse add-on.

Brightpearl Zones group multiple locations. Where Brightpearl has Zones, we create multiple Dolibarr Entrepot records (one per physical location) and annotate the zone affiliation in the Entrepot description field. If the customer uses only one physical warehouse with zone-based internal areas, we create a single Entrepot and document the zone-to-area mapping for the customer's warehouse management workflow configuration.

Brightpearl Sales Orders map to Dolibarr CommandeClient. We preserve order number, order date, customer reference (linked to the mapped Societe), line items with quantities and prices, discount values, and order status. Brightpearl's order-level owner assignment maps to Dolibarr's fk_user_author on the order header. Orders in pending or draft status migrate as draft Dolibarr orders; orders in confirmed or shipped status migrate as validated orders.

Brightpearl Purchase Orders map to Dolibarr CommandeFournisseur. We preserve PO number, vendor reference (mapped to the corresponding Dolibarr Societe with Tiers fournisseur set), expected delivery date, line items with quantities and costs, and received quantities. If Brightpearl tracks partial receipts, we create multiple Dolibarr product reception lines to match.

Brightpearl invoices map to Dolibarr Facture. We preserve invoice number, invoice date, due date, customer reference, line items with prices and VAT, discount values, and payment status. Brightpearl's embedded accounting data (debit account, credit account) maps to the corresponding Dolibarr accounting account entries in the Accountancy module. Paid invoices migrate as validated Factures with payment lines; unpaid invoices migrate as open Factures.

Brightpearl credit notes map to Dolibarr Facture with type set to AC (avoir/correction). We preserve the original invoice reference in the Facture's linked invoice field, the credit note date, line items with corrected prices or quantities, and any refund amount. The accounting entries reverse the original invoice postings using the configured reversal accounts.

Brightpearl supports multiple price lists per product. In Dolibarr, customer-specific pricing is managed via PrixSpeciaux attached to a Societe. We map each Brightpearl price list to a Dolibarr price level group or individual Societe pricing. For Brightpearl price lists not tied to a specific customer, we create Dolibarr Customer Categories with the corresponding price rules. Price list logic (volume breaks, quantity thresholds) is documented for manual Dolibarr configuration if the customer uses complex pricing tiers.

Brightpearl's Chart of Accounts with account codes maps to Dolibarr's Plan de compte. We export the full account code list from Brightpearl and create corresponding Dolibarr accounting account records with the same account code, label, and account type (court-terme, long-terme, charge, produit). Account type mapping aligns Brightpearl's account classification with Dolibarr's account class (actif, passif, charge, produit). If Dolibarr's Accountancy module uses a standard French PCG structure, we map Brightpearl accounts to the nearest PCG equivalent and flag any non-standard Brightpearl accounts for the customer's accountant to validate.

Brightpearl inventory summary (total cost value per SKU) and inventory detail (per-warehouse, per-location stock levels) map to Dolibarr Stock records. We create a Stock Entrepot for each Brightpearl warehouse or zone, then populate product stock quantities using Dolibarr's Stock Movement records. The cost value from Brightpearl (realtime_stock_valuation) maps to Dolibarr's PMP (Prix Moyen Pondere) if the customer uses average cost valuation, or to a custom ExtraField if they use standard cost.

Brightpearl assigns a staff member as Owner of Contact and auto-assigns orders to the contact owner. We extract the Brightpearl user roster and match by email against the Dolibarr User table. Any Brightpearl Owner without a matching Dolibarr User is held in a reconciliation queue for the customer's admin to provision before record import. Dolibarr's User module must be enabled to support owner assignments; if disabled, owner references are stored as a text ExtraField.