Usage: Insert / update inventory records in the OneSource database
-
Download our blank CSV inventory template: Download Blank CSV Inventory Spreadsheet
Want to learn more about OneSource's Inventory CSV Spreadsheet? View Field Descriptions >>
-
Fill out the blank spreadsheet with your product information & inventory levels
-
Save your CSV Inventory spreadsheet to your computer making sure to name your file as follows:
{servicetype}_{anyname}.csv
For example your inventory file should look something like this:inv_abc123.csv
Please note, you must include all fields even if they are blank.
- 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:
{inv)_{anyname).csv
For example your inventory file should look something like this: inv_abc123.csv
OneSource's CSV Inventory 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 >>
- OneSource_inv_template.csv221 Bytes