Update to the FBA Quantity report for EU
On May 2 2022 Amazon added two new integer columns, afn‑fulfillable‑quantity‑local and afn‑fulfillable‑quantity‑remote, to the _GET_FBA_MYI_ALL_INVENTORYDATA and _GET_FBA_MYI_UNSUPPRESSED_INVENTORYDATA feeds for Spain, UK, France, Germany and Italy. The columns appear at the end of the tab‑delimited file and split the existing afn‑fulfillable‑quantity into local and remote stock.
Overview
On May 2 2022 Amazon refreshed the FBA inventory reports for its five European marketplaces—Spain, United Kingdom, France, Germany, and Italy. The update introduces two new columns, afn‑fulfillable‑quantity‑local and afn‑fulfillable‑quantity‑remote, to both the _GET_FBA_MYI_ALL_INVENTORYDATA and _GET_FBA_MYI_UNSUPPRESSED_INVENTORYDATA feeds. Sellers who depend on these reports for stock planning, replenishment, or multi‑country fulfillment must adjust their data pipelines to capture the added fields and leverage the clearer visibility into intra‑EU inventory distribution.
Key Points
- Report scope broadened — The two new columns appear in every “all inventory” and “unsuppressed inventory” file for all five EU sites, so any integration that pulls either feed will receive the extra data.
- Local vs. remote distinction — afn‑fulfillable‑quantity‑local reports units stored in the fulfillment center that directly serves the requested marketplace, while afn‑fulfillable‑quantity‑remote lists units held in any other EU fulfillment center that can be transferred to satisfy demand. For example, a UK‑based SKU with 80 units in the UK hub and 20 units in the French hub will show 80 in the local column and 20 in the remote column on the UK report.
- Existing columns untouched — All previously available fields—SKU, ASIN, total afn‑fulfillable‑quantity, etc.—remain exactly as before, ensuring that historic scripts and dashboards continue to function without modification.
- File format unchanged — The reports are still delivered as tab‑delimited text files; the new columns are added to the header row as integer values, so parsing logic only needs to recognize two additional column names.
- Immediate effect — The schema change went live on the release date, and any request made after May 2 2022 returns the expanded file. There is no fallback to the legacy format, so downstream systems must be ready to handle the new columns right away.
How the Updated Report Works
-
— When a seller or third‑party tool requests _GET_FBA_MYI_ALL_INVENTORYDATA (or its unsuppressed counterpart) for an EU marketplace, Amazon assembles the current inventory snapshot and appends the two new columns to the end of the file.
Analysis & Recommendations
Why This Matters
The new columns give sellers precise visibility of stock stored in the marketplace‑specific fulfillment center versus other EU hubs, enabling accurate replenishment and transfer planning. Without updating pipelines, reports will be mis‑parsed, causing inventory mismatches and potential stock‑outs.
Key Takeaways
- New columns added on May 2 2022 to both all‑inventory and unsuppressed inventory reports for the five EU marketplaces.
- Column names are afn‑fulfillable‑quantity‑local and afn‑fulfillable‑quantity‑remote, added to the header row as integer values.
- The original afn‑fulfillable‑quantity field remains unchanged and equals the sum of local and remote quantities.
- Reports are still tab‑delimited and delivered via MWS Reports API and the newer SP‑API.
Recommended Actions
- →Update CSV/TSV parsing code to include the two new headers (Seller Central > Reports > Inventory > Download) and map them to local_qty and remote_q...
- →Modify inventory sync scripts to store afn‑fulfillable‑quantity‑local and afn‑fulfillable‑quantity‑remote in your database (e.g., add columns in th...
- →Run test pulls using both MWS and SP‑API after May 2 2022 to verify the new columns are present and correctly processed.
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!