RUN-TIGER

Kontext

RUN-TIGER sells worldwide through Amazon. For bookkeeping and stock tracking, sales and refunds must be represented in Minimax in a structured, auditable form. Amazon provides export reports, but they need normalization, aggregation and accounting-specific logic before they can be posted as ERP documents.

Problem

• Per-order invoicing is not operationally feasible at Amazon volume.
• Accounting requires monthly aggregation and country/market separation.
• EU OSS requires strict filtering and country-specific VAT handling.
• Non-EU exports need zero-VAT treatment and compliant invoice descriptions.
• Minimax requires stable customer/item references for deterministic posting.

Projektziele

• Create monthly Minimax summary invoices from Amazon exports.
• Aggregate line items by SKU (plus shipping lines where applicable).
• Handle refunds as separate documents using negative quantities.
• Provision missing Minimax master data (customers, placeholder items) when needed.
• Support multiple export formats (EU OSS, US, CA) with a lightweight workflow.

Lösungsüberblick

We implemented a small upload-based app that:

• Accepts region-specific Amazon CSV exports (EU/US/CA) via a minimal UI.
• Normalizes and aggregates report rows by country/market and SKU.
• Creates or reuses per-market Minimax customers (e.g. `am_XX`).
• Ensures SKUs exist as Minimax items (creates placeholders for unknown SKUs).
• Posts Minimax issued invoices for the previous month with correct currency/exchange rates and VAT logic.

Architektur & technischer Ansatz

Inputs and parsing

• EU OSS export: filters to eligible scheme, excludes VAT-number buyers, groups by arrival country.
• US/CA exports: parses settlement-style rows and aggregates sales/refunds per SKU.

Aggregation model

• Sales and refunds are split into separate buckets.
• SKU totals are aggregated into a single Minimax invoice row per SKU.
• Shipping credits can be mapped to a dedicated shipping SKU row.

Minimax posting

• Creates/reuses customers per market (`am_XX`).
• Fetches exchange rates for period-end date and applies the invoice exchange rate.
• Posts `InvoiceType = R` issued invoices with a monthly period window (`DateTransactionFrom` → `DateTransaction`).
• Applies VAT rules per flow (EU OSS vs exports) and assigns a warehouse for inventory tracking.

Technologie-Stack

• PHP (upload UI, CSV parsing, aggregation)
• Minimax OAuth2 + REST API
• Composer dependencies (PhpSpreadsheet available)
• Basic access protection via `.htaccess` / `.htpasswd`

Results & Impact

• Clean monthly Minimax documents instead of per-order noise.
• Consistent capture of sales and refunds across regions.
• Faster bookkeeping and more reliable stock/accounting workflows.
• Missing master data (customer/SKU) no longer blocks posting.

Summary

This tool converts Amazon marketplace exports into monthly Minimax summary invoices, handling region-specific formats, EU OSS filtering, currency/exchange rate logic, VAT rules, and master data provisioning—built to support global e-commerce accounting and stock tracking.