# Amazon Vendor Central Data Connector User Guide

> **Note:** Amazon Vendor Central is Amazon's portal for vendors who sell their products wholesale directly to Amazon. This guide will help you connect your Amazon Vendor Central account to Power My Analytics, enabling you to automate the collection of your vendor sales, inventory, traffic, and forecasting data and create insightful reports.

## Prerequisites

Before connecting Amazon Vendor Central to Power My Analytics:

- You must have an active Amazon Vendor Central account
- You must be able to sign in with the Amazon credentials that have access to your Vendor Central account (Power My Analytics authenticates via single sign-on with Amazon)

> **Important:** The Amazon Vendor Central connector reports first-party (1P) vendor data only. If you sell on Amazon as a third-party (3P) seller, use the [Amazon Seller Central connector](https://knowledge.powermyanalytics.com/application/sources/amazon-seller-data-connector/) instead.

## Adding Amazon Vendor Central as a Data Source

1. Log in to your Power My Analytics Hub
2. Navigate to **Sources** in the main menu
3. Click **\+ Add New Source**
4. Select Amazon Vendor Central from the gallery
5. Assign a memorable name to the account
6. Click **Connect** to authenticate via Amazon single sign-on
7. Approve the required permissions in the consent pop-up

For a detailed walkthrough, see [How to Connect to Amazon Vendor Central](https://knowledge.powermyanalytics.com/application/sources/how-to-connect-to-amazon-vendor-central/).

## Creating a Data Studio Report

Follow these steps to create a Data Studio report using your Amazon Vendor Central data:

1. After adding Amazon Vendor Central as a data source, go to **Reports > Data Studio**
2. Select Amazon Vendor Central under Create Data Studio Report (this will open the official Data Studio application in a new window)
3. Data Studio Configuration:

    - Step 1: Name your data source (e.g., "Amazon Vendor Central - \[Organization Name\]"), choose your Power My Analytics hub from the dropdown, optionally leave "Use report template for new reports" checked for the PMA demo template, and click **Next**
    - Step 2: Under User Account, select your Amazon Vendor Central account (for real data) or "Sample Account" (for sample data), then click **Connect** (top right) to complete the configuration
    - Step 3: Click **Create Report** (top right)

For a quick start, you can use our pre-built [Amazon Vendor Central demo template](https://lookerstudio.google.com/reporting/4fc05787-4948-4d4a-88d2-24a213b0d338).

## Key Reports and Fields

Popular metrics and dimensions available in Amazon Vendor Central reports include:

- Sales Report Metrics: Ordered Revenue Amount, Shipped Revenue Amount, Ordered Units, Shipped Units, Shipped Cogs Amount, Customer Returns
- Sales Report Dimensions: Asin, Ordered Revenue Currency Code, Shipped Revenue Currency Code
- Inventory Report Metrics: Sellable On Hand Inventory Units, Sellable On Hand Inventory Cost Amount, Unsellable On Hand Inventory Units, Unsellable On Hand Inventory Cost Amount, Aged90plus Days Sellable Inventory Units
- Sourcing Sales Report Metrics: Sourcing Shipped Revenue Amount, Sourcing Shipped Units, Sourcing Shipped Cogs Amount, Sourcing Customer Returns
- Sourcing Inventory Report Metrics: Sourcing Sellable On Hand Inventory Units, Sourcing Sellable On Hand Inventory Cost Amount, Sourcing Unsellable On Hand Inventory Units, Sourcing Unsellable On Hand Inventory Cost Amount, Sourcing Aged90plus Days Sellable Inventory Units
- Forecasting Report Metrics: Mean Forecast Units, P70forecast Units, P80forecast Units, P90forecast Units
- Shared Dimensions: Asin, Marketplace ID, Start Date, End Date

Fields that start with Sourcing show Amazon's Sourcing view (the Consignment view if you are a consignment vendor). The other Sales and Inventory fields show the Manufacturing view. Compare them side by side, but don't add them together. See [Manufacturing and Sourcing Fields](#manufacturing-and-sourcing-fields) below.

For a complete list of available Amazon Vendor Central fields, refer to the [Schema Explorer](https://hub.powermyanalytics.com/resources/schema/amazonvendor).

## Limitations and Important Considerations

- **Backfilling:** Up to 2 years of historical data is available. Power My Analytics backfills the full 2 years when you first connect your Amazon Vendor Central account as a data source.
- **Sourcing report history:** If your data source was connected before the Sourcing Sales Report and Sourcing Inventory Report were added, their data starts about a week before they were added. For older dates, [run a manual backfill](https://knowledge.powermyanalytics.com/application/sources/backfill-connection-data/) for the dates you need. A backfill refreshes every report for those dates, including the Sourcing reports. Amazon limits how often reports can be requested, so a long date range can take several hours to fill in.
- **Data availability:** Amazon publishes Vendor Central data on a delay, so your most recent dates will normally sit 3 to 4 days behind today. See below.
- **Forecasting history:** Amazon supplies only the most recent forecast. Historical forecast data cannot be requested, so your Forecasting Report will not build up a history of past forecasts over time.
- **Vendor codes and report scope:** One Amazon Vendor Central connection covers every vendor code in your vendor group. The Sales Report and Inventory Report show the Manufacturing distributor view, and the Sourcing Sales Report and Sourcing Inventory Report show the Sourcing view (or the Consignment view for consignment vendors). All of them, and the Forecasting Report, cover the Retail selling program. Amazon Fresh data is not collected. See below.

### What does this mean for me?

- Your most recent dates will normally be 3 to 4 days behind today. That is Amazon's publishing schedule, not a problem with your sync. Set your report date range to end 3 or more days ago.
- Your Forecasting Report always shows Amazon's latest forecast, not a history of past forecasts.
- ASINs that Amazon reports only under the Sourcing or Consignment view appear in the Sourcing fields, not in the Sales and Inventory Report fields. The check under **Missing ASINs from Some Vendor Codes** below shows whether this affects you.

### Amazon's Data Availability Delay

Amazon does not release Vendor Central reporting data immediately. Amazon's published availability targets for the reports PMA collects are:

- **Vendor Sales and Vendor Traffic (daily periods):** 72 hours after the reporting period closes.
- **Vendor Sales and Vendor Traffic (weekly periods ending Saturday):** end of the day Monday, 48 hours after the period closes.
- **Vendor Forecasting:** refreshed within 72 hours after the week ends.
- **Vendor Inventory:** Amazon does not publish an availability target; in practice this report follows the same 3 to 4 day pattern.

So a report you open on a Thursday will often end on the previous Sunday or Monday. Some periods take longer than Amazon's stated targets, and delays of up to a week are occasionally reported.

A day can still be unpublished almost 2 days after it ends, so Power My Analytics syncs with a 3 day margin. Set your report date range to end 3 or more days ago. A date range that covers only the last 1 or 2 days returns no rows.

> **Important:** No setting in Power My Analytics can retrieve data that Amazon has not yet published. Changing your sync time, widening your report's date range, or running a manual backfill will not pull days that Amazon has not released. Those days will fill in on their own once Amazon publishes them.

> **Note:** If you add the **PMA Maximum Cached Data Date** metadata field to a Vendor Central report, expect it to read a few days newer than your most recent row of data. That field describes the cached data behind your report rather than the row it sits beside, so the gap is expected here and does not mean data is missing. See [What Fields Are Available In PMA's Connectors?](https://knowledge.powermyanalytics.com/support/faq/what-fields-are-available-in-pma-s-connectors/)

For how other connectors behave, see [Understanding Data Delays](https://knowledge.powermyanalytics.com/application/troubleshooting/understanding-data-delays/).

### Manufacturing and Sourcing Fields

Amazon reports your sales and inventory under two distributor views: the Manufacturing view, and a supplier view, which is Sourcing for most vendors or Consignment for consignment vendors. Power My Analytics collects both:

- **Sales Report and Inventory Report:** the Manufacturing view
- **Sourcing Sales Report and Sourcing Inventory Report:** the Sourcing view, or the Consignment view if you are a consignment vendor
- **Forecasting Report:** the Retail selling program
- **Traffic Report:** not limited to a view or program, but it follows Amazon's manufacturer catalog, so most ASINs that appear only in the Sourcing view have no Glance Views

Each Sourcing field has the same name as its Manufacturing field with "Sourcing" in front, for example **Shipped Units** and **Sourcing Shipped Units**. To compare the two views, put both fields in one table with **Asin** as the dimension. The table lists every ASIN once.

Do not add the Manufacturing and Sourcing fields together. For an ASIN that appears in both views, the two count mostly the same sales, so the sum counts the same units twice. Your totals for each view can still differ a lot, because each view also has ASINs the other one does not. There is no combined total: use the view that matches how you report in Vendor Central.

Some inventory ASINs appear only in the Manufacturing view. For a full picture of your inventory, show the Manufacturing and Sourcing inventory fields side by side.

Some fields have no Sourcing version:

- **Ordered Revenue Amount, Ordered Revenue Currency Code and Ordered Units:** Amazon fills these only in the Manufacturing view.
- **Out of stock rates and unfilled customer ordered units:** Amazon leaves these empty in the Sourcing and Consignment views.
- **Consignment vendors:** Amazon may also leave Sourcing Shipped Cogs Amount, Sourcing Receive Fill Rate, Sourcing Average Vendor Lead Time Days and Sourcing Vendor Confirmation Rate empty.

The Forecasting Report has no view option, so it may not include ASINs that appear only in the Sourcing view.

In every account where we could check, Amazon Business sales were already part of the Retail figures. Amazon Fresh data is not collected.

### Missing ASINs from Some Vendor Codes

Amazon groups your vendor codes into a vendor group, and connecting Amazon Vendor Central to Power My Analytics authorizes the whole group. ASINs that Amazon reports only under the Sourcing or Consignment view do not appear in the Sales Report and Inventory Report fields. They appear in the Sourcing fields instead.

To check whether this affects you:

1. Build a table with **Asin** as the dimension and **Shipped Units** as the metric.
2. Build a second table with **Asin** as the dimension and **Sourcing Shipped Units** as the metric, using the same date range. End the date range 3 or more days ago. If your data source was connected before the Sourcing reports were added, use dates the Sourcing reports already cover (see **Sourcing report history** above).
3. Compare the two lists. ASINs that appear only in the second table are reported under the Sourcing or Consignment view. Add the Sourcing fields to your reports to see them.

Do not use Glance Views for this check. The Traffic Report misses most ASINs that appear only in the Sourcing view.

These steps do not change which view a field shows:

- Reconnecting your data source, or connecting each vendor code as its own data source. Amazon authorizes the whole vendor group at once, so your existing connection already covers every vendor code.
- Changing your sync time.

You also cannot filter or break down your reports by vendor code: Amazon's vendor reports do not say which vendor code each row belongs to, so there is no Vendor Code field.

If an ASIN is missing from both the Manufacturing and Sourcing fields, [submit a ticket](https://knowledge.powermyanalytics.com/support/submit-a-ticket/) with your vendor codes and an example ASIN, and our support team will help.

## Troubleshooting

Please see our [Basic Troubleshooting](https://knowledge.powermyanalytics.com/application/troubleshooting/basic-troubleshooting/) article for help with common issues that may affect the Amazon Vendor Central connector.
