Inventory Management: Import via FTP Upload

  • Updated

Usage: Insert / update 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

Please note, you must include all fields even if they are blank.

  1. 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 >>


Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request