> ## Documentation Index
> Fetch the complete documentation index at: https://docs.dema.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Integrate orders and inventory

> Mix and match e-commerce platforms, sFTP, and data warehouses to sync orders, inventory, and returns seamlessly with Dema.

## Flexible data integration

Dema allows you to combine multiple data sources to fit your business needs. Whether you rely on an e-commerce platform, sFTP, or a data warehouse, Dema supports hybrid setups to ensure your data flows seamlessly.

### Supported integration types

* **E-commerce platforms**: Shopify, Centra, Commercetools.
* **sFTP**: Sync files for orders, inventory, and returns directly from your system.
* **Data warehouses**: Snowflake, Databricks, Google BigQuery, or custom pipelines.

<Info>
  **Mix and match**: For example, you can fetch order data via sFTP, inventory data from Shopify, and marketing costs from your data warehouse. Dema adapts to your workflow.
</Info>

***

## Connect your e-commerce platform

Dema integrates with popular e-commerce platforms to streamline order and inventory tracking.

### Platforms supported

* **Shopify**: Set up in minutes with our [Shopify guide](/integrations/ecommerce/shopify).
* **Centra**: Learn how to connect Centra in our [Centra guide](/integrations/ecommerce/centra).
* **Commercetools**: Follow instructions in our [Commercetools guide](/integrations/ecommerce/commercetools).

### Data synced from e-commerce platforms

* **Orders**: IDs, customer details, purchased items, timestamps, shipping, statuses, and taxes.
* **Inventory**: Product and variant IDs, attributes, stock levels, and COGS.
* **Returns**: Quantities, reasons, and refund statuses.
* **Incoming deliveries**: If supported by the platform, track shipments to predict stock availability.

***

## Connect your data warehouse

Data warehouses allow advanced reporting and data centralization. Use Dema to sync with Snowflake, Databricks, or Google BigQuery.

### Supported warehouses

* **Snowflake**: Set up with our [Snowflake guide](/integrations/datawarehouse/snowflake).
* **Databricks**: Follow our [Databricks guide](/integrations/datawarehouse/databricks).
* **Google BigQuery**: Follow our [Google BigQuery guide](/integrations/datawarehouse/bigquery).

### What can be synced from a warehouse?

* **Orders**: IDs, customer details, purchased items, timestamps, shipping, statuses, and taxes.
* **Inventory**: Product and variant IDs, attributes, stock levels, and COGS.
* **Returns**: Quantities, reasons, and refund statuses.
* **Incoming deliveries**: If supported by the platform, track shipments to predict stock availability.

<Info>
  Data warehouses are perfect for centralizing data from multiple sources, allowing Dema to use it for profitability calculations and operational insights.
</Info>

***

## Connect via sFTP

Dema’s sFTP integration is ideal for businesses with custom systems or specific export requirements.

### What data can you sync via sFTP?

* **Orders**: IDs, customer details, purchased items, timestamps, shipping, statuses, and taxes.
* **Inventory**: Product and variant IDs, attributes, stock levels, and COGS.
* **Returns**: Quantities, reasons, and refund statuses.
* **Incoming deliveries**: If supported by the platform, track shipments to predict stock availability.

### When to use sFTP?

* Your e-commerce platform lacks direct integration with Dema.
* You have a legacy system or custom database exporting data files.
* You want additional control over the data you provide.

<Info>
  For detailed instructions, visit our [file transfer guide](/integrations/datawarehouse/fileTransfer).
</Info>

***

## Batch vs. webhook ingestion

Dema combines real-time and scheduled updates to ensure your data is always fresh.

### Webhooks (real-time updates)

* Ideal for instant order updates.
* Supported by Shopify, Centra, and Commercetools.

### Batch processing (nightly sync)

* Captures any missing or delayed updates.

<Info>
  **Best practice**: Use webhooks for real-time updates and nightly batch jobs for completeness.
</Info>

***

## Setting up your integrations

1. **Choose your data source(s)**:\
   Decide if you’ll use e-commerce platforms, sFTP, data warehouses, or a combination.

2. **Follow the guides**:\
   Each integration type has its own setup process:
   * [E-commerce platforms](/integrations/ecommerce/overview)
   * [File transfer (sFTP and Azure Blob)](/integrations/datawarehouse/fileTransfer)
   * [Data warehouse overview](/integrations/datawarehouse/overview), [Snowflake](/integrations/datawarehouse/snowflake), [Databricks](/integrations/datawarehouse/databricks), and [BigQuery](/integrations/datawarehouse/bigquery)

3. **Verify data flow**:\
   Check the Dema dashboard to ensure orders, inventory, and returns are syncing correctly.

4. **Optimize your setup**:\
   Use multiple sources to get the most accurate and complete data for your operations.