Google Merchant Center local inventories table
Overview
Local inventories data allows merchants to export their local offers of their
products to BigQuery. This data includes pricing, availability,
and quantity of the product along with the information about pick-up and product
in-store location.
The format of local inventories data
corresponds primarily to the format of the relevant fields of the Content API's
localinventory
resource.
Depending on the type of Merchant account that you use, the data is written to
one of the following tables:
- If you are using an individual Merchant ID, then the data is written to the
LocalInventories_MERCHANT_ID table.
- If you are using an MCA account, then the data is written to the
LocalInventories_AGGREGATOR_ID table.
Schema
The LocalInventories_ tables have 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 |
ID of the Multi Client Account (MCA). |
|
store_code |
STRING |
Store code of this local inventory resource. |
|
price |
RECORD |
Local price of the item. |
|
price.value |
NUMERIC |
Local price of the item. |
99 |
price.currency |
STRING |
Currency of the local price of the item. |
CHF |
sale_price |
RECORD |
Local sale price of the item. |
|
sale_price.value |
NUMERIC |
Local sale price of the item. |
49 |
sale_price.currency |
STRING |
Currency of the local sale price of the item. |
CHF |
sale_price_effective_start_date |
TIMESTAMP |
Start date and time when the item is on sale. |
2021-03-30 00:00:00 UTC |
sale_price_effective_end_date |
TIMESTAMP |
End date and time when the item is on sale. |
2021-04-14 00:00:00 UTC |
availability |
STRING |
Local availability status of the item. |
out of stock |
quantity |
INTEGER |
Quantity of the item. |
500 |
pickup_method |
STRING |
Supported pick-up method of the item. |
ship to store |
pickup_sla |
STRING |
Expected elapsed time between the order date and the date that the item
is ready for pickup. |
three days |
instore_product_location |
STRING |
In-store location of the item. |
|
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\u003eLocal inventories data from Google Merchant Center can be exported to BigQuery, providing details like pricing, availability, quantity, pickup options, and in-store location.\u003c/p\u003e\n"],["\u003cp\u003eThe data format in BigQuery aligns with the \u003ccode\u003elocalinventory\u003c/code\u003e resource fields in the Content API.\u003c/p\u003e\n"],["\u003cp\u003eData is written to either the \u003ccode\u003eLocalInventories_MERCHANT_ID\u003c/code\u003e table for individual accounts or the \u003ccode\u003eLocalInventories_AGGREGATOR_ID\u003c/code\u003e table for MCA accounts.\u003c/p\u003e\n"],["\u003cp\u003eThe \u003ccode\u003eLocalInventories_\u003c/code\u003e tables include key columns such as \u003ccode\u003eproduct_id\u003c/code\u003e, \u003ccode\u003emerchant_id\u003c/code\u003e, \u003ccode\u003estore_code\u003c/code\u003e, \u003ccode\u003eprice\u003c/code\u003e, \u003ccode\u003esale_price\u003c/code\u003e, \u003ccode\u003eavailability\u003c/code\u003e, \u003ccode\u003equantity\u003c/code\u003e, \u003ccode\u003epickup_method\u003c/code\u003e, \u003ccode\u003epickup_sla\u003c/code\u003e, and \u003ccode\u003einstore_product_location\u003c/code\u003e.\u003c/p\u003e\n"]]],[],null,["# Google Merchant Center local inventories table\n==============================================\n\nOverview\n--------\n\nLocal inventories data allows merchants to export their local offers of their\nproducts to BigQuery. This data includes pricing, availability,\nand quantity of the product along with the information about pick-up and product\nin-store location.\n\nThe format of local inventories data\ncorresponds primarily to the format of the relevant fields of the Content API's\n[`localinventory`](https://developers.google.com/shopping-content/reference/rest/v2.1/localinventory)\nresource.\n\nDepending on the type of Merchant account that you use, the data is written to\none of the following tables:\n\n- If you are using an individual Merchant ID, then the data is written to the `LocalInventories_`\u003cvar translate=\"no\"\u003eMERCHANT_ID\u003c/var\u003e table.\n- If you are using an MCA account, then the data is written to the `LocalInventories_`\u003cvar translate=\"no\"\u003eAGGREGATOR_ID\u003c/var\u003e table.\n\nSchema\n------\n\nThe `LocalInventories_` tables have the following schema:"]]
