SFTP File Uploads

How to push data to Toolio via SSH File Transfer Protocol

Updated over a week ago

You can push files directly from your data warehouse into Toolio via SFTP into Toolio's Azure Storage.

Requirements

To setup Automated CSV Feeds, you will need to attain the following information from your Customer Success manager.

  • Connection String (username@hostname)

  • Password

  • Storage Container/Import Folder

Please keep in mind that the protocol must be SFTP and Port should be set to 22 when transferring the data.
โ€‹

File Naming Convention

Filenames sent to Toolio should follow the naming convention below:

{prefix}_{epoch time}.csv

Where, prefix refers to the data model and is followed by epoch time in seconds. Below are the different prefixes for the different data models

Prefixes

Data Model

Prefix

Product

products

Inventory

inventory

Sale

sales

Purchase Order

purchase_orders

Receipt (if applicable)

receipts

Bookings

bookings

Bundles

bundles

Location

location

Transfer Order

transfer_order

Examples

  • products_1588799741.csv

  • inventory_1588799764.csv

File Format

Encoding

Your CSV files must use UTF-8 encoding.

Header Line

First line in the file has to be the header line. Toolio uses header names to match values to Toolio data models. For each data model, header names will match either a core field already defined on the Toolio data models or a custom attribute that have been previously defined on the Toolio platform.

For example, for the Product Data model, you can use the header names, product_id or variant_id since these are core fields, but to pass in category as a field name, it first has to be configured as a custom attribute on Toolio.

Input Lines

Each line following the header line is an input line and should include all values in the order specified in the header line.

Data Model Format

Related Articles

Did this answer your question?