Every hour DirectScale will do a synchronization. This sync will take all submitted orders that haven’t been shipped yet and create a .CSV file that will be inside the client’s SFTP site in:

└───From DirectScale
│   │
│   └───<Warehouse name>

---

---

Download the File

Download this .CSV file and update the last three columns:

• DATESHIPPED
• CARRIER
• TRACKINGNUMBER

Keep the DATESHIPPED format the same (i.e., “01/01/0001 00:00:00”).

For Example: Change that date to “01/25/2018 12:30:00” for Jan 25 2018 at 12:30pm.

---

Columns Included in the File by Default

The following shows all of the default columns included in the .CSV file.

//If you change the order of HEADERS be sure to update the excel / CSV portions.
        private readonly List<string> _headers = new List<string>
        {
            "ORDERNUMBER",
            "PACKAGEID",
            "VENDORREFERENCE",
            "DISTRIBUTERID",
            "ORDERDATETME",
            "SHIPMETHOD",
            "SHIPNAME",
            "SHIPADDRESS1",
            "SHIPADDRESS2",
            "SHIPCITY",
            "SHIPSTATE",
            "SHIPPOSTAL",
            "SHIPCOUNTRY",
            "SHIPPHONE",
            "SHIPEMAIL",
            "SHIPTOTALVALUE",
            "WEIGHT",
            "ORDERNOTES",
            "SKU",
            "QUANTITY",
            "VALUE",
            "CURRENCY",
            "LINENOTES",
            "DATESHIPPED",
            "CARRIER",
            "TRACKINGNUMBER"
        };

---

---

Upload the File

Once the .CSV file is updated, place it inside the folder on the SFTP site:

home folder (/) 
│
└───To DirectScale
│   │
│   └───<Warehouse name>

---

---

Ship Synchronization

The sync that happens every hour will also check the folder above for any new .CSV files that has been uploaded. Then the shipping status of the order will change in DirectScale’s database to Shipped.

If the update is successful, then it will no longer show up in Inventory > Shipping within Corporate Office.

You can force the synchronization to happen by clicking the Synchronize button in the Shipping page.

Once a folder has been processed it will get copied to either the archive or error folder inside of To DirectScale.

home folder (/) 
│
└───To DirectScale  
│   │
│   └───archive
│   │
│   └───error

Read more: Understanding Ship Synchronization