Cross-store SKU ID mapping checklist for web shop and CRM

SKU drift between stores breaks web shop redemption and support macros. Apple StoreKit and Google Play Billing each require their own product identifiers; a web shop adds a third namespace.

Checklist

1. Canonical offer key. Human-readable key (for example pass_s1_premium) owned by economy design.
2. Three IDs. Map canonical key → App Store product ID → Play product ID → web-shop SKU.
3. CRM payload. Email/push deep links carry the canonical key, never a single-store ID alone.
4. Support macros. Agents search by canonical key; scripts expand to store IDs.
5. Retirement. When an offer ends, mark all three IDs retired on the same date in the sheet.
6. No silent reuse. Do not recycle Play product IDs for a different entitlement.
7. Reconciliation. Weekly join of store proceeds and web-shop settlements on canonical key.

Limits: Xsolla/Appcharge-specific field names are not body-read here; attach provider docs when wiring a named web shop.

Download the artifact.

Research checked 20 September 2026. Local draft; human editorial review pending.