Connect Amazon Vendor Central to MySQL

Authorize Amazon Vendor Central through OAuth2, select the marketplace you want to report on, save your MySQL connection details, and pair both systems in a datastream.

Choose from 30 metrics and 34 dimensions, including ordered revenue, shipped revenue, ordered units, open purchase order units, inventory costs, vendor lead time, report level, and normalized date fields. You can rename selected columns, preview the result, and write it to a MySQL table.

Catchr can load vendor sales, traffic, inventory, forecasting, and net pure product margin reports into MySQL. Sales, traffic, inventory, and margin reports use the requested date window, while forecasting returns Amazon's latest forecast snapshot.

Configure the job with a normalized Amazon Vendor Central date field, such as the calendar date derived from the report date. Catchr can then delete and rewrite the scheduled window in MySQL to limit duplicate rows across overlapping runs.

Use MySQL queries or views to compare ordered and shipped revenue, track ordered and unfilled units, monitor aged or unhealthy inventory costs, and review vendor lead time by date or report level for reusable agency and client reporting.

Yes. Connect an existing MySQL 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.