Connexion Wix pour LinkyFlow
LinkyFlow connecte Excel a Wix pour consulter, modifier et publier les donnees e-commerce utiles depuis un tableur.
Ressources
14
Requetes de lecture
11
Actions ecriture
5
Champs documentes
168
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
Categories
The categories of your store, hidden ones included: their name, parent and how many products each holds.
Utilise comme filtre par
Categories
The categories of your store, hidden ones included: their name, parent and how many products each holds.
Route: GET /categories
Formule Excel: =LF.wix.categories("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
namedefault | string | — | - |
slug | string | — | - |
visibledefault | boolean | — | - |
itemCounterdefault | number | — | - |
parentCategory | string | → categories | - |
id | id | → categories | - |
createdDate | date | — | - |
updatedDate | date | — | - |
Locations
The places your store keeps stock at: each variant has a stock row at each of them.
Utilise comme filtre par
Locations
The places your store keeps stock at: each variant has a stock row at each of them.
Route: GET /locations
Formule Excel: =LF.wix.locations("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
namedefault | string | — | - |
locationTypedefault | string | — | - |
defaultLocationdefault | boolean | — | - |
wixLocationId | string | — | - |
createdDate | date | — | - |
updatedDate | date | — | - |
Options
The options that make variants (size, colour) and the modifiers that only ask the buyer (a gift message), shared by your products.
Options
The options that make variants (size, colour) and the modifiers that only ask the buyer (a gift message), shared by your products.
Route: GET /customizations
Formule Excel: =LF.wix.customizations("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
namedefault | string | — | - |
customizationTypedefault | string | — | - |
customizationRenderType | string | — | - |
key | string | — | - |
choicesSettings | string | — | - |
choices | string | — | - |
createdDate | date | — | - |
updatedDate | date | — | - |
Products
The products of your Wix store: name, type, visibility, price range and availability. Their SKUs and prices are on their variants.
Utilise comme filtre par
Products
The products of your Wix store: name, type, visibility, price range and availability. Their SKUs and prices are on their variants.
Route: GET /products
Formule Excel: =LF.wix.products("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
namedefault | string | — | - |
productTypedefault | string | — | - |
visibledefault | boolean | — | - |
availabilityStatusdefault | string | — | - |
currencydefault | string | — | - |
updatedDatedefault | date | — | - |
Update Product
Update Product
Route: PATCH /mutation/products
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Stock
The stock of each variant at each location: tracked by quantity, or only in stock or not. A SKU is read here as the store spells it.
Stock
The stock of each variant at each location: tracked by quantity, or only in stock or not. A SKU is read here as the store spells it.
Route: GET /inventoryItems
Formule Excel: =LF.wix.inventoryItems("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
namedefault | string | — | - |
variantSkudefault | string | — | - |
locationIddefault | string | → locations | - |
trackQuantitydefault | boolean | — | - |
quantitydefault | number | — | - |
availabilityStatusdefault | string | — | - |
updatedDatedefault | date | — | - |
Set Stock
Set Stock
Route: PATCH /mutation/inventoryItems
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Stock Adjustments
Moves the stock of a variant at a location by a difference, applied to whatever the store holds at that instant: a sale made at the same moment is never erased.
Adjust Stock
Adjust Stock
Route: POST /mutation/inventoryAdjustments
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Variants
Every variant of your products: its SKU, its price, its options and whether it is in stock.
Variants
Every variant of your products: its SKU, its price, its options and whether it is in stock.
Route: GET /variants
Formule Excel: =LF.wix.variants("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
productIddefault | string | → products | - |
namedefault | string | — | - |
currencydefault | string | — | - |
skudefault | string | — | - |
inStockdefault | boolean | — | - |
Customers
Contacts
The contacts of your site — buyers among them: name, email, phone and company.
Contacts
The contacts of your site — buyers among them: name, email, phone and company.
Route: GET /contacts
Formule Excel: =LF.wix.contacts("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
info | string | — | - |
name | string | — | - |
company | string | — | - |
primaryInfo | string | — | - |
emaildefault | string | — | - |
phone | string | — | - |
source | string | — | - |
sourceType | string | — | - |
lastActivity | string | — | - |
activityDate | date | — | - |
createdDate | date | — | - |
updatedDatedefault | date | — | - |
Sales
Cancel Order
Cancels this order: its buyer is emailed only when asked, its items restocked only when asked.
Cancel Order
Cancel Order
Route: POST /mutation/orderCancel
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Fulfill Order
Records a shipment of this order’s lines, with its tracking when given. Empty lines: every line of an unfulfilled order, whole.
Fulfill Order
Fulfill Order
Route: POST /mutation/orderCreateFulfillment
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Fulfillments
The shipments recorded on an order: which lines, their tracking and their status.
Fulfillments
The shipments recorded on an order: which lines, their tracking and their status.
Route: GET /orderFulfillments
Formule Excel: =LF.wix.orderFulfillments("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
orderIddefault | id | → orders | - |
statusdefault | string | — | - |
completeddefault | boolean | — | - |
trackingNumberdefault | string | — | - |
createdDatedefault | date | — | - |
Order Payments
The payments made on an order: amount, status and method.
Order Payments
The payments made on an order: amount, status and method.
Route: GET /orderPayments
Formule Excel: =LF.wix.orderPayments("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
orderIddefault | id | → orders | - |
amountdefault | string | — | - |
statusdefault | string | — | - |
paymentMethodNamedefault | string | — | - |
createdDatedefault | date | — | - |
Order Refunds
The refunds made on an order: what was refunded, and why.
Order Refunds
The refunds made on an order: what was refunded, and why.
Route: GET /orderRefunds
Formule Excel: =LF.wix.orderRefunds("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
orderIddefault | id | → orders | - |
summary | string | — | - |
refunded | string | — | - |
details | string | — | - |
reasondefault | string | — | - |
items | string | — | - |
transactions | string | — | - |
createdDatedefault | date | — | - |
Orders
The orders of your store, latest updated first: their status, payment, fulfillment, totals and lines.
Utilise comme filtre par
Orders
The orders of your store, latest updated first: their status, payment, fulfillment, totals and lines.
Route: GET /orders
Formule Excel: =LF.wix.orders("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
numberdefault | number | — | - |
statusdefault | string | — | - |
paymentStatusdefault | string | — | - |
fulfillmentStatusdefault | string | — | - |
currencydefault | string | — | - |
updatedDatedefault | date | — | - |