Google Merchant Center regional inventories table
Overview
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.
Schema
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. This field is a primary key. |
online:en:AU:666840730 |
merchant_id |
INTEGER |
Merchant account ID. This field is a primary key. |
|
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 |
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2025-08-25 UTC.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-25 UTC."],[[["\u003cp\u003eThe regional inventories table in Google Merchant Center displays regional availability and pricing overrides for products.\u003c/p\u003e\n"],["\u003cp\u003eData format in the table aligns with the Content API's \u003ccode\u003eregionalinventory\u003c/code\u003e resource.\u003c/p\u003e\n"],["\u003cp\u003eThe table name is \u003ccode\u003eRegionalInventories_MERCHANT_ID\u003c/code\u003e for individual accounts or \u003ccode\u003eRegionalInventories_AGGREGATOR_ID\u003c/code\u003e for MCA accounts.\u003c/p\u003e\n"],["\u003cp\u003eKey fields in the schema include \u003ccode\u003eproduct_id\u003c/code\u003e, \u003ccode\u003emerchant_id\u003c/code\u003e, \u003ccode\u003eregion_id\u003c/code\u003e, \u003ccode\u003eprice\u003c/code\u003e, \u003ccode\u003esale_price\u003c/code\u003e, and \u003ccode\u003eavailability\u003c/code\u003e.\u003c/p\u003e\n"],["\u003cp\u003eThe information includes specifics such as regional price, sale price, start and end dates of sales and the currency for each.\u003c/p\u003e\n"]]],[],null,["# Google Merchant Center regional inventories table\n=================================================\n\nOverview\n--------\n\nRegional inventories table shows merchants their regional availability and pricing overrides of their products. The format of regional inventories data\ncorresponds primarily to the format of the relevant fields of the Content API's\n[`regionalinventory`](https://developers.google.com/shopping-content/reference/rest/v2.1/regionalinventory) resource.\n\nThe data is written to a table named\n`RegionalInventories_`\u003cvar translate=\"no\"\u003eMERCHANT_ID\u003c/var\u003e if you are using an\nindividual Merchant ID, or\n`RegionalInventories_`\u003cvar translate=\"no\"\u003eAGGREGATOR_ID\u003c/var\u003e if you are using an\nMCA account.\n\nSchema\n------\n\nThe `RegionalInventories_` table has the following schema:"]]
