Sales & order analytics
Track revenue, units, and trends over time
Workhorse & Show Pony (WHSP) helps independent ecommerce sellers understand and grow their business with custom analytics, reporting, and operational insights built around your needs, starting with Amazon through its official Selling Partner API.
We build custom data and reporting solutions for ecommerce sellers, shaped by your needs and the platforms you sell on. By connecting securely to your seller accounts through official APIs, we turn raw order, inventory, pricing, advertising, and financial data into clear insights you can act on.
Track revenue, units, and trends over time
Stay ahead of low-stock and out-of-stock risks
FBA and AWD inventory, inbound shipments, and fulfillment costs
Track fees and profitability
Organize performance by product, SKU, and category
See ad spend, impressions, and ad versus organic sales
Every report is built around your business and the platforms you sell on. Amazon is supported today, with more platforms added as our clients need them.
Workhorse & Show Pony LLC builds custom reports for Amazon sellers and brand owners using Amazon's Selling Partner API (SP-API) and the Amazon Ads API. You authorize access through Amazon, choose the reports you need, and can revoke access at any time.
Each area below is a role in Amazon's Selling Partner API that you grant us when you authorize. Depending on your business, your reports can draw on:
For brands enrolled in Amazon Brand Registry: Search Query Performance, Top Search Terms, Market Basket, and Repeat Purchase reports for your own brands, charted over time so you can see which search terms and products drive your sales. Reported only to you, never pooled with other sellers.
SP-API role: Brand Analytics
Account health and performance metrics for your seller account, tracked over time so you can spot a declining metric before it affects your account.
SP-API role: Selling Partner Insights
Orders, units, and sales by ASIN, SKU, and marketplace, alongside current inventory levels, days of cover, and low-stock alerts, so you know what to reorder and when.
SP-API role: Inventory and Order Tracking
Settlement reports, fees, refunds, and reimbursements reconciled by SKU. Upload your cost of goods in the portal to see true margin per product and per order.
SP-API role: Finance and Accounting
FBA inventory, inbound shipments, removals, and fulfillment and storage fees, so you see the full cost of fulfillment and can plan replenishment.
SP-API role: Amazon Fulfillment
AWD inventory and inbound shipment reporting, combined with your FBA inventory, to plan replenishment across your whole supply chain.
SP-API role: Amazon Warehousing and Distribution
Catalog and listing reports by ASIN and SKU: listing status, suppressed or incomplete listings, and issues to fix, so your catalog stays live and complete.
SP-API role: Product Listing
Sponsored Products, Sponsored Brands, and Sponsored Display performance by ASIN: ad spend, impressions, clicks, and ad versus organic sales.
Amazon Ads API (separate from SP-API)
Amazon data, including Brand Analytics, is used only to provide reports to the selling partner who authorized it. We never combine data across sellers, never sell or share it, and never publish or use insights about Amazon's own business.
Sell somewhere else? Tell us which platform you need.
Grant access through the platform's official authorization flow (for Amazon, Seller Central and Amazon Ads). You stay in control and can revoke access at any time.
We securely retrieve and organize your data on a scheduled basis.
Access dashboards, reports, and insights that help you make faster, better decisions.
Your data is encrypted, used only to provide services to you, and never sold or shared for anyone else's purposes.
Designed around the realities of independent ecommerce businesses.
Workhorse & Show Pony (WHSP) is a specialized data and analytics practice for ecommerce sellers, founded by data engineers with deep experience building real-time and batch data systems. We bring proven data practices to the specific needs of independent online businesses.
Every solution is custom, so pricing is quote-based. Requesting a quote is free: we schedule a call to understand your use cases, then send a written quote listing all fees before any work starts.
Connecting your Amazon account and building the reports you chose.
Scheduled data refresh, hosting of your portal, and support. It scales with the number of reports and how often they refresh, not with your revenue or order volume.
No per-seat fees, no usage fees, and nothing payable to Amazon for API access. Additional work later, such as a new report or platform, is quoted separately.
What drives the quote: which Amazon data areas and reports you need, the size of your catalog, your monthly order volume, how often reports refresh, and the number of marketplaces.
Fill in the form below and we will be in touch to schedule your call.