Import Pipeline Blueprint
10-stage CSV import pipeline — click each stage to inspect validation rules and outputs
Pipeline Stages
Stage 1
CSV Intake
File size, format, and encoding validation before processing begins.
Validation Checks
File extension is .csv
Size ≤ 50MB
Encoding is UTF-8 or UTF-16
Header row present
Minimum 1 data row
Stage Output
File URI + raw row count
Row Validation Statuses
valid
Row passed all validation checks and is ready for import.
warning
Row has non-critical issues — import will proceed with manager approval.
duplicate
SKU already exists in inventory. Resolve: skip, overwrite, merge, or create_new.
missing_required
A required field (name, sku, price) is missing or empty.
invalid_category
Product category could not be auto-detected or mapped.
stock_conflict
Incoming stock quantity conflicts with existing warehouse records.
price_conflict
Price delta > 20% vs existing record. Requires manager approval.