Summary of Amazon Marketplace SP API Walkthrough 2022 - Orders, Sales and Products requests examples

00:00:00 - 00:50:00

The Amazon Marketplace SP API allows developers to access and retrieve data sets such as orders, sales, products, and seller information using programming languages like Python or JavaScript. The video provides examples of how to use the API for retrieving order and product pricing information, automating tasks, and monitoring seller efficiency. The speaker also discusses the challenges of automating the payments report from Amazon and suggests seeking personalized assistance for detailed questions. Despite the poor documentation of the API, the video highlights the potential of SP API for building custom software projects, and viewers are encouraged to contact Delta Logic for help with custom integrations.

• 00:00:00 applications that are specifically tailored to your needs as an Amazon seller. The Amazon SP API provides access to data sets such as orders, sales, and products, which can be accessed using different programming languages such as Python or JavaScript. Delta Logic, a software agency that builds custom software projects, uses the Amazon SP API to build tailored solutions for bigger sellers who sell on different marketplaces and channels. In this section, Jacob, the co-founder of Delta Logic, provides an overview of the Amazon SP API and showcases some examples of data sets that can be accessed using the Python programming language.
• 00:05:00 In this section of the video, the speaker explains the concept of private and public Amazon Marketplace apps, along with the Amazon Marketplace API. Private apps are for personal use and gathering orders data, while public apps need Amazon's approval and go through a review process. The video discusses how to search for apps on Amazon's Central Partner Network, which lists categories like automated pricing and shipping solutions. The video then dives into the Orders and Sales API, which the speaker demonstrates how to use with Python. The speaker also explains the concept of references and models, which give an overview of what can be retrieved from the API.
• 00:10:00 In this section, the speaker discusses how to gather orders and filter them using different parameters through the Amazon Marketplace SP API. The API offers a range of parameters such as created after, created before, and filter by status, which help filter orders by specific timestamps and marketplaces, making it easier for sellers to manage their orders. Additionally, the speaker demonstrates how developers can use the Python wrapper to simplify the process of creating manual requests, and shows how to register as an Amazon developer to access the API.
• 00:15:00 In this section, the speaker walks through the process of using the Amazon Marketplace SP API to retrieve order information. He explains that the API credentials can be obtained by registering as a developer on Amazon's developer account and provides a line of code that reads the developer account credentials. Then, he demonstrates how to retrieve order information by using the orders API endpoint and provides an example of retrieving orders created after a certain date. He also addresses a question about whether the API provides email addresses of buyers and explains that Amazon hides the email addresses, so it is not possible to retrieve them. Lastly, he shows how to retrieve historical order information using the get order request.
• 00:20:00 In this section, the speaker provides examples of using Amazon Marketplace SP API for retrieving order metrics and product pricing information. For order metrics, the speaker shows how to use the "Sales" API to get aggregated matrix for a given interval broken down by granularity. For product pricing, the speaker uses the "Products" API to programmatically retrieve product pricing information of different marketplaces and for products, which can be useful for building monitoring tools. They retrieve information about a particular item by using the "Get item offers" API with the ASIN of the item and the condition. The retrieved information includes the listing price, buy box winner, and information about different buy box sellers.
• 00:25:00 In this section, the speaker demonstrates how the Amazon Marketplace SP API can be used to retrieve seller information, such as feedback count and seller ID, which is useful for identifying and studying different sellers. They also show how the API can be used to automate the process of retrieving and appending order data to a Google sheet. The code is simple and covers only a few relevant arguments to avoid storing unnecessary information. The demonstration highlights the potential of the SP API for automating tasks and improving seller efficiency.
• 00:30:00 In this section of the video, the presenter demonstrates a Python script that retrieves information about the orders in a very nice and simple way from Amazon Marketplace. The custom coding approach used in the script allows for the retrieval of information about orders from multiple marketplaces or multiple seller accounts, making it ideal for agencies with multiple accounts to monitor. The presenter then moves on to discuss different custom coding projects they are working on for clients, including building custom e-commerce stores, scraping and aggregating data from different marketplaces, monitoring competitor prices, and studying buyer behavior to track moves of buyers in real-time. The presenter invites viewers to contact them if they ever need help with custom integrations.
• 00:35:00 In this section, the speaker and the audience engage in a Q&A session. One question asks if the Amazon FBA calculator can be linked in the API, to which the speaker responds that if there is already a solution out there like the calculator, it can be easily connected to the code. Another question is about automating a report that blends data of all orders report, sponsored ads, and estimated Amazon fees, to monitor daily profitability. The speaker says it is possible to retrieve all the historical data using either the order report or the orders API and manipulate it in the Jupiter Notebook. The second part of the question is about whether the API can retrieve information about the type of sale - organic or advertised. The speaker checks and explains that there is something called the Amazon Ads API that handles ads, but is not sure about the Amazon Order API.
• 00:40:00 In this section of the video, the speaker discusses the possibility of exporting complete shipping addresses of buyers through automation. They mention that while Amazon may try not to show all data, sellers can still retrieve certain information, such as city and postal code, as it is accessible through the API. However, it may not be possible to retrieve full shipping addresses unless it's through certain tactics and custom programming, which may not provide long-term stability. The speaker also explains why software companies that use the same API may produce different results, as developers create their algorithms based on the data. The video also covers how to get the session percentage and buy box percentage from the product API.
• 00:45:00 In this section, the speaker discusses the difficulty of automating the payments report from Amazon using the API, as there is no dedicated API called payments, but a section called reports with different accessible reports for sellers. While the speaker has limited experience with this report, they suggest that the lack of immediate availability in the documentation could indicate that it is more difficult to automate than some others. It is also noted that the API has poor documentation overall, making it challenging to use, especially in custom automations such as repricing inventory. The speaker recommends consulting the documentation and seeking personalized assistance for detailed questions.
• 00:50:00 This section is the end of the video, in which the host thanks the presenter for his interesting presentation on Amazon Marketplace API. They discussed how APIs make it easier to fetch necessary data from Amazon, especially as scraping Amazon is difficult due to the way they hide their data. The host encourages viewers to chat with Jacob if they need help with this kind of thing and shares a link to a YouTube video where Jacob gives a step-by-step guide on setting up a developer account and Google Sheets account, doing the requests they did in the webinar, and providing links to the open source code on GitHub.