┌─────────────────────────────────────────────────────────────────────────┐
│                      DROPSHIP NETWORK                                    │
├─────────────────────────────────────────────────────────────────────────┤
│                                                                          │
│   Customer Order                                                         │
│        │                                                                 │
│        ▼                                                                 │
│   ┌─────────────────┐                                                   │
│   │  Fulfillment    │                                                   │
│   │    Router       │                                                   │
│   └────────┬────────┘                                                   │
│            │                                                             │
│   ┌────────┼────────┬────────────┐                                      │
│   ▼        ▼        ▼            ▼                                      │
│ SUPLIFUL  COLLECTIVE  DIGITAL   MANUAL                                  │
│ (POD/WL)  (Curated)  (Instant)  (Custom)                               │
│                                                                          │
└─────────────────────────────────────────────────────────────────────────┘

// Supliful order creation
const createSuplifulOrder = async (shopifyOrder: ShopifyOrder) => {
  const suplifulItems = shopifyOrder.line_items.filter(
    item => item.vendor === 'supliful'
  );

  if (suplifulItems.length === 0) return null;

  // Create order via Supliful API
  const response = await supliful.orders.create({
    external_id: shopifyOrder.id,
    shipping_address: shopifyOrder.shipping_address,
    items: suplifulItems.map(item => ({
      sku: item.sku,
      quantity: item.quantity
    }))
  });

  // Record fulfillment
  await supabase.from('supliful_fulfillments').insert({
    shopify_order_id: shopifyOrder.id,
    supliful_order_id: response.id,
    status: 'pending'
  });

  return response;
};

Collective Partner Store
        │
        ▼
  Product Catalog API
        │
        ▼
  ┌─────────────────┐
  │ collective_     │
  │ products        │
  └────────┬────────┘
           │
           ▼
  Shopify Product Sync
        │
        ▼
  Published to Store

Purchase Complete
       │
       ▼
┌─────────────────┐
│ digital_        │
│ deliveries      │
│ (create record) │
└────────┬────────┘
         │
         ▼
  Generate Access
  (URL, license key)
         │
         ▼
  Email Customer
  (instant delivery)
         │
         ▼
  Update Shopify
  (fulfilled status)

-- Margin analysis by product source
SELECT
  CASE
    WHEN p.vendor = 'supliful' THEN 'Supliful'
    WHEN p.vendor = 'collective' THEN 'Collective'
    WHEN p.product_type = 'digital' THEN 'Digital'
    ELSE 'Other'
  END as source,
  COUNT(*) as orders,
  SUM(o.total_price) as revenue,
  SUM(o.total_price - o.total_cost) as gross_profit,
  ROUND(
    SUM(o.total_price - o.total_cost) / NULLIF(SUM(o.total_price), 0) * 100,
    2
  ) as margin_pct
FROM shopify_orders o
JOIN shopify_products p ON o.product_id = p.id
WHERE o.created_at > NOW() - INTERVAL '30 days'
GROUP BY 1
ORDER BY revenue DESC;