5. Integrate orders and inventory
Mix and match ecommerce 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 ecommerce platform, sFTP, or a data warehouse, Dema supports hybrid setups to ensure your data flows seamlessly.
Supported integration types
- Ecommerce platforms: Shopify, Centra, Commercetools.
- sFTP: Sync files for orders, inventory, and returns directly from your system.
- Data warehouses: Snowflake, BigQuery, or custom pipelines.
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.
Connect your ecommerce platform
Dema integrates with popular ecommerce platforms to streamline order and inventory tracking.
Platforms supported
- Shopify: Set up in minutes with our Shopify guide.
- Centra: Learn how to connect Centra in our Centra guide.
- Commercetools: Follow instructions in our Commercetools guide.
Data synced from ecommerce 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 seamlessly with Snowflake or BigQuery.
Supported warehouses
- Snowflake: Set up with our Snowflake guide.
- BigQuery: Learn more in our BigQuery guide.
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.
Data warehouses are perfect for centralizing data from multiple sources, allowing Dema to use it for profitability calculations and operational insights.
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 ecommerce 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.
For detailed instructions, visit our sFTP integration guide.
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.
Best practice: Use webhooks for real-time updates and nightly batch jobs for completeness.
Setting up your integrations
-
Choose your data source(s):
Decide if you’ll use ecommerce platforms, sFTP, data warehouses, or a combination. -
Follow the guides:
Each integration type has its own setup process: -
Verify data flow:
Check the Dema dashboard to ensure orders, inventory, and returns are syncing correctly. -
Optimize your setup:
Use multiple sources to get the most accurate and complete data for your operations.