PrestaShop: the XML catalogue read in one line

Goal Read every product of a PrestaShop 8 shop through its Webservice, in XML, as it answers.

A real PrestaShop 8.2.8 and its demo catalogue. Its Webservice answers XML.

not told, the hub refuses the XML and says what to add;
response_format: xml: the hub reads the XML; PrestaShop ignores offset=, and the repeated page is refused;
pagination: { kind: prestashop }: the 19 products, their name read from the XML.

lumnik Open
E-commerce
PrestaShop
Connector

products.xml

<?xml version="1.0" encoding="UTF-8"?>
<prestashop xmlns:xlink="http://www.w3.org/1999/xlink">
<products>
<product>
	<id><![CDATA[1]]></id>
	<reference><![CDATA[demo_1]]></reference>
	<price><![CDATA[23.900000]]></price>
	<name><language id="1" xlink:href="http://host.docker.internal:9320/api/languages/1"><![CDATA[Hummingbird printed t-shirt]]></language></name>
</product>
</products>
</prestashop>

manifests/lab-docker-compose.yml

# PrestaShop 8, its demo catalogue, installed unattended; MySQL beside it. The Webservice (XML by default) is# switched on by the runner with a read-only key.name: lumnik-prestashopservices:  mysql:    image: mysql:8.0    environment:      MYSQL_ROOT_PASSWORD: lab-root      MYSQL_DATABASE: prestashop    tmpfs: [/var/lib/mysql]    healthcheck:      test: ["CMD", "mysqladmin", "ping", "-h", "127.0.0.1", "-plab-root"]      interval: 3s      retries: 40  prestashop:    image: prestashop/prestashop:8.2-apache    depends_on:      mysql: { condition: service_healthy }    environment:      DB_SERVER: mysql      DB_NAME: prestashop      DB_USER: root      DB_PASSWD: lab-root      PS_INSTALL_AUTO: "1"      PS_DOMAIN: host.docker.internal:${PRESTASHOP_PORT:-9320}      PS_FOLDER_ADMIN: admin-lab      PS_FOLDER_INSTALL: install-lab      ADMIN_MAIL: lab@example.test      ADMIN_PASSWD: lab-admin-password    ports: ["127.0.0.1:${PRESTASHOP_PORT:-9320}:80"]   # this machine only

manifests/10-products-xml.yaml

apiVersion: connectors.lumnik.io/v1kind: Connectormetadata:  name: scenario-prestashop-a  connector_type: rest-generic  scopes: [catalogue]spec:  base_url: http://host.docker.internal:9320/webservice  auth: { kind: api-key, in: query, name: ws_key, value_env: SCENARIO_PRESTASHOP_A_KEY }  endpoints:    - id: products      path: /dispatcher.php?url=products&display=[id,reference,price,name]      method: GET      pagination: { kind: offset, offset_param: offset, limit_param: limit, limit: 5, response_path: $.products }      target:        kind: hybrid        table: ext.scenario_prestashop_a        unique_key: $.id        promote:          - { name: reference, path: $.reference, type: text }          - { name: price, path: $.price, type: text }

$ lm apply -f manifests/10-products-xml.yaml
Applied connector "scenario-prestashop-a" — 1 endpoint

$ lm connector run scenario-prestashop-a
run scheduled: 5624fe78-deab-4332-864f-7e05aebfad2c

$ lm run get 5624fe78-deab-4332-864f-7e05aebfad2c
ID        CONNECTOR              ENDPOINT  STATUS  IN  OUT  SKIPPED  DEAD-LETTERS  STARTED           ENDED             EVALUATED
5624fe78  scenario-prestashop-a  products  Failed  0   0    0        0             2026-11-02 23:35  2026-11-02 23:35  yes
✖ run failed: the response is not JSON (Content-Type text/xml;charset=utf-8) — rest-generic reads JSON; an endpoint answering XML declares response_format: xml

manifests/20-products-offset.yaml

apiVersion: connectors.lumnik.io/v1kind: Connectormetadata:  name: scenario-prestashop-a  connector_type: rest-generic  scopes: [catalogue]spec:  base_url: http://host.docker.internal:9320/webservice  auth: { kind: api-key, in: query, name: ws_key, value_env: SCENARIO_PRESTASHOP_A_KEY }  endpoints:    - id: products      path: /dispatcher.php?url=products&display=[id,reference,price,name]      method: GET      response_format: xml                                # the shop answers XML      pagination: { kind: offset, offset_param: offset, limit_param: limit, limit: 5, response_path: $.products.product }      target:        kind: hybrid        table: ext.scenario_prestashop_a        unique_key: $.id        promote:          - { name: reference, path: $.reference, type: text }          - { name: price, path: $.price, type: decimal }          - { name: name, path: "$.name.language['#text']", type: text }

$ lm apply -f manifests/20-products-offset.yaml
Applied connector "scenario-prestashop-a" — 1 endpoint

$ lm connector run scenario-prestashop-a
run scheduled: 678d3c64-4d46-4be0-9038-9ed08388b96c

$ lm run get 678d3c64-4d46-4be0-9038-9ed08388b96c
ID        CONNECTOR              ENDPOINT  STATUS  IN  OUT  SKIPPED  DEAD-LETTERS  STARTED           ENDED             EVALUATED
678d3c64  scenario-prestashop-a  products  Failed  0   0    0        0             2026-11-02 23:35  2026-11-02 23:35  yes
✖ run failed: Endpoint 'products': the source answered the same page twice in a row — the paging parameter is not reaching it (check the pagination's parameter names, or use the source's preset)

products.xml

<?xml version="1.0" encoding="UTF-8"?>
<prestashop xmlns:xlink="http://www.w3.org/1999/xlink">
<products>
<product>
	<id><![CDATA[1]]></id>
	<reference><![CDATA[demo_1]]></reference>
	<price><![CDATA[23.900000]]></price>
	<name><language id="1" xlink:href="http://host.docker.internal:9320/api/languages/1"><![CDATA[Hummingbird printed t-shirt]]></language></name>
</product>
</products>
</prestashop>

manifests/30-products-preset.yaml

apiVersion: connectors.lumnik.io/v1kind: Connectormetadata:  name: scenario-prestashop-a  connector_type: rest-generic  scopes: [catalogue]spec:  base_url: http://host.docker.internal:9320/webservice  auth: { kind: api-key, in: query, name: ws_key, value_env: SCENARIO_PRESTASHOP_A_KEY }  endpoints:    - id: products      path: /dispatcher.php?url=products&display=[id,reference,price,name]      method: GET      response_format: xml                                # the shop answers XML      pagination: { kind: prestashop, resource: products, limit: 5, response_path: $.products.product }   # limit=0,5, then limit=5,5…      target:        kind: hybrid        table: ext.scenario_prestashop_a        unique_key: $.id        promote:          - { name: reference, path: $.reference, type: text }          - { name: price, path: $.price, type: decimal }          - { name: name, path: "$.name.language['#text']", type: text }

$ lm apply -f manifests/30-products-preset.yaml
Applied connector "scenario-prestashop-a" — 1 endpoint

$ lm connector run scenario-prestashop-a
run scheduled: 8cb80f69-7af9-473b-bf4a-1cebb0d6e5de

$ lm run get 8cb80f69-7af9-473b-bf4a-1cebb0d6e5de
ID        CONNECTOR              ENDPOINT  STATUS     IN  OUT  SKIPPED  DEAD-LETTERS  STARTED           ENDED             EVALUATED
8cb80f69  scenario-prestashop-a  products  Completed  19  19   0        0             2026-11-02 23:35  2026-11-02 23:35  yes

Limits

An XML document that declares a DTD or an entity is refused: lumnik never reads one.
Values arrive as text: the price is promoted as decimal to compare it.
PrestaShop's demo catalogue: 19 products; a throwaway key, drawn at each replay.

E-commerce · catalogue

The catalogue lives in PrestaShop.

Every product must be read, every night.

PrestaShop 8.2.8, its demo catalogue

The problem

PrestaShop answers XML.

Not JSON, like most APIs.
And it pages its own way: limit=0,50.

What is not changed

The shop stays as it is.

Its Webservice, a read-only key.
No module, no setting.

The first try

The hub refuses XML it was not told about.

It never reads zero products in silence.
It says the word to add.

What had to be written

response_format: xml
pagination: { kind: prestashop }

Two lines.

19 products out of 19, name and price.
A 25-line connector.

What was fixed

Three gaps found, three fixes.

The hub reads XML.
A repeated page fails the read.
The prestashop preset.

The limit

XML read safely.

No DTD, no entity: refused.
Values arrive as text.

Try it

The scenario replays locally.

Every step is published with its output.

This scenario runs on lumnik Open, free and open source.

Try lumnik Open →