Before getting started - add your customer numbers to distributors in OneSource.
How to Add Distributor Customers Numbers to OneSource
Usage: Add/update Order Shipment Notification records to the OneSource database
-
Download our blank CSV Order Shipment Notifications template: Download Blank CSV Order Shipment Notification Spreadsheet
Want to learn more about OneSource's Order Shipment Notification CSV Spreadsheet? View Field Descriptions
- Fill out the blank spreadsheet with your Order Shipment Notification information. Please note, you must include all fields even if they are blank.
-
Save your CSV Order Shipment Notification spreadsheet to your computer making sure to name your file as follows:
{servicetype)_{anyname).csv
For example your order shipment notification file should look something like this:osn_abc123.csv
- Upload the CSV spreadsheet using our FTP upload process
FTP Details
Protocol: SFTP
Hostname: ostransfer.dc-onesource.com
Port: 22
Username is yourAPI Key
Password is your API Password
How to create an API Key & Password >>
How to create an API Key & Password >>
| FTP Folder Name | Description |
| import | Files put in the import folder are automatically processed and imported by OneSource |
| errors | The error folder holds files that could not be processed due to an error during the import |
| archive | Successfully processed files are placed in the archive folder |
| manual | Files placed here are manually processed. Please don't use this folder unless directed |
File Specifications:
Required File Format:
csv
Required File Name Format:
{osn)_{anyname).csv For example your order shipment notification file should look something like this: osn_abc123.csv
OneSource's CSV Order Shipment Notification spreadsheet format is recommended for the most efficient import/update process.
Contact support@dc-onesource.com with questions about other spreadsheet formats that may be accepted.
Need help using our FTP?
View our FTP Upload Help Guide >>