Connect Amazon Vendor Central to PostgreSQL

Authorize Amazon Vendor Central through OAuth2, select the marketplace you want to use, save your PostgreSQL connection details, and pair both systems in a datastream that writes your selected columns.

Choose from 30 metrics and 34 dimensions, including ordered revenue, shipped revenue, ordered units, open purchase order units, inventory costs, report level, and normalized date fields, then organize the selected columns in PostgreSQL.

Catchr can read vendor sales, traffic, inventory, forecasting, and net pure product margin reports for the marketplace selected during authorization and load their available fields into PostgreSQL.

Normalized day, week, month, quarter, year, and calendar-date dimensions are derived from each report's start date, while forecasting uses Amazon's forecast generation date and returns the latest forecast snapshot.

Use PostgreSQL queries and reporting tools to compare ordered and shipped revenue, monitor ordered and unfilled units, review vendor lead time, and assess sellable, unsellable, aged, or unhealthy inventory costs by available date and report level.

Yes. Connect an existing PostgreSQL database first. The Catchr job creates and populates the destination table you configure inside that database.

Yes. Create a separate datastream and job for each source, write each export to its own table, then combine the data downstream with SQL, views, or your BI tool.