Inventory Management: Import via FTP Upload

Usage: Insert / update an inventory records in the OneSource database

  1. Download our blank CSV inventory template: Download Blank CSV Inventory Spreadsheet
    Want to learn more about OneSource's Inventory CSV Spreadsheet? View Field Descriptions >>
  2. Fill out the blank spreadsheet with your product information & inventory levels
    Before you start filling out the spreadsheet, you must already have FOB ID's created in OneSource. 
    Create FOB ID's >>  in the OneSource Database.
  3. 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
  4. Please note, you must include all fields even if they are blank.

  5. Upload the CSV spreadsheet using our FTP upload process

FTP Details
Protocol: SFTP

Port: 22
Username is yourAPI Key
Password is your API 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 with questions about other spreadsheet formats that may be accepted.

Need help using our FTP?
View our FTP Upload Help Guide >>