Understanding the Customer Shipment Sales Report for FBA Sellers
The Customer Shipment Sales Report is a daily, tab‑delimited file that provides product‑level data for every FBA order shipped, retaining up to 18 months of history. It includes the seller SKU, Amazon FNSKU, marketplace ASIN, fulfillment‑center ID, unit price, shipping charge and gift‑wrap fee, plus city, state and postal code of the buyer.
Overview
The Customer Shipment Sales Report is an Amazon‑generated file that lists every FBA order shipped to a buyer, broken down to the individual product level. It is refreshed daily and can be downloaded from Seller Central for any date range within the last 18 months. Sellers who rely on accurate revenue tracking, inventory placement, and regional demand insights should incorporate this report into their regular data‑maintenance routine.
Key Points
- Product‑level granularity — Each line in the file represents a single SKU that was shipped, showing the exact quantity, price paid, and delivery address, so sellers can see which items generated revenue on a per‑order basis.
- 18‑month retention window — Amazon stores shipment data for a year and a half; any records older than that disappear unless the seller exports and archives the files beforehand.
- Triple identifier inclusion — The report supplies the seller‑assigned SKU, the Amazon‑assigned FNSKU, and the marketplace ASIN, enabling seamless cross‑referencing with inventory management systems and other Amazon reports.
- Fulfillment‑center attribution — A column identifies the specific Amazon warehouse that dispatched the order, helping sellers evaluate how their inbound shipments are being utilized across the network.
- Full pricing breakdown — Separate fields list the unit item price, per‑unit shipping charge, and any gift‑wrap fee, allowing precise calculation of gross sales, shipping reimbursements, and ancillary revenue.
- Geographic destination data — City, state/region, and postal‑code fields capture the buyer’s delivery location, which can be leveraged for market‑size analysis, tax compliance, and targeted advertising.
How the Customer Shipment Sales Report Works
- Generate the file — In Seller Central, the seller selects “Reports → Fulfillment → Customer Shipment Sales Report,” chooses a start and end date, and clicks “Request.” For example, a seller wanting data for March 2024 would set 03/01/2024 as the start date and 03/31/2024 as the end date, then submit the request.
Analysis & Recommendations
Why This Matters
With line‑by‑line pricing and fulfillment data, sellers can reconcile daily payments, spot missing reimbursements (e.g., a $12.34 discrepancy) and optimize inventory by directing stock to the warehouses that ship the most units. The 18‑month retention forces regular archiving to preserve audit‑ready records.
Key Takeaways
- Data is retained for 18 months; older records disappear unless archived.
- Each row contains three identifiers: seller SKU, Amazon FNSKU, and marketplace ASIN.
- A FulfillmentCenterID column reveals which Amazon warehouse dispatched each unit.
- Pricing breakdown fields include ItemPrice, ShippingPrice, and GiftWrapFee for precise gross‑sales calculations.
Recommended Actions
- →In Seller Central, navigate to Reports → Fulfillment → Customer Shipment Sales Report, select the desired start and end dates, and click “Request”.
- →When the file appears in the Download tab, download the .txt or .csv, then import it into your BI tool (e.g., Power BI, Excel) mapping columns like...
- →Save the file to a secure archive using the naming pattern CustShipSales_YYYYMMDD-YYYYMMDD.csv and store it in cloud storage for at least 18 months.
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!