You can use the
ProductView
table of the Reports
service to show a filtered view of your product data,
including product statuses.
For example, you can query ProductView
to do the following:
- List products that have issues, so you can resolve them.
- Get a list of your new products, so you can verify serving.
To view full details of all your products, use
products.list
.
You must include the product_view.id
field in the SELECT
clause of your
query. The product_view.id
has the same value as the product's REST
ID.
You can filter based on all the available fields except the following:
product_view.expiration_date
product_view.item_issues
You can sort the response based on all the available fields except the following:
product_view.gtin
product_view.item_issues
Here's an example that returns all the available fields for your products with
the status NOT_ELIGIBLE_OR_DISAPPROVED
. To make the request, pass the
following Merchant Center Query Language statement to the
reports.search
method:
SELECT
product_view.id,
product_view.offer_id,
product_view.title,
product_view.brand,
product_view.currency_code,
product_view.price_micros,
product_view.language_code,
product_view.condition,
product_view.channel,
product_view.availability,
product_view.shipping_label,
product_view.gtin,
product_view.item_group_id,
product_view.creation_time,
product_view.expiration_date,
product_view.aggregated_destination_status,
product_view.item_issues
FROM ProductView
WHERE product_view.aggregated_destination_status = 'NOT_ELIGIBLE_OR_DISAPPROVED'
See the ProductView
reference for
more information on specific fields and behavior.
See Performance metrics to learn how
to retrieve performance data for your products with the Reports
service.