How to Integrate ShipBob with V0

1// app/api/shipbob/orders/route.ts
2import { NextRequest, NextResponse } from 'next/server';
3
4const SHIPBOB_API = 'https://api.shipbob.com/1_0';
5
6async function shipbobFetch<T>(
7  path: string,
8  params?: Record<string, string>
9): Promise<T> {
10  const token = process.env.SHIPBOB_ACCESS_TOKEN;
11  if (!token) throw new Error('SHIPBOB_ACCESS_TOKEN is not configured');
12
13  const url = new URL(`${SHIPBOB_API}${path}`);
14  if (params) {
15    Object.entries(params).forEach(([k, v]) => url.searchParams.set(k, v));
16  }
17
18  const response = await fetch(url.toString(), {
19    headers: {
20      Authorization: `Bearer ${token}`,
21      'Content-Type': 'application/json',
22    },
23  });
24
25  if (response.status === 401) {
26    throw new Error('Invalid ShipBob API token — check SHIPBOB_ACCESS_TOKEN');
27  }
28  if (response.status === 429) {
29    throw new Error('ShipBob API rate limit exceeded — retry after a moment');
30  }
31  if (!response.ok) {
32    const text = await response.text();
33    throw new Error(`ShipBob API error ${response.status}: ${text}`);
34  }
35
36  return response.json() as Promise<T>;
37}
38
39interface ShipBobOrder {
40  id: number;
41  order_number: string;
42  created_date: string;
43  status: string;
44  recipient: { name: string; email: string };
45  shipments: Array<{
46    id: number;
47    status: string;
48    tracking_number: string;
49    estimated_delivery_date: string;
50  }>;
51  products: Array<{ name: string; quantity: number }>;
52}
53
54export async function GET(request: NextRequest) {
55  const { searchParams } = new URL(request.url);
56  const status = searchParams.get('status');
57  const page = searchParams.get('page') || '1';
58  const limit = searchParams.get('limit') || '50';
59
60  const params: Record<string, string> = { Page: page, Limit: limit };
61  if (status) params.Status = status;
62
63  try {
64    const data = await shipbobFetch<{
65      data: ShipBobOrder[];
66      total_count: number;
67      page_count: number;
68    }>('/order', params);
69
70    const orders = data.data.map(o => ({
71      id: o.id,
72      orderNumber: o.order_number,
73      createdAt: o.created_date,
74      status: o.status,
75      customerName: o.recipient?.name || 'Unknown',
76      itemCount: o.products.reduce((sum, p) => sum + p.quantity, 0),
77      trackingNumber: o.shipments?.[0]?.tracking_number || null,
78      estimatedDelivery: o.shipments?.[0]?.estimated_delivery_date || null,
79    }));
80
81    return NextResponse.json({
82      orders,
83      totalCount: data.total_count,
84      pageCount: data.page_count,
85    });
86  } catch (error) {
87    const message = error instanceof Error ? error.message : 'Unknown error';
88    console.error('ShipBob orders error:', message);
89    return NextResponse.json({ error: message }, { status: 500 });
90  }
91}

1// app/api/shipbob/inventory/route.ts
2import { NextRequest, NextResponse } from 'next/server';
3
4const SHIPBOB_API = 'https://api.shipbob.com/1_0';
5
6interface InventoryItem {
7  id: number;
8  name: string;
9  sku: string;
10  fulfillment_center_quantities: Array<{
11    fulfillment_center: { id: number; name: string };
12    onhand_quantity: number;
13    committed_quantity: number;
14    sellable_quantity: number;
15  }>;
16}
17
18export async function GET(request: NextRequest) {
19  const token = process.env.SHIPBOB_ACCESS_TOKEN;
20  if (!token) {
21    return NextResponse.json(
22      { error: 'SHIPBOB_ACCESS_TOKEN is not configured' },
23      { status: 500 }
24    );
25  }
26
27  const { searchParams } = new URL(request.url);
28  const lowStockThreshold = parseInt(
29    searchParams.get('threshold') || '10',
30    10
31  );
32
33  try {
34    const response = await fetch(
35      `${SHIPBOB_API}/inventory?Limit=250`,
36      {
37        headers: {
38          Authorization: `Bearer ${token}`,
39          'Content-Type': 'application/json',
40        },
41      }
42    );
43
44    if (!response.ok) {
45      throw new Error(`ShipBob API error: ${response.status}`);
46    }
47
48    const data = await response.json();
49    const items: InventoryItem[] = data.data || [];
50
51    const inventory = items.map(item => {
52      const totalOnhand = item.fulfillment_center_quantities.reduce(
53        (sum, fc) => sum + fc.onhand_quantity,
54        0
55      );
56      const totalSellable = item.fulfillment_center_quantities.reduce(
57        (sum, fc) => sum + fc.sellable_quantity,
58        0
59      );
60
61      return {
62        id: item.id,
63        name: item.name,
64        sku: item.sku,
65        totalOnhand,
66        totalSellable,
67        isLowStock: totalSellable < lowStockThreshold,
68        isOutOfStock: totalSellable === 0,
69        byLocation: item.fulfillment_center_quantities.map(fc => ({
70          locationName: fc.fulfillment_center.name,
71          onhand: fc.onhand_quantity,
72          sellable: fc.sellable_quantity,
73          committed: fc.committed_quantity,
74        })),
75      };
76    });
77
78    const summary = {
79      total: inventory.length,
80      inStock: inventory.filter(i => !i.isLowStock && !i.isOutOfStock).length,
81      lowStock: inventory.filter(i => i.isLowStock && !i.isOutOfStock).length,
82      outOfStock: inventory.filter(i => i.isOutOfStock).length,
83    };
84
85    return NextResponse.json({ inventory, summary });
86  } catch (error) {
87    const message = error instanceof Error ? error.message : 'Unknown error';
88    return NextResponse.json({ error: message }, { status: 500 });
89  }
90}