Element with all fields
ps_get_element_full
Shows everything stored for one product, category or CMS page, including fields added by other modules.
TellMyShop Free: No. This tool is only in TellMyShop Pro. TellMyShop Free has only ready reports that read your store.
Ask Claude
„Product 112 has an extra "Care instructions" tab from another module. Show me what is stored there.”
Example answer
Product 112: 14 tables.
product_lang (id_lang=1): name „Sofa Oslo”, meta_title „”…
producttab_lang (module producttabs, id_lang=1): content „<p>Vacuum weekly…”
Technical details
Reads the rows of every database table keyed to the element (id_product, id_category or id_cms), including tables of other modules, marked with the module name. For a product also combination and image tables. Long values are shortened (max_chars); one table can be read in full with table (with offset). Tables with customer, order and cart data are left out. Not in the free Audit.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| type | string | yes | Element type: product, category or cms (CMS page). |
| id | integer | yes | Element ID. |
| lang | string | no | Only rows in this language (ISO code) in tables with id_lang. Default: all languages. |
| shop_id | integer | no | Only rows of this shop in tables with id_shop. Default: all shops. |
| table | string | no | Only this table (without prefix), e.g. product_lang, with full rows and paging. |
| max_chars | integer | no | Shortening of long values (default 200 characters, 2000 with table). 20–20,000. |
| limit | integer | no | Max rows (default 20, max 200). |
| offset | integer | no | Rows to skip (paging), default 0. |
Limits
Read only. Without customer, order and cart tables.
Related tools
- Change any field of an element ps_update_element_field
- Get product ps_get_product
- Get category ps_get_category
- Get CMS page ps_get_cms_page
Last updated: 2026-10-11