Local-First Architecture
United Commerce operates as a local binary that orchestrates synchronization from multiple commerce APIs (Amazon Seller, Shopify Admin, Stripe, etc.) into a locally hosted DuckDB or PostgreSQL file storage database inside your Virtual Private Cloud (VPC).
Quickstart CLI
curl -sSf https://get.unitedcommerce.cc | sh unitedcommerce init --local
This initializes a local database catalog and generates a schema mapping config in your current workspace directory.
Standard DDL schema
Our DDL includes ready-to-query unified transaction models:
CREATE TABLE unified_orders ( order_id VARCHAR PRIMARY KEY, channel VARCHAR, -- 'shopify', 'amazon', 'stripe' gross_amount DECIMAL(12, 2), net_amount DECIMAL(12, 2), currency VARCHAR, created_at TIMESTAMP );