Setup takes a few minutes. You connect your Amazon, Shopify, or Walmart account and choose the data you want in Google Sheets. After that, data loads and syncs automatically in the background going forward.
.svg "Gorilla ROI")
4.8 Rating · 11k+ Downloads · Trusted by Sellers
Last updated -
June 12, 2026
What This Report Covers
✅ The Orders report returns every Amazon order and order item in your account with full pricing detail: item price, shipping price, taxes, promotional discounts, and order total.
✅ Order status, fulfillment channel, and last update date are included so you can track orders through their full lifecycle.
✅ Shipping address fields and return quantity are included per order so you can analyze customer geography and match returns back to original orders.
The Amazon Seller Central Orders report returns every order and order item in your account. It covers the full pricing breakdown at the item level, order status, fulfillment channel, shipping address, and return quantities matched from customer return data.
Supported Fields
What Sellers Use This For
Order-level revenue breakdown. Item price, shipping price, taxes, and promotional discounts are returned per order item. This gives you the full revenue picture per transaction without manually pulling separate reports.
Fulfillment channel analysis. FulfillmentChannel lets you separate FBA orders from FBM orders. Comparing conversion rates, return rates, and revenue per channel per SKU surfaces which fulfillment method performs better for each product.
Customer geography mapping. City, StateOrRegion, PostalCode, and CountryCode in the shipping address let you map order density by location. This data is useful for identifying high-demand regions and optimizing fulfillment center selection.
Return matching. Return quantity is joined back to the original order row so you can see which orders generated returns and calculate net units sold per SKU without building the join yourself.
B2B order separation. IsBusinessOrder flags Amazon Business orders. If you have B2B pricing or quantity discounts, this field lets you segment B2B revenue and order volume independently.
How Gorilla ROI Pulls This Data
Gorilla ROI connects to the Amazon SP-API using the getOrders and getOrderItems operations from the OrdersAPI, listFinancialEvents from the FinancesAPI, and GET_FLAT_FILE_RETURNS_DATA_BY_RETURN_DATE from the ReturnsReportsAPI. 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 Reports and Supported Fields
Frequently
Asked Questions
How long does setup take?
How does it get data into Google Sheets?
Gorilla ROI connects directly to your ecommerce platforms and syncs structured data into Google Sheets automatically. Once connected, data stays available without re-downloading files.
What platforms can I connect?
Gorilla ROI supports Amazon, Shopify, and Walmart. The focus is ecommerce operations rather than connecting dozens of unrelated platforms.
Will my data stay accurate and update automatically?
Yes. Once connected, data syncs automatically based on your settings so Sheets stays current without manual exports or re-imports.
Does the data match my platform?
Yes. Gorilla ROI pulls data directly from the source. What you see in your sheet matches what the platform API reports.
Do I need coding or technical skills?
No. Gorilla ROI works through a point-and-click interface inside Google Sheets. Advanced users can use formulas if they want, but coding is not required.
Manual Exports Waste Your Team's Time
Replace the Manual Spreadsheet Work and Save 40 Hours a Month
