Products Cache

List cached product data from pricestest.products_cache table.

HTTP: GET /external-data/products-cache

Query parameters

Name	Type	Required	Description	Example
limit	integer	no	Maximum number of rows per page (default 50).	50
page	integer	no	1-indexed page when using limit.	1
offset	integer	no	Explicit offset. Overrides page when supplied.	0
domain	string	no	Filter cached products for a specific domain.	example-shop.cz
product_id	string	no	Filter by product ID (supports partial matching).	PROD123
age_hours	integer	no	Show only cache entries newer than specified hours.	24
sort	string	no	Sort column (cache_date, domain, product_id).	cache_date
direction	string	no	Sort direction (asc, desc).	desc

Notes

Returns paginated data from pricestest.products_cache table with filtering and sorting capabilities.

Sample request

curl -H "Authorization: ApiKey YOUR_API_KEY" "https://admin.elpricing.com/api/external-data/products-cache?limit=20&domain=example-shop.cz&sort=cache_date&direction=desc"

Interactive call

HTTP MethodLimitMaximum number of rows per page (default 50).Page1-indexed page when using limit.OffsetExplicit offset. Overrides page when supplied.DomainFilter cached products for a specific domain.Product IDFilter by product ID (supports partial matching).Age in HoursShow only cache entries newer than specified hours.Sort BySort column (cache_date, domain, product_id).DirectionSort direction (asc, desc).

Queue workflow

Tasks are persisted to var/api_queue/tasks.json. Process them with:

php go.php cron:list\nphp go.php cron:go

Logs are written to var/api_queue/logs/{task_id}.log.