Updates to Amazon Points in Flat Files & XSD
Effective March 21 2023 Amazon will drop the StandardPricePointsPercent and SalePricePointsPercent columns from all inventory flat‑file templates and the matching XSD. Feeds that still include these fields will be rejected with a 400‑level XSD validation error. Sellers must delete the columns and use the Promotions API (e.g., POST /createPromotion) to configure point‑based offers.
Overview
On March 21 2023 Amazon will drop the StandardPricePointsPercent and SalePricePointsPercent fields from its inventory flat‑file schema and the matching XSD definition. The removal is part of a larger effort to simplify the way sellers configure Amazon Points, the loyalty credit shoppers can earn on eligible purchases. Sellers who still include these columns after the deadline will see their feeds rejected, so they must adjust their upload process or shift to the Promotions API to keep point‑based offers alive.
Key Points
- Removal date — Effective March 21 2023 the two points‑related columns disappear from every inventory flat‑file template and from the XSD used for validation.
- Who is affected — Any seller who currently submits StandardPricePointsPercent or SalePricePointsPercent in their inventory feeds will experience validation failures once the change goes live.
- Why Amazon is acting — The company is consolidating points management to a single, API‑driven workflow, reducing the number of attributes sellers must maintain in flat files.
- No automatic migration — Existing point percentages are not converted automatically; sellers must recreate each offer using the new promotion tools.
- Reporting stays intact — Sales reports will continue to show points earned, but the source of those points must now come from approved promotion configurations rather than flat‑file data.
- Compliance consequence — Feeds that still contain the removed attributes after the cut‑off will be rejected with an XSD validation error, halting inventory updates for those SKUs.
How the Points Removal Works
- Schema revision — Amazon publishes an updated XSD that omits the two points fields. For example, a file that previously contained a header named StandardPricePointsPercent will now trigger a “field not recognized” error during the upload process.
- Flat‑file validation — When a seller submits an inventory file, Amazon’s ingestion engine cross‑checks every column against the new XSD. If the deprecated column remains, the system returns a 400‑level error such as “Invalid element: SalePricePointsPercent.”
Analysis & Recommendations
Why This Matters
If sellers keep the deprecated columns after March 21 2023 their inventory feeds will fail, halting SKU updates and potentially stopping points accrual for shoppers. Switching to the Promotions API ensures loyalty credits continue, but requires new implementation steps and testing to avoid revenue impact.
Key Takeaways
- StandardPricePointsPercent and SalePricePointsPercent are removed from flat‑file schema on March 21 2023.
- Feeds containing these columns will be rejected with a 400‑level XSD validation error (e.g., "Invalid element: SalePricePointsPercent").
- Points must now be configured via the Amazon Advertising Promotions API, using a POST to /createPromotion with JSON payload.
- Sales reports will still display points earned, but the source must come from approved promotions, not flat‑file data.
Recommended Actions
- →Download the latest inventory template from Seller Central > Inventory > Add Products via Upload > Download Template and delete any columns matchin...
- →Create point‑based promotions via the Promotions API: obtain SP‑API credentials, generate an access token, and POST to /advertising/promotions/v1/c...
- →Upload a small test file without the removed columns and verify the ‘Points’ status column on the Manage Inventory page shows “No points configured.”
Comments
Join the discussion
Log in or create an account to share your thoughts on this update.
No comments yet. Be the first to share your thoughts!