Connexion PrestaShop pour LinkyFlow

LinkyFlow connecte Excel a PrestaShop pour consulter, modifier et publier les donnees e-commerce utiles depuis un tableur.

Ressources

Requetes de lecture

Actions ecriture

Champs documentes

152

Workflows a ramener dans Excel

Chaque ressource ci-dessous correspond a un workflow tableur concret. Les lectures ramenent des colonnes utiles dans Excel; les creations et modifications indiquent ce qui peut etre relu en lignes avant envoi.

Catalog

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

Route: GET /combinations

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

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this record, or several as 12\|15. Answers the rows found, none when the id is unknown.
`id_product`	string	No	Exactly this value, or several as a\|b.
`reference`	string	No	Exactly this value, or several as a\|b.
`per_page`	number	No	Rows per page (max 100) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans 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	—	-

Modification

Update Combination Price Impact

Route: PATCH /mutation/combinations

Entrees configurables

Name	Type	Required	Description
`id`	id	Yes	-
`price`	string	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Manufacturers

The brands your products are sold under.

Utilise comme filtre par

Manufacturers · id

Products · id_manufacturer

Lecture

Manufacturers

The brands your products are sold under.

Route: GET /manufacturers

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

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this record, or several as 12\|15. Answers the rows found, none when the id is unknown.
`name`	string	No	Records whose value holds this text.
`active`	boolean	No	Exactly this value, or several as a\|b.
`per_page`	number	No	Rows per page (max 100) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`name` default	string	—	-
`active` default	boolean	—	-
`date_add`	string	—	-
`date_upd`	string	—	-

Move Base Price

Sets the price of a product with combinations, tax excluded: the base each adds its impact to, so all of them move by the same difference.

Creation

Move Base Price

Route: POST /mutation/productBasePrice

Entrees configurables

Name	Type	Required	Description
`combinations_moved`	number	Yes	-
`price`	string	Yes	-
`product_id`	id	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Products

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

Utilise comme filtre par

Combinations · id_product

Order Lines · product_id

Order Lines · product_reference

Products · id

Products · reference

Stock · id_product

Lecture

Products

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

Route: GET /products

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

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this record, or several as 12\|15. Answers the rows found, none when the id is unknown.
`reference`	string	No	Exactly this value, or several as a\|b.
`name`	string	No	Records whose value holds this text.
`active`	boolean	No	Exactly this value, or several as a\|b.
`id_category_default`	string	No	Exactly this value, or several as a\|b.
`id_manufacturer`	string	No	Exactly this value, or several as a\|b.
`date_upd_from`	string	No	On or after this date, on the shop’s clock (2026-01-31 or 2026-01-31 18:00:00).
`date_upd_to`	string	No	On or before this date, on the shop’s clock (2026-01-31 or 2026-01-31 18:00:00).
`sort`	enum	No	The order of the rows. By ascending id when empty. Values: id_ASC, id_DESC, date_upd_ASC, date_upd_DESC
`language`	id	No	The language of the translated fields. The shop’s default language when empty.
`per_page`	number	No	Rows per page (max 100) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans 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	—	-

Modification

Update Product Price

Route: PATCH /mutation/products

Entrees configurables

Name	Type	Required	Description
`id`	id	Yes	-
`price`	string	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Customers

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

Utilise comme filtre par

Customers · id

Customers · email

Orders · id_customer

Lecture

Customers

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

Route: GET /customers

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

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this record, or several as 12\|15. Answers the rows found, none when the id is unknown.
`email`	string	No	Exactly this value, or several as a\|b.
`lastname`	string	No	Records whose value holds this text.
`company`	string	No	Records whose value holds this text.
`active`	boolean	No	Exactly this value, or several as a\|b.
`date_upd_from`	string	No	On or after this date, on the shop’s clock (2026-01-31 or 2026-01-31 18:00:00).
`date_upd_to`	string	No	On or before this date, on the shop’s clock (2026-01-31 or 2026-01-31 18:00:00).
`sort`	enum	No	The order of the rows. By ascending id when empty. Values: id_ASC, id_DESC, date_upd_ASC, date_upd_DESC
`per_page`	number	No	Rows per page (max 100) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans 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).

Lecture

Stock

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

Route: GET /stockAvailables

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

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this record, or several as 12\|15. Answers the rows found, none when the id is unknown.
`id_product`	string	No	Exactly this value, or several as a\|b.
`id_product_attribute`	string	No	Exactly this value, or several as a\|b.
`per_page`	number	No	Rows per page (max 100) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans 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	—	-

Modification

Set Stock

Route: PATCH /mutation/stockAvailables

Entrees configurables

Name	Type	Required	Description
`id`	id	Yes	-
`quantity`	number	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Sales

Order Lines

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

Utilise comme filtre par

Order Lines · id

Lecture

Order Lines

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

Route: GET /orderDetails

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

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this record, or several as 12\|15. Answers the rows found, none when the id is unknown.
`id_order`	string	No	Exactly this value, or several as a\|b.
`product_id`	string	No	Exactly this value, or several as a\|b.
`product_reference`	string	No	Exactly this value, or several as a\|b.
`per_page`	number	No	Rows per page (max 100) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans 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.

Utilise comme filtre par

Order States · id

Orders · current_state

Lecture

Order States

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

Route: GET /orderStates

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

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this record, or several as 12\|15. Answers the rows found, none when the id is unknown.
`language`	id	No	The language of the translated fields. The shop’s default language when empty.
`per_page`	number	No	Rows per page (max 100) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans 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.

Utilise comme filtre par

Order Lines · id_order

Orders · id

Orders · reference

Lecture

Orders

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

Route: GET /orders

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

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this record, or several as 12\|15. Answers the rows found, none when the id is unknown.
`reference`	string	No	Exactly this value, or several as a\|b.
`current_state`	string	No	Exactly this value, or several as a\|b.
`id_customer`	string	No	Exactly this value, or several as a\|b.
`date_add_from`	string	No	On or after this date, on the shop’s clock (2026-01-31 or 2026-01-31 18:00:00).
`date_add_to`	string	No	On or before this date, on the shop’s clock (2026-01-31 or 2026-01-31 18:00:00).
`date_upd_from`	string	No	On or after this date, on the shop’s clock (2026-01-31 or 2026-01-31 18:00:00).
`date_upd_to`	string	No	On or before this date, on the shop’s clock (2026-01-31 or 2026-01-31 18:00:00).
`sort`	enum	No	The order of the rows. By ascending id when empty. Values: id_ASC, id_DESC, date_upd_ASC, date_upd_DESC
`per_page`	number	No	Rows per page (max 100) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans 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.

Utilise comme filtre par

Currencies · id

Lecture

Currencies

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

Route: GET /currencies

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

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this record, or several as 12\|15. Answers the rows found, none when the id is unknown.
`per_page`	number	No	Rows per page (max 100) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans 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.

Utilise comme filtre par

Categories · language

Languages · id

Order States · language

Products · language

Lecture

Languages

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

Route: GET /languages

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

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this record, or several as 12\|15. Answers the rows found, none when the id is unknown.
`active`	boolean	No	Exactly this value, or several as a\|b.
`per_page`	number	No	Rows per page (max 100) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`name` default	string	—	-
`iso_code` default	string	—	-
`language_code`	string	—	-
`active` default	boolean	—	-

Sales Settings

What your shop’s sales are read with: the time zone its dates are written on, and the order states that give stock back.

Lecture

Sales Settings

What your shop’s sales are read with: the time zone its dates are written on, and the order states that give stock back.

Route: GET /salesSettings

Formule Excel: =LF.prestashop.salesSettings("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`per_page`	number	No	Rows per page (max 100) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`name` default	string	—	-
`value` default	string	—	-

← PrécédentConfiguration de la connexion PrestaShop Suivant →LinkyFlow pour Square