Product Data for Fittings & Faucets: Technical Values and Finishes
Two data layers in one product: hard technical values like flow rate and connection, and a wide matrix of finishes and versions as variants — where ETIM helps, and where it stops.
- ✓Fittings and faucets carry two data layers at once: hard technical values (flow rate, connection, pressure) and a broad matrix of finishes and versions as variants.
- ✓ETIM classifies the article and its technical features well for established brands — but not the finishes, the images or the sales content.
- ✓Finishes belong in the catalog as variants of one base article, not as separate products — each with its own GTIN/EAN.
- ✓Productbay models technical values plus a finish/version variant matrix in one system and uses AI enrichment where ETIM stops: content, images and the accessory longtail.
A single-lever basin mixer looks like a simple product until you try to describe it in data. It has a flow rate you are legally required to state, a connection thread that determines whether it even fits, an operating pressure range, a noise class, a cartridge, an aerator. And then it exists in chrome, in brushed nickel, in matte black and in brass — four finishes, each a sellable article of its own. One product, two entirely different kinds of data pulling in opposite directions.
Product data for fittings and faucets is split between hard technical values and a broad matrix of finishes and versions as variants. Get the technical values wrong and the tap is unbuyable; skip the finish variants and it's unsearchable. This is a focused sub-branch of the wider plumbing & heating product data challenge, and it's one of the sharpest examples in the SHK world of specs and variants colliding in the same article.
Which values and finishes make up a fitting?
A fitting carries two data layers, and both have to be clean before the product is fit to publish:
- Technical values: flow rate (l/min), connection type and thread (e.g. G 3/8), operating and test pressure, noise class, mounting type, aerator and cartridge, temperature limiter — the numbers that decide fit and compliance.
- Finish and version (the variant layer): chrome, brushed nickel, matte black, brass; single-lever, thermostatic, wall- or deck-mounted; low-pressure vs. high-pressure. One model easily explodes into six or eight sellable variants.
- Commercial keys: a GTIN/EAN per variant, images per finish, and sales copy — none of which arrives from a technical classification.
The trap is treating each finish as a separate product. Model it that way and your catalog triples in size, your images scatter, and a shopper who wants "the same tap but in black" lands on an unrelated page. The right model is one base article with a finish/version variant matrix — the same logic a fashion retailer uses for a size run.
Does ETIM cover fittings — and where does it stop?
ETIM is the technical classification standard that dominates sanitary and electrical wholesale in the German-speaking market. For fittings it is genuinely strong: it defines the product class and the technical feature set — flow rate, connection, pressure — that a mixer or thermostat should carry. But it's worth being honest about its edges:
| Data layer | What ETIM delivers | Where it stops |
|---|---|---|
| Classification | Clean product class per fitting type | Own-label & small-brand ranges often unclassified |
| Technical features | Flow rate, connection, pressure, noise class | Depends on the manufacturer actually filling ETIM |
| Finish variants | Not the job of a classification | Chrome / nickel / matte black matrix absent |
| Images & media | — | Per-finish images have to come from elsewhere |
| Sales content | — | Descriptions, SEO and benefit copy missing |
In short: ETIM gives you the class and the technical skeleton for the established brands, and that is a real head start. What it does not give you is the finish matrix, the images per variant, or a single line of sales content — and it thins out fast for accessories, own-label and the small-brand longtail. Those gaps are exactly the manual work. For the standards landscape as a whole, see our explainer on GDSN, ETIM & eCl@ss.
How does Productbay handle values and variants together?
The job is a three-step process run for both data layers at once — and that's what Productbay is built for:
- Consolidate: connect each source once — supplier Excel, CSV, feed URL, FTP, API, or a PDF datasheet — and match by SKU or GTIN/EAN so existing products update and new ones are created. Technical values and finish variants land in one catalog.
- Enrich: AI parses flow rates, connections and pressure out of raw files and datasheets, assigns the ETIM-aligned class, writes the description once and adapts it per finish, fills missing attributes from whitelisted sources and translates via DeepL — always with a review queue before publishing. Per-finish images are organized in the DAM.
- Publish: two-way sync to Shopify and Shopware, ERP connections (Xentral, weclapp) and feed exports for Amazon, OTTO and Kaufland — the finish matrix intact, each variant with its own GTIN/EAN.
Crucially, Productbay starts where ETIM stops. If a manufacturer already delivers a clean ETIM feed for its core range, great — Productbay complements it and takes over the finish variants, the per-variant images, the sales content and the accessory longtail no classification carries. It's built for specialist retailers running multi-supplier, multi-channel catalogs — from mid-sized shops to large chains.