PrestaShop connection for LinkyFlow
LinkyFlow brings PrestaShop ecommerce data into Excel so teams can browse, edit, validate, and publish from the spreadsheet.
Resources
13
Read requests
12
Write actions
4
Documented fields
152
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.
Used as filter by
Categories
The categories of your catalogue, each with its parent.
Route: GET /categories
Excel formula: =LF.prestashop.categories("selection", "fields")
Inputs you can set
Data returned in Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
namedefault | string | — | - |
id_parentdefault | number | → categories | - |
level_depth | number | — | - |
activedefault | 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.
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
Data returned in Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
id_productdefault | number | → products | - |
referencedefault | string | — | - |
pricedefault | string | — | - |
wholesale_price | string | — | - |
default_ondefault | boolean | — | - |
ean13 | string | — | - |
isbn | string | — | - |
upc | string | — | - |
mpn | string | — | - |
minimal_quantity | number | — | - |
weight | string | — | - |
available_date | string | — | - |
Update Combination Price Impact
Update Combination Price Impact
Route: PATCH /mutation/combinations
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Manufacturers
The brands your products are sold under.
Used as filter by
Manufacturers
The brands your products are sold under.
Route: GET /manufacturers
Excel formula: =LF.prestashop.manufacturers("selection", "fields")
Inputs you can set
Data returned in Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
namedefault | string | — | - |
activedefault | 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.
Move Base Price
Move Base Price
Route: POST /mutation/productBasePrice
Inputs you can set
Data returned in Excel
This action returns a confirmation rather than a selectable table.
Products
The products of your shop: their reference, list price, type and status.
Used as filter by
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
Data returned in Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
referencedefault | string | — | - |
namedefault | string | — | - |
pricedefault | string | — | - |
activedefault | boolean | — | - |
product_typedefault | string | — | - |
date_upddefault | string | — | - |
Update Product Price
Update Product Price
Route: PATCH /mutation/products
Inputs you can set
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.
Used as filter by
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
Data returned in Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
firstnamedefault | string | — | - |
lastnamedefault | string | — | - |
emaildefault | string | — | - |
companydefault | string | — | - |
activedefault | boolean | — | - |
date_upddefault | string | — | - |
Inventory
Stock
The stock of every product and combination: one row per combination, and one for the product (combination 0).
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
Data returned in Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
id_productdefault | number | → products | - |
id_product_attributedefault | number | → combinations | - |
quantitydefault | number | — | - |
depends_on_stock | boolean | — | - |
out_of_stock | number | — | - |
id_shop | number | — | - |
Set Stock
Set Stock
Route: PATCH /mutation/stockAvailables
Inputs you can set
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.
Used as filter by
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
Data returned in Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
id_orderdefault | number | → orders | - |
product_iddefault | number | → products | - |
product_referencedefault | string | — | - |
product_namedefault | string | — | - |
product_quantitydefault | number | — | - |
unit_price_tax_incldefault | string | — | - |
total_price_tax_incldefault | string | — | - |
Order States
The states an order goes through: what current_state means in your shop.
Used as filter by
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
Data returned in Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
namedefault | string | — | - |
paiddefault | boolean | — | - |
shippeddefault | boolean | — | - |
deliverydefault | boolean | — | - |
invoice | boolean | — | - |
logable | boolean | — | - |
hidden | boolean | — | - |
deleted | boolean | — | - |
color | string | — | - |
Orders
The orders of your shop: their reference, state, totals, customer and payment.
Used as filter by
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
Data returned in Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
referencedefault | string | — | - |
current_statedefault | number | → orderStates | - |
id_customerdefault | number | → customers | - |
id_currencydefault | number | → currencies | - |
paymentdefault | string | — | - |
total_paid_tax_incldefault | string | — | - |
date_adddefault | string | — | - |
Shop
Currencies
The currencies of your shop: what an order’s id_currency means.
Used as filter by
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
Data returned in Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
iso_codedefault | string | — | - |
conversion_ratedefault | string | — | - |
activedefault | boolean | — | - |
Languages
The languages of your shop: what a translated field can be read in.
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
Data returned in Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
namedefault | string | — | - |
iso_codedefault | string | — | - |
language_code | string | — | - |
activedefault | 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.
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
Excel formula: =LF.prestashop.salesSettings("selection", "fields")
Inputs you can set
Data returned in Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
namedefault | string | — | - |
valuedefault | string | — | - |