Salesforce-ERP Manufacturing Integration

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30

public class InventorySyncBatch implements Database.Batchable<SObject> {
    
    public Database.QueryLocator start(Database.BatchableContext bc) {
        // Get products needing sync
        return Database.getQueryLocator([
            SELECT Id, ERP_Product_Id__c 
            FROM Product2 
            WHERE Sync_Enabled__c = true
        ]);
    }
    
    public void execute(Database.BatchableContext bc, List<Product2> products) {
        // Call ERP API for inventory levels
        Map<String, Decimal> inventory = ERPService.getInventoryLevels(
            getERPIds(products)
        );
        
        // Update Salesforce records
        List<Product2> toUpdate = new List<Product2>();
        for (Product2 p : products) {
            if (inventory.containsKey(p.ERP_Product_Id__c)) {
                p.Available_Quantity__c = inventory.get(p.ERP_Product_Id__c);
                p.Last_Inventory_Sync__c = DateTime.now();
                toUpdate.add(p);
            }
        }
        
        update toUpdate;
    }
}

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18

trigger OpportunityTrigger on Opportunity (after update) {
    List<Opportunity> wonOpps = new List<Opportunity>();
    
    for (Opportunity opp : Trigger.new) {
        Opportunity oldOpp = Trigger.oldMap.get(opp.Id);
        
        // Check if just moved to Closed Won
        if (opp.StageName == 'Closed Won' && 
            oldOpp.StageName != 'Closed Won') {
            wonOpps.add(opp);
        }
    }
    
    if (!wonOpps.isEmpty()) {
        // Async callout to ERP
        ERPOrderService.createOrdersAsync(wonOpps);
    }
}