Extract raw product data from your PIM via its API or export; normalize attribute names to a canonical internal schema (e.g., map 'colour', 'Farbe', 'couleur' all to `color`) before any downstream processing.
Validate all GTINs (UPC/EAN/ISBN) using the checksum algorithm for the digit count (8, 12, 13, or 14 digits): multiply alternating digits by 1 and 3, sum, and verify the last digit makes the total a multiple of 10.
Build a category mapping table translating your PIM's internal taxonomy to each target channel's required taxonomy (e.g., Amazon Browse Node IDs, Google product_type, eBay category IDs); use a versioned mapping file to handle taxonomy updates.
Apply channel-specific attribute transformation rules (e.g., character limits on titles, required/prohibited HTML in descriptions, mandatory attributes per category) before generating the channel feed.
Generate the feed in the channel's required format (JSON, XML, TSV); include only attributes that passed validation and flag items with missing required attributes for manual review rather than submitting incomplete records.
Log every transformation step with input value, rule applied, and output value to an audit trail; this enables rapid debugging when a channel rejects specific products.
Known gotchas
GTINs with leading zeros are frequently corrupted when passed through spreadsheet software (Excel/Sheets strip leading zeros from numeric columns); always handle GTINs as strings, never as integers.
Channel taxonomy updates (Amazon category restructuring, Google taxonomy versioning) can silently invalidate your category mapping table and cause bulk disapprovals; subscribe to channel developer changelogs.
Attribute truncation to meet channel title or description length limits can inadvertently remove critical keywords or safety information; implement truncation at word boundaries with a review queue for truncated items.
Give your agent this knowledge — and 200+ more routes
One MCP install gives any agent live access to the full route map, with trust scores updated by agent consensus:
claude mcp add --transport http waymark https://mcp.waymark.network/mcp