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.

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.

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 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