Dutchie Lite
Dutchie is a unified platform providing e-commerce, POS, payments, and marketing tools to streamline operations for cannabis dispensaries.
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | check | CASH_SUMMARY, CLOSING_REPORT, CUSTOMER, INVENTORY_SNAPSHOT, PRODUCT, REGISTER_ADJUSTMENT, REGISTER_TRANSACTION, and TRANSACTION. |
| History mode | ||
| Custom data | ||
| Data blocking | check | |
| Column hashing | check | |
| Re-sync | check | |
| API configurable | check | API configuration |
| Priority-first sync | ||
| Fivetran data models | ||
| Private networking | ||
| Authorization via API |
Supported deployment models
We support the SaaS and Hybrid deployment models for the connector.
You must have an Enterprise or Business Critical plan to use the Hybrid Deployment model.
Setup guide
Follow our step-by-step Dutchie setup guide to connect Dutchie with your destination using Fivetran connectors.
Sync overview
To capture new records, we incrementally sync the following tables:
CASH_SUMMARYCLOSING_REPORTCUSTOMERINVENTORY_SNAPSHOTPRODUCTREGISTER_ADJUSTMENTREGISTER_TRANSACTIONTRANSACTION
We re-import the remaining tables during every sync.
Schema information
This schema applies to all Dutchie connections.
Explore Dutchie schema ERD
Limitations
The Dutchie API allows us to only sync:
- last 6 days' worth of data for the
CASH_SUMMARYtable - last 31 days' worth of data for the
CLOSING_REPORTtable - last 2 months' worth of data for the
TRANSACTIONtable - last 5 months' worth of data for the
INVENTORY_SNAPSHOTtable