You can use the
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
You must include the
product_view.id field in the
SELECT clause of your
product_view.id has the same value as the product's REST
You can filter based on all the available fields except the following:
You can sort the response based on all the available fields except the following:
Here's an example that returns all the available fields for your products with
NOT_ELIGIBLE_OR_DISAPPROVED. To make the request, pass the
following Merchant Center Query Language statement to the
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'
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