Skip to main content
Automated CSV Feeds

How to integrate with Toolio using automated CSV feeds sent to Toolio's Azure Storage.

Updated over a week ago

Automated CSV Feeds enable integrating any data source into Toolio via sending CSV feeds to Toolio's Azure Storage programmatically. This is very similar to sharing data feeds via FTP uploads.


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

  • Azure Storage Account Name

  • Access Key

Additionally, you will need AzCopy library from Azure to be able to trigger these feeds.

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


Data Model








Purchase Order





  • products_1588799741.csv

  • inventory_1588799764.csv

File Format


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


How can I escape special characters like , in my data feed?

If you have special characters like , in your data feed, for example, supplier names like Acme, Co or product names like Cool, White Shirt, these can cause issues while importing CSVs and need to be properly escaped.
You need to make sure that values with commas in them need to be escaped by quotes. You can read more about this here, and below is an example of how escaping looks.


SKU, Title, Color
1, Cool, White Shirt, White
2, Black Shirt, Black

As you can see, the above CSV feed will cause issues while being imported, because SKU-1 will appear as 4 columns. It should be fixed as follows.

After Escaping

SKU, Title, Color
1, "Cool, White Shirt", White
2, Black Shirt, Black

Which date formats do Toolio support?

We support YYYY/MM/DD, MM/DD/YYYY, and ISO Date formats.

Related Articles

Did this answer your question?