LinkyFlow — agents autonomes et données métier live dans Excel ou sur le webLinkyFlow
ConnexionCommencer
Connexion WooCommerce pour LinkyFlow

Connexion WooCommerce pour LinkyFlow

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

Ressources

36

Requetes de lecture

36

Actions ecriture

55

Champs documentes

221

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.

Analytics

Coupon Totals

Coupon counts grouped by type.

Lecture

Coupon Totals

Coupon counts grouped by type.

Route: GET /reportCouponsTotals

Formule Excel: =LF.woocommerce.reportCouponsTotals("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
Donnees retournees dans Excel
Field
Type
Relations
Description
slug
default

string

—

-

name
default

string

—

-

total
default

number

—

-

Customer Totals

Customer counts grouped by type.

Lecture

Customer Totals

Customer counts grouped by type.

Route: GET /reportCustomersTotals

Formule Excel: =LF.woocommerce.reportCustomersTotals("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
Donnees retournees dans Excel
Field
Type
Relations
Description
slug
default

string

—

-

name
default

string

—

-

total
default

number

—

-

Order Totals

Order counts grouped by status.

Lecture

Order Totals

Order counts grouped by status.

Route: GET /reportOrdersTotals

Formule Excel: =LF.woocommerce.reportOrdersTotals("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
Donnees retournees dans Excel
Field
Type
Relations
Description
slug
default

string

—

-

name
default

string

—

-

total
default

number

—

-

Product Totals

Product counts grouped by type.

Lecture

Product Totals

Product counts grouped by type.

Route: GET /reportProductsTotals

Formule Excel: =LF.woocommerce.reportProductsTotals("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
Donnees retournees dans Excel
Field
Type
Relations
Description
slug
default

string

—

-

name
default

string

—

-

total
default

number

—

-

Review Totals

Review counts grouped by status.

Lecture

Review Totals

Review counts grouped by status.

Route: GET /reportReviewsTotals

Formule Excel: =LF.woocommerce.reportReviewsTotals("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
Donnees retournees dans Excel
Field
Type
Relations
Description
slug
default

string

—

-

name
default

string

—

-

total
default

number

—

-

Sales Report

Summary sales report for a date range.

Lecture

Sales Report

Summary sales report for a date range.

Route: GET /reportSales

Formule Excel: =LF.woocommerce.reportSales("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
date_mindateNo-
date_maxdateNo-
Donnees retournees dans Excel
Field
Type
Relations
Description
total_sales
default

number

—

-

net_revenue
default

number

—

-

average_sales
default

number

—

-

total_orders
default

number

—

-

total_items
default

number

—

-

total_customers
default

number

—

-

Top Sellers

Top-selling products by quantity.

Lecture

Top Sellers

Top-selling products by quantity.

Route: GET /reportTopSellers

Formule Excel: =LF.woocommerce.reportTopSellers("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
date_mindateNo-
date_maxdateNo-
per_pagenumberNoItems per page (max 100) Default: 100
pagenumberNoPage number, 1-based Default: 1
Donnees retournees dans Excel
Field
Type
Relations
Description
product_id
default

id

→ products

-

name
default

string

—

-

quantity
default

number

—

-

total
default

number

—

-

Catalog

Attribute Terms

Terms (values) belonging to a product attribute.

Lecture

Attribute Terms

Terms (values) belonging to a product attribute.

Route: GET /productAttributeTerms

Formule Excel: =LF.woocommerce.productAttributeTerms("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
attribute_ididYesParent attribute ID
searchstringNoFilter by keyword
per_pagenumberNoItems per page (max 100) Default: 100
pagenumberNoPage number, 1-based Default: 1
Donnees retournees dans Excel
Field
Type
Relations
Description
id
default

id

—

-

name
default

string

—

-

slug
default

string

—

-

description

string

—

-

menu_order

number

—

-

count
default

number

—

-

Creation

Create Term

Create Term

Route: POST /mutation/productAttributeTerms

Entrees configurables
NameTypeRequiredDescription
attribute_ididYes-
descriptionstringNo-
menu_ordernumberNo-
namestringYes-
slugstringNo-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Update Term

Update Term

Route: PATCH /mutation/productAttributeTerms

Entrees configurables
NameTypeRequiredDescription
attribute_ididYes-
descriptionstringNo-
menu_ordernumberNo-
namestringYes-
slugstringNo-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Delete Term

Delete Term

Route: DELETE /mutation/productAttributeTerms

Entrees configurables
NameTypeRequiredDescription
attribute_ididYes-
descriptionstringNo-
menu_ordernumberNo-
namestringYes-
slugstringNo-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Product Attributes

Global product attributes (color, size, etc.).

Lecture

Product Attributes

Global product attributes (color, size, etc.).

Route: GET /productAttributes

Formule Excel: =LF.woocommerce.productAttributes("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
per_pagenumberNoItems per page (max 100) Default: 100
pagenumberNoPage number, 1-based Default: 1
Donnees retournees dans Excel
Field
Type
Relations
Description
id
default

id

—

-

name
default

string

—

-

slug
default

string

—

-

type

string

—

-

order_by

enum

—

-

has_archives

boolean

—

-

Creation

Create Attribute

Create Attribute

Route: POST /mutation/productAttributes

Entrees configurables
NameTypeRequiredDescription
has_archivesbooleanNo-
namestringYes-
order_byenumNoValues: menu_order, name, name_num, id
slugstringNo-
typestringNo-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Update Attribute

Update Attribute

Route: PATCH /mutation/productAttributes

Entrees configurables
NameTypeRequiredDescription
has_archivesbooleanNo-
namestringYes-
order_byenumNoValues: menu_order, name, name_num, id
slugstringNo-
typestringNo-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Delete Attribute

Delete Attribute

Route: DELETE /mutation/productAttributes

Entrees configurables
NameTypeRequiredDescription
has_archivesbooleanNo-
namestringYes-
order_byenumNoValues: menu_order, name, name_num, id
slugstringNo-
typestringNo-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Product Brands

Product brands in your store.

Lecture

Product Brands

Product brands in your store.

Route: GET /brands

Formule Excel: =LF.woocommerce.brands("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
searchstringNoFilter by keyword
per_pagenumberNoItems per page (max 100) Default: 100
pagenumberNoPage number, 1-based Default: 1
Donnees retournees dans Excel
Field
Type
Relations
Description
id
default

id

—

-

name
default

string

—

-

slug
default

string

—

-

description

string

—

-

count
default

number

—

-

Creation

Create Brand

Create Brand

Route: POST /mutation/brands

Entrees configurables
NameTypeRequiredDescription
descriptionstringNo-
namestringYes-
slugstringNo-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Update Brand

Update Brand

Route: PATCH /mutation/brands

Entrees configurables
NameTypeRequiredDescription
descriptionstringNo-
namestringYes-
slugstringNo-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Delete Brand

Delete Brand

Route: DELETE /mutation/brands

Entrees configurables
NameTypeRequiredDescription
descriptionstringNo-
namestringYes-
slugstringNo-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Product Categories

Product categories in your store.

Lecture

Product Categories

Product categories in your store.

Route: GET /categories

Formule Excel: =LF.woocommerce.categories("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
searchstringNoFilter by keyword
per_pagenumberNoItems per page (max 100) Default: 100
pagenumberNoPage number, 1-based Default: 1
Donnees retournees dans Excel
Field
Type
Relations
Description
id
default

id

—

-

name
default

string

—

-

slug
default

string

—

-

parent

id

→ categories

-

description

string

—

-

count
default

number

—

-

Creation

Create Category

Create Category

Route: POST /mutation/categories

Entrees configurables
NameTypeRequiredDescription
descriptionstringNo-
namestringYes-
parentidNo-
slugstringNo-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Update Category

Update Category

Route: PATCH /mutation/categories

Entrees configurables
NameTypeRequiredDescription
descriptionstringNo-
namestringYes-
parentidNo-
slugstringNo-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Delete Category

Delete Category

Route: DELETE /mutation/categories

Entrees configurables
NameTypeRequiredDescription
descriptionstringNo-
namestringYes-
parentidNo-
slugstringNo-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Product Reviews

Customer reviews on products.

Lecture

Product Reviews

Customer reviews on products.

Route: GET /productReviews

Formule Excel: =LF.woocommerce.productReviews("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
productidNoFilter by product ID
statusenumNoDefault: approved Values: all, hold, approved, spam, trash
per_pagenumberNoItems per page (max 100) Default: 100
pagenumberNoPage number, 1-based Default: 1
Donnees retournees dans Excel
Field
Type
Relations
Description
id
default

id

—

-

product_id
default

id

→ products

-

status
default

enum

—

-

reviewer
default

string

—

-

rating
default

number

—

-

review
default

string

—

-

date_created
default

date

—

-

Creation

Create Review

Create Review

Route: POST /mutation/productReviews

Entrees configurables
NameTypeRequiredDescription
product_ididYes-
ratingnumberNo-
reviewstringYes-
reviewerstringYes-
reviewer_emailstringYes-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Update Review

Update Review

Route: PATCH /mutation/productReviews

Entrees configurables
NameTypeRequiredDescription
product_ididYes-
ratingnumberNo-
reviewstringYes-
reviewerstringYes-
reviewer_emailstringYes-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Delete Review

Delete Review

Route: DELETE /mutation/productReviews

Entrees configurables
NameTypeRequiredDescription
product_ididYes-
ratingnumberNo-
reviewstringYes-
reviewerstringYes-
reviewer_emailstringYes-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Product Tags

Product tags in your store.

Lecture

Product Tags

Product tags in your store.

Route: GET /tags

Formule Excel: =LF.woocommerce.tags("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
searchstringNoFilter by keyword
per_pagenumberNoItems per page (max 100) Default: 100
pagenumberNoPage number, 1-based Default: 1
Donnees retournees dans Excel
Field
Type
Relations
Description
id
default

id

—

-

name
default

string

—

-

slug
default

string

—

-

description

string

—

-

count
default

number

—

-

Creation

Create Tag

Create Tag

Route: POST /mutation/tags

Entrees configurables
NameTypeRequiredDescription
descriptionstringNo-
namestringYes-
slugstringNo-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Update Tag

Update Tag

Route: PATCH /mutation/tags

Entrees configurables
NameTypeRequiredDescription
descriptionstringNo-
namestringYes-
slugstringNo-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Delete Tag

Delete Tag

Route: DELETE /mutation/tags

Entrees configurables
NameTypeRequiredDescription
descriptionstringNo-
namestringYes-
slugstringNo-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Product Variations

Variations (size, color, etc.) for variable products.

Lecture

Product Variations

Variations (size, color, etc.) for variable products.

Route: GET /productVariations

Formule Excel: =LF.woocommerce.productVariations("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
product_ididYesParent product
per_pagenumberNoItems per page (max 100) Default: 100
pagenumberNoPage number, 1-based Default: 1
Donnees retournees dans Excel
Field
Type
Relations
Description
id
default

id

—

-

sku
default

string

—

-

status
default

enum

—

-

price
default

number

—

-

stock_quantity
default

number

—

-

stock_status
default

enum

—

-

date_created
default

date

—

-

Creation

Create Variation

Create Variation

Route: POST /mutation/productVariations

Entrees configurables
NameTypeRequiredDescription
manage_stockbooleanNo-
product_ididYes-
regular_pricenumberNo-
sale_pricenumberNo-
skustringNo-
stock_quantitynumberNo-
stock_statusenumNoValues: instock, outofstock, onbackorder
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Update Variation

Update Variation

Route: PATCH /mutation/productVariations

Entrees configurables
NameTypeRequiredDescription
manage_stockbooleanNo-
product_ididYes-
regular_pricenumberNo-
sale_pricenumberNo-
skustringNo-
stock_quantitynumberNo-
stock_statusenumNoValues: instock, outofstock, onbackorder
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Delete Variation

Delete Variation

Route: DELETE /mutation/productVariations

Entrees configurables
NameTypeRequiredDescription
manage_stockbooleanNo-
product_ididYes-
regular_pricenumberNo-
sale_pricenumberNo-
skustringNo-
stock_quantitynumberNo-
stock_statusenumNoValues: instock, outofstock, onbackorder
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Products

Products in your WooCommerce store.

Lecture

Products

Products in your WooCommerce store.

Route: GET /products

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

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
statusenumNoFilter by product status Values: any, publish, draft, pending, private
categorystringNoFilter by category slug or ID
searchstringNoFilter by keyword
skustringNoFilter by exact SKU
includestringNoOnly these record IDs, comma-separated. One value is an exact lookup.
stock_statusenumNoFilter by stock status Values: instock, outofstock, onbackorder
afterdateNoProducts created after this ISO 8601 date
beforedateNoProducts created before this ISO 8601 date
orderbyenumNoField WooCommerce orders by Values: date, id, include, title, slug
orderenumNoSort direction Values: asc, desc
per_pagenumberNoItems per page (max 100) Default: 100
pagenumberNoPage number, 1-based Default: 1
Donnees retournees dans Excel
Field
Type
Relations
Description
id
default

id

—

-

name
default

string

—

-

sku
default

string

—

-

status
default

enum

—

-

price
default

number

—

-

regular_price
default

number

—

-

stock_quantity
default

number

—

-

stock_status
default

enum

—

-

date_created
default

date

—

-

Creation

Create Product

Create Product

Route: POST /mutation/products

Entrees configurables
NameTypeRequiredDescription
descriptionstringNo-
manage_stockbooleanNo-
namestringYes-
regular_pricenumberNo-
sale_pricenumberNo-
short_descriptionstringNo-
skustringNo-
statusenumNoValues: publish, draft, pending, private
stock_quantitynumberNo-
stock_statusenumNoValues: instock, outofstock, onbackorder
typeenumNoValues: simple, grouped, external, variable
weightstringNo-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Update Product

Update Product

Route: PATCH /mutation/products

Entrees configurables
NameTypeRequiredDescription
descriptionstringNo-
manage_stockbooleanNo-
namestringYes-
regular_pricenumberNo-
sale_pricenumberNo-
short_descriptionstringNo-
skustringNo-
statusenumNoValues: publish, draft, pending, private
stock_quantitynumberNo-
stock_statusenumNoValues: instock, outofstock, onbackorder
typeenumNoValues: simple, grouped, external, variable
weightstringNo-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Delete Product

Delete Product

Route: DELETE /mutation/products

Entrees configurables
NameTypeRequiredDescription
descriptionstringNo-
manage_stockbooleanNo-
namestringYes-
regular_pricenumberNo-
sale_pricenumberNo-
short_descriptionstringNo-
skustringNo-
statusenumNoValues: publish, draft, pending, private
stock_quantitynumberNo-
stock_statusenumNoValues: instock, outofstock, onbackorder
typeenumNoValues: simple, grouped, external, variable
weightstringNo-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Shipping Classes

Product shipping classes.

Lecture

Shipping Classes

Product shipping classes.

Route: GET /shippingClasses

Formule Excel: =LF.woocommerce.shippingClasses("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
searchstringNoFilter by keyword
per_pagenumberNoItems per page (max 100) Default: 100
pagenumberNoPage number, 1-based Default: 1
Donnees retournees dans Excel
Field
Type
Relations
Description
id
default

id

—

-

name
default

string

—

-

slug
default

string

—

-

description

string

—

-

count
default

number

—

-

Creation

Create Shipping Class

Create Shipping Class

Route: POST /mutation/shippingClasses

Entrees configurables
NameTypeRequiredDescription
descriptionstringNo-
namestringYes-
slugstringNo-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Update Shipping Class

Update Shipping Class

Route: PATCH /mutation/shippingClasses

Entrees configurables
NameTypeRequiredDescription
descriptionstringNo-
namestringYes-
slugstringNo-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Delete Shipping Class

Delete Shipping Class

Route: DELETE /mutation/shippingClasses

Entrees configurables
NameTypeRequiredDescription
descriptionstringNo-
namestringYes-
slugstringNo-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Customers

Customers

Store customers.

Utilise comme filtre par

Orders · customer
Lecture

Customers

Store customers.

Route: GET /customers

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

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
roleenumNoDefault: customer Values: all, administrator, editor, customer, subscriber
searchstringNoFilter by keyword
emailstringNoFilter by email
includestringNoOnly these record IDs, comma-separated. One value is an exact lookup.
orderbyenumNoField WooCommerce orders by Values: id, include, name, registered_date
orderenumNoSort direction Values: asc, desc
per_pagenumberNoItems per page (max 100) Default: 100
pagenumberNoPage number, 1-based Default: 1
Donnees retournees dans Excel
Field
Type
Relations
Description
id
default

id

—

-

email
default

string

—

-

first_name
default

string

—

-

last_name
default

string

—

-

orders_count
default

number

—

-

total_spent
default

number

—

-

date_created
default

date

—

-

Creation

Create Customer

Create Customer

Route: POST /mutation/customers

Entrees configurables
NameTypeRequiredDescription
emailstringYes-
first_namestringNo-
last_namestringNo-
passwordstringNo-
usernamestringNo-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Update Customer

Update Customer

Route: PATCH /mutation/customers

Entrees configurables
NameTypeRequiredDescription
emailstringYes-
first_namestringNo-
last_namestringNo-
passwordstringNo-
usernamestringNo-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Delete Customer

Delete Customer

Route: DELETE /mutation/customers

Entrees configurables
NameTypeRequiredDescription
emailstringYes-
first_namestringNo-
last_namestringNo-
passwordstringNo-
usernamestringNo-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Marketing

Coupons

Discount coupons.

Lecture

Coupons

Discount coupons.

Route: GET /coupons

Formule Excel: =LF.woocommerce.coupons("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
searchstringNoFilter by keyword
per_pagenumberNoItems per page (max 100) Default: 100
pagenumberNoPage number, 1-based Default: 1
Donnees retournees dans Excel
Field
Type
Relations
Description
id
default

id

—

-

code
default

string

—

-

amount
default

number

—

-

discount_type
default

enum

—

-

date_expires
default

date

—

-

usage_count
default

number

—

-

date_created
default

date

—

-

Creation

Create Coupon

Create Coupon

Route: POST /mutation/coupons

Entrees configurables
NameTypeRequiredDescription
amountnumberNo-
codestringYes-
date_expiresdateNo-
discount_typeenumYesValues: percent, fixed_cart, fixed_product
individual_usebooleanNo-
minimum_amountnumberNo-
usage_limitnumberNo-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Update Coupon

Update Coupon

Route: PATCH /mutation/coupons

Entrees configurables
NameTypeRequiredDescription
amountnumberNo-
codestringYes-
date_expiresdateNo-
discount_typeenumYesValues: percent, fixed_cart, fixed_product
individual_usebooleanNo-
minimum_amountnumberNo-
usage_limitnumberNo-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Delete Coupon

Delete Coupon

Route: DELETE /mutation/coupons

Entrees configurables
NameTypeRequiredDescription
amountnumberNo-
codestringYes-
date_expiresdateNo-
discount_typeenumYesValues: percent, fixed_cart, fixed_product
individual_usebooleanNo-
minimum_amountnumberNo-
usage_limitnumberNo-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Sales

Order Notes

Notes attached to orders.

Lecture

Order Notes

Notes attached to orders.

Route: GET /orderNotes

Formule Excel: =LF.woocommerce.orderNotes("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
order_ididYes-
per_pagenumberNoItems per page (max 100) Default: 100
pagenumberNoPage number, 1-based Default: 1
Donnees retournees dans Excel
Field
Type
Relations
Description
id
default

id

—

-

order_id

id

→ orders

-

author
default

string

—

-

note
default

string

—

-

customer_note
default

boolean

—

-

date_created
default

date

—

-

Creation

Create Order Note

Create Order Note

Route: POST /mutation/orderNotes

Entrees configurables
NameTypeRequiredDescription
customer_notebooleanNo-
notestringYes-
order_ididYes-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Delete Order Note

Delete Order Note

Route: DELETE /mutation/orderNotes

Entrees configurables
NameTypeRequiredDescription
customer_notebooleanNo-
notestringYes-
order_ididYes-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Order Statuses

Order statuses available in the store.

Lecture

Order Statuses

Order statuses available in the store.

Route: GET /orderStatuses

Formule Excel: =LF.woocommerce.orderStatuses("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
Donnees retournees dans Excel
Field
Type
Relations
Description
slug
default

string

—

-

name
default

string

—

-

Orders

Customer orders in your WooCommerce store.

Lecture

Orders

Customer orders in your WooCommerce store.

Route: GET /orders

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

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
statusenumNoFilter by order status Values: any, pending, processing, on-hold, completed
customeridNoFilter by customer
afterdateNoOrders created after this date
beforedateNoOrders created before this date
searchstringNoFilter by keyword
includestringNoOnly these record IDs, comma-separated. One value is an exact lookup.
orderbyenumNoField WooCommerce orders by Values: date, id, include, title, slug
orderenumNoSort direction Values: asc, desc
per_pagenumberNoItems per page (max 100) Default: 100
pagenumberNoPage number, 1-based Default: 1
Donnees retournees dans Excel
Field
Type
Relations
Description
id
default

id

—

-

number
default

string

—

-

status
default

enum

—

-

total
default

number

—

-

customer_id
default

id

→ customers

-

first_name
default

string

—

-

last_name
default

string

—

-

email
default

string

—

-

date_created
default

date

—

-

Creation

Create Order

Create Order

Route: POST /mutation/orders

Entrees configurables
NameTypeRequiredDescription
billing.emailstringNo-
billing.first_namestringNo-
billing.last_namestringNo-
billing.phonestringNo-
customer_ididNo-
payment_methodstringNo-
statusenumNoValues: pending, processing, on-hold, completed
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Update Order

Update Order

Route: PATCH /mutation/orders

Entrees configurables
NameTypeRequiredDescription
billing.emailstringNo-
billing.first_namestringNo-
billing.last_namestringNo-
billing.phonestringNo-
customer_ididNo-
payment_methodstringNo-
statusenumNoValues: pending, processing, on-hold, completed
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Delete Order

Delete Order

Route: DELETE /mutation/orders

Entrees configurables
NameTypeRequiredDescription
billing.emailstringNo-
billing.first_namestringNo-
billing.last_namestringNo-
billing.phonestringNo-
customer_ididNo-
payment_methodstringNo-
statusenumNoValues: pending, processing, on-hold, completed
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Refunds

Refunds applied to orders.

Lecture

Refunds

Refunds applied to orders.

Route: GET /refunds

Formule Excel: =LF.woocommerce.refunds("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
order_ididYes-
per_pagenumberNoItems per page (max 100) Default: 100
pagenumberNoPage number, 1-based Default: 1
Donnees retournees dans Excel
Field
Type
Relations
Description
id
default

id

—

-

order_id

id

→ orders

-

amount
default

number

—

-

reason
default

string

—

-

refunded_by

id

—

-

date_created
default

date

—

-

Creation

Create Refund

Create Refund

Route: POST /mutation/refunds

Entrees configurables
NameTypeRequiredDescription
amountnumberYes-
order_ididYes-
reasonstringNo-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Delete Refund

Delete Refund

Route: DELETE /mutation/refunds

Entrees configurables
NameTypeRequiredDescription
amountnumberYes-
order_ididYes-
reasonstringNo-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Settings

Continents

Continents and the countries they contain.

Lecture

Continents

Continents and the countries they contain.

Route: GET /dataContinents

Formule Excel: =LF.woocommerce.dataContinents("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
per_pagenumberNoItems per page (max 100) Default: 100
pagenumberNoPage number, 1-based Default: 1
Donnees retournees dans Excel
Field
Type
Relations
Description
code
default

string

—

-

name
default

string

—

-

Countries

Countries supported by the store.

Lecture

Countries

Countries supported by the store.

Route: GET /dataCountries

Formule Excel: =LF.woocommerce.dataCountries("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
per_pagenumberNoItems per page (max 100) Default: 100
pagenumberNoPage number, 1-based Default: 1
Donnees retournees dans Excel
Field
Type
Relations
Description
code
default

string

—

-

name
default

string

—

-

Currencies

Currencies supported by the store.

Lecture

Currencies

Currencies supported by the store.

Route: GET /dataCurrencies

Formule Excel: =LF.woocommerce.dataCurrencies("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
per_pagenumberNoItems per page (max 100) Default: 100
pagenumberNoPage number, 1-based Default: 1
Donnees retournees dans Excel
Field
Type
Relations
Description
code
default

string

—

-

name
default

string

—

-

symbol
default

string

—

-

Payment Gateways

Configured payment gateways.

Lecture

Payment Gateways

Configured payment gateways.

Route: GET /paymentGateways

Formule Excel: =LF.woocommerce.paymentGateways("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
Donnees retournees dans Excel
Field
Type
Relations
Description
id
default

id

—

-

title
default

string

—

-

description

string

—

-

enabled
default

boolean

—

-

method_title
default

string

—

-

Modification

Update Payment Gateway

Update Payment Gateway

Route: PATCH /mutation/paymentGateways

Entrees configurables
NameTypeRequiredDescription
descriptionstringNo-
enabledbooleanNo-
idstringYes-
titlestringNo-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Settings Groups

Top-level groups of store settings.

Lecture

Settings Groups

Top-level groups of store settings.

Route: GET /settingsGroups

Formule Excel: =LF.woocommerce.settingsGroups("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
Donnees retournees dans Excel
Field
Type
Relations
Description
id
default

id

—

-

label
default

string

—

-

description
default

string

—

-

parent_id

string

—

-

Settings Options

Individual settings within a group (e.g. general, products, tax).

Lecture

Settings Options

Individual settings within a group (e.g. general, products, tax).

Route: GET /settingsOptions

Formule Excel: =LF.woocommerce.settingsOptions("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
group_idstringYese.g. general, products, tax, shipping, account
Donnees retournees dans Excel
Field
Type
Relations
Description
id
default

id

—

-

label
default

string

—

-

value
default

string

—

-

default

string

—

-

type

string

—

-

description

string

—

-

Modification

Update Setting

Update Setting

Route: PATCH /mutation/settingsOptions

Entrees configurables
NameTypeRequiredDescription
group_idstringYes-
idstringYes-
valuestringYes-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Shipping Methods

Shipping methods available to assign to zones.

Lecture

Shipping Methods

Shipping methods available to assign to zones.

Route: GET /shippingMethods

Formule Excel: =LF.woocommerce.shippingMethods("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
Donnees retournees dans Excel
Field
Type
Relations
Description
id
default

id

—

-

title
default

string

—

-

description
default

string

—

-

Shipping Zone Locations

Locations covered by a shipping zone.

Lecture

Shipping Zone Locations

Locations covered by a shipping zone.

Route: GET /shippingZoneLocations

Formule Excel: =LF.woocommerce.shippingZoneLocations("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
zone_ididYesParent shipping zone ID
Donnees retournees dans Excel
Field
Type
Relations
Description
code
default

string

—

-

type
default

string

—

-

Shipping Zone Methods

Shipping methods assigned to a specific zone.

Lecture

Shipping Zone Methods

Shipping methods assigned to a specific zone.

Route: GET /shippingZoneMethods

Formule Excel: =LF.woocommerce.shippingZoneMethods("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
zone_ididYesParent shipping zone ID
Donnees retournees dans Excel
Field
Type
Relations
Description
instance_id
default

id

—

-

title
default

string

—

-

method_id
default

string

—

-

enabled
default

boolean

—

-

order

number

—

-

Creation

Add Method to Zone

Add Method to Zone

Route: POST /mutation/shippingZoneMethods

Entrees configurables
NameTypeRequiredDescription
method_idstringYes-
zone_ididYes-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Remove Method from Zone

Remove Method from Zone

Route: DELETE /mutation/shippingZoneMethods

Entrees configurables
NameTypeRequiredDescription
method_idstringYes-
zone_ididYes-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Shipping Zones

Configured shipping zones.

Lecture

Shipping Zones

Configured shipping zones.

Route: GET /shippingZones

Formule Excel: =LF.woocommerce.shippingZones("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
Donnees retournees dans Excel
Field
Type
Relations
Description
id
default

id

—

-

name
default

string

—

-

order

number

—

-

Creation

Create Shipping Zone

Create Shipping Zone

Route: POST /mutation/shippingZones

Entrees configurables
NameTypeRequiredDescription
namestringYes-
ordernumberNo-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Update Shipping Zone

Update Shipping Zone

Route: PATCH /mutation/shippingZones

Entrees configurables
NameTypeRequiredDescription
namestringYes-
ordernumberNo-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Delete Shipping Zone

Delete Shipping Zone

Route: DELETE /mutation/shippingZones

Entrees configurables
NameTypeRequiredDescription
namestringYes-
ordernumberNo-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

System Status Tools

Maintenance tools (clear cache, regenerate, etc.).

Lecture

System Status Tools

Maintenance tools (clear cache, regenerate, etc.).

Route: GET /systemStatusTools

Formule Excel: =LF.woocommerce.systemStatusTools("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
Donnees retournees dans Excel
Field
Type
Relations
Description
id
default

id

—

-

name
default

string

—

-

action
default

string

—

-

description
default

string

—

-

Tax Classes

Tax classes configured in the store.

Lecture

Tax Classes

Tax classes configured in the store.

Route: GET /taxClasses

Formule Excel: =LF.woocommerce.taxClasses("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
Donnees retournees dans Excel
Field
Type
Relations
Description
slug
default

string

—

-

name
default

string

—

-

Creation

Create Tax Class

Create Tax Class

Route: POST /mutation/taxClasses

Entrees configurables
NameTypeRequiredDescription
namestringYes-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Delete Tax Class

Delete Tax Class

Route: DELETE /mutation/taxClasses

Entrees configurables
NameTypeRequiredDescription
namestringYes-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Tax Rates

Tax rates configured in the store.

Lecture

Tax Rates

Tax rates configured in the store.

Route: GET /taxRates

Formule Excel: =LF.woocommerce.taxRates("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
classstringNo-
per_pagenumberNoItems per page (max 100) Default: 100
pagenumberNoPage number, 1-based Default: 1
Donnees retournees dans Excel
Field
Type
Relations
Description
id
default

id

—

-

country
default

string

—

-

state
default

string

—

-

rate
default

string

—

-

name
default

string

—

-

class

string

—

-

shipping

boolean

—

-

compound

boolean

—

-

Creation

Create Tax Rate

Create Tax Rate

Route: POST /mutation/taxRates

Entrees configurables
NameTypeRequiredDescription
classstringNo-
countrystringNo-
namestringNo-
ratestringYes-
statestringNo-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Update Tax Rate

Update Tax Rate

Route: PATCH /mutation/taxRates

Entrees configurables
NameTypeRequiredDescription
classstringNo-
countrystringNo-
namestringNo-
ratestringYes-
statestringNo-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Delete Tax Rate

Delete Tax Rate

Route: DELETE /mutation/taxRates

Entrees configurables
NameTypeRequiredDescription
classstringNo-
countrystringNo-
namestringNo-
ratestringYes-
statestringNo-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Webhooks

Webhooks configured in the store.

Lecture

Webhooks

Webhooks configured in the store.

Route: GET /webhooks

Formule Excel: =LF.woocommerce.webhooks("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
statusenumNoDefault: all Values: all, active, paused, disabled
per_pagenumberNoItems per page (max 100) Default: 100
pagenumberNoPage number, 1-based Default: 1
Donnees retournees dans Excel
Field
Type
Relations
Description
id
default

id

—

-

name
default

string

—

-

status
default

enum

—

-

topic
default

string

—

-

delivery_url
default

string

—

-

date_created
default

date

—

-

Creation

Create Webhook

Create Webhook

Route: POST /mutation/webhooks

Entrees configurables
NameTypeRequiredDescription
delivery_urlstringYes-
namestringNo-
secretstringNo-
topicstringYes-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Update Webhook

Update Webhook

Route: PATCH /mutation/webhooks

Entrees configurables
NameTypeRequiredDescription
delivery_urlstringYes-
namestringNo-
secretstringNo-
topicstringYes-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Delete Webhook

Delete Webhook

Route: DELETE /mutation/webhooks

Entrees configurables
NameTypeRequiredDescription
delivery_urlstringYes-
namestringNo-
secretstringNo-
topicstringYes-
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

← PrécédentRéglages boutique, expédition & taxesSuivant →LinkyFlow pour Stripe