Amazon MWS: Transition to SP-API

Supercharge seller operations with code-free, automated Amazon MWS, now SP-API, data integration for analytics & sales automation

Thomas Spicer
Published in
5 min readJun 3, 2022

--

Some of the most important Amazon MWS APIs will be turned off as of July, 30th, 2020. Amazon also has stated that third-party public developers using any MWS API must fully migrate to Selling Partner API (SP-API) by December 31, 2022.

Amazon MWS to Selling Partner Migration

Amazon Sellers need to do everything they can to get an edge. The highest-performing sellers on Amazon drive performance by taking advantage of an essential resource available to them, data. Historically, they would tap into performance data from Amazon Merchant Services or Amazon MWS, which is now a legacy collection of data APIs to automate business operations.

The future is Amazon Selling Partner. Having direct, automated access to SP-API data allows sellers to discover insights as to when customers may be more likely to purchase, optimize ad spending, inform inventory management decisions, target special offers, and promotions.

Openbridge offers code-free, fully-automated SP-API data pipelines to a private data lake or cloud warehouse. Here are some of the areas we support:

Amazon Inventory

Get FBA Inventory Reports data for the listing, condition, disposition, and quantity to help with day-to-day inventory.

Amazon Orders

Order and item information for both FBA and seller-fulfilled orders including order status, fulfillment and sales channel information, and item details with Order API, and FBA Orders Reports.

Perform order synchronization, order research, and demand-based decision support with a real-time feed of your order transactions. This will allow you to synchronize Amazon order data with order data in your local ordering system for fulfillment-by-merchant (FBM) efforts.

  • Find SKUs with high or low sales volumes
  • Support for FBA replenishment and removal decisions
  • Monitor sales trends by SKU
  • Find SKU sales trends by sales channel and by fulfillment channel
  • Find SKUs that have been in a given state for too long
  • Find unexpected changes in sales trends by SKU
  • Support for sales channel and fulfillment channel decisions

Amazon Finance

Balances, payouts, estimated and actual selling, storage, and fulfillment fee data with FBA Settlement Reports, FBA Fees, and Finance API.

Settlement reports provide a detailed breakdown of your account activity for a given settlement period. By reviewing the settlement report, you can understand your account activity like fees, A-to-Z guarantee claims, chargebacks, customer refunds, and reserves that can affect your balance.

Detail Sales & Traffic

Business level Sales and Traffic reports offer performance metrics for product sales, revenue, units ordered, and page traffic metrics such as page views and buy box.

Vendor Central

Manage retail business operations with automated integration so vendors can improve and maintain performance at scale while growing business.

Retail Analytics

Vendor Retail Analytics delivers ordered revenue, glance views, conversion, replenishable out-of-stock, lost buy box, returns, replacements, and many more.

Brand Analytics

Brand Analytics offers sellers and vendors market basket analysis, search terms, repeat purchases, alternate purchases, item comparisons, and much more.

Amazon Fulfillment API

Get comprehensive, product-level detail on inbound shipments, shipped FBA orders, quantity, tracking, and shipping with FBA Fulfillment Reports and Inbound Fulfillment API.

If you sell products on different marketplaces, Amazon’s Fulfilled by Amazon (FBA) is the go-to for fulfilling orders. Getting insights into your inbound shipments to a destination Amazon fulfillment center is critical to operational insights.

Our integration delivers critical inbound fulfillment shipment data for your inventory sent to Amazon’s fulfillment network:

  • Status of inbound shipments
  • Amazon fulfillment center destination
  • Items contained in an inbound shipment
  • Amazon’s fulfillment network SKU of the item
  • Seller SKU
  • Shipment name

With your inventory registered within Amazon’s fulfillment network, our Fulfillment Inbound Shipment API connector automates the delivery of data you need to develop insights into your orders, whether you are selling on Amazon’s retail website or through other retail channels.

Unify your Amazon global selling data

Global marketplaces represent the world’s largest e-commerce opportunities. Our data integration allows you to gain immediate access to your operational data. Tapping into your Amazon marketplace data means you can optimize global sales, operations, and support.

Openbridge supports global Amazon Seller Central marketplaces via the Selling Partner API:

For a complete list, see Amazons documentation:

Extend your retail and commerce strategy by selling to Amazon customers worldwide

Not selling globally yet? Over 300 million customers shop in Amazon stores worldwide. If you are not selling on Amazon today, you miss out on significant growth and revenue opportunities.

Are you worried about complex logistics? Did you know that Amazon can handle the shipping, returns, and customer service for you? It is called Fulfillment by Amazon (FBA).

Getting started is quick and easy:

  • Advertise on Amazon — Promote your products and brand to millions of customers. Pay only when your ads are clicked. Your first $50 in clicks is free.
  • Sell on Amazon — Put your products in front of tens of millions of Amazon shoppers. With no per-item listing fees, Amazon can help you grow your business.
  • Fulfillment by Amazon (FBA) — Enable your listings on Amazon to qualify for Amazon Prime and Free Shipping on eligible orders with world-class fulfillment.
  • Sell in Europe — Reach millions of new customers through one Amazon European account and bring your business to the next level. Read the getting started in Europe guide by Amazon

If and when you start selling globally, we will be there to support you!

Not using an API? Stop the painful, messy, and manual Seller Central report downloads

Are you manually downloading CSV files from the Amazon Seller Central? Do you log in to grab an Amazon seller download inventory file? How about getting a CVS of your latest Amazon seller central order report? Those days of manual report downloads are over! Start using the new automated SP-API data pipeline service today.

No painful, agonizing development work, we did the Selling Partner API integration for you

Unify your data in industry-leading data destinations like Amazon Redshift, Amazon Redshift Spectrum, Google BigQuery, Snowflake, Azure Data Lake, and Amazon Athena. Use your favorite business intelligence, data visualization, SQL, or data science tools like Google Data Studio, Tableau, Microsoft Power BI, Looker, or Amazon Quicksight?

No need to hire an Amazon Selling Partner developer or build your own integrations. By using a pre-built, fully-managed Amazon SP-API or Ads connector, sellers can increase selling efficiency, reduce labor requirements, and improve response time to customers.

Scale swiftly and accelerate your Seller operations with our world-class SP-API data integration service.

Get a free trial of our Amazon Advertising API and Amazon Selling Partner API seller software data integrations today!

--

--