Stay organized with collections Save and categorize content based on your preferences.

Google Merchant Center regional inventories table schema

Regional inventories table schema

Regional inventories table shows merchants their regional availability and pricing overrides of their products. The format of regional inventories data corresponds primarily to the format of the relevant fields of the Content API's regionalinventory resource.

The data is written to a table named RegionalInventories_merchant_id if you are using an individual Merchant ID, or RegionalInventories_aggregator_id if you are using an MCA account.

The RegionalInventories_ table has the following schema:

Column BigQuery data type Description Example data
product_id STRING Content API's REST ID of the product in the form: channel:content_language:feed_label:offer_id online:en:AU:666840730
merchant_id INTEGER Merchant account ID
aggregator_id INTEGER Aggregator account ID for multi-client accounts
region_id STRING Region ID of the inventory
price RECORD Regional price of the item
price.value NUMERIC Regional price of the item 99
price.currency STRING Currency of the regional price of the item CHF
sale_price RECORD Regional sale price of the item
sale_price.value NUMERIC Regional sale price of the item 49
sale_price.currency STRING Currency of the regional sale price of the item CHF
sale_price_effective_start_date TIMESTAMP Start date and time when the item is on sale in the region 2021-03-30 00:00:00 UTC
sale_price_effective_end_date TIMESTAMP End date and time when the item is on sale in the region 2021-04-14 00:00:00 UTC
availability STRING Regional availability status of the item out of stock