Documentation

ChatPilot

Orders

Order lifecycle, items JSON, and conversation linkage.

orders stores items JSONB, total_amount, platform_fee, woocommerce_order_id, and capi_fired.

Lifecycle: pending, confirmed, paid, fulfilled.

const items = [{product_id: 'prod_123', name: 'Starter bundle', quantity: 1, unit_price: 2500}];