Store

Shopify Store
     ↓ (webhook sync)
shopify_products / shopify_orders / shopify_customers
     ↓
Available to all apps:
- Publisher (sidebar widgets)
- Platform (creator storefronts)
- Agency (client fulfillment)
- Jarvis (order queries)

// Webhook handler
export async function handleProductUpdate(product: ShopifyProduct) {
  await supabase
    .from('shopify_products')
    .upsert({
      shopify_id: product.id,
      name: product.title,
      price: product.variants[0].price,
      inventory_count: product.variants[0].inventory_quantity,
      updated_at: new Date().toISOString()
    });
}

SELECT name, image_url, price 
FROM shopify_products 
WHERE vertical = 'travel' AND in_stock = true
LIMIT 4;

-- "What orders came in today?"
SELECT customer_name, total, status
FROM shopify_orders
WHERE created_at::date = CURRENT_DATE;

SELECT * FROM shopify_products
WHERE creator_id = 'creator-uuid';