Filter products

AI-generated Key Takeaways

• The Merchant API is the new version of the Content API for Shopping and represents the future of product data integration.

• The ProductView table within the Reports service allows you to filter and view your product data, including statuses and performance potential.

• You can query ProductView to identify and resolve product issues, verify new product serving, and gain insights into click potential.

• The reports.search method, coupled with Merchant Center Query Language, enables you to retrieve specific product data based on your chosen criteria.

• Refer to the provided resources for detailed information on ProductView fields, performance metrics, and utilizing the Reports service effectively.

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.