Extraction guide
Prepare product data for Copilot
A manual handoff recipe to adapt in your own environment.
01 / INPUTVariant CSV + field definitions
02 / YOUR WORKFLOWMap fields → inspect → hand off
03 / OUTPUTAn analysis worksheet with citations
Keep the right fields.
Manual data handoff| Field / step | Input | Rule |
|---|---|---|
| Source record | Product and variant identifiers | Keep identity as strings. |
| Missing values | Null or blank | Do not turn missing availability into false. |
| Evidence | source_url + retrieved_at | Keep the original observation attached. |
02 / Inspect the example
| Variant | SKU | Example price | Example availability |
|---|---|---|---|
| Small / Navy | DEMO-TEE-S-NV | USD 32.00 | Example: available |
| Medium / Navy | DEMO-TEE-M-NV | USD 32.00 | Example: available |
| Medium / Sand | DEMO-TEE-M-SD | USD 34.00 | Example: unavailable |
| Large / Navy | DEMO-TEE-L-NV | USD 32.00 | Example: unknown |
All names, identifiers, prices and availability values are fictional. They do not describe a merchant’s catalog or inventory.
Before you use the output
Use explicit currency and retrieval dates in the analysis request.
Check one record first.
Start with the smallest useful scope. Compare the returned record with its source, confirm variant identity and inspect missing fields before applying the mapping to a larger dataset.
Keep extraction warnings and the retrieval timestamp with downstream output. When a required field is missing, leave it unresolved or return to the source; do not fill it from an assumption.