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 Seller Central (SC) 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 sales_and_traffic_detail_sales_traffic_by_child_item:
• Find the report path for the table you want validated, click on the link to get to this table in Seller 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 Download. In this example we’ll review the following:
- Date: 11/24/2022
- Note: this table is pulled on a day-by-day basis and should be validated by day as Amazon’s aggregations often don’t tie to sums of each daily report in aggregate.
- Open pgAdmin and connect to the server you just set up.
- Right click your database and choose "Query tool” from the menu.
Open downloaded file in Excel and Pivot the data for the following metrics:
Step 4: Query your database to compare with Seller Central:
• Write the following SQL in this window, then click the play button to run your query
SELECT
date AS report_date,
SUM(sessions_total) AS sessions,
SUM(page_views_total) AS page_views,
SUM(units_ordered) AS units_ordered,
SUM(ordered_product_sales) AS ordered_product_sales
FROM public.sales_and_traffic_detail_sales_traffic_by_child_item
WHERE date = `2022-11-24`
GROUP BY date;Step 5: Compare your results.
Seller Central:
Database:
Follow this process to validate all your Seller Central tables. Find information about all the available Seller Central tables here.