E2E Testing Overview

What is E2E Testing?

The E2E test suite verifies the complete data flow of the Magic PIM platform:

Supplier Connectors → APLT Tables → Medusa Products → Tenant Databases

It runs automated tests against the live database and APIs, captures screenshots of results, and publishes a dashboard with per-phase status.

Live Dashboard

E2E Dashboard Live test results with per-phase breakdown and action items

Playwright Report Full test report with screenshots, videos, and traces

Test Phases

The tests follow the same 4-phase structure as the E2E Flow Verificatie Plan:

Phase	Name	What it verifies
1	Connector → APLT	Product counts, data quality, duplicate SKUs, sync freshness, stock per supplier
1b	Translations	Dutch (NL) translation coverage for product names, descriptions, materials, techniques
2	APLT → Medusa	Product sync, variant mapping, tiered pricing, image associations
3	Tenant DB Updates	Record counts, cross-validation, sales channel associations across all tenants
4	Stock Levels	Stock freshness, quantity anomalies, PIM↔tenant parity
5	Storefront UI	Homepage, product listing/detail, search, cart, categories on brinxx.magiceverse.online (with video)

Architecture

Test Layers

Layer	Purpose	Tools
Data verification	SQL queries to verify data pipeline correctness	Playwright + `pg` (direct PostgreSQL)
API verification	Call admin API endpoints, verify sync status	Playwright `request` API
Platform UI	Navigate storefront pages with video + screenshots	Playwright browser (Phase 5)

Infrastructure

/mnt/data/magic_pim/e2e/          ← Test project
├── tests/                         ← Test specs (per phase)
├── helpers/                       ← DB, API, screenshot helpers
├── scripts/
│   ├── run-e2e.sh                ← Run tests + deploy
│   ├── deploy-report.sh          ← Deploy report to subdomain
│   └── generate-dashboard.py     ← Generate plan dashboard
├── playwright.config.ts          ← Playwright config
└── nginx/                         ← Nginx config for subdomain

e2etest.magiceverse.online/        ← Live dashboard
├── index.html                     ← Plan-level dashboard (auto-generated)
├── latest/                        ← Playwright HTML report
└── history/                       ← Archived previous runs

How to Run

cd /mnt/data/magic_pim/e2e

# Run all phases
bash scripts/run-e2e.sh

# Run specific phase
bash scripts/run-e2e.sh phase1
bash scripts/run-e2e.sh phase4

# Run tests only (no deploy)
npx playwright test

# Deploy report + dashboard only
bash scripts/deploy-report.sh

Suppliers Tested

Code	Supplier	Products	Stock	Translations
01	Spranz	✅	❌ No stock in APLT	N/A (Dutch source)
04	XD Connect	✅	❌ No stock in APLT	✅ Required
05	PF Concept	✅	❌ No stock in APLT	✅ Required
06	MidOcean	✅	✅	✅ Required
07	Toppoint	✅	✅ (has negative qty issues)	✅ Required
09	NewWave	✅	Not yet tested	✅ Required