Integration Services
Connecting your ERP, CRM, e-commerce, and EDI systems through API-first integrations.
HubSpot ↔ Acumatica Sync
Bi-directional sync between Acumatica ERP and HubSpot CRM, running on 15-minute BullMQ cron cycles.
| Sync Path | Direction | What Syncs |
|---|---|---|
| Customers → Companies | Acumatica → HubSpot | Name, address, phone, AR balance, payment terms, customer class, salesperson, ship via |
| StockItems → Products | Acumatica → HubSpot | Product catalog with UPC, image URL, pricing |
| SalesOrders → Orders | Acumatica → HubSpot | Order details, line items, invoice status, shipment tracking, carrier info |
| Cases ↔ Tickets | Bi-directional | Support cases with status mapping, owner assignment, 10-min sync + webhooks |
| Contacts | Acumatica → HubSpot | Real contacts from MainContact (email-gated quality) |
Write-back: HubSpot record IDs written back to Acumatica attributes (HUBSPOTPID, HUBSPOTCID, HUBSPOTTID, UsrHubSpotDealId) for bidirectional dedup.
Add-on module: $500/month as part of AcuOps subscription.
EDI Gateway (Orderful)
API-first EDI for traditional retailer connectivity. Studio B builds and owns the integration layer; Orderful handles X12 ↔ JSON translation and trading partner connectivity.
| Document | Direction | Mapping |
|---|---|---|
| 850 (Purchase Order) | Retailer → Acumatica | PO → Sales Order creation |
| 856 (ASN) | Acumatica → Retailer | Shipment confirmation |
| 810 (Invoice) | Acumatica → Retailer | Invoice transmission |
Channel strategy: Orderful EDI for traditional retailers (Wayfair, Walmart, Target). Acumatica native connectors for marketplaces (Amazon, Shopify, BigCommerce).
Add-on module: $500/month + per-transaction fees.
CRM Implementation
HubSpot Enterprise setup from pipeline design to property architecture:
- Pipeline configuration (sales, service, onboarding, offboarding)
- Custom property creation and sync mapping
- Workflow automation (form → ticket → webhook → BullMQ)
- Employee onboarding/offboarding automation
- Help Desk email consolidation
Data Migration
ETL design for moving between ERPs, CRMs, or consolidating data sources:
- Field mapping and transform design
- Validation and data quality gates
- Cutover planning with rollback procedures
- Historical data backfill (orders, customers, products)
Email Consolidation
Moving from fragmented email intake (Acumatica email processing + direct inbox) to a single HubSpot Help Desk intake:
- Per-mailbox cutover with zero-downtime transition
- Anti-duplicate safeguards (source tagging, echo prevention, Redis locks)
- Pipeline routing by email address
- Owner auto-assignment from Acumatica employee mapping