Skip to main content

Integration Setup

Integrations connect Tether to your external systems, automatically syncing sales orders, inventory, products, and other data.
Integration setup requires Admin access. Contact your administrator if you need to set up integrations.

Why Integrate?

BenefitDescription
Automated Data FlowNo manual data entry
Scheduled SyncData stays current with cron-based scheduling
Reduced ErrorsEliminate manual mistakes
Time SavingsFocus on analysis, not data entry

Supported External Services

Tether connects to external systems through the ingestion service. The following external services are currently supported:
External ServiceDescription
ShopifyE-commerce platform for sales orders and products
BigQueryGoogle Cloud data warehouse for sales history and other data
RedshiftAWS data warehouse for sales history and other data
TrackStarWarehouse management system for inventory data
BrewmanBrewery management system
The available external services and their supported capabilities are loaded dynamically from the system metadata. New services may be added without requiring a documentation update.

Data Types (Capabilities)

Each external service supports a subset of the following data types that can be synced:
Data TypeDescription
Sales OrdersIndividual sales order records
Sales HistoryAggregated historical sales data
Pending SalesOrders not yet completed
Warehouse InventoryStock levels from warehouse systems
ProductsProduct and SKU information
ChannelsChannel configuration data
PricingPricing information
Forecast VersionsForecast data
Sales ForecastSales forecast data
When creating an integration, you select which data types (capabilities) to enable based on what the chosen external service supports.

Setting Up an Integration

General Setup Flow

1

Navigate to Integrations

Go to Integrations in the sidebar
2

Click Create Integration

Click the Create Integration button to open the setup dialog
3

Enter Basic Information

FieldRequiredDescription
Integration NameYesA descriptive name (e.g., “Shopify Production”)
External ServiceYesSelect from the dropdown of available services
4

Configure Schedule

Set the sync schedule:
FieldDefaultDescription
Cron Expression0 0 0 * * *When the sync runs (daily at midnight by default)
TimezoneUTCTimezone for the cron schedule
5

Select Capabilities

Check the data types you want to sync. The available options depend on the selected external service. Each capability shows a display name and description.
6

Enter Credentials

Provide the required credentials for the selected service. The credential fields are dynamic — each service defines its own required fields (e.g., API keys, store URLs, access tokens).
7

Create

Click Create Integration to save. You will be navigated to the integration detail page.

Shopify Integration

To connect a Shopify store:
1

Create Integration

Click Create Integration and select Shopify as the external service
2

Enter Credentials

Provide the required Shopify credentials:
CredentialDescription
Store URLYour Shopify store URL (e.g., your-store.myshopify.com)
Admin API Access TokenGenerated from Shopify Admin → Settings → Apps and sales channels
3

Select Capabilities

Choose which data types to sync (e.g., sales orders, products)
4

Set Schedule

Configure the cron expression for sync frequency. A daily sync is recommended for most use cases.
5

Create and Enable

Create the integration. It will be enabled by default and begin syncing on the configured schedule.
Shopify sync details:
  • Uses the Shopify GraphQL Admin API to fetch orders
  • Syncs new and updated orders since the last sync
  • Filters orders by financial status (paid, partially refunded)
  • Maps Shopify SKUs to Tether SKUs via external ID matching

Data Warehouse Integrations (BigQuery / Redshift)

For importing data from data warehouses:
1

Create Integration

Select BigQuery or Redshift as the external service
2

Enter Connection Credentials

Provide the required database connection details as prompted by the credential fields
3

Select Data Types

Choose which data types to import (e.g., sales history, products, pricing)
4

Configure Schedule

Set the cron expression for how often to pull data

Warehouse Integration (TrackStar)

For syncing inventory data from warehouse management systems:
1

Create Integration

Select TrackStar as the external service
2

Enter Credentials

Provide the required TrackStar API credentials
3

Select Capabilities

Enable Warehouse Inventory and any other supported data types
4

Configure Schedule

Set the sync frequency using a cron expression

Integration Configuration

Schedule Settings

Integrations use cron expressions for scheduling with timezone support:
SettingDescriptionExample
Cron ExpressionStandard 6-field cron format0 0 0 * * * (daily at midnight)
TimezoneIANA timezone for the scheduleAmerica/New_York, Europe/London, UTC
Common cron patterns:
ScheduleCron Expression
Daily at midnight0 0 0 * * *
Every 6 hours0 0 */6 * * *
Every hour0 0 * * * *

Capabilities

Capabilities define which data types the integration syncs. You can enable or disable individual capabilities from the integration detail page after creation.

Dry Run Mode

Integrations can operate in dry run mode, which validates data mapping without saving any data to Tether. This is useful for:
  • Verifying field mappings before going live
  • Testing new integration configurations
  • Debugging data quality issues

Managing Integrations

Integration Dashboard

The integrations dashboard shows all configured integrations with:
ColumnDescription
NameIntegration display name
External ServiceThe connected platform (e.g., Shopify, BigQuery)
StatusEnabled or disabled
Last SyncWhen the integration last ran
Next SyncWhen the next scheduled sync will occur
CapabilitiesWhich data types are configured

Integration Detail Page

Click on an integration to view its detail page, which includes:
  • Integration info: Name, external service, enabled status, dry run mode
  • Schedule settings: Cron expression and timezone (editable)
  • Capabilities: List of enabled data types (editable)
  • Sync execution history: Table of past sync runs with status, domain type, duration, and record counts

Enabling / Disabling an Integration

Toggle the integration’s enabled status from the integration detail page or the dashboard. Disabling an integration stops all scheduled syncs but preserves the configuration.

Triggering a Manual Sync

From the integration detail page, click Trigger Sync to run an immediate sync outside the regular schedule.

Resetting Sync State

This action is only available to administrators. Resetting sync state deletes all execution history for the integration and forces the next sync to perform a full data fetch.
Use Reset Sync State when you need to re-import all data from scratch, such as after fixing a mapping issue.

Deleting an Integration

To permanently remove an integration:
  1. Navigate to the integration detail page
  2. Click Delete Integration
  3. Confirm the deletion
Deleting an integration removes all its configuration and sync history. Historical data already synced to Tether is preserved.

Credential Management

Each external service defines its own credential fields. Credentials are entered during integration creation and stored securely.
AspectDetails
Dynamic FieldsCredential fields vary by service — the form adapts automatically
Field TypesText fields, number fields, with labels and placeholders
Required FieldsMarked with an asterisk (*) in the form
SecurityCredentials are stored securely and not displayed after creation

Integration Best Practices

Before enabling a new integration for production use:
  • Run in dry run mode to validate mappings
  • Review the sync execution results for errors
  • Check for unmapped SKUs or channels
After enabling:
  • Watch the first few sync executions
  • Verify data accuracy in Tether
  • Check for failed or skipped records
Set sync frequency based on your needs:
  • Daily syncs are sufficient for most sales data
  • More frequent syncs for real-time inventory needs
  • Consider API rate limits of the external service
Periodically check:
  • Sync execution history for failures
  • Credential validity
  • Data quality and completeness

Multiple Integrations

Managing Multiple Sources

You can create multiple integrations, even for the same external service:
  • Each integration has its own schedule and capabilities
  • Data flows to appropriate channels based on mapping
  • All data is consolidated within Tether

Integration Architecture Options

Tether supports different integration architectures depending on your needs:
PatternDescription
Individual Channel IntegrationsOne integration per sales channel (e.g., one Shopify integration per store)
Centralized ERP IntegrationA single ERP or data warehouse integration that provides all sales data
HybridCombination of direct channel integrations and centralized data sources
See Sync Sessions for details on monitoring your integrations.

Next Steps

Sync Sessions

Monitor sync activity

Troubleshooting

Resolve integration issues

Channels

Manage sales channels

User Access

Control integration access