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
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:
-
Click the Synchronize button on the Shipping page.
Synchronize button
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
Comments
0 comments
Please sign in to leave a comment.