Sales Total Report

Summed sales amounts, unit counts, and order counts per SKU for any selected period and order status: no aggregation required.

amazon seller central report field data

4.8 Rating · 11k+ Downloads · Trusted by Sellers

Encased
Pet Lovers
Vahdam Teas
Boldify
Viva Naturals
Hyperzon
Ridgeline Insights
Lovebug Probiotics
Encased
Pet Lovers
Vahdam Teas
Boldify
Viva Naturals
Hyperzon
Ridgeline Insights
Lovebug Probiotics
Last updated -
June 13, 2026

What This Report Covers

✅ Sales Total is a custom Gorilla ROI dataset that returns summed sales amounts, unit counts, and order counts for the filters you select: period, SKU, ASIN, marketplace, and order status.

✅ Every order status variant is available as a separate field so you can pull exactly the total you need without building aggregation logic in your sheet.

✅ Use alongside Sales for SKU-level row data and ProfitLoss Total for period profitability summaries.

Sales Total is a custom Gorilla ROI dataset. It sums your Amazon sales amounts, unit counts, and order counts for the filters you apply: marketplace, SKU, ASIN, and period. Every order status is available as a separate field so you can define the exact sales total you want to pull into each cell in your sheet.

Supported Fields

|Report Name|API|Field Name|Description| |---|---|---|---| |Sales Total|GorillaROI API|Marketplace|Marketplace used to filter Amazon order totals| |Sales Total|GorillaROI API|SKU|Seller SKU used to filter Amazon order totals| |Sales Total|GorillaROI API|ASIN|Amazon product identifier used to filter Amazon order totals| |Sales Total|GorillaROI API|SalesTotal - AllButCanceled|Total sales amount from Amazon orders excluding canceled orders| |Sales Total|GorillaROI API|SalesTotal - All|Total sales amount from all Amazon orders| |Sales Total|GorillaROI API|SalesTotal - PendingAvailability (JP only)|Total sales amount from PendingAvailability orders| |Sales Total|GorillaROI API|SalesTotal - Pending|Total sales amount from pending orders| |Sales Total|GorillaROI API|SalesTotal - Unshipped|Total sales amount from unshipped orders| |Sales Total|GorillaROI API|SalesTotal - PartiallyShipped|Total sales amount from partially shipped orders| |Sales Total|GorillaROI API|SalesTotal - Shipped|Total sales amount from shipped orders| |Sales Total|GorillaROI API|SalesTotal - InvoiceUnconfirmed|Total sales amount from invoice unconfirmed orders| |Sales Total|GorillaROI API|SalesTotal - Canceled|Total sales amount from canceled orders| |Sales Total|GorillaROI API|SalesTotal - Unfulfillable|Total sales amount from unfulfillable orders| |Sales Total|GorillaROI API|UnitsCount - AllButCanceled|Units ordered from Amazon orders excluding canceled orders| |Sales Total|GorillaROI API|UnitsCount - All|Units ordered from all Amazon orders| |Sales Total|GorillaROI API|UnitsCount - PendingAvailability (JP only)|Units ordered from PendingAvailability orders| |Sales Total|GorillaROI API|UnitsCount - Pending|Units ordered from pending orders| |Sales Total|GorillaROI API|UnitsCount - Unshipped|Units ordered from unshipped orders| |Sales Total|GorillaROI API|UnitsCount - PartiallyShipped|Units ordered from partially shipped orders| |Sales Total|GorillaROI API|UnitsCount - Shipped|Units ordered from shipped orders| |Sales Total|GorillaROI API|UnitsCount - InvoiceUnconfirmed|Units ordered from invoice unconfirmed orders| |Sales Total|GorillaROI API|UnitsCount - Canceled|Units ordered from canceled orders| |Sales Total|GorillaROI API|UnitsCount - Unfulfillable|Units ordered from unfulfillable orders| |Sales Total|GorillaROI API|OrdersCount - AllButCanceled|Count of Amazon orders excluding canceled orders| |Sales Total|GorillaROI API|OrdersCount - All|Count of all Amazon orders| |Sales Total|GorillaROI API|OrdersCount - PendingAvailability (JP only)|Count of PendingAvailability orders| |Sales Total|GorillaROI API|OrdersCount - Pending|Count of pending orders| |Sales Total|GorillaROI API|OrdersCount - Unshipped|Count of unshipped orders| |Sales Total|GorillaROI API|OrdersCount - PartiallyShipped|Count of partially shipped orders| |Sales Total|GorillaROI API|OrdersCount - Shipped|Count of shipped orders| |Sales Total|GorillaROI API|OrdersCount - InvoiceUnconfirmed|Count of invoice unconfirmed orders| |Sales Total|GorillaROI API|OrdersCount - Canceled|Count of canceled orders| |Sales Total|GorillaROI API|OrdersCount - Unfulfillable|Count of unfulfillable orders|

What Sellers Use This For

Single-cell sales KPIs for dashboards. Pull SalesTotal - AllButCanceled for a marketplace and date range to get one revenue figure per cell. No SUMIF, no pivot table, no sheet restructuring needed.

Period-over-period sales comparison. Pull Sales Total for the current and prior period side by side to build a comparison view. Every status variant is available so your comparison uses the same definition in both columns.

Cancellation and pipeline totals. SalesTotal - Canceled and UnitsCount - Unshipped as period totals give you the aggregate view of what did not convert and what is still in the fulfillment pipeline: useful for operational review without drilling into row-level order data.

How Gorilla ROI Pulls This Data

Sales Total is a custom Gorilla ROI dataset built from your Amazon order data. Data updates automatically on a regular schedule. No csv exports. No manual downloads. The numbers are current the moment you open the sheet. Feed AI with our data to stay on top and ahead of your business.

For field definitions, see the Amazon Seller Data Supported article in our help center.

Other Amazon SP-API Reports and Fields

This data is available through our Amazon Seller Central Reports

| Report | What It Covers | Fields | |---|---|---| | [AWD Inbound Shipments](/amazon-seller-central-reports/awd-inbound-shipments/) | Shipment status, origin, destination, carrier, and received quantity per AWD inbound order | 26 | | [AWD Inbound Shipment Items](/amazon-seller-central-reports/awd-inbound-shipment-items/) | SKU, ASIN, package type, prep category, and dimensions for every item in an AWD inbound shipment | 16 | | [Business Report](/amazon-seller-central-reports/business-report/) | Sessions, page views, Buy Box percentage, unit session rate, and ordered product sales by SKU | 26 | | [Buy Box](/amazon-seller-central-reports/buy-box/) | Marketplace, competing offer count, and Buy Box winner status per SKU | 5 | | [Buy Box Offers](/amazon-seller-central-reports/buy-box-offers/) | Every competing offer per SKU with pricing, fulfillment method, seller feedback, and Buy Box status | 16 | | [Buy Box Winner Full](/amazon-seller-central-reports/buy-box-winner-full/) | The current Buy Box winning offer per SKU with pricing, fulfillment method, and seller detail | 15 | | [Category](/amazon-seller-central-reports/category/) | Full browse category path, top level category, and child category per SKU and ASIN | 6 | | [COGS](/amazon-seller-central-reports/cost-of-goods-sold-cogs/) | Centralized cost of goods sold per SKU matched against Amazon sales and finance data | 4 | | [Competitive Price](/amazon-seller-central-reports/competitive-price/) | Amazon's competitive price per SKU by pricing model, condition, offer count, and landed price | 11 | | [Cost Dump](/amazon-seller-central-reports/cost-dump/) | Raw uploaded cost of goods per SKU with currency, the source behind all COGS calculations | 4 | | [Fees Estimate](/amazon-seller-central-reports/fees-estimate/) | Estimated and final Amazon fees per SKU broken down by FBA, referral, per-item, and variable closing fees | 16 | | [Finance](/amazon-seller-central-reports/finance/) | Every financial event posted to your account: shipments, refunds, fees, charges, and adjustments | 7 | | [Finance Total](/amazon-seller-central-reports/finance-total/) | Summed finance amounts filtered by marketplace, SKU, event type, and charge type | 6 | | [GrossProfit](/amazon-seller-central-reports/gross-profit/) | Calculated gross profit per SKU using Amazon finance amounts, fee data, and uploaded cost inputs | 4 | | [Inbound Shipments](/amazon-seller-central-reports/fba-inbound-shipment/) | FBA shipment name, ship-from address, destination fulfillment center, status, and prep requirements | 19 | | [Inbound Shipment Items](/amazon-seller-central-reports/fba-inbound-shipment-items/) | SKU, quantities shipped and received, fulfillment network SKU, and status per FBA inbound shipment | 9 | | [Inventory](/amazon-seller-central-reports/inventory/) | Total, fulfillable, reserved, inbound, unsellable, and future supply quantities per SKU | 19 | | [Inventory Health](/amazon-seller-central-reports/inventory-health/) | Aged inventory brackets, days of supply, sell-through rate, restock recommendations, and storage cost estimates | 65 | | [Inventory History](/amazon-seller-central-reports/inventory-history/) | Daily FBA inventory snapshots per SKU stored by Gorilla ROI for historical trending and stockout analysis | 21 | | [Inventory Ledger](/amazon-seller-central-reports/inventory-ledger/) | Starting and ending warehouse balances with every inventory movement: receipts, shipments, returns, and losses | 20 | | [Inventory OOS](/amazon-seller-central-reports/inventory-oos/) | Out-of-stock days and out-of-stock percentage per SKU calculated from stored inventory history | 5 | | [Inventory Received](/amazon-seller-central-reports/inventory-received/) | Received date, fulfillment center, FNSKU, and quantity received per FBA inbound receipt | 10 | | [Inventory Restock](/amazon-seller-central-reports/inventory-restock/) | Amazon's recommended replenishment quantity, ship date, days of supply, and restock alerts per SKU | 16 | | [Orders](/amazon-seller-central-reports/orders/) | Every order and order item with pricing, taxes, discounts, fulfillment channel, shipping address, and return quantity | 27 | | [Price](/amazon-seller-central-reports/price/) | Buy Box price, lowest price, and your price per SKU with listing price, shipping, and landed price broken out | 20 | | [Product](/amazon-seller-central-reports/product/) | Full catalog attributes per SKU: title, brand, dimensions, identifiers, keywords, variation details, and image URL | 46 | | [ProfitLoss](/amazon-seller-central-reports/profit-loss/) | Calculated profit or loss per SKU using Amazon sales, fees, charges, and uploaded cost of goods | 8 | | [ProfitLoss Orders](/amazon-seller-central-reports/profit-loss-orders/) | Order-level calculated profit or loss per order ID and SKU with sales, fees, charges, and COGS | 10 | | [ProfitLoss Total](/amazon-seller-central-reports/profit-loss-total/) | Total profit or loss for any selected period summed across marketplace, SKU, and ASIN filters | 8 | | [Ranking](/amazon-seller-central-reports/ranking/) | BSR by top-level category and child category per SKU and ASIN across all marketplaces | 5 | | [ReconcileRefunds](/amazon-seller-central-reports/reconcile-refunds/) | Original order quantity matched against returned quantity per order ID and SKU | 8 | | [Refund](/amazon-seller-central-reports/refund/) | Refund rate, units refunded, and total refund amount per SKU and ASIN | 6 | | [Refund Total](/amazon-seller-central-reports/refund-total/) | Total refund percentage, units refunded, and refund amount for a selected marketplace and period | 4 | | [Reimburse Details](/amazon-seller-central-reports/reimburse-details/) | Every FBA reimbursement with reason, condition, cash and inventory quantities, and total amount | 17 | | [Reimburse Inventory](/amazon-seller-central-reports/reimburse-inventory/) | Inventory adjustment events from the ledger with date, fulfillment center, quantity, reason, and disposition | 10 | | [Reimburse Replace](/amazon-seller-central-reports/reimburse-replace/) | Every FBA replacement shipment with reason code, fulfillment center, and original order ID | 9 | | [Reimburse Returns](/amazon-seller-central-reports/reimburse-returns/) | Every customer return with reason, disposition, status, fulfillment center, and customer comments | 14 | | [Removals](/amazon-seller-central-reports/removals/) | Amazon's recommended removal quantities per SKU split by sellable and unsellable age brackets | 14 | | [Removals Details](/amazon-seller-central-reports/removals-details/) | Every removal order line with status, quantities, disposition, removal fee, and last updated date | 16 | | [Sales](/amazon-seller-central-reports/sales/) | Sales amounts, unit counts, and order counts per SKU broken down by every Amazon order status | 33 | | [Sales Total](/amazon-seller-central-reports/sales-total/) | Summed sales amounts, unit counts, and order counts for any selected period and order status | 33 | | [Settlement](/amazon-seller-central-reports/settlement/) | Settlement ID, period dates, deposit date, and total amount per Amazon settlement payment | 6 | | [Settlement Details](/amazon-seller-central-reports/settlement-details/) | Every transaction line inside each settlement with amount type, description, order IDs, and posted date | 19 | | [Storage Fees](/amazon-seller-central-reports/storage-fees/) | Estimated monthly storage fee per ASIN with dimensions, weight, size tier, storage rate, and discount eligibility | 24 |

Frequently
Asked Questions

Black upward arrow on white background

What is a Seller Central report?

Amazon generates structured data sets from your account activity. Each report covers a specific area: orders, inventory, settlements, fees, reimbursements, and more. The fields on each page show exactly what data that report contains and how it is labeled in Amazon's system.

Black upward arrow on white background

Where does Gorilla ROI get this data?

We pull directly from Amazon's Selling Partner API. No third-party intermediaries. No manual csv exports. The data comes from Amazon's own reporting infrastructure, the same source Seller Central uses to generate your reports.

Black upward arrow on white background

How current is the data once it's connected?

Data refreshes automatically on a regular schedule. The exact cadence varies by report type based on how frequently Amazon makes that data available through the API.

Black upward arrow on white background

Do I need to download anything or export from Seller Central?

No. Once connected, your account data pulls automatically. There are no csv files to export, no manual steps, and no scheduled downloads to manage.

Black upward arrow on white background

Can I pull multiple reports at the same time?

Yes. Each report maps to a separate dataset. You can pull as many as your account supports and work with them side by side.

Black upward arrow on white background

What does the "API" column in the field table mean?

It identifies which Amazon SP-API endpoint provides that data. Different report types pull from different APIs: the Reports API, Orders API, FBA Inventory API, Product Pricing API, and others. This helps you understand the data source behind each field.

Black upward arrow on white background

Are all fields listed on each page actually available in my account?

Field availability depends on your seller account type and the marketplaces you sell in. FBA-specific fields, for example, are not available to FBM-only accounts. The fields listed reflect what Amazon exposes through the API for that report.

Black upward arrow on white background

What if I don't see a report I need?

Check the data-supported page for the full list of reports we pull. If the report you need is not there, contact our support team. We add reports based on seller demand.

Manual Exports Waste Your Team's Time

Replace the Manual Spreadsheet Work and Save 40 Hours a Month