Google Merchant Center Product Feed Attribute Repair Planner: GTIN MPN Brand Rules, Image Requirements, Shipping Attributes, and a Supplemental Feed Patch Sheet

Prompt

Act as a Google Merchant Center feed specialist who clears product attribute rejections, enforces GTIN MPN brand identity rules, fixes image and shipping attributes, and writes supplemental feed patches sellers can upload.

Inputs:
- Store platform and how the primary feed is generated (Shopify app, Content API, CSV scheduled fetch): [FeedSource]
- Sample rejected offer rows with item id, title, brand, GTIN, MPN, image link, and the Merchant Center issue codes: [RejectedOffers]
- Shipping model (table rates, carrier calculated, free over threshold) and return policy URL if any: [ShippingAndReturns]
- Whether products are apparel, media, or hard goods that change identifier rules: [ProductVertical]
- Countries and languages in the feed: [TargetMarkets]
- Output format: [Format]

Generate:
1. An issue triage table: each RejectedOffers row mapped to root cause (identifier, image, shipping, price mismatch) with a one line fix.
2. A GTIN MPN brand rule card for ProductVertical: when GTIN is required, when MPN plus brand substitutes, and when identifier exists false is allowed.
3. An image fix list: main image rules (no promo overlay, correct URL, enough pixels) tied to each failing offer; mark uncertain policy edges as [confirm Merchant Center image specs].
4. A shipping attributes block for ShippingAndReturns and TargetMarkets: shipping(country:price) or account level shipping services, plus return policy link attribute if required.
5. A supplemental feed patch sheet: column headers Google expects, one corrected row per RejectedOffers item, and which fields override the primary feed.
6. A revalidation checklist: upload patch, request review timing, and which issues need a primary feed fix instead of supplemental.
7. A prevention note for FeedSource: which platform field maps to each Google attribute so the next sync does not reintroduce bad GTINs.
8. A FAQ for common false fixes (fake GTINs, white background myths, deleting offers instead of patching).

Constraints:
- Do not invent GTIN check digit math results or claim a specific review SLA; use [confirm].
- Never recommend fabricating GTINs. Plain operator tone. No em dashes.

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

FeedSource: Shopify + Google and YouTube channel app primary feed; supplemental CSV planned
RejectedOffers: 1) SKU LAMP-14 id shopify_US_111_14 title Brass Desk Lamp brand Homelight GTIN blank MPN HL-14 issue missing_gtin + image_too_small 2) SKU SERUM-02 id shopify_US_222_02 title Cobalt Serum 30ml brand Northcove GTIN 00012345678905 (fails validation) MPN NC-S02 issue invalid_gtin + shipping_missing
ShippingAndReturns: US flat 5.99 under 50 USD else free; returns URL https://northcove.example/returns
ProductVertical: hard goods home and beauty
TargetMarkets: United States, English
Format: triage table, identifier rules, image fixes, shipping block, supplemental sheet, checklist, prevention, FAQ

Example Output

1) TRIAGE
| id | Issues | Root cause | Fix |
| shopify_US_111_14 | missing_gtin, image_too_small | no GTIN and 400px image | add GTIN or brand+MPN if no GTIN exists; replace image with >= max recommended size [confirm] |
| shopify_US_222_02 | invalid_gtin, shipping_missing | bad check digit / attribute; shipping not on offer or account | correct GTIN from packaging or clear and use MPN+brand if legitimately GTIN-less; add shipping(US:5.99 USD) or account shipping service |

2) IDENTIFIER RULES (hard goods)
- Prefer real GTIN from packaging barcode.
- If no GTIN exists: brand + mpn required; set identifier_exists to no when Google allows for that vertical [confirm].
- Never pad fake UPC values. SERUM-02 current GTIN fails validation: verify digits with the brand owner before reupload.

3) IMAGE FIXES
- LAMP-14: export a clean product photo without price sticker overlay; minimum longer side per Merchant Center [confirm]; update image_link.
- SERUM-02: image OK if issue list only mentioned GTIN and shipping; recheck after identifier fix.

4) SHIPPING ATTRIBUTES
Account level: US shipping service 5.99 USD below 50, 0 USD at/above 50 [confirm channel shipping settings].
Offer level patch if needed: shipping(country:US:price:5.99 USD) for under-threshold SKUs, or rely on account services consistently.
returns: link https://northcove.example/returns in return_policy or merchant returns settings [confirm attribute name for your feed type].

5) SUPPLEMENTAL PATCH SHEET
Columns: id, gtin, mpn, brand, identifier_exists, image_link, shipping
Rows:
shopify_US_111_14, [real GTIN or blank], HL-14, Homelight, [yes/no per rule], https://cdn.example/lamp14-large.jpg, shipping(country:US:price:5.99 USD)
shopify_US_222_02, [corrected GTIN], NC-S02, Northcove, yes, [unchanged], shipping(country:US:price:5.99 USD)

6) REVALIDATION
[ ] Upload supplemental CSV in Merchant Center
[ ] Confirm overrides on the two ids
[ ] Fix Shopify product fields so the primary app feed matches
[ ] Request review only after attributes show pending then eligible [confirm]

7) PREVENTION (Shopify)
- GTIN field -> barcode; MPN -> SKU or custom MPN metafield; brand -> vendor
- Image: use the first image over the size floor; strip promo banners before sync

8) FAQ
- Fake GTINs get you suspended; leave blank and use brand+MPN when truly GTIN-less.
- White background is not always mandatory for all surfaces; follow current image specs [confirm].
- Do not delete offers to clear issues if the SKU should stay shoppable; patch attributes instead.