Google Merchant Center local inventories table
Overview
Local inventories data allows merchants to export their local offers of theirproducts to BigQuery. This data includes pricing, availability,and quantity of the product along with the information about pick-up and productin-store location.
The format of local inventories datacorresponds primarily to the format of the relevant fields of the Content API'slocalinventoryresource.
Depending on the type of Merchant account that you use, the data is written toone of the following tables:
- If you are using an individual Merchant ID, then the data is written to the
LocalInventories_MERCHANT_IDtable. - If you are using an MCA account, then the data is written to the
LocalInventories_AGGREGATOR_IDtable.
Schema
TheLocalInventories_ 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 theMulti 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 theCreative Commons Attribution 4.0 License, and code samples are licensed under theApache 2.0 License. For details, see theGoogle Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2026-02-19 UTC.