Tetap teratur dengan koleksi
Simpan dan kategorikan konten berdasarkan preferensi Anda.
Tabel inventaris lokal Google Merchant Center
Ringkasan
Data inventaris lokal memungkinkan penjual mengekspor penawaran lokal produk mereka ke BigQuery. Data ini mencakup harga, ketersediaan, dan jumlah produk beserta informasi tentang pengambilan dan lokasi produk di toko.
Format data inventaris lokal terutama berkaitan dengan format kolom yang relevan dari resource localinventory Content API.
Bergantung pada jenis akun Penjual yang Anda gunakan, data akan ditulis ke salah satu tabel berikut:
Jika Anda menggunakan ID Penjual tertentu, data akan dituliskan ke tabel LocalInventories_MERCHANT_ID.
Jika Anda menggunakan akun MCA, data akan ditulis pada tabel LocalInventories_AGGREGATOR_ID.
Skema
Tabel LocalInventories_ memiliki skema berikut:
Kolom
Jenis data BigQuery
Deskripsi
Data contoh
product_id
STRING
ID REST Content API produk dalam bentuk:
channel:content_language:feed_label:offer_id. Kolom ini adalah kunci utama.
[[["Mudah dipahami","easyToUnderstand","thumb-up"],["Memecahkan masalah saya","solvedMyProblem","thumb-up"],["Lainnya","otherUp","thumb-up"]],[["Sulit dipahami","hardToUnderstand","thumb-down"],["Informasi atau kode contoh salah","incorrectInformationOrSampleCode","thumb-down"],["Informasi/contoh yang saya butuhkan tidak ada","missingTheInformationSamplesINeed","thumb-down"],["Masalah terjemahan","translationIssue","thumb-down"],["Lainnya","otherDown","thumb-down"]],["Terakhir diperbarui pada 2025-09-04 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:"]]
