LinkyFlow - Cashflow pour vos crypto, banques et gestion de budgetLinkyFlow
Documentation
Tarif
Blog
ConnexionInstaller
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

218

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
name
default

string

—

-

slug
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
name
default

string

—

-

slug
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
name
default

string

—

-

slug
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
name
default

string

—

-

slug
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
name
default

string

—

-

slug
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
average_sales
default

number

—

-

net_revenue
default

number

—

-

total_customers
default

number

—

-

total_items
default

number

—

-

total_orders
default

number

—

-

total_sales
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
Donnees retournees dans Excel
Field
Type
Relations
Description
name
default

string

—

-

product_id
default

id

→ products

-

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
Donnees retournees dans Excel
Field
Type
Relations
Description
count
default

number

—

-

description

string

—

-

id
default

id

—

-

menu_order

number

—

-

name
default

string

—

-

slug
default

string

—

-

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
Donnees retournees dans Excel
Field
Type
Relations
Description
has_archives

boolean

—

-

id
default

id

—

-

name
default

string

—

-

order_by

enum

—

-

slug
default

string

—

-

type

string

—

-

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
Donnees retournees dans Excel
Field
Type
Relations
Description
count
default

number

—

-

description

string

—

-

id
default

id

—

-

name
default

string

—

-

slug
default

string

—

-

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
Donnees retournees dans Excel
Field
Type
Relations
Description
count
default

number

—

-

description

string

—

-

id
default

id

—

-

name
default

string

—

-

parent

id

→ categories

-

slug
default

string

—

-

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
Donnees retournees dans Excel
Field
Type
Relations
Description
date_created
default

date

—

-

id
default

id

—

-

product_id
default

id

→ products

-

rating
default

number

—

-

review
default

string

—

-

reviewer
default

string

—

-

status
default

string

—

-

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
Donnees retournees dans Excel
Field
Type
Relations
Description
count
default

number

—

-

description

string

—

-

id
default

id

—

-

name
default

string

—

-

slug
default

string

—

-

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 ID
per_pagenumberNoItems per page (max 100) Default: 100
Donnees retournees dans Excel
Field
Type
Relations
Description
date_created
default

date

—

-

id
default

id

—

-

price
default

number

—

-

sku
default

string

—

-

status
default

string

—

-

stock_quantity
default

number

—

-

stock_status
default

string

—

-

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
per_pagenumberNoItems per page (max 100) Default: 100
Donnees retournees dans Excel
Field
Type
Relations
Description
date_created
default

date

—

-

id
default

id

—

-

name
default

string

—

-

price
default

number

—

-

regular_price
default

number

—

-

sku
default

string

—

-

status
default

enum

—

-

stock_quantity
default

number

—

-

stock_status
default

enum

—

-

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
Donnees retournees dans Excel
Field
Type
Relations
Description
count
default

number

—

-

description

string

—

-

id
default

id

—

-

name
default

string

—

-

slug
default

string

—

-

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
per_pagenumberNoItems per page (max 100) Default: 100
Donnees retournees dans Excel
Field
Type
Relations
Description
date_created
default

date

—

-

email
default

string

—

-

first_name
default

string

—

-

id
default

id

—

-

last_name
default

string

—

-

orders_count
default

number

—

-

total_spent
default

number

—

-

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
Donnees retournees dans Excel
Field
Type
Relations
Description
amount
default

number

—

-

code
default

string

—

-

date_created
default

date

—

-

date_expires
default

date

—

-

discount_type
default

enum

—

-

id
default

id

—

-

usage_count
default

number

—

-

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
Donnees retournees dans Excel
Field
Type
Relations
Description
author
default

string

—

-

customer_note
default

boolean

—

-

date_created
default

date

—

-

id
default

id

—

-

note
default

string

—

-

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
name
default

string

—

-

slug
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 ID
afterdateNoOrders created after this date
beforedateNoOrders created before this date
per_pagenumberNoItems per page (max 100) Default: 100
Donnees retournees dans Excel
Field
Type
Relations
Description
email
default

string

—

-

first_name
default

string

—

-

last_name
default

string

—

-

customer_id
default

id

→ customers

-

date_created
default

date

—

-

id
default

id

—

-

number
default

string

—

-

status
default

string

—

-

total
default

number

—

-

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
Donnees retournees dans Excel
Field
Type
Relations
Description
amount
default

number

—

-

date_created
default

date

—

-

id
default

id

—

-

reason
default

string

—

-

refunded_by

id

—

-

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

string

—

-

enabled
default

boolean

—

-

id
default

id

—

-

method_title
default

string

—

-

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
description
default

string

—

-

id
default

id

—

-

label
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
default

string

—

-

description

string

—

-

id
default

id

—

-

label
default

string

—

-

type

string

—

-

value
default

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
description
default

string

—

-

id
default

id

—

-

title
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
enabled
default

boolean

—

-

instance_id
default

id

—

-

method_id
default

string

—

-

order

number

—

-

title
default

string

—

-

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
action
default

string

—

-

description
default

string

—

-

id
default

id

—

-

name
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
name
default

string

—

-

slug
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
Donnees retournees dans Excel
Field
Type
Relations
Description
class

string

—

-

compound

boolean

—

-

country
default

string

—

-

id
default

id

—

-

name
default

string

—

-

rate
default

string

—

-

shipping

boolean

—

-

state
default

string

—

-

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
Donnees retournees dans Excel
Field
Type
Relations
Description
date_created
default

date

—

-

delivery_url
default

string

—

-

id
default

id

—

-

name
default

string

—

-

status
default

string

—

-

topic
default

string

—

-

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