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 your SFTP site in:

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

What We’ll Cover

• Download the File
  • Columns Included in the File by Default
• Upload the File
• Ship Synchronization

---

---

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, for Jan 25, 2018, at 12:30 pm, you would change the date to “01/25/2018 12:30:00”.

---

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 you update the CSV file, 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 uploaded. Then the shipping status of the order will change in DirectScale’s database to “Shipped”.

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

To force the synchronization:

1. Click the Synchronize button on the Shipping page.

   

Once a folder processes, it will get copied to either the archive or error folder inside To DirectScale.

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

Read more: Understanding Ship Synchronization