Product catalogue & warehouse
Sofar Products
The full catalogue of everything Sofar Solar sells — PV inverters, hybrid inverters, ESI all-in-one systems, batteries and accessories — plus live stock snapshots per warehouse. Exposed as a read API so every internal service shares one source of truth for SKUs.
Seeded from the NL warehouse report
The first import loads 120 SKUs across 10 categories from NL Stock Report 20260423. Each row keeps its ERP material number (e.g. 900.01200098-0) so records line up with the existing Sofar accounting system.
Data model
- Product
- sku, matNo, familyCode, model, categoryCode, productKind (INVERTER_PV / INVERTER_HYBRID / ESI_AIO / BATTERY / ACCESSORY), ratedPowerW, phaseCount, active
- ProductCategory
- code, name, summaryGroup, order
- ProductStockSnapshot
- productId, warehouseCode (NL-K+N / NL-K+G-FOX / GIT), stockFree, stockLocked, stockInTransit, snapshotAt
- Warehouse
- code, name, region, countryIso2 — operator-visible, editable
API surface
All endpoints are org-scoped. Public read endpoint lets other services pull the catalogue without user credentials.
Who reads this
TMS Asset records FK into Product. CSP RMA cases need to know which SKU is being replaced and which spare-part SKUs to pull. Tickets tag product context. Sofar CSP and future e-learning content key off the same catalogue.