Commercial faucet product attributes

Commercial faucets are sold into washrooms and kitchens where the fixture, the sink holes and local water-use rules all constrain the choice. The deciding facts are spread across a spec sheet: hole count and centers, spout reach, the aerator or laminar insert that sets flow, and for metering or sensor models the cycle volume and run time. Supplier files often print a flow rate without the test pressure or insert type.

One base model can generate hundreds of orderable part numbers once spout length, handle style, finish, flow insert, cycle setting and power option are combined. When those options are encoded only in a suffix, search and filtering fail and a buyer ends up with a 1.5 gpm kitchen insert on a lavatory that needed 0.5 gpm. Each option belongs in its own field.

Drinking-water and performance certifications also need care. Lead content, contaminant leaching for end-point devices and the plumbing-fitting performance standard are three different claims. Recording each with its standard and certifier, per SKU, keeps a school or hospital submittal from resting on a broad series-level statement that may not cover the part installed.

The commercial faucets attribute template

18 candidate fields in 5 groups, ordered the way a record gets built: identify the item, capture its specifications, then record fit and the evidence behind any claim. 10 are marked Core: without them the item cannot be identified or filtered. Example values show the expected format only; they do not describe a real SKU.

Identity

Which exact item, variant and pack this record describes.

Check before use: Preserve leading zeros and punctuation, validate against the manufacturer record, and check the GTIN check digit and packaging level before linking.

Attribute	Type	Priority	Example format
Manufacturer Part Number (MPN) manufacturer_part_number_mpn	Identifier	Core	CF-4410-CP
GTIN-14 / UPC gtin_14_upc	Identifier	Core	10614141220042

Technical specifications

Measured or rated values that must travel with their unit and test conditions.

Check before use: Store the number and unit separately. Convert only when the source unit and test conditions are known.

Attribute	Type	Priority	Example format
Spout Reach (center-to-center) spout_reach_center_to_center	Number · in	Core	4-1/8
Flow Rate at 60 psi flow_rate_at_60_psi	Number · gpm	Core	0.5
Metering Cycle Time metering_cycle_time	Text · s	Buyer decision	5-30 s adjustable
Cycle Volume cycle_volume	Number · gal/cycle	Buyer decision	0.20

Selection attributes

The type, material and option choices buyers filter and compare on.

Check before use: Map supplier wording to a governed vocabulary only after checking the source text and which variant it applies to.

Attribute	Type	Priority	Example format
Faucet Type faucet_type	Controlled list	Core	Metering faucet
Activation Type activation_type	Controlled list	Core	Push-button metering
Finish finish	Controlled list	Core	Polished Chrome
Spout Style spout_style	Controlled list	Buyer decision	Fixed low-profile
Body Material body_material	Controlled list	Buyer decision	Cast brass
Power Source power_source	Controlled list	Buyer decision	None (mechanical metering)

Fit & compatibility

What the item mounts to, mates with, replaces or works alongside.

Check before use: Keep model and series qualifiers. A similar-looking part is not a verified fit until a source says so.

Attribute	Type	Priority	Example format
Mounting Type mounting_type	Controlled list	Core	Deck-mount
Mounting Centers / Hole Configuration mounting_centers_hole_configuration	Controlled list · in	Core	4 in centerset (3-hole)
Inlet Connection inlet_connection	Text	Buyer decision	1/2 in NPSM male shank

Evidence & compliance

Listings, standards, classifications and origin claims that need a document behind them.

Check before use: Link the manufacturer document or label with its edition or date. Never copy a certification from a neighboring SKU.

Attribute	Type	Priority	Example format
Country of Origin country_of_origin	Controlled list	Core	United States
Plumbing Fitting Standard plumbing_fitting_standard	Controlled list	Channel / evidence	ASME A112.18.1/CSA B125.1
Drinking Water Certification drinking_water_certification	Controlled list	Channel / evidence	NSF/ANSI/CAN 61 Section 9; NSF/ANSI/CAN 372

Normalize supplier values

The same value arrives in many spellings. Map each raw string to one governed value, and keep the raw text beside it so a reviewer can see what the supplier actually wrote.

Often missing from supplier files

These fields are commonly absent from price lists and basic feeds, even though the information usually exists in a datasheet, label or installation manual. Treat an empty value as a request for evidence, not as permission to fill it from a similar model.

• Aerator / Outlet Type and Supplied Insert Flow Rate
• Shank Length / Maximum Deck Thickness
• Rated Operating Pressure and Temperature Range
• Metering Cycle Time and Cycle Volume
• Power Source and Backup Mode

Questions the record must answer

Buyers and counter-sales reps choosing commercial faucets ask questions like these. Each one needs a specific field, sourced for the exact variant.

• Will this fit the three holes on 4-inch centers in our existing lavatory?
• Does it meet the 0.5 gpm limit for a public lavatory?
• How long does it run after one push, and can we shorten the cycle?
• Is it certified for drinking-water use if a sink doubles as a fill station?

From supplier file to record

1. Resolve identity first. Link the supplier SKU, manufacturer part number and packaging identifiers without merging distinct variants or pack sizes.
2. Extract with the source attached. Pull values from rows, tables and datasheets, keeping the raw text, unit and page or row reference.
3. Map to your classification. Assign the ETIM, ECLASS, UNSPSC or internal class your company licenses, and keep the supplier's original terms.
4. Review, sync and watch. Hold conflicts and safety-related values for a category expert, write approved values to ERP or PIM, and recheck when the supplier sends a new file.

For the full method, see how to build a category attribute template and the category catalog gap audit.

FAQ