Amazon Vendor (1P) Invoices Automation

We automated the retrieval of Amazon 1P sales data by developing a Selenium-based script that extracts invoice details from Vendor Central reports. This solution improved our client's ability to manage and analyze sales data across channels, enhancing their planning and analytics.
Data Extraction Reporting

Prerequisites

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.

Objective

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.

Implementation

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.

Result

Our solution automated the retrieval of invoice data and improved planning and analytics for the new data channel – the first-party Amazon model (1P).

Your E-commerce Success Starts Here

Need expert development for your online business? Let’s connect and bring your ideas to life.