Optimal Data Transfer from SQL Server to Shopify Website

In our company, when we send an order to a customer, we refer to courier service for that. They are responsible for providing tracking numbers and delivering goods to customer doors, but we need to track end-to-end communication with a customer and make sure they are satisfied with the service. So once the tracking number of a shipment is known, we get this info on our SQL server.Instead of manually adding the tracking number to the customer’s account on Shopify, we decided to automate the process. By properly configuring the data integration from the SQL server to the Shopify website with Skyvia, the tracking number is automatically transferred to the customer account and generates an automatic email notification sent to the customer’s email box.