Extraction guide

Join review data to product records

A manual handoff recipe to adapt in your own environment.

01 / INPUTAuthorized review export + product IDs
02 / YOUR WORKFLOWMap fields → inspect → hand off
03 / OUTPUTA review-to-product mapping

Keep the right fields.

Manual data handoff
Join review data to product records field map
Field / stepInputRule
Source recordProduct and variant identifiersKeep identity as strings.
Review provenanceReview source + timePreserve the original review identity.
Evidencesource_url + retrieved_atKeep the original observation attached.

Before you use the output

Reviews are a separate input; the current product schema does not contain review text.

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.

Continue this workflow