Project Overview

graph TD
    Company[Company: Supplier/Customer] -->|sells| Product[Product Catalog]
    Company -->|issues| Invoice[Purchase Invoice]
    Invoice -->|has| Item[Line Items]
    Item -->|links| Product
    Invoice -->|triggers| STOCK[Stock Adjustment]
    STOCK -->|logs| Transaction[Inventory Transactions]
    Transaction -->|updates| CachedQty[Quantity on Hand]
    Invoice -->|receives| Payment[Payments]

Key Business Components

1. Companies: Distinct from users; represent business entities.
2. Products: Catalog with SKUs and cached stock levels.
3. Invoices: Bills received from suppliers; status updates via payments.
4. Channels: Multi-instance e-commerce integrations (WooCommerce, Amazon, Shopify).
5. Apps: Logistics/SMS/Payment integrations with shared config registry.

Common Patterns

• Registry System: Add new channels or apps by adding a TypeScript object in the registry. No DB migration is needed.
• JSONB Config: Encrypted credentials and dynamic fields are stored in a single JSONB column, validated by Zod schemas generated on the fly.
• Sync/Publish Queue: Changes to channel items are staged as a log (channel_product_changelog) and pushed to marketplaces using a minimal "latest wins" delta merge logic.