Google Merchant Center local inventories table schema

Local inventories table schema

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.

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

The LocalInventories_ 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
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 date that an order will be ready for pickup relative to the order date three day
instore_product_location STRING In-store location of the item