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

You can use the following fields to view the performance potential of your products:

  • product_view.click_potential
  • product_view.click_potential_rank

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
  product_view.click_potential
  product_view.click_potential_rank
FROM ProductView
WHERE product_view.aggregated_destination_status = 'NOT_ELIGIBLE_OR_DISAPPROVED'

Run

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.

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.