ProductView

ProductView

Fields available for query in product_view table.

Products in the current inventory. Products in this table are the same as a Product resource in Products sub-API but not all product attributes from Products sub-API are available for query in this table. In contrast to Products sub-API, this table allows to filter the returned list of products by product attributes. To retrieve a single product by id or list all products, Products sub-API should be used.

Values are only set for fields requested explicitly in the request's search query.

Fields
price

Price

Product price. Absent if the information about the price of the product is not available.

gtin[]

string

List of Global Trade Item Numbers (GTINs) of the product.

creation_time

Timestamp

The time the merchant created the product in timestamp seconds.

expiration_date

Date

Expiration date for the product, specified on insertion.

status_per_reporting_context[]

StatusPerReportingContext

Detailed product status per reporting context.

Reporting contexts included in this list can be restricted using a filter on the reporting_context field.

Equivalent to ProductStatus.destination_statuses in Products API.

This field cannot be used for sorting or filtering the results.

item_issues[]

ItemIssue

List of item issues for the product.

This field cannot be used for sorting the results.

Only selected attributes of this field (for example, item_issues.severity.aggregated_severity ) can be used for filtering the results.

click_potential

ClickPotential

Estimated performance potential compared to highest performing products of the merchant.

id

string

REST ID of the product, in the form of channel~languageCode~feedLabel~offerId . Merchant API methods that operate on products take this as their name parameter.

Required in the SELECT clause.

channel

ChannelEnum

Channel of the product. Can be ONLINE or LOCAL .

language_code

string

Language code of the product in BCP 47 format.

feed_label

string

Feed label of the product.

offer_id

string

Merchant-provided id of the product.

title

string

Title of the product.

brand

string

Brand of the product.

category_l1

string

Product category (1st level) in Google's product taxonomy .

category_l2

string

Product category (2nd level) in Google's product taxonomy .

category_l3

string

Product category (3rd level) in Google's product taxonomy .

category_l4

string

Product category (4th level) in Google's product taxonomy .

category_l5

string

Product category (5th level) in Google's product taxonomy .

product_type_l1

string

Product type (1st level) in merchant's own product taxonomy .

product_type_l2

string

Product type (2nd level) in merchant's own product taxonomy .

product_type_l3

string

Product type (3rd level) in merchant's own product taxonomy .

product_type_l4

string

Product type (4th level) in merchant's own product taxonomy .

product_type_l5

string

Product type (5th level) in merchant's own product taxonomy .

condition

string

Condition of the product.

availability

string

Availability of the product.

shipping_label

string

Normalized shipping label specified in the data source.

item_group_id

string

Item group id provided by the merchant for grouping variants together.

aggregated_reporting_context_status

AggregatedReportingContextStatus

Aggregated status across all reporting contexts.

Reporting contexts included in the computation of the aggregated status can be restricted using a filter on the reporting_context field.

reporting_context

ReportingContextEnum

Reporting context to restrict the query to.

Restricts the reporting contexts returned in status_per_reporting_context and item_issues , and used to compute aggregated_reporting_context_status .

This field can only be used in the WHERE clause and cannot be selected in the SELECT clause.

click_potential_rank

int64

Normalized click potential of the product. Values range from 1 to 1000, where 1 is the highest click potential and 1000 is the theoretical lowest.