Shopify Integration

1// n8n/Make Workflow: Shopify → Invoice-api.xhub
2 
3// 1. Trigger: Shopify Webhook (orders/paid)
4// 2. Transform: Shopify → Invoice-api.xhub Format
5// 3. Action: POST https://service.invoice-api.xhub.io/api/v1/invoice/de/xrechnung/generate
6 
7// Compute items with all required fields
8const items = shopifyOrder.line_items.map((item, index) => {
9  const unitPrice = parseFloat(item.price);
10  const taxRate = 19;
11  const netAmount = unitPrice * item.quantity;
12  const taxAmount = Math.round(netAmount * taxRate) / 100;
13  const grossAmount = netAmount + taxAmount;
14  return {
15    position: index + 1,
16    description: item.title,
17    quantity: item.quantity,
18    unit: "C62", // UN/ECE Rec 20: Stück — Klartext wie "piece" fällt bei BR-CL-23 durch
19    unitPrice,
20    taxRate,
21    netAmount,
22    taxAmount,
23    grossAmount,
24  };
25});
26 
27const subtotal = items.reduce((sum, i) => sum + i.netAmount, 0);
28const totalTax = items.reduce((sum, i) => sum + i.taxAmount, 0);
29 
30const payload = {
31  invoice: {
32    invoiceNumber: `SHOP-${shopifyOrder.id}`,
33    type: "invoice",
34    issueDate: new Date().toISOString().slice(0, 10),
35    dueDate: new Date(Date.now() + 30 * 86400000).toISOString().slice(0, 10),
36    currency: "EUR",
37    seller: {
38      name: "Your Shop Name",
39      vatId: "DE123456789",
40      street: "Shopstraße 1",
41      city: "Hamburg",
42      postalCode: "20095",
43      countryCode: "DE",
44      // BR-DE-2 requires a seller contact; BR-DE-6 its phone number. Leaving
45      // both out is the most common reason a first XRechnung is rejected.
46      email: "rechnung@your-shop.de",
47      phone: "+49 40 1234567",
48    },
49    buyer: {
50      name: shopifyOrder.billing_address.company,
51      vatId: shopifyOrder.customer.tax_id,
52      street: shopifyOrder.billing_address.address1,
53      city: shopifyOrder.billing_address.city,
54      postalCode: shopifyOrder.billing_address.zip,
55      countryCode: shopifyOrder.billing_address.country_code,
56    },
57    countrySpecific: {
58      countryCode: "DE",
59      buyerReference: "SHOP-LEITWEG-ID",
60    },
61    items,
62    subtotal,
63    total: subtotal + totalTax,
64    taxSummary: [{ taxRate: 19, netAmount: subtotal, taxAmount: totalTax }],
65    paymentTerms: { dueDays: 30, description: "Payable within 30 days" },
66  },
67};
68 
69const response = await fetch(
70  "https://service.invoice-api.xhub.io/api/v1/invoice/de/xrechnung/generate",
71  {
72    method: "POST",
73    headers: {
74      "Content-Type": "application/json",
75      Authorization: "Bearer sk_live_xxxxxxxxxxxxxxxxxxxx",
76    },
77    body: JSON.stringify(payload),
78  }
79);