Shopware icon

Shopware

Shopware

Actions778

Product Price → Search Product Price

AI-generated

Overview

This node performs a search operation for product prices within the Shopware platform. It allows users to query product price data with various parameters such as pagination (page and limit), filtering, sorting, and grouping. This node is useful for scenarios where you need to retrieve specific product price information based on complex search criteria, for example, fetching product prices that meet certain conditions or sorting them by price or date.

Use Case Examples

  1. Retrieve the first page of product prices with a limit of 20 items per page.
  2. Search product prices filtered by a specific price range or currency.
  3. Sort product prices by ascending or descending order.
  4. Group product prices by certain fields for aggregated analysis.

Properties

Name Meaning
Page The page number of the search result to retrieve, used for pagination.
Limit The number of items to return per page in the search result.
Filter A JSON array of filters to restrict the search results based on specific criteria.
Sort A JSON array defining the sorting order of the search results.
Post Filter A JSON array of filters applied after aggregations, which do not affect the aggregation results.
Associations A JSON object defining related entities to include in the search results.
Aggregations A JSON array defining aggregations to perform on the search results.
Grouping A JSON array defining fields over which to perform groupings in the search results.
Fields A JSON array specifying which fields should be returned in the search results.
Total Count Mode Option to determine how the total number of hits is calculated: none (disabled), exact (slow but accurate), or next-pages (fast for next pages only).
Ids A JSON array of specific IDs to search for.
Includes A JSON object specifying fields to include for given entities, used to control returned data at the API level.
Request Options Node-level request options such as batching, SSL certificate validation, proxy settings, and timeout configuration.

Output

JSON

  • data - The search results containing product price data matching the query parameters.
  • total - The total number of matching product price records, if total count mode is enabled.

Dependencies

  • Shopware API credentials

Troubleshooting

  • Invalid JSON in filter, sort, post-filter, associations, aggregations, grouping, fields, ids, or includes properties can cause request failures. Ensure JSON is correctly formatted.
  • Incorrect pagination values (page or limit) may result in empty or incomplete results.
  • Using 'exact' total count mode may slow down the query significantly on large datasets.
  • Network or authentication issues with Shopware API credentials can cause request failures. Verify credentials and network connectivity.

Links

Discussion