Oak Flats UI Primitives Catalogue

Step 1 / Choose source

Source picker

Choose a source

CSV fileComma, semicolon, tab or pipe-delimited text — parts, customers, quotes.Most commonExcel workbook.xlsx with multi-sheet support — picks the active sheet by default.Multi-sheetJSON documentNewline-delimited or array. Auto-detects deeply nested objects.Nested OKGoogle SheetsLive link to a Google Sheet — re-fetches on every run.Live linkAirtable baseOAuth into an Airtable workspace and pick a base + table.OAuthDirect databaseRead-only Postgres connection. Provide a SELECT or table name.Read-onlyWebhook endpointPush rows to a unique URL — useful for partner integrations.Streaming

Step 2 / Preview file + detect types

CSV preview

manta-parts-2026-05-28.csv721 rows · 58.4 kB

DelimitercommaEncodingUTF-8Header rowauto-detected

First 10 rows of manta-parts-2026-05-28.csv — read-only preview
#	SKU	Title	Supplier	RRP	Stock
01	MFM-EX-2010-COMM	VE Commodore cat-back exhaust — 2.5"	Manta Performance	1,498.00	6
02	MFM-EX-2014-RANGER	PX Ranger 3.2 turbo-back DPF-delete	Manta Performance	2,180.00	3
03	MFM-MUF-NS-200	Universal straight-through muffler 2"	Redback	182.00	24
04	MFM-CAT-LC79	LC79 V8 4.5L sports cat 200CPSI	Beaudesert	1,080.00	2
05	MFM-FIT-CLAMP-25	Heavy-duty exhaust clamp 2.5"	Manta Performance	18.50	240
06	MFM-EX-LDV-T60	LDV T60 3" turbo-back	Manta Performance	1,720.00	4
07	MFM-CAT-NL-300	100-cell metal cat — 3"	Redback	320.00	11
08	MFM-EX-NM300	Navara NP300 3" turbo-back DPF-back	Manta Performance	1,940.00	5
09	MFM-MUF-OVAL-3	Universal oval muffler 3" straight-through	Redback	240.00	16
10	MFM-FIT-FLEX-25	Stainless flex 2.5" 200mm	Beaudesert	62.00

Detected types per column

SKUsampleMFM-EX-2010-COMM

detected · Text

Override

TitlesampleVE Commodore cat-back exhaust

detected · Text

Override

SuppliersampleManta Performance

detected · Text

Override

RRPsample1,498.00

detected · Number

Overrideoverridden

Stocksample6

detected · Number

Override

Step 3 / Map columns, define transforms, review validation

Column mapping

5 of 5 mapped

SKUMFM-EX-2010-COMM
Target field
requiredauto-match 97% · high
Skip
TitleVE Commodore cat-back exhaust — 2.5"
Target field
requiredauto-match 92% · high
Skip
SupplierManta Performance
Target field
requiredauto-match 78% · med
Skip
RRP1,498.00
Target field
auto-match 99% · high
Skip
Stock6
Target field
auto-match 88% · high
Skip

Transform pipelines

Transforms

Transform rules editor

Chained transforms apply left-to-right. Preview row updates as you go.

SKUraw MFM-EX-2010-COMM previewmfm-ex-2010-comm
pipeline
01trim02lowercase
Add
SupplierrawManta PerformancepreviewManta Performance
pipeline
01regex-replace/\s+/02lookupsupplier_map
Add
Stockraw—previewn/a
pipeline
01coalesce→ n/a
Add

Validation results

Validation

35 issues across 721 rows

Cannot commit

BlockerMissing required: Supplier reference
8 rows
BlockerInvalid format: RRP not a currency value
3 rows
WarningDuplicate SKU already in catalog
5 rows
WarningOut of range: Stock < 0
2 rows
BlockerForeign-key missing: Supplier not found
6 rows
InfoLow-confidence mapping flagged for review
11 rows

Step 4 / Dry-run

Dry-run outcome

Dry-run

Dry-run summary

721 rows evaluated · no writes performed yet

Net +482 parts, +196 updated, 19 quarantined

482Rows to create
196Rows to update
24Rows skipped
19Rows failed

Step 5 / Commit + finalise

Import progress

Import

manta-parts-2026-05-28.csv

Rate36 rows/sETA~6.7s

478 / 721 rows · 66%

Final dry-run for the operator’s sign-off

Dry-run

Final commit outcome

721 rows evaluated · no writes performed yet

Ready to commit

482Rows to create
196Rows to update
24Rows skipped
19Rows failed