Stay organized with collections
Save and categorize content based on your preferences.
Google Merchant Center product inventory table
Overview
Best sellers data helps merchants understand the most popular brands and
products in Shopping ads and unpaid listings. For more information about best
sellers, see the description in Supported reports.
The data is written to a table named BestSellers_TopProducts_Inventory_MERCHANT_ID.
Schema
The BestSellers_TopProducts_Inventory_ table has the following schema:
Column
BigQuery data type
Description
rank_id
STRING
Rank identifier to join against the Top Products table
product_id
STRING
Content API's REST ID of the product in the form
channel:content_language:feed_label:offer_id.
merchant_Id
INTEGER
Merchant account ID.
aggregator_id
INTEGER
Aggregator account ID for multi-client accounts.
Example
The example below demonstrates how the BestSellers_TopProducts_Inventory_ table
provides a mapping to your products for all target countries in the Products_
table.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-03-05 UTC."],[[["The Product Inventory table in Google Merchant Center will be deprecated on September 1, 2025, and users are advised to switch to the new best sellers report."],["The best sellers report data helps merchants to identify the most popular brands and products in Shopping ads and unpaid listings."],["The data from this table is stored in the `BestSellers_TopProducts_Inventory_`\u003cvar translate=\"no\"\u003eMERCHANT_ID\u003c/var\u003e table, which includes identifiers to link products with their rankings."],["The table includes the ranking id, product id, merchant id, and aggregator id."],["The provided example demonstrates how the `BestSellers_TopProducts_Inventory_` table links product rankings to product IDs across different countries."]]],[]]
