Resistor product attributes

Resistor data looks tidy until several suppliers describe the same value. One file says 4K7, another 4.7 kOhm, a third uses the three-digit code 472, and a fourth gives 4700 with no unit. Unless the catalog converts all of them to one number in ohms, identical parts appear as separate products and different parts can be merged by mistake.

Power rating is necessary but not sufficient. Small chip resistors are often limited by maximum working voltage before they reach their power rating, and the rated power applies only up to a stated temperature before derating. Tolerance, temperature coefficient and composition, such as thick film, thin film or metal foil, separate a general-purpose part from a precision one.

Packaging and qualification decide what can actually be ordered. The same resistor can ship on 7 in or 13 in reels, in cut tape or in bulk, each with its own orderable part number. Automotive qualification, anti-sulfur construction and lifecycle status matter to buyers building products that must run for years, and those details rarely appear in a basic price file.

The resistors 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	RS0805F4K70-T7
GTIN-13 / UPC gtin_13_upc	Identifier	Core	5412345000365
Packaging packaging	Controlled list	Core	Tape & Reel, 7 in, 5,000 pcs

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
Resistance Tolerance resistance_tolerance	Controlled list · %	Core	±1 %
Power Rating (P70) power_rating_p70	Number · W	Core	0.125
Operating Temperature Range operating_temperature_range	Text · °C	Core	-55 °C to +155 °C
Temperature Coefficient (TCR) temperature_coefficient_tcr	Number · ppm/°C	Buyer decision	±100
Maximum Working Voltage maximum_working_voltage	Number · V	Buyer decision	150
Overload Voltage (Short-Time) overload_voltage_short_time	Number · V	Buyer decision	300

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
Resistance resistance	Number · Ω	Core	4700
Package / Case package_case	Controlled list	Core	0805 (2012 Metric)
Composition composition	Controlled list	Core	Thick Film
Number of Terminations number_of_terminations	Controlled list	Buyer decision	2
Lifecycle Status lifecycle_status	Controlled list	Buyer decision	Active

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	Surface Mount

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
AEC-Q200 Qualified aec_q200_qualified	Controlled list	Channel / evidence	AEC-Q200 qualified
RoHS / REACH SVHC Status rohs_reach_svhc_status	Controlled list	Channel / evidence	RoHS compliant; no SVHC > 0.1 % w/w
Country of Origin country_of_origin	Controlled list	Channel / evidence	Taiwan

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.

• Maximum Working Voltage
• Pulse / Surge Withstanding Capability
• Sulfur Resistance
• Orderable Packaging Variant
• Power Derating Start Temperature

Questions the record must answer

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

• Is 4K7 in one supplier's file the same part as 4.7 kΩ in another?
• Will this 0805 resistor handle 200 V across it?
• Is this part sold on a 7 in reel of 5,000, or in cut tape?
• Is there an anti-sulfur version for a harsh environment?

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