Tetap teratur dengan koleksi
Simpan dan kategorikan konten berdasarkan preferensi Anda.
Tabel inventaris regional Google Merchant Center
Ringkasan
Tabel inventaris regional menampilkan penggantian ketersediaan dan harga regional produk kepada penjual. Format data inventaris regional terutama berkaitan dengan format kolom yang relevan dari resource regionalinventory Content API.
Data ditulis ke tabel bernama RegionalInventories_MERCHANT_ID jika Anda menggunakan ID Penjual perorangan, atau RegionalInventories_AGGREGATOR_ID jika Anda menggunakan akun MCA.
Skema
Tabel RegionalInventories_ 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.
online:en:AU:666840730
merchant_id
INTEGER
ID akun penjual. Kolom ini adalah kunci utama.
aggregator_id
INTEGER
ID akun agregator untuk akun multiklien.
region_id
STRING
ID wilayah inventaris.
price
RECORD
Harga regional item.
price.value
NUMERIC
Harga regional item.
99
price.currency
STRING
Mata uang untuk harga regional item.
CHF
sale_price
RECORD
Harga promo regional item.
sale_price.value
NUMERIC
Harga promo regional item.
49
sale_price.currency
STRING
Mata uang untuk harga promo regional item.
CHF
sale_price_effective_start_date
TIMESTAMP
Tanggal dan waktu mulai saat item dipromosikan di suatu wilayah.
2021-03-30 00:00:00 UTC
sale_price_effective_end_date
TIMESTAMP
Tanggal dan waktu berakhir saat item dipromosikan di suatu wilayah.
[[["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\u003eThe regional inventories table in Google Merchant Center displays regional availability and pricing overrides for products.\u003c/p\u003e\n"],["\u003cp\u003eData format in the table aligns with the Content API's \u003ccode\u003eregionalinventory\u003c/code\u003e resource.\u003c/p\u003e\n"],["\u003cp\u003eThe table name is \u003ccode\u003eRegionalInventories_MERCHANT_ID\u003c/code\u003e for individual accounts or \u003ccode\u003eRegionalInventories_AGGREGATOR_ID\u003c/code\u003e for MCA accounts.\u003c/p\u003e\n"],["\u003cp\u003eKey fields in the schema include \u003ccode\u003eproduct_id\u003c/code\u003e, \u003ccode\u003emerchant_id\u003c/code\u003e, \u003ccode\u003eregion_id\u003c/code\u003e, \u003ccode\u003eprice\u003c/code\u003e, \u003ccode\u003esale_price\u003c/code\u003e, and \u003ccode\u003eavailability\u003c/code\u003e.\u003c/p\u003e\n"],["\u003cp\u003eThe information includes specifics such as regional price, sale price, start and end dates of sales and the currency for each.\u003c/p\u003e\n"]]],[],null,["# Google Merchant Center regional inventories table\n=================================================\n\nOverview\n--------\n\nRegional inventories table shows merchants their regional availability and pricing overrides of their products. The format of regional inventories data\ncorresponds primarily to the format of the relevant fields of the Content API's\n[`regionalinventory`](https://developers.google.com/shopping-content/reference/rest/v2.1/regionalinventory) resource.\n\nThe data is written to a table named\n`RegionalInventories_`\u003cvar translate=\"no\"\u003eMERCHANT_ID\u003c/var\u003e if you are using an\nindividual Merchant ID, or\n`RegionalInventories_`\u003cvar translate=\"no\"\u003eAGGREGATOR_ID\u003c/var\u003e if you are using an\nMCA account.\n\nSchema\n------\n\nThe `RegionalInventories_` table has the following schema:"]]
