Vendor Central Data Validation for Reason Customers

Congratulations on connecting your database! You now have access to your Amazon data through these connections. On this page we’ll review how you would validate your Vendor Central (VC) data using pgAdmin and SQL.

Step 1: Download & Install pgAdmin here (or any other SQL workbench of your preference).

Step 2: Connect your database to pgAdmin using the instructions here.

Step 3: Identify which table you want validated by going to our Help Center.

• In this example we’ll review retail_analytics_sales:

• Find the report path for the table you want validated, click on the link to get to this table in Vendor Central, and log in.

• Find the report filters under the Statistics section. Report filters are important because they determine what data is being fetched.

• Set up the report filters to match how you would like to validate the data and click Apply. In this example we’ll be reviewing the following:
• Date: 11/24/2022
• Distributor View: Manufacturing
• Program: Amazon Retail
• Period: Daily


Step 4: Query your database to compare with Vendor Central:

• Open pgAdmin and connect to the server you just set up.
• Right click your database and choose”Query tool” from the menu.


• Write the following SQL in this window, then click the play button to run your query

Copy

SELECT
   date AS report_date,
   SUM(ordered_revenue) AS ordered_revenue,
   SUM(ordered_units) AS ordered_units,
   SUM(shipped_revenue) AS shipped_revenue,
   SUM(shipped_cogs) AS shipped_cogs,
   SUM(shipped_units) AS shipped_units,
   SUM(customer_returns) AS customer_returns
FROM public.retail_analytics_sales
WHERE date = `2022-11-24`
   AND program = `Amazon Retail`
   AND distributor_view = `Manufacturing`
GROUP BY date;

Step 5: Compare your results. In the first image below, see the Sales table in Vendor Central. Compare this with the SQL output in Reason shown in the second image. Notice how the columns match up, including the circled Shipped COGS column.

Vendor Central:



Reason database:



Follow this process to validate all your Vendor Central tables. Find information about all the available Vendor Central tables here.