Multi-Channel E-Commerce Finance: Shopify + Amazon + WooCommerce

Typical Swiss E-Commerce Setup:

Channel 1: Shopify (Haupt-Shop, 60% Revenue)
Channel 2: Amazon.de (Marketplace, 30% Revenue)
Channel 3: WooCommerce (B2B Shop, 10% Revenue)

Finance Chaos without Automation:

3 separate accounting systems (Shopify → Excel, Amazon → Excel, WooCommerce → Excel)
Manual MWST-Berechnung (CH 8.1%, EU variable rates per country)
No Inventory-Sync (Overselling risk)
No Channel-Profitability (which channel is profitable?)

Zeit: 50 Std./Monat (Finance-Admin)

With Automation:

Unified Accounting: All channels → Bexio (auto-sync)
Automatic MWST: CH 8.1%, EU OSS (One-Stop-Shop)
Real-Time Inventory: Sync across all channels
Profitability Dashboard: Revenue, COGS, Margin per channel (Power BI)

Zeit: 5 Std./Monat (only review)

Savings: 45 Std./Monat = CHF 3,600/Monat

In diesem Guide:

Multi-Channel Finance Challenges (MWST, Currency, Inventory)
Channel-Breakdown: Shopify, Amazon, WooCommerce (how to integrate each)
MWST-Automation: CH 8.1% + EU OSS
Inventory-Sync: Real-Time Stock Updates
Profitability-Tracking: Which channel makes money?
Tools-Stack: Bexio, Make.com, Power BI (CHF 500-1,500/Mo)

Multi-Channel Finance Challenges

Problem 1: MWST-Komplexität (CH + EU)

CH Inland:

Standard-Rate: 8.1% (most products)
Reduced-Rate: 2.6% (Food, Books, Medicines)
Schwelle: MWST-Registrierung ab CHF 100,000 Umsatz

EU Fernverkauf:

Schwelle: €10,000/Jahr (dann OSS-Registrierung erforderlich)
OSS (One-Stop-Shop): Zentrale Abrechnung für alle EU-Länder
Rates: Variable (DE 19%, FR 20%, IT 22%, etc.)

Problem: Manuelle Berechnung = Fehlerrisiko (Strafen bis CHF 250,000)

Problem 2: Multi-Currency Accounting

Channels:

Shopify: CHF + EUR + USD
Amazon.de: EUR (converted to CHF for accounting)
WooCommerce: CHF

Problem: FX-Umrechnung (Shopify EUR sales → CHF accounting)

Example:

Sale: €100 (Amazon.de)
FX-Rate: 1.05 CHF/EUR (at time of sale)
CHF Revenue: €100 × 1.05 = CHF 105

Challenge: FX-Rates ändern sich täglich → manuelle Umrechnung zeitraubend

Problem 3: Inventory-Sync (Overselling)

Scenario:

Product: Swiss Chocolate (100 units in stock)
Shopify: 50 units sold
Amazon: 40 units sold
Total: 90 units sold

Without Real-Time Sync:

WooCommerce zeigt noch 100 units available → Kunde bestellt 20 units
Problem: Only 10 units in stock → Overselling → Kunde verärgert

Solution: Real-Time Inventory-Sync (all channels updated simultaneously)

Problem 4: Channel-Profitability (which channel is profitable?)

Metrics needed:

Revenue per Channel: Shopify CHF 100k, Amazon CHF 50k, WooCommerce CHF 10k
COGS per Channel: Shopify CHF 60k, Amazon CHF 35k, WooCommerce CHF 7k
Fees per Channel: Shopify 2%, Amazon 15%, WooCommerce 0% (self-hosted)
Net Profit per Channel: ?

Without Automation: Manual Excel-Berechnungen (50 Std./Monat)

Channel-Breakdown: Integration Guides

Channel 1: Shopify Integration

API: Shopify Admin API (https://shopify.dev/api/admin-rest)

Data to Sync:

Orders (revenue, MWST, currency)
Products (inventory)
Customers (for invoicing)

Tool: Make.com + Bexio

Workflow:

Shopify Webhook: New Order
  ↓
Make.com: Receive Webhook
  ↓
Parse Data:
  - Order ID: {{order.id}}
  - Total: {{order.total_price}}
  - Currency: {{order.currency}}
  - MWST: {{order.total_tax}}
  - Country: {{order.billing_address.country}}
  ↓
Bexio API: Create Invoice
  - Customer: {{order.customer.email}}
  - Amount: {{order.total_price}} (in CHF, converted if EUR/USD)
  - Tax Rate: {{map_country_to_tax_rate(order.country)}}
    - CH: 8.1%
    - DE: 19%
    - FR: 20%
  ↓
Update Inventory (all channels via Make.com)

Setup: 4 Stunden

Channel 2: Amazon FBA Integration

API: Amazon SP-API (https://developer-docs.amazon.com/sp-api/)

Data to Sync:

Orders (via SP-API Orders endpoint)
FBA Inventory (real-time stock levels)
Fees (FBA fees, referral fees)

Challenge: Amazon API is complex (OAuth 2.0, AWS Signature v4)

Solution: Use pre-built Make.com Amazon module

Workflow:

Amazon SP-API: Get Orders (hourly)
  ↓
Make.com: Fetch Orders
  ↓
For each Order:
  - Parse: Order ID, Total (EUR), MWST, Country
  - FX Conversion: EUR → CHF (via API https://exchangerate-api.com)
  ↓
Bexio API: Create Invoice (in CHF)
  - Amount: {{total_eur * fx_rate}}
  - Tax Rate: {{amazon_tax_rate}} (DE 19%)
  ↓
Update Inventory (deduct sold quantity)

Amazon Fees (auto-deduct from revenue):

Referral Fee: 15% (category-dependent)
FBA Fee: €2-5 per item (depends on size/weight)

Setup: 6 Stunden (complex API)

Channel 3: WooCommerce Integration

API: WooCommerce REST API (https://woocommerce.github.io/woocommerce-rest-api-docs/)

Data to Sync:

Orders
Products (inventory)
Customers

Tool: Make.com + Bexio

Workflow:

WooCommerce Webhook: Order Created
  ↓
Make.com: Receive Webhook
  ↓
Parse Data: Order ID, Total (CHF), MWST
  ↓
Bexio API: Create Invoice
  - Customer: {{order.billing.email}}
  - Amount: {{order.total}}
  - Tax Rate: 8.1% (CH)
  ↓
Update Inventory (all channels)

Setup: 2 Stunden (simplest API)

MWST-Automation: CH + EU OSS

CH MWST (8.1%)

Tool: Bexio MWST-Abrechnung

Process:

Quartalsweise: Bexio generates MWST-Abrechnung (auto-calculated from all invoices)
Review: Check Accuracy (5 Min.)
Submit: Upload to estv.admin.ch
Payment: Bank-Transfer (IBAN provided by ESTV)

Automation-Rate: 95% (only 5 Min. review/Quartal)

EU OSS (One-Stop-Shop)

Schwelle: €10,000 Umsatz/Jahr in EU

Registration: https://www.estv.admin.ch/estv/de/home/mehrwertsteuer/dienstleistungen/oss.html

Process:

Register OSS: Switzerland as Member State (via ESTV)
Quartalsweise Meldung: All EU sales (grouped by country)
Payment: Switzerland collects tax, transfers to EU countries

Example (Q1 2026):

DE Sales: €50,000 × 19% = €9,500 MWST
FR Sales: €30,000 × 20% = €6,000 MWST
IT Sales: €20,000 × 22% = €4,400 MWST
Total: €19,900 MWST → Pay to ESTV (they forward to DE, FR, IT)

Tool: Bexio OSS-Report (auto-generated)

Setup: 2 Stunden (one-time OSS registration)

Inventory-Sync: Real-Time Stock Updates

Problem: Stock is sold on Shopify → but Amazon still shows old stock → Overselling

Solution: Central Inventory System (all channels pull from one source)

Tool: Make.com + Google Sheets (or dedicated Inventory Software like Cin7)

Workflow:

Google Sheets: Master Inventory
  - Product SKU: CHOCOLATE-100G
  - Stock: 100 units
  ↓
When Order placed (any channel):
  1. Shopify Webhook → Make.com → Update Google Sheets (Stock - 1)
  2. Google Sheets triggers update → Push to all channels:
     - Shopify API: Update Stock
     - Amazon SP-API: Update Stock
     - WooCommerce API: Update Stock

Latency: < 1 Min. (real-time)

Cost: CHF 0 (Google Sheets is free) or CHF 100/Mo (Cin7 for advanced features)

Example:

Initial State: | SKU | Shopify Stock | Amazon Stock | WooCommerce Stock | Master Stock | |--------------|---------------|--------------|-------------------|--------------| | CHOCOLATE-100G| 100 | 100 | 100 | 100 |

After Shopify Sale (50 units): | SKU | Shopify Stock | Amazon Stock | WooCommerce Stock | Master Stock | |--------------|---------------|--------------|-------------------|--------------| | CHOCOLATE-100G| 50 | 50 | 50 | 50 |

After Amazon Sale (40 units): | SKU | Shopify Stock | Amazon Stock | WooCommerce Stock | Master Stock | |--------------|---------------|--------------|-------------------|--------------| | CHOCOLATE-100G| 10 | 10 | 10 | 10 |

Result: No overselling (all channels show correct stock)

Profitability-Tracking per Channel

Metrics needed:

Revenue: Total sales (after returns)
COGS: Cost of Goods Sold
Fees: Shopify 2%, Amazon 15%, WooCommerce 0%
Shipping: Fulfilled by Amazon (FBA) vs. Self-Shipping
MWST: Deducted from revenue

Formula:

Net Profit = Revenue - COGS - Fees - Shipping - MWST

Tool: Power BI Dashboard (connected to Bexio + Shopify + Amazon APIs)

Example Dashboard (Power BI):

[Channel Profitability - Q1 2026]

| Channel      | Revenue  | COGS    | Fees   | Shipping | MWST   | Net Profit | Margin |
|--------------|----------|---------|--------|----------|--------|------------|--------|
| Shopify      | CHF 100k | CHF 60k | CHF 2k | CHF 5k   | CHF 8k | CHF 25k    | 25%    |
| Amazon.de    | CHF 50k  | CHF 35k | CHF 7.5k| CHF 0   | CHF 7k | CHF 0.5k   | 1%     |
| WooCommerce  | CHF 10k  | CHF 7k  | CHF 0  | CHF 1k   | CHF 1k | CHF 1k     | 10%    |
| **Total**    | **CHF 160k**| **CHF 102k**| **CHF 9.5k**| **CHF 6k**| **CHF 16k**| **CHF 26.5k**| **16.6%**|

Insight: Amazon has lowest margin (1%) → consider reducing Amazon presence or increasing prices

Actionable Insights:

✅ Shopify is most profitable (25% margin)
⚠️ Amazon is barely profitable (1% margin) → Optimize (reduce FBA fees or increase prices)
✅ WooCommerce is profitable (10% margin) → Scale B2B sales

Tools-Stack: Budget per Revenue Tier

Small E-Commerce (CHF 100k-500k ARR)

| Tool | Use Case | Cost/Monat | |-----------------------|-----------------------------------|------------| | Bexio | Accounting, MWST, Invoicing | CHF 50 | | Make.com | Workflow Automation | CHF 29 | | Google Sheets | Inventory Master | CHF 0 | | Power BI | Profitability Dashboard | CHF 10 | | FX-API (exchangerate) | Currency Conversion | CHF 10 | | Total | | CHF 99/Mo|

ROI: 50 Std./Monat gespart × CHF 80/Std. = CHF 4,000/Monat

Medium E-Commerce (CHF 500k-2M ARR)

| Tool | Use Case | Cost/Monat | |-----------------------|-----------------------------------|------------| | Bexio Enterprise | Multi-User Accounting | CHF 100 | | Make.com Teams | 100k Operations | CHF 99 | | Cin7 | Advanced Inventory Management | CHF 200 | | Power BI | 5 Users | CHF 50 | | Shopify Advanced | Lower Transaction Fees | CHF 300 | | Total | | CHF 749/Mo|

ROI: 80 Std./Monat gespart × CHF 100/Std. = CHF 8,000/Monat

Large E-Commerce (CHF 2M+ ARR)

| Tool | Use Case | Cost/Monat | |-----------------------|-----------------------------------|------------| | Abacus | Enterprise Accounting | CHF 300 | | Make.com Enterprise | Unlimited Operations | CHF 299 | | TradeGecko/Cin7 | Multi-Warehouse Inventory | CHF 500 | | Tableau | Advanced Analytics | CHF 280 | | Shopify Plus | Enterprise Features | CHF 2,000 | | Total | | CHF 3,379/Mo|

ROI: 120 Std./Monat gespart × CHF 120/Std. = CHF 14,400/Monat

2-Week Quick-Start Implementation

Week 1: Channel Integration

Day 1-2: Shopify

[ ] Register Make.com
[ ] Connect Shopify API
[ ] Create Workflow: New Order → Bexio Invoice
[ ] Test with 10 orders

Day 3-4: Amazon

[ ] Register Amazon SP-API
[ ] Connect to Make.com
[ ] Create Workflow: Get Orders → Bexio Invoice
[ ] Test with 10 orders

Day 5-7: WooCommerce

[ ] Connect WooCommerce API
[ ] Create Workflow: Order Created → Bexio Invoice
[ ] Test with 10 orders

Week 2: MWST + Inventory + Dashboard

Day 8-9: MWST Automation

[ ] Bexio: Activate MWST-Abrechnung
[ ] Configure Tax Rates (CH 8.1%, DE 19%, FR 20%, etc.)
[ ] Test: Generate Q1 2026 MWST-Report

Day 10-11: Inventory Sync

[ ] Setup Google Sheets Master Inventory
[ ] Create Make.com Workflow: Order → Update Inventory → Push to all channels
[ ] Test with 10 products

Day 12-14: Profitability Dashboard

[ ] Connect Power BI to Bexio API
[ ] Create Dashboard: Revenue, COGS, Fees, Net Profit per Channel
[ ] Review with team

Häufige Fragen (FAQ)

F: Brauche ich OSS-Registrierung, wenn ich nur €5,000/Jahr in EU verkaufe? A: Nein, Schwelle ist €10,000. Aber: Behalte im Auge (wenn du überschreitest, musst du rückwirkend registrieren).

F: Kann ich Bexio für alle Channels nutzen? A: Ja, Bexio unterstützt Multi-Channel via API. Aber: Du brauchst Make.com (oder Zapier) für Workflow-Automation (Shopify → Bexio, Amazon → Bexio, etc.).

F: Was ist der grösste Fehler bei Multi-Channel E-Commerce? A: Keine Inventory-Sync → Overselling → Verärgerte Kunden → Negative Reviews. Lösung: Implement Real-Time Inventory-Sync (siehe oben).

F: Welcher Channel ist profitabler: Shopify oder Amazon? A: Depends on fees. Shopify: 2% fees (low), self-shipping (high). Amazon: 15% fees (high), FBA shipping (low). Rule of Thumb: Shopify ist profitabler für high-margin products (> 30% margin). Amazon ist besser für low-margin, high-volume products (wegen FBA efficiency).

Fazit: Multi-Channel E-Commerce Finance braucht Automation

Without Automation:

50 Std./Monat Finance-Admin
MWST-Fehlerrisiko (Strafen bis CHF 250,000)
Overselling (verärgerte Kunden)
No Channel-Profitability Insights

With Automation:

5 Std./Monat (only review)
Automatic MWST (CH + EU OSS)
Real-Time Inventory-Sync
Profitability Dashboard (which channel makes money?)

ROI: 45 Std./Monat gespart = CHF 3,600/Monat

Action: Start with 2-Week Quick-Start (see above).

Letzte Aktualisierung: 21. Januar 2026 Autor: Lukas Huber, SwissFinanceAI

Haftungsausschluss: Dieser Artikel dient ausschliesslich zu Informationszwecken und stellt keine Finanzberatung dar. Konsultieren Sie einen zugelassenen Finanzberater, bevor Sie Anlageentscheide treffen.

Multi-Channel E-Commerce Finance: Shopify + Amazon + WooCommerce (Schweizer MWST-Automation)