Search products
ps_search_products
Read-onlyContent & SEO and Catalog · writes right awayWorks in TellMyShop FreeVisible right after install
Finds products by name, reference, category or missing information.
TellMyShop Free: Yes. This tool is in TellMyShop Free, which costs nothing. It only reads your store and never changes anything.
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 the 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 yes). |
| manufacturer_id | integer | no | Only products of this manufacturer. |
| active | enum: all | active | inactive | no | Product status (default active). |
| missing | array of enum: description | description_short | meta_title | meta_description | images | image_legends | ean13 | manufacturer | no | Products missing ALL of the listed elements (in language lang). Max 8 items. |
| missing_feature_id | integer | no | Products with no value of this feature (ID from ps_list_features). |
| description_shorter_than | integer | no | Description (without HTML) shorter than N characters, empty included. Range 1 to 10,000. |
| columns | array of enum: reference | ean13 | active | default_category | categories | manufacturer | price | quantity | features | meta_title | meta_description | description_length | link_rewrite | url | no | Result columns besides ID and name. Default: reference, active, default_category. Max 14 items. |
| lang | string | no | ISO language code, for example pl or en. Defaults to the shop's default language. |
| 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. |
| sort | enum: id | name | date_add | date_upd | no | Sort order. Default id. |
| order | enum: asc | desc | no | Sort direction. Default asc. |
| limit | integer | no | Maximum rows (default 50, max 200). |
| offset | integer | no | Rows to skip, for paging (default 0). |
Limits
Max 200 rows per call (default 50), paged with offset. Up to 8 missing filters and 14 columns.
Related tools
- Get product ps_get_product
- Update product content ps_update_product_content
- SEO audit ps_audit_seo
Use cases with this tool
- Find products with the same title or description in Google
- Find out why the shop search doesn't find a product
- Turn 'page not found' errors into a plan for old addresses
- Decide which products to improve first, based on sales
- Find products without images, EAN or manufacturer
- Write Google titles and descriptions for a whole category
- Rewrite product descriptions in your brand's tone
- Fill in empty short descriptions
- Write SEO texts for category pages
- Describe hundreds of product photos for Google in one go
- Clean up duplicate feature values
- Fill in missing product features for filters
- Move products between categories
- Fix the default category of products
- Make product names consistent for Google Shopping and search
- Translate product content into another shop language
- Launch a new collection: category texts and product assignment
- Raise or lower prices for a whole category
- Set a time-limited sale on a category
- Round prices to .99 after a price update
- Custom product export for a supplier or marketplace
- Correct stock levels after an inventory count
- Schedule a seasonal sale in advance with start and end dates
- Update wholesale prices from a supplier price list
- Review your blog for missing Google texts and outdated posts
- Write a blog post that links to your products
- Refresh an old blog post that still gets traffic
- Add new products from a supplier list
- Add, reorder or replace product photos
- Create new categories and move products into them
- Retire a product without losing its Google traffic
- Set prices, codes and stock for sizes and colours
- Run a promotion on a whole brand or category
- Get the whole shop ready for Black Friday
- Send visitors from any old address to the right new page
- Check that a big job fits your hourly limits before it starts
Last updated: 2026-10-11