SFTP Inventory Uploads

ShipEarly supports SFTP inventory uploads for any retailer that is using a POS that does not currently have a premium integration. This allows your POS to schedule automated reports that send your inventory data to ShipEarly for display on your vendors website.

The Data File

The data file you create only works as a CSV file. Within the file we are looking for two columns labelled UPC, QTY

Ideally the report you would generate only sends UPCs where the QTY is greater than zero for quicker processing and where there is only a UPC field so no blanks. This also means you must have the UPC codes for your vendor in your POS.

SELECT [UPC], [Quantity] as QTY from Products 
WHERE Quantity > 0 AND hide = 0

Is an example query that could be run. After successful upload we delete the file so no need to worry about file name or date on the file.

SFTP Credentials

The URL or host to send the data file to is: sftp://inv-data.shipearlyapp.com/upload

If asked for a port select Port 22

Username:

Password:

You will be required a username and password to authenticate and upload your file. In the meantime, please request credentials by sending an email to [e-mail]

Report Scheduling

We recommend at a minimum you send your file across daily first thing in the morning around 6am and for more accurate inventory reflective of your store to schedule reports a few times throughout the day such as noon and before close to reflect any changes of inventory through sales.