Normalise catalogue titles

Make product titles consistent with rules.

Prompt

Normalise these product titles using the rules below. Keep every SKU unchanged and return a table: SKU | Original | New title | Changes made.
Rules: {{rules}}
Rows:
{{rows}}
If a rule cannot be applied because information is missing, leave the title as is and write “missing: …”. Never add a brand that is not in the original.

Fill the variables

{{rows}}

{{rules}}

Result

Normalise these product titles using the rules below. Keep every SKU unchanged and return a table: SKU | Original | New title | Changes made.
Rules: {{rules}}
Rows:
{{rows}}
If a rule cannot be applied because information is missing, leave the title as is and write “missing: …”. Never add a brand that is not in the original.

Copy prompt

Example

Input: rules = Brand + Product + Size + Colour; rows = 20 messy titles

Expected output: A normalised table with change notes.