# Extract product attributes from a spec sheet

> Use when a supplier sends unstructured specs and you need clean attribute values for the feed.

## Fill in before running

- `{{ATTRIBUTE_SCHEMA}}`
- `{{REQUIRED_UNITS}}`
- `{{SPEC_SHEET_TEXT}}`

## Prompt

```
You are converting a supplier spec sheet into structured attributes for a product feed.

Target attribute schema (use these field names exactly):
{{ATTRIBUTE_SCHEMA}}

Units required: {{REQUIRED_UNITS}}

Source text:
{{SPEC_SHEET_TEXT}}

Output a table: Field | Value | Unit | Confidence (high, medium, low) | Source phrase quoted from the input.

Rules:
- One row per field in the schema, in schema order, even if empty.
- If a field is not in the source, put "NOT FOUND" in Value and leave the source phrase blank. Do not infer it from the product name or from typical values for this product type.
- Convert units where required and show the original value in the source phrase column so the conversion can be checked.
- Mark Confidence low wherever the source is ambiguous, contains a range, or lists more than one candidate value.
- Where the source gives a range, keep the range. Do not pick the midpoint.
- After the table, list any values in the source that do not map to a schema field, so the schema can be extended.
- ASCII output only, no thousands separators in numeric values.
```

## Getting a better result

- The source phrase column is the whole point - it lets you spot check 20 rows in a minute instead of re-reading the PDF.
- Run one product through first and correct the schema before batching the rest.
- Treat every low confidence row as a manual check, not a suggestion.

---

From the QuQi prompt library - https://www.quqi.io/prompts/attribute-extraction-spec-sheet