Acumatica E-commerce Integration Guide

Introduction

Integrating Acumatica with e-commerce platforms enables automated order processing, inventory synchronization, and seamless customer experiences. This guide covers various integration approaches and best practices.

Integration Options

Available Solutions

• Pre-built connectors - Shopify, Magento, WooCommerce
• Acumatica Commerce API - REST API for custom integrations
• Integration platforms - Celigo, Boomi, Tray.io
• Custom development - Using Acumatica REST/GraphQL APIs

Order Synchronization

Order Import

// Acumatica Commerce API - Import Orders
// 1. Pull orders from e-commerce platform
// 2. Create customer if not exists
// 3. Create sales order in Acumatica
// 4. Update order status in e-commerce

POST /api/data/SO301000
{
  "CustomerID": { "value": "CUST001" },
  "OrderType": { "value": "SO" },
  "Details": [
    {
      "InventoryID": { "value": "PROD-001" },
      "Quantity": { "value": 2 },
      "UnitPrice": { "value": 49.99 }
    }
  ]
}

Order Status Sync

// Update order status back to e-commerce
// 1. Monitor Acumatica shipment status
// 2. Update tracking info
// 3. Sync fulfillment status

{
  "OrderID": "SO-001234",
  "Status": "Shipped",
  "TrackingNumber": "1Z999AA10123456784",
  "ShipDate": "2024-01-15"
}

Inventory Sync

Real-time Updates

// Push inventory to e-commerce
// 1. Monitor inventory changes in Acumatica
// 2. Update stock levels in e-commerce

PUT /api/v1/products/PROD-001/inventory
{
  "available": 150,
  "reserved": 10,
  "warehouse": "MAIN"
}

Scheduled Sync

// Batch inventory sync
// Schedule: Every 15 minutes
// 1. Export inventory from Acumatica
// 2. Compare with e-commerce
// 3. Update differences

Payment Processing

Payment Gateway Integration

// Process payment through Acumatica
// 1. Capture payment at checkout
// 2. Process in Acumatica
// 3. Reconcile with orders

POST /api/data/AR301000
{
  "CustomerID": { "value": "CUST001" },
  "DocType": { "value": "Invoice" },
  "Payments": [
    {
      "PaymentMethod": { "value": "CREDITCARD" },
      "Amount": { "value": 99.98 }
    }
  ]
}

Payment Reconciliation

// Reconcile payments
// 1. Import payment transactions
// 2. Match with orders
// 3. Update AR

Custom Integration

API Integration Pattern

// Custom integration service
class EcommerceIntegrationService
{
    public function syncOrders()
    {
        $orders = $this->ecommerceClient->getOrders([
            'status' => 'pending',
            'since' => $this->lastSyncTime
        ]);
        
        foreach ($orders as $order) {
            $this->acumaticaClient->createSalesOrder($order);
            $this->ecommerceClient->updateOrderStatus($order->id, 'processing');
        }
    }
}

Best Practices

• Real-time sync - Process orders immediately
• Error handling - Implement retry logic for failures
• Idempotency - Handle duplicate order imports
• Monitoring - Track sync status and errors
• Testing - Test thoroughly before production

Summary

E-commerce integration with Acumatica streamlines operations and improves customer satisfaction. Choose the right integration approach based on your complexity and budget.

For more Acumatica guides, check out Acumatica Customer Portal and Acumatica REST API.