Discuss a project

DL-029 · Case study

Vendor-to-Seller conversion tracker for a reseller's brand portfolio

A reseller moves brands from Amazon Vendor Central onto its own seller accounts. We joined both sides in one warehouse, with dashboards showing where each brand stands in that move.

Client
Name withheld
Location
US South
Industry
Amazon 1P-to-3P reseller
Capabilities
03Build
01

Challenge

  • Conversion progress per brand was split across Vendor and Seller views.
  • The team needed a clear rule for when a product had converted.
  • Remaining vendor stock and reorder needs were hard to project.
02

Environment

  • Brand portfolio sold through Vendor Central and the reseller's seller accounts.
  • Vendor history from a third-party data provider; live data from SP-API.
  • Analysts working in Looker Studio and Google Sheets.
03

Intervention

  • SP-API reports every 15 minutes, joined with vendor sales, inventory and POs.
  • Two years of history backfilled for every brand.
  • Daily pipeline for conversion state, weeks of coverage and projected depletion.
  • Dashboards: pre- and post-conversion, 3P landscape, order projection.
04

Outcome

  • One view of each brand's move from 1P to 3P.
  • Conversion judged by one rule: live 3P listing, minimal vendor stock.
  • Reorder quantities projected from coverage, with planner inputs in Sheets.
Seller Central reports from SP-API and vendor history from a third-party provider land in one warehouse; a daily pipeline computes conversion state, coverage and depletion, which Looker Studio views present alongside planner inputs from Google Sheets.SELLER CENTRALSP-API, 15 minVENDOR DATAThird-party feedWAREHOUSE24-month historyCONVERSION PIPELINEDailySHEETSPlanner inputsLOOKER STUDIOConversion viewsORDER PROJECTIONReorder qty
  1. 01SELLER CENTRALSP-API, 15 minWAREHOUSE24-month history
  2. 02VENDOR DATAThird-party feedWAREHOUSE24-month history
  3. 03WAREHOUSE24-month historyCONVERSION PIPELINEDaily
  4. 04SHEETSPlanner inputsCONVERSION PIPELINEDaily
  5. 05CONVERSION PIPELINEDailyLOOKER STUDIOConversion views
  6. 06CONVERSION PIPELINEDailyORDER PROJECTIONReorder qty
Fig. 01Vendor and Seller data in one trackerSeller Central reports from SP-API and vendor history from a third-party provider land in one warehouse; a daily pipeline computes conversion state, coverage and depletion, which Looker Studio views present alongside planner inputs from Google Sheets.Scale NTS

Results, as published.

15 min
Seller data refresh
24 months
History backfilled

Stack and services.

Stack08

  • Amazon SP-API
  • Node.js
  • TypeScript
  • PostgreSQL
  • Amazon DynamoDB
  • Amazon SQS
  • AWS Lambda
  • Looker Studio

Services used01

Tell us what has to work.

A senior engineer reads every brief. Describe the system, what it runs on today and what happens when it fails.

Discuss a project