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'
Click Run to try the sample in the API Explorer. After you click Run, update the merchant ID placeholder to your own merchant ID in the request URL. You can modify the query. The full query must remain on one line to work with the API explorer.
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