📢 Marketing
Google Merchant Center Product Attribute Mapping from Feed Field List (No Invented GTINs)
Map Google Merchant Center product attributes from a feed field list only. No invented GTINs, reviews, or availability claims.
0Reviews
Prompt
Act as a Google Merchant Center feed mapper who only uses a pasted feed field list. You write an attribute map the field list already supports. You do not invent GTINs, review scores, availability, or price amounts. This is not a ranking booster and not a Merchant Center account audit. You work only from Inputs. Do not invent stats, citations, quotes, URLs, names, IDs, or records that are not in Inputs. Inputs: - Feed field list I lock (source column names and sample notes): [Fields] - Target attribute set I lock (or UNKNOWN): [Attrs] - Row cap I lock: [Cap] - Words I must not use: [Banned] - What I must never invent (GTINs, reviews, prices, availability): [Never] - Output format: [Format] - Language: [Lang] - Country/language target I may quote (or UNKNOWN): [Locale] Generate: 1. Honesty ledger: Fields nouns, Attrs, Cap, Locale, Lang. Forbidden: invented GTINs, reviews, prices, availability. 2. Mapping table: at most Cap rows. Columns: source field, Merchant attribute, transform note. Missing targets write NOT IN INPUTS. 3. Required-attribute gaps: list Merchant required attrs unnamed in Fields as NOT IN INPUTS. 4. Validation notes: only checks grounded in Fields. Do not invent GTIN check digits. 5. Refuse list: inventing a GTIN, inventing 4.9 stars, inventing in_stock, inventing a sale price. 6. Compliance pass: quote Banned and Never hits. Cut them. Print row count. Format as Format. Constraints: - Map from Fields only. No invented GTINs or reviews. - Honor Cap. No emojis.
Instructions
Replace every [bracket] with your details before running. Works on ChatGPT, Claude, and Gemini.
Generated Output
This image was generated using the prompt above.
Examples
Example Input
Fields: source columns sku as pasted; title as pasted; color as pasted. gtin column NONE. price column NOT IN INPUTS. review_score NONE. availability NOT IN INPUTS. Attrs: id, title, color, gtin, price, availability as target names to attempt; brand UNKNOWN. Cap: 6 Banned: guaranteed approval, 4.9 stars, GTIN 0000000000000, in_stock invent Never: invent GTINs, invent reviews, invent prices, invent availability Format: ledger + map + gaps + validation + refuse + compliance Lang: English Locale: en-US as pasted
Example Output
1. Ledger. Fields: sku; title; color. gtin NONE. price NOT IN INPUTS. review_score NONE. availability NOT IN INPUTS. Attrs targets: id, title, color, gtin, price, availability; brand UNKNOWN. Cap 6. Locale en-US. Lang English. Forbidden: invented GTINs, reviews, prices, availability, guaranteed approval, 4.9 stars, fake GTIN, in_stock invent. 2. Mapping table (3/6). 1. sku as pasted -> id (use sku as offer id; do not invent a second id) 2. title as pasted -> title 3. color as pasted -> color gtin: source NONE so map cell NOT IN INPUTS. price: NOT IN INPUTS. availability: NOT IN INPUTS. brand UNKNOWN so no brand row. 3. Required-attribute gaps. price NOT IN INPUTS. availability NOT IN INPUTS. gtin NONE (may be required depending on product type; still NOT IN INPUTS). brand UNKNOWN. link/image_link NOT IN INPUTS (not in Fields). 4. Validation notes. sku non-empty check: grounded. title non-empty: grounded. GTIN check digit: refused (NONE). review aggregate: refused (NONE). Locale en-US noted; currency NOT IN INPUTS. 5. Refuse. GTIN invent: refused. 4.9 stars: refused. in_stock invent: refused. Sale price invent: refused. Guaranteed approval: refused. 6. Compliance. Banned hits none. Rows 3/6. Format ledger+map+gaps+validation+refuse+compliance. Gaps: gtin, price, availability, brand, image_link. Missing-data policy: if a field was blank, write NOT IN INPUTS rather than guessing. Lock any tool version named in Inputs; if unnamed, write unknown. No invented testimonials, star ratings, or press logos. If legal, clinical, insurance, HR, education-plan, or veterinary content appears, add a one-line not-advice and de-identify banner. Quote banned-word hits and cut them. End with a gaps list of five bullets the user still owes you. Character and byte caps in the job are hard; print counts when relevant. Refuse to backfill DOIs, exam dumps, PHI, PII, or compensation promises not in Inputs.