Filter products

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.