We are pleased to present PowerSync Salesforce Integration release 2.5 called "System Reliability 2019". This release holds one of the most anticipated features, the new Salesforce synchronization queue.

Introducing optimized Magento and Salesforce synchronization queue!

In older versions, the queue was limited to a 5-minute interval, which guaranteed the best performance; however, there were several limitations:

  1. Partial synchronization of data when Salesforce goes into maintenace or when the Salesforce system is under a heavy load.
  2. Minimum recommended schedule interval of 5 minutes.
  3. Assumed object dependency, resulting in a not optimal process.

Solution 1: Partial Data synchronization

We broke down the synchronization process into microtransactions. We also added status workers for each transaction (bulk or single). This new architecture allows us to:

  1. Catch the exact step where the sale has stopped. The modern architecture allows Powersync Magento Salesforce integration to resume the process smoothly without restarting it from the beginning every time.
  2. Utilize the re-try limit more accurately before giving up and resulting in an error.

Solution 2: Minimum Interval

The Powersync Magento Salesforce integration is now able to support a more frequent synchronization schedule. We've stress-tested the new queue while running on a one-minute interval with tens of thousands to hundreds of thousands of records. This enhancement does not only give us the ability to send data to Salesforce close to real-time but also increases the overall performance when dealing with large subsets of data.

Solution 3: Assumed object dependency

The old queue had a specific Magento to Salesforce synchronization sequence. Products and Customers were always first, followed by Orders, Invoices, shipments, and Credit Memos. The old system did not know about which objects depend on one another, and the system had to make assumptions. The new synchronization queue between Magento and Salesforce is now sophisticated enough to know object dependency. Having a clear understanding of the dependency chain allows the new synchronization process to make smart decisions when the data can be sent from one system to another without waiting for everything to complete.