LinkyFlow — autonomous agents and live business data in Excel or on the webLinkyFlow
Log inStart free
PrestaShop connection for LinkyFlow

PrestaShop connection for LinkyFlow

LinkyFlow brings PrestaShop ecommerce data into Excel so teams can browse, edit, validate, and publish from the spreadsheet.

Resources

11

Read requests

11

Write actions

3

Documented fields

149

Workflows you can move into Excel

Each resource below maps to a practical spreadsheet workflow. Read actions bring useful columns into Excel; create and edit actions show what can be reviewed in rows before sending changes.

Catalog

Categories

The categories of your catalogue, each with its parent.

Read

Categories

The categories of your catalogue, each with its parent.

Route: GET /categories

Excel formula: =LF.prestashop.categories("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record, or several as 12|15. Answers the rows found, none when the id is unknown.
namestringNoRecords whose value holds this text.
id_parentstringNoExactly this value, or several as a|b.
activebooleanNoExactly this value, or several as a|b.
languageidNoThe language of the translated fields. The shop’s default language when empty.
per_pagenumberNoRows per page (max 100) Default: 100
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

name
default

string

—

-

id_parent
default

number

→ categories

-

level_depth

number

—

-

active
default

boolean

—

-

position

number

—

-

link_rewrite

string

—

-

description

string

—

-

date_add

string

—

-

date_upd

string

—

-

Combinations

The combinations of your products: each size or colour, its reference and its price impact.

Read

Combinations

The combinations of your products: each size or colour, its reference and its price impact.

Route: GET /combinations

Excel formula: =LF.prestashop.combinations("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record, or several as 12|15. Answers the rows found, none when the id is unknown.
id_productstringNoExactly this value, or several as a|b.
referencestringNoExactly this value, or several as a|b.
per_pagenumberNoRows per page (max 100) Default: 100
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

id_product
default

number

→ products

-

reference
default

string

—

-

price
default

string

—

-

wholesale_price

string

—

-

default_on
default

boolean

—

-

ean13

string

—

-

isbn

string

—

-

upc

string

—

-

mpn

string

—

-

minimal_quantity

number

—

-

weight

string

—

-

available_date

string

—

-

Edit

Update Combination Price Impact

Update Combination Price Impact

Route: PATCH /mutation/combinations

Inputs you can set
NameTypeRequiredDescription
ididYes-
pricestringYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Manufacturers

The brands your products are sold under.

Read

Manufacturers

The brands your products are sold under.

Route: GET /manufacturers

Excel formula: =LF.prestashop.manufacturers("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record, or several as 12|15. Answers the rows found, none when the id is unknown.
namestringNoRecords whose value holds this text.
activebooleanNoExactly this value, or several as a|b.
per_pagenumberNoRows per page (max 100) Default: 100
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

name
default

string

—

-

active
default

boolean

—

-

date_add

string

—

-

date_upd

string

—

-

Products

The products of your shop: their reference, list price, type and status.

Read

Products

The products of your shop: their reference, list price, type and status.

Route: GET /products

Excel formula: =LF.prestashop.products("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record, or several as 12|15. Answers the rows found, none when the id is unknown.
referencestringNoExactly this value, or several as a|b.
namestringNoRecords whose value holds this text.
activebooleanNoExactly this value, or several as a|b.
id_category_defaultstringNoExactly this value, or several as a|b.
id_manufacturerstringNoExactly this value, or several as a|b.
date_upd_fromstringNoOn or after this date, on the shop’s clock (2026-01-31 or 2026-01-31 18:00:00).
date_upd_tostringNoOn or before this date, on the shop’s clock (2026-01-31 or 2026-01-31 18:00:00).
sortenumNoThe order of the rows. By ascending id when empty. Values: id_ASC, id_DESC, date_upd_ASC, date_upd_DESC
languageidNoThe language of the translated fields. The shop’s default language when empty.
per_pagenumberNoRows per page (max 100) Default: 100
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

reference
default

string

—

-

name
default

string

—

-

price
default

string

—

-

active
default

boolean

—

-

product_type
default

string

—

-

date_upd
default

string

—

-

Edit

Update Product Price

Update Product Price

Route: PATCH /mutation/products

Inputs you can set
NameTypeRequiredDescription
ididYes-
pricestringYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Customers

Customers

The customers of your shop: their name, email, company and status.

Read

Customers

The customers of your shop: their name, email, company and status.

Route: GET /customers

Excel formula: =LF.prestashop.customers("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record, or several as 12|15. Answers the rows found, none when the id is unknown.
emailstringNoExactly this value, or several as a|b.
lastnamestringNoRecords whose value holds this text.
companystringNoRecords whose value holds this text.
activebooleanNoExactly this value, or several as a|b.
date_upd_fromstringNoOn or after this date, on the shop’s clock (2026-01-31 or 2026-01-31 18:00:00).
date_upd_tostringNoOn or before this date, on the shop’s clock (2026-01-31 or 2026-01-31 18:00:00).
sortenumNoThe order of the rows. By ascending id when empty. Values: id_ASC, id_DESC, date_upd_ASC, date_upd_DESC
per_pagenumberNoRows per page (max 100) Default: 100
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

firstname
default

string

—

-

lastname
default

string

—

-

email
default

string

—

-

company
default

string

—

-

active
default

boolean

—

-

date_upd
default

string

—

-

Inventory

Stock

The stock of every product and combination: one row per combination, and one for the product (combination 0).

Read

Stock

The stock of every product and combination: one row per combination, and one for the product (combination 0).

Route: GET /stockAvailables

Excel formula: =LF.prestashop.stockAvailables("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record, or several as 12|15. Answers the rows found, none when the id is unknown.
id_productstringNoExactly this value, or several as a|b.
id_product_attributestringNoExactly this value, or several as a|b.
per_pagenumberNoRows per page (max 100) Default: 100
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

id_product
default

number

→ products

-

id_product_attribute
default

number

→ combinations

-

quantity
default

number

—

-

depends_on_stock

boolean

—

-

out_of_stock

number

—

-

id_shop

number

—

-

Edit

Set Stock

Set Stock

Route: PATCH /mutation/stockAvailables

Inputs you can set
NameTypeRequiredDescription
ididYes-
quantitynumberYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Sales

Order Lines

The lines of your orders: each product sold, its reference, quantity and prices.

Read

Order Lines

The lines of your orders: each product sold, its reference, quantity and prices.

Route: GET /orderDetails

Excel formula: =LF.prestashop.orderDetails("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record, or several as 12|15. Answers the rows found, none when the id is unknown.
id_orderstringNoExactly this value, or several as a|b.
product_idstringNoExactly this value, or several as a|b.
product_referencestringNoExactly this value, or several as a|b.
per_pagenumberNoRows per page (max 100) Default: 100
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

id_order
default

number

→ orders

-

product_id
default

number

→ products

-

product_reference
default

string

—

-

product_name
default

string

—

-

product_quantity
default

number

—

-

unit_price_tax_incl
default

string

—

-

total_price_tax_incl
default

string

—

-

Order States

The states an order goes through: what current_state means in your shop.

Read

Order States

The states an order goes through: what current_state means in your shop.

Route: GET /orderStates

Excel formula: =LF.prestashop.orderStates("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record, or several as 12|15. Answers the rows found, none when the id is unknown.
languageidNoThe language of the translated fields. The shop’s default language when empty.
per_pagenumberNoRows per page (max 100) Default: 100
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

name
default

string

—

-

paid
default

boolean

—

-

shipped
default

boolean

—

-

delivery
default

boolean

—

-

invoice

boolean

—

-

logable

boolean

—

-

hidden

boolean

—

-

deleted

boolean

—

-

color

string

—

-

Orders

The orders of your shop: their reference, state, totals, customer and payment.

Read

Orders

The orders of your shop: their reference, state, totals, customer and payment.

Route: GET /orders

Excel formula: =LF.prestashop.orders("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record, or several as 12|15. Answers the rows found, none when the id is unknown.
referencestringNoExactly this value, or several as a|b.
current_statestringNoExactly this value, or several as a|b.
id_customerstringNoExactly this value, or several as a|b.
date_add_fromstringNoOn or after this date, on the shop’s clock (2026-01-31 or 2026-01-31 18:00:00).
date_add_tostringNoOn or before this date, on the shop’s clock (2026-01-31 or 2026-01-31 18:00:00).
date_upd_fromstringNoOn or after this date, on the shop’s clock (2026-01-31 or 2026-01-31 18:00:00).
date_upd_tostringNoOn or before this date, on the shop’s clock (2026-01-31 or 2026-01-31 18:00:00).
sortenumNoThe order of the rows. By ascending id when empty. Values: id_ASC, id_DESC, date_upd_ASC, date_upd_DESC
per_pagenumberNoRows per page (max 100) Default: 100
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

reference
default

string

—

-

current_state
default

number

→ orderStates

-

id_customer
default

number

→ customers

-

id_currency
default

number

→ currencies

-

payment
default

string

—

-

total_paid_tax_incl
default

string

—

-

date_add
default

string

—

-

Shop

Currencies

The currencies of your shop: what an order’s id_currency means.

Read

Currencies

The currencies of your shop: what an order’s id_currency means.

Route: GET /currencies

Excel formula: =LF.prestashop.currencies("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record, or several as 12|15. Answers the rows found, none when the id is unknown.
per_pagenumberNoRows per page (max 100) Default: 100
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

iso_code
default

string

—

-

conversion_rate
default

string

—

-

active
default

boolean

—

-

Languages

The languages of your shop: what a translated field can be read in.

Read

Languages

The languages of your shop: what a translated field can be read in.

Route: GET /languages

Excel formula: =LF.prestashop.languages("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record, or several as 12|15. Answers the rows found, none when the id is unknown.
activebooleanNoExactly this value, or several as a|b.
per_pagenumberNoRows per page (max 100) Default: 100
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

name
default

string

—

-

iso_code
default

string

—

-

language_code

string

—

-

active
default

boolean

—

-

← PreviousPrestaShop connection setupNext →LinkyFlow for Square