Stay organized with collections
Save and categorize content based on your preferences.
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.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-29 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:"]]
