Search products
ps_search_products
Read-onlyBlock 1 · Content & SEOFree in AuditDaily connectorVisible right after install
Finds products by name, reference, category or missing information.
Ask Claude
„Find products in Sofas with a description shorter than 300 characters and no meta description.”
Example answer
17 products. ID 112 Sofa Oslo 3-seat (description 84 characters), ID 113 Sofa Oslo 2-seat (0), ID 140 Corner sofa Bergen (212) ...
Technical details
Searches products and filters them by gaps in content. The main tool for finding which products to improve: empty or short description, missing meta, missing feature, no images or EAN, products of a category or manufacturer. Returns a table with the columns you choose. Description lengths are counted without HTML.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| query | string | no | Fragment of name, reference, EAN or ID (max 100 characters). |
| category_id | integer | no | Only products of this category (ID from ps_get_category_tree). |
| include_subcategories | boolean | no | With category_id: include subcategories (default true). |
| manufacturer_id | integer | no | Only products of this manufacturer. |
| missing | array of enum | no | Products missing ALL listed elements in the given language: description, description_short, meta_title, meta_description, images, image_legends, ean13, manufacturer. |
| description_shorter_than | integer | no | Description (without HTML) shorter than N characters, empty included (1-10000). |
| missing_feature_id | integer | no | Products with no value of this feature (ID from ps_list_features). |
| active | enum: all | active | inactive | no | Product status (default active). |
| columns | array of enum | no | Extra columns beyond ID and name (max 14): reference, ean13, active, default_category, categories, manufacturer, price, quantity, features, meta_title, meta_description, description_length, link_rewrite, url. Default: reference, active, default_category. |
| sort | enum: id | name | date_add | date_upd | no | Sort field (default id). |
| order | enum: asc | desc | no | Sort direction (default asc). |
| lang | string | no | ISO language code, for example en or pl. Defaults to the shop's default language. |
| limit | integer | no | Maximum rows (default 50, max 200). |
| offset | integer | no | Rows to skip, for paging (default 0). |
| shop_id | integer | no | Shop ID in a multistore installation. Defaults to the shop in the connector address. IDs are listed by ps_get_shop_info. |
Limits
Max 200 rows per call, paged with offset.
Related tools
- Get product ps_get_product
- Update product content ps_update_product_content
- SEO audit ps_audit_seo
Last updated: 2026-10-03