Data & Integrations
Toolio seamlessly integrates with most common commerce systems and provides open integration endpoints. See below for more information.
Integration GuideThis document covers key principles around how to structure your data and how to integrate your data sources with Toolio.
Managing IntegrationsWithin Toolio, we have made managing your integrations easy - this help article covers common integration management workflows in Toolio.
Import TemplatesImport templates show the expected data fields for the model you are importing.
Sharing Integration CredentialsPlease see below for recommendations on sharing any account credentials for integration setup.
Core Attribute FAQsBelow are FAQs for Core Attributes in Core Models
Integration FAQsPlease see frequently asked questions about Toolio Integration below.
Using Import Filters in ToolioYou can apply an import filter to files you are ingesting into Toolio to filter out data based on specific criteria
Data EnrichmentIf you are missing specific measures on your Sales and Inventory feeds, Toolio can enrich that data using your product feed.
Import Status and Error DiagnosticsUsing the import status grid you can see all past imports into Toolio and diagnose import errors.
Post Import Data Validation for Merchandise PlanningHow to validate your imported data during MP onboarding
Pre-Import Validation WorksheetGuide to filling out the Pre-Import Validation Worksheet
Manual ImportsPlease see below for how to import data into Toolio manually. This is an important step during data validation.
Item Plan Data ValidationA guide to validating your Item level data during the Item Plan module onboarding process
Viewing & Managing Data ImportsLearn more about how to view and manage your imported files
Creating a Custom Product Group
Managing Imported DataYou can view and manage all the raw data imported into Toolio by going through Account > Models
Scheduled Reports DeliveriesHow to schedule report deliveries to email on a Monthly, Weekly, Daily or Custom recurrence.
Toolio / Slack IntegrationUsing scheduled report deliveries you can schedule have your reports delivered to appropriate slack channels so that you don't miss a beat
Configuring and Managing ExportersHow to configure an exporter in Toolio for S3, NetSuite, and Manual Export Workflows
Automated Plan ExportsToolio supports automated exports of plans built in Toolio to a destination of your choice.
Export Data from ModelsReference these steps to export your data from Data Models.
Data Validation FAQsFrequently asked questions and troubleshooting tips for Data Validation
Refreshing DataHere's how to refresh your data if you have updated historical values or changed your product attributes
SFTP File UploadsHow to push data to Toolio via SSH File Transfer Protocol
Google Sheets integrationIf you are using Google Sheets as your source of record for SKU Master or Purchase Orders, you can integrate Google Sheets to Toolio.
Automated CSV FeedsHow to integrate with Toolio using automated CSV feeds sent to Toolio's Azure Storage.
Google BigQuery IntegrationIntegrate Toolio with your Google BigQuery data warehouse
Syncing Data & PaginationThis article explains the details of how Toolio syncs data with integrated datawarehouses.
Amazon Redshift IntegrationIntegrate Toolio with your Amazon Redshift data warehouse
Snowflake IntegrationIntegrate Toolio with your Snowflake data warehouse
Looker IntegrationIntegrate your Looker for BI instance through Scheduled Data Deliveries
NetSuite IntegrationToolio supports out of the box integration with NetSuite. Please follow the steps to connect your NetSuite instance with Toolio
NetSuite Integration - Toolio Saved SearchesThis document will provide a step-by-step guide on how to create a saved search.
Troubleshooting NetSuite Saved Search DeploymentsHow to troubleshoot and address issues with your NetSuite Saved Search Delivery to Toolio
Shopify IntegrationIntegrate your Shopify instance through Shopify Private Apps
Exchanges via ShopifyHow Exchanges are handled in Toolio when Using a Returns Solution (i.e. Loop Returns, Happy Returns) via Shopify
Markdowns via ShopifyHow Toolio captures markdown data from Shopify sales