Discuss a project

DL-035 · Case study

MWS to SP-API and feed migration for a textbook seller

A textbook seller ran Amazon on its own Python scripts. We moved them from MWS to SP-API, then replaced retired feeds, keeping the file formats its team already used.

Client
Name withheld
Location
US South
Industry
Textbook retailer
Capabilities
02Stabilize03Build
01

Challenge

  • In-house scripts for orders, tracking and listings depended on the retiring MWS.
  • Amazon later deprecated several feeds the inventory loader relied on.
  • The internal team wanted to keep its own input and output formats.
02

Environment

  • Python scripts run by the seller's in-house IT team.
  • Order lists, tracking uploads and price and stock feeds.
  • Flat-file inventory loads for a large catalogue of book listings.
03

Intervention

  • Rewrote order, tracking and price and stock calls against SP-API.
  • Replaced deprecated feeds and the flat-file loader with current SP-API equivalents.
  • Kept every script's existing file formats so downstream processes did not change.
  • Added ISBN-to-ASIN lookup and offer scripts, and assessed Buy Shipping.
04

Outcome

  • Daily order and listing scripts run on SP-API instead of MWS.
  • Feed deprecations handled without retraining staff or reworking downstream files.
  • The seller's own team still owns and runs the scripts.
The seller's Python scripts keep their input and output files; a migration layer swaps retired MWS calls and deprecated feeds for SP-API Orders and Feeds.SELLER'S OWN SCRIPTSbeforeSCRIPT FILESUnchanged formatsINVENTORY LOADERFlat filesMWSRetiredSP-API LAYERCalls + feedsORDERS APIOrders / trackingFEEDS APIPrice / stockCATALOGISBN to ASIN
  1. 01SCRIPT FILESUnchanged formatsMWSRetiredbefore
  2. 02SCRIPT FILESUnchanged formatsSP-API LAYERCalls + feeds
  3. 03INVENTORY LOADERFlat filesSP-API LAYERCalls + feeds
  4. 04SP-API LAYERCalls + feedsORDERS APIOrders / tracking
  5. 05SP-API LAYERCalls + feedsFEEDS APIPrice / stock
  6. 06SP-API LAYERCalls + feedsCATALOGISBN to ASIN
Fig. 01Same scripts, new Amazon APIThe seller's Python scripts keep their input and output files; a migration layer swaps retired MWS calls and deprecated feeds for SP-API Orders and Feeds.Scale NTS

Stack and services.

Stack06

  • Amazon SP-API
  • Feeds API
  • Orders API
  • Python
  • Flat-file inventory feeds
  • Amazon MWS (retired)

Services used02

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