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

149

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

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.

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	—	-

Products

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

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.

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.

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.

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.

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.

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

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	—	-

Connexion PrestaShop pour LinkyFlow

Workflows a ramener dans Excel

Catalog

Categories

Categories

Entrees configurables

Donnees retournees dans Excel

Combinations

Combinations

Entrees configurables

Donnees retournees dans Excel

Update Combination Price Impact

Entrees configurables

Donnees retournees dans Excel

Manufacturers

Manufacturers

Entrees configurables

Donnees retournees dans Excel

Products

Products

Entrees configurables

Donnees retournees dans Excel

Update Product Price

Entrees configurables

Donnees retournees dans Excel

Customers

Customers

Customers

Entrees configurables

Donnees retournees dans Excel

Inventory

Stock

Stock

Entrees configurables

Donnees retournees dans Excel

Set Stock

Entrees configurables

Donnees retournees dans Excel

Sales

Order Lines

Order Lines

Entrees configurables

Donnees retournees dans Excel

Order States

Order States

Entrees configurables

Donnees retournees dans Excel

Orders

Orders

Entrees configurables

Donnees retournees dans Excel

Shop

Currencies

Currencies

Entrees configurables

Donnees retournees dans Excel

Languages

Languages

Entrees configurables

Donnees retournees dans Excel