Our client, alongside Amazon third-party (3P) sales, was expanding their sales through the first-party (1P) model, where Amazon directly purchases products in bulk and places orders on behalf of the company. The first-party model differs from the third-party one, is available only to a select group of sellers and products, but offers several advantages and is more profitable.
To integrate 1P sales analytics, enhance planning, and compare with other sales channels, it was necessary to obtain data on bulk invoices, specifically how Amazon purchases products. The task was to retrieve a list of invoices, their status, and the products (with their ASINs) included in each invoice.
Unfortunately, Amazon does not provide an API for retrieving invoice data. Invoices and their statuses are only accessible directly through the vendorcentral.amazon.com interface.
We were tasked with the efficient extraction of data from the Vendor Central interface.
After a series of tests, we developed an automated solution using Selenium. The script emulates user actions daily, autonomously logging into the Amazon Vendor interface and navigating through all invoices to retrieve and update their data for the past 30 days. This solution is implemented for both the US and European markets.
The invoice data is directly uploaded into tables in the Data Warehouse, where it is available for reporting and BI analytics.
Our solution automated the retrieval of invoice data and improved planning and analytics for the new data channel – the first-party Amazon model (1P).
Need expert development for your online business? Let’s connect and bring your ideas to life.