A profitability and re-marketing system for a US Amazon seller
A seller of medical, dental and veterinary practice labels on Amazon tracked profitability entirely in Excel, manually pulling ShipStation exports and calculating Amazon fees by hand. We built a multi-tenant system that imports shipped orders automatically, applies item cost and Amazon referral fees, and calculates profit at the order, item and portfolio level.
- CLIENT
- A US medical and dental supplies seller on Amazon
- INDUSTRY
- Ecommerce, Amazon Seller Central
- ENGAGEMENT
- Custom system design, development and long-term support, ongoing since Q4 2024.
- STACK
- ASP.NET Core, C#, SQL Server, Entity Framework, Web API, ShipStation API
COREinventory + pricing
Profitability lived in a spreadsheet, rebuilt by hand after every batch of orders.
- Manually downloading order and shipment files exported from ShipStation
- Manually entering item pricing, cost, shipping cost and Amazon referral fees to work out profitability
- No centralized way to see profit margin per order or per item
- No structured way to see which customers buy which products, or who needs re-targeting for annual renewal purchases
- No access control, so everyone working with the data had the same level of access
One system, built around how the work actually happens.
Shipped orders pulled in automatically
Only orders that have actually shipped are imported from ShipStation, carrying order, customer, SKU and quantity detail straight into the system.
Profit calculated automatically, per unit and per order
Item cost, shipping cost pulled through from ShipStation, and Amazon referral fee per item are applied automatically to produce price, cost, profit and margin without a spreadsheet.
A dashboard and two drill-down reports
Sales, profit, customer and order totals for any period, plus item-level and order-line-level reports filterable by SKU, customer, vendor, ASIN, brand and warehouse.
A full item and category catalog
Every SKU, cost, price, vendor and category the client sells, structured to match their actual product lines, with bulk import and export.
Year-based tagging for renewal products
Customers are tagged by the specific product year they purchased, since several label products are annual and need re-purchasing, so the client can filter and re-target the following year's buyers.
Role-based access across the whole system
A granular per-module permission matrix across every functional area, separating customer, manager and admin access consistently throughout the application.
What it runs on.
What changed.
- Manual Excel-based cost, shipping and Amazon-fee tracking eliminated
- Order-level and item-level profitability visible directly in the system instead of reconstructed by hand
- A centralized item catalog and category structure covering the client's full product range
- A centralized customer database with year-based tagging supporting repeat and renewal outreach
- Role-based access lets the client extend system access to staff without exposing full admin functionality
This page shows no percentages or figures because none have been confirmed by the client for publication. Where a number is not verified, it is left out rather than estimated.
After go-live.
The system has been in continuous daily use since the project began, for order import, profitability tracking and customer re-marketing, and we remain the client's long-term partner for support and enhancements.
The work behind this project.
Where this work applies.
Running into something similar?
Describe what you are dealing with and we will tell you honestly whether this is a pattern we have solved before.