Connexion BigCommerce pour LinkyFlow

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

Ressources

Requetes de lecture

Actions ecriture

Champs documentes

372

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

Brands

The brands of your catalogue.

Utilise comme filtre par

Products · brand_id

Lecture

Brands

The brands of your catalogue.

Route: GET /brands

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

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this record. Answers one row, or none when the id is unknown.
`id_in`	string	No	Only these record IDs, comma-separated.
`name`	string	No	Exactly this name.
`name_like`	string	No	-
`per_page`	number	No	Rows per page (max 250) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`name` default	string	—	-
`page_title` default	string	—	-
`meta_description`	string	—	-
`search_keywords`	string	—	-
`image_url`	string	—	-
`custom_url`	string	—	-
`url` default	string	—	-

Creation

Create Brand

Route: POST /mutation/brands

Entrees configurables

Name	Type	Required	Description
`image_url`	string	No	-
`meta_description`	string	No	-
`name`	string	Yes	-
`page_title`	string	No	-
`search_keywords`	string	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Update Brand

Route: PATCH /mutation/brands

Entrees configurables

Name	Type	Required	Description
`image_url`	string	No	-
`meta_description`	string	No	-
`name`	string	Yes	-
`page_title`	string	No	-
`search_keywords`	string	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Delete Brand

Route: DELETE /mutation/brands

Entrees configurables

Name	Type	Required	Description
`image_url`	string	No	-
`meta_description`	string	No	-
`name`	string	Yes	-
`page_title`	string	No	-
`search_keywords`	string	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Field	Type	Relations	Description
`category_id` default	id	—	-
`name` default	string	—	-
`parent_id` default	id	→ categories	-
`tree_id`	id	—	-
`is_visible` default	boolean	—	-
`sort_order`	number	—	-
`page_title`	string	—	-
`url`	string	—	-
`path`	string	—	-
`description`	string	—	-
`views`	number	—	-

Name	Type	Required	Description
`link`	string	Yes	-
`product_id`	id	Yes	Parent product
`per_page`	number	No	Rows per page (max 250) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`product_id` default	id	→ products	-
`name` default	string	—	-
`value` default	string	—	-

Creation

Add Custom Field

Route: POST /mutation/productCustomFields

Entrees configurables

Name	Type	Required	Description
`name`	string	Yes	-
`product_id`	id	Yes	-
`value`	string	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Update Custom Field

Route: PATCH /mutation/productCustomFields

Entrees configurables

Name	Type	Required	Description
`name`	string	Yes	-
`product_id`	id	Yes	-
`value`	string	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Delete Custom Field

Route: DELETE /mutation/productCustomFields

Entrees configurables

Name	Type	Required	Description
`name`	string	Yes	-
`product_id`	id	Yes	-
`value`	string	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Product Images

The images of a product, its thumbnail among them.

Lecture

Product Images

The images of a product, its thumbnail among them.

Route: GET /productImages

Formule Excel: =LF.bigcommerce.productImages("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`product_id`	id	Yes	Parent product
`per_page`	number	No	Rows per page (max 250) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`product_id` default	id	→ products	-
`is_thumbnail` default	boolean	—	-
`sort_order` default	number	—	-
`description` default	string	—	-
`url_standard` default	string	—	-
`date_modified` default	date	—	-

Creation

Add Product Image

Route: POST /mutation/productImages

Entrees configurables

Name	Type	Required	Description
`description`	string	No	-
`image_url`	string	Yes	-
`is_thumbnail`	boolean	No	-
`product_id`	id	Yes	-
`sort_order`	number	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Update Product Image

Route: PATCH /mutation/productImages

Entrees configurables

Name	Type	Required	Description
`description`	string	No	-
`image_url`	string	Yes	-
`is_thumbnail`	boolean	No	-
`product_id`	id	Yes	-
`sort_order`	number	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Delete Product Image

Route: DELETE /mutation/productImages

Entrees configurables

Name	Type	Required	Description
`description`	string	No	-
`image_url`	string	Yes	-
`is_thumbnail`	boolean	No	-
`product_id`	id	Yes	-
`sort_order`	number	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Product Modifiers

The choices a shopper adds to a product that make no variant (a gift note, an engraving), with their price adjustments.

Lecture

Product Modifiers

The choices a shopper adds to a product that make no variant (a gift note, an engraving), with their price adjustments.

Route: GET /productModifiers

Formule Excel: =LF.bigcommerce.productModifiers("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`product_id`	id	Yes	Parent product
`per_page`	number	No	Rows per page (max 250) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`product_id` default	id	→ products	-
`display_name` default	string	—	-
`name`	string	—	-
`type` default	string	—	-
`required` default	boolean	—	-
`sort_order`	number	—	-
`option_values`	string	—	-

Product Options

The options a shopper picks to choose a variant (size, colour), with their values.

Lecture

Product Options

The options a shopper picks to choose a variant (size, colour), with their values.

Route: GET /productOptions

Formule Excel: =LF.bigcommerce.productOptions("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`product_id`	id	Yes	Parent product
`per_page`	number	No	Rows per page (max 250) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`product_id` default	id	→ products	-
`display_name` default	string	—	-
`name`	string	—	-
`type` default	string	—	-
`sort_order`	number	—	-
`option_values` default	string	—	-

Product Reviews

What shoppers wrote about a product, and whether it is shown.

Lecture

Product Reviews

What shoppers wrote about a product, and whether it is shown.

Route: GET /productReviews

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

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`product_id`	id	Yes	Parent product
`per_page`	number	No	Rows per page (max 250) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`product_id` default	id	→ products	-
`title` default	string	—	-
`rating` default	number	—	-
`status` default	enum	—	-
`name` default	string	—	-
`date_modified` default	date	—	-

Product Variants

The variants of a product: each SKU, its prices and its stock.

Lecture

Product Variants

The variants of a product: each SKU, its prices and its stock.

Route: GET /productVariants

Formule Excel: =LF.bigcommerce.productVariants("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`product_id`	id	Yes	Parent product
`per_page`	number	No	Rows per page (max 250) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`product_id` default	id	→ products	-
`sku` default	string	—	-
`price` default	number	—	-
`calculated_price` default	number	—	-
`inventory_level` default	number	—	-

Creation

Create Variant

Route: POST /mutation/productVariants

Entrees configurables

Name	Type	Required	Description
`cost_price`	number	No	-
`gtin`	string	No	-
`image_url`	string	No	-
`inventory_level`	number	No	-
`inventory_warning_level`	number	No	-
`map_price`	number	No	-
`mpn`	string	No	-
`option_values`	string	Yes	-
`price`	number	No	-
`product_id`	id	Yes	-
`purchasing_disabled`	boolean	No	-
`retail_price`	number	No	-
`sale_price`	number	No	-
`sku`	string	Yes	-
`upc`	string	No	-
`weight`	number	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Update Variant

Route: PATCH /mutation/productVariants

Entrees configurables

Name	Type	Required	Description
`cost_price`	number	No	-
`gtin`	string	No	-
`image_url`	string	No	-
`inventory_level`	number	No	-
`inventory_warning_level`	number	No	-
`map_price`	number	No	-
`mpn`	string	No	-
`option_values`	string	Yes	-
`price`	number	No	-
`product_id`	id	Yes	-
`purchasing_disabled`	boolean	No	-
`retail_price`	number	No	-
`sale_price`	number	No	-
`sku`	string	Yes	-
`upc`	string	No	-
`weight`	number	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Delete Variant

Route: DELETE /mutation/productVariants

Entrees configurables

Name	Type	Required	Description
`cost_price`	number	No	-
`gtin`	string	No	-
`image_url`	string	No	-
`inventory_level`	number	No	-
`inventory_warning_level`	number	No	-
`map_price`	number	No	-
`mpn`	string	No	-
`option_values`	string	Yes	-
`price`	number	No	-
`product_id`	id	Yes	-
`purchasing_disabled`	boolean	No	-
`retail_price`	number	No	-
`sale_price`	number	No	-
`sku`	string	Yes	-
`upc`	string	No	-
`weight`	number	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Products

Products in your BigCommerce catalogue.

Utilise comme filtre par

Product Custom Fields · product_id

Product Images · product_id

Product Modifiers · product_id

Product Options · product_id

Product Reviews · product_id

Product Variants · product_id

Variants · product_id

Lecture

Products

Products in your BigCommerce catalogue.

Route: GET /products

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

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this record. Answers one row, or none when the id is unknown.
`id_in`	string	No	Only these record IDs, comma-separated.
`name`	string	No	Exactly this name.
`sku`	string	No	Exactly this SKU.
`sku_in`	string	No	Only these SKUs, comma-separated.
`keyword`	string	No	Search the name, the SKU and the description.
`type`	enum	No	Values: physical, digital
`availability`	enum	No	Values: available, disabled, preorder
`is_visible`	boolean	No	Only the products shown, or hidden, on the storefront.
`is_featured`	boolean	No	-
`categories`	id	No	Only the products listed in this category.
`brand_id`	id	No	-
`inventory_level_max`	number	No	Only the products with this much stock or less.
`date_modified_min`	string	No	On or after this date (ISO 8601, 2026-01-31 or a date-time).
`date_modified_max`	string	No	On or before this date (ISO 8601, 2026-01-31 or a date-time).
`sort`	enum	No	Field BigCommerce orders by Values: id, name, sku, price, date_modified
`direction`	enum	No	Values: asc, desc
`per_page`	number	No	Rows per page (max 250) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`name` default	string	—	-
`sku` default	string	—	-
`price` default	number	—	-
`calculated_price` default	number	—	-
`inventory_level` default	number	—	-
`availability` default	enum	—	-
`is_visible` default	boolean	—	-
`date_modified` default	date	—	-

Creation

Create Product

Route: POST /mutation/products

Entrees configurables

Name	Type	Required	Description
`availability`	enum	No	Values: available, disabled, preorder
`brand_id`	id	No	-
`categories`	string[]	No	-
`condition`	enum	No	Values: New, Used, Refurbished
`cost_price`	number	No	-
`depth`	number	No	-
`description`	string	No	-
`gtin`	string	No	-
`height`	number	No	-
`inventory_level`	number	No	-
`inventory_tracking`	enum	No	Values: none, product, variant
`inventory_warning_level`	number	No	-
`is_featured`	boolean	No	-
`is_free_shipping`	boolean	No	-
`is_visible`	boolean	No	-
`map_price`	number	No	-
`mpn`	string	No	-
`name`	string	Yes	-
`page_title`	string	No	-
`price`	number	Yes	-
`retail_price`	number	No	-
`sale_price`	number	No	-
`search_keywords`	string	No	-
`sku`	string	No	-
`type`	enum	Yes	Values: physical, digital
`upc`	string	No	-
`weight`	number	Yes	-
`width`	number	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Update Product

Route: PATCH /mutation/products

Entrees configurables

Name	Type	Required	Description
`availability`	enum	No	Values: available, disabled, preorder
`brand_id`	id	No	-
`categories`	string[]	No	-
`condition`	enum	No	Values: New, Used, Refurbished
`cost_price`	number	No	-
`depth`	number	No	-
`description`	string	No	-
`gtin`	string	No	-
`height`	number	No	-
`inventory_level`	number	No	-
`inventory_tracking`	enum	No	Values: none, product, variant
`inventory_warning_level`	number	No	-
`is_featured`	boolean	No	-
`is_free_shipping`	boolean	No	-
`is_visible`	boolean	No	-
`map_price`	number	No	-
`mpn`	string	No	-
`name`	string	Yes	-
`page_title`	string	No	-
`price`	number	Yes	-
`retail_price`	number	No	-
`sale_price`	number	No	-
`search_keywords`	string	No	-
`sku`	string	No	-
`type`	enum	Yes	Values: physical, digital
`upc`	string	No	-
`weight`	number	Yes	-
`width`	number	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Delete Product

Route: DELETE /mutation/products

Entrees configurables

Name	Type	Required	Description
`availability`	enum	No	Values: available, disabled, preorder
`brand_id`	id	No	-
`categories`	string[]	No	-
`condition`	enum	No	Values: New, Used, Refurbished
`cost_price`	number	No	-
`depth`	number	No	-
`description`	string	No	-
`gtin`	string	No	-
`height`	number	No	-
`inventory_level`	number	No	-
`inventory_tracking`	enum	No	Values: none, product, variant
`inventory_warning_level`	number	No	-
`is_featured`	boolean	No	-
`is_free_shipping`	boolean	No	-
`is_visible`	boolean	No	-
`map_price`	number	No	-
`mpn`	string	No	-
`name`	string	Yes	-
`page_title`	string	No	-
`price`	number	Yes	-
`retail_price`	number	No	-
`sale_price`	number	No	-
`search_keywords`	string	No	-
`sku`	string	No	-
`type`	enum	Yes	Values: physical, digital
`upc`	string	No	-
`weight`	number	Yes	-
`width`	number	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Variants

Every variant of the store — each SKU, its prices and its stock — across all products.

Lecture

Variants

Every variant of the store — each SKU, its prices and its stock — across all products.

Route: GET /variants

Formule Excel: =LF.bigcommerce.variants("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this record. Answers one row, or none when the id is unknown.
`id_in`	string	No	Only these record IDs, comma-separated.
`sku`	string	No	Exactly this SKU.
`sku_in`	string	No	Only these SKUs, comma-separated.
`product_id`	id	No	Only the variants of this product.
`product_id_in`	string	No	Only the variants of these product IDs, comma-separated.
`per_page`	number	No	Rows per page (max 250) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`product_id` default	id	→ products	-
`sku` default	string	—	-
`price` default	number	—	-
`calculated_price` default	number	—	-
`inventory_level` default	number	—	-

Customers

Customer Addresses

The addresses your customers ship and bill to.

Lecture

Customer Addresses

The addresses your customers ship and bill to.

Route: GET /customerAddresses

Formule Excel: =LF.bigcommerce.customerAddresses("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`id_in`	string	No	Only these record IDs, comma-separated.
`customer_id_in`	string	No	Only the addresses of these customer IDs, comma-separated.
`company_in`	string	No	Only these companies, comma-separated.
`per_page`	number	No	Rows per page (max 250) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`customer_id` default	id	→ customers	-
`first_name` default	string	—	-
`last_name` default	string	—	-
`address1` default	string	—	-
`city` default	string	—	-
`postal_code` default	string	—	-
`country_code` default	string	—	-

Creation

Add Customer Address

Route: POST /mutation/customerAddresses

Entrees configurables

Name	Type	Required	Description
`address_type`	enum	No	Values: residential, commercial
`address1`	string	Yes	-
`address2`	string	No	-
`city`	string	Yes	-
`company`	string	No	-
`country_code`	string	Yes	-
`customer_id`	id	Yes	-
`first_name`	string	Yes	-
`last_name`	string	Yes	-
`phone`	string	No	-
`postal_code`	string	Yes	-
`state_or_province`	string	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Update Customer Address

Route: PATCH /mutation/customerAddresses

Entrees configurables

Name	Type	Required	Description
`address_type`	enum	No	Values: residential, commercial
`address1`	string	Yes	-
`address2`	string	No	-
`city`	string	Yes	-
`company`	string	No	-
`country_code`	string	Yes	-
`customer_id`	id	Yes	-
`first_name`	string	Yes	-
`last_name`	string	Yes	-
`phone`	string	No	-
`postal_code`	string	Yes	-
`state_or_province`	string	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Delete Customer Address

Route: DELETE /mutation/customerAddresses

Entrees configurables

Name	Type	Required	Description
`address_type`	enum	No	Values: residential, commercial
`address1`	string	Yes	-
`address2`	string	No	-
`city`	string	Yes	-
`company`	string	No	-
`country_code`	string	Yes	-
`customer_id`	id	Yes	-
`first_name`	string	Yes	-
`last_name`	string	Yes	-
`phone`	string	No	-
`postal_code`	string	Yes	-
`state_or_province`	string	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Customer Groups

The groups customers belong to, with the catalogue each may see and the discounts it gets.

Lecture

Customer Groups

The groups customers belong to, with the catalogue each may see and the discounts it gets.

Route: GET /customerGroups

Formule Excel: =LF.bigcommerce.customerGroups("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`name`	string	No	Exactly this name.
`is_default`	boolean	No	-
`per_page`	number	No	Rows per page (max 250) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`name` default	string	—	-
`is_default` default	boolean	—	-
`is_group_for_guests`	boolean	—	-
`category_access`	string	—	-
`type` default	enum	—	-
`categories`	string[]	—	-
`discount_rules`	string	—	-
`date_created`	string	—	-
`date_modified`	string	—	-

Creation

Create Customer Group

Route: POST /mutation/customerGroups

Entrees configurables

Name	Type	Required	Description
`category_access.categories`	string[]	No	-
`category_access.type`	enum	No	Values: all, specific, none
`discount_rules`	string	No	-
`is_default`	boolean	No	-
`name`	string	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Update Customer Group

Route: PATCH /mutation/customerGroups

Entrees configurables

Name	Type	Required	Description
`category_access.categories`	string[]	No	-
`category_access.type`	enum	No	Values: all, specific, none
`discount_rules`	string	No	-
`is_default`	boolean	No	-
`name`	string	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Delete Customer Group

Route: DELETE /mutation/customerGroups

Entrees configurables

Name	Type	Required	Description
`category_access.categories`	string[]	No	-
`category_access.type`	enum	No	Values: all, specific, none
`discount_rules`	string	No	-
`is_default`	boolean	No	-
`name`	string	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Customers

The customers of your BigCommerce store.

Utilise comme filtre par

Orders · customer_id

Lecture

Customers

The customers of your BigCommerce store.

Route: GET /customers

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

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`id_in`	string	No	Only these record IDs, comma-separated.
`email_in`	string	No	Only these emails, comma-separated.
`name_like`	string	No	Search the first and last names.
`company_in`	string	No	Only these companies, comma-separated.
`customer_group_id_in`	string	No	Only the customers of these group IDs, comma-separated.
`date_created_min`	string	No	An ISO 8601 date or date-time.
`date_created_max`	string	No	An ISO 8601 date or date-time.
`date_modified_min`	string	No	An ISO 8601 date or date-time.
`date_modified_max`	string	No	An ISO 8601 date or date-time.
`sort`	enum	No	Field and direction BigCommerce orders by Values: date_created:asc, date_created:desc, last_name:asc, last_name:desc, date_modified:asc
`per_page`	number	No	Rows per page (max 250) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`email` default	string	—	-
`first_name` default	string	—	-
`last_name` default	string	—	-
`company` default	string	—	-
`customer_group_id` default	id	→ customerGroups	-
`date_modified` default	date	—	-

Creation

Create Customer

Route: POST /mutation/customers

Entrees configurables

Name	Type	Required	Description
`accepts_product_review_abandoned_cart_emails`	boolean	No	-
`company`	string	No	-
`customer_group_id`	id	No	-
`email`	string	Yes	-
`first_name`	string	Yes	-
`last_name`	string	Yes	-
`notes`	string	No	-
`phone`	string	No	-
`tax_exempt_category`	string	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Update Customer

Route: PATCH /mutation/customers

Entrees configurables

Name	Type	Required	Description
`accepts_product_review_abandoned_cart_emails`	boolean	No	-
`company`	string	No	-
`customer_group_id`	id	No	-
`email`	string	Yes	-
`first_name`	string	Yes	-
`last_name`	string	Yes	-
`notes`	string	No	-
`phone`	string	No	-
`tax_exempt_category`	string	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Delete Customer

Route: DELETE /mutation/customers

Entrees configurables

Name	Type	Required	Description
`accepts_product_review_abandoned_cart_emails`	boolean	No	-
`company`	string	No	-
`customer_group_id`	id	No	-
`email`	string	Yes	-
`first_name`	string	Yes	-
`last_name`	string	Yes	-
`notes`	string	No	-
`phone`	string	No	-
`tax_exempt_category`	string	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Inventory

Inventory Levels

The stock of every SKU at a location: on hand, available to sell, and its safety stock.

Lecture

Inventory Levels

The stock of every SKU at a location: on hand, available to sell, and its safety stock.

Route: GET /inventoryItems

Formule Excel: =LF.bigcommerce.inventoryItems("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`location_id`	id	Yes	The location the levels are read at
`sku_in`	string	No	Only these SKUs, comma-separated.
`product_id_in`	string	No	Only the SKUs of these product IDs, comma-separated.
`variant_id_in`	string	No	Only these variant IDs, comma-separated.
`per_page`	number	No	Rows per page (max 250) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans Excel

Field	Type	Relations	Description
`location_id` default	id	→ inventoryLocations	-
`identity`	string	—	-
`sku` default	string	—	-
`product_id`	id	→ products	-
`variant_id` default	id	—	-
`total_inventory_onhand` default	number	—	-
`available_to_sell` default	number	—	-
`qty_backordered`	number	—	-
`settings`	string	—	-
`safety_stock`	number	—	-
`warning_level`	number	—	-
`is_in_stock`	boolean	—	-
`bin_picking_number`	string	—	-
`backorder_limit`	number	—	-

Inventory Locations

The places your store keeps stock: warehouses, shops, pickup points.

Utilise comme filtre par

Inventory Levels · location_id

Lecture

Inventory Locations

The places your store keeps stock: warehouses, shops, pickup points.

Route: GET /inventoryLocations

Formule Excel: =LF.bigcommerce.inventoryLocations("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`location_id_in`	string	No	Only these location IDs, comma-separated.
`location_code_in`	string	No	Only these codes, comma-separated.
`is_active`	boolean	No	-
`per_page`	number	No	Rows per page (max 250) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`code` default	string	—	-
`label` default	string	—	-
`type_id` default	string	—	-
`enabled` default	boolean	—	-
`storefront_visibility`	boolean	—	-
`managed_by_external_source`	boolean	—	-
`description`	string	—	-
`address`	string	—	-
`city`	string	—	-
`country_code`	string	—	-
`created_at`	date	—	-
`updated_at`	date	—	-

Stock Level

Set the stock a location holds of one SKU, variant or product, to an absolute quantity.

Creation

Set Stock Level

Route: POST /mutation/inventoryAdjustments

Entrees configurables

Name	Type	Required	Description
`location_id`	id	Yes	-
`product_id`	id	No	-
`quantity`	number	Yes	-
`reason`	string	No	-
`sku`	string	No	-
`variant_id`	id	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Marketing

Coupons

The coupon codes your customers enter at checkout.

Lecture

Coupons

The coupon codes your customers enter at checkout.

Route: GET /coupons

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

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this coupon. Answers one row, or none when the id is unknown.
`code`	string	No	Exactly this code.
`name`	string	No	Exactly this name.
`type`	enum	No	Values: per_item_discount, per_total_discount, shipping_discount, free_shipping, percentage_discount
`min_id`	number	No	-
`max_id`	number	No	-
`per_page`	number	No	Rows per page (max 250) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`name` default	string	—	-
`code` default	string	—	-
`type` default	enum	—	-
`amount` default	number	—	-
`enabled` default	boolean	—	-
`expires` default	string	—	-
`num_uses` default	number	—	-

Creation

Create Coupon

Route: POST /mutation/coupons

Entrees configurables

Name	Type	Required	Description
`amount`	number	Yes	-
`applies_to.entity`	enum	No	Values: products, categories
`applies_to.ids`	string[]	No	-
`code`	string	Yes	-
`enabled`	boolean	No	-
`expires`	string	No	-
`max_uses`	number	No	-
`max_uses_per_customer`	number	No	-
`min_purchase`	number	No	-
`name`	string	Yes	-
`type`	enum	Yes	Values: per_item_discount, per_total_discount, shipping_discount, free_shipping, percentage_discount

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Update Coupon

Route: PATCH /mutation/coupons

Entrees configurables

Name	Type	Required	Description
`amount`	number	Yes	-
`applies_to.entity`	enum	No	Values: products, categories
`applies_to.ids`	string[]	No	-
`code`	string	Yes	-
`enabled`	boolean	No	-
`expires`	string	No	-
`max_uses`	number	No	-
`max_uses_per_customer`	number	No	-
`min_purchase`	number	No	-
`name`	string	Yes	-
`type`	enum	Yes	Values: per_item_discount, per_total_discount, shipping_discount, free_shipping, percentage_discount

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Delete Coupon

Route: DELETE /mutation/coupons

Entrees configurables

Name	Type	Required	Description
`amount`	number	Yes	-
`applies_to.entity`	enum	No	Values: products, categories
`applies_to.ids`	string[]	No	-
`code`	string	Yes	-
`enabled`	boolean	No	-
`expires`	string	No	-
`max_uses`	number	No	-
`max_uses_per_customer`	number	No	-
`min_purchase`	number	No	-
`name`	string	Yes	-
`type`	enum	Yes	Values: per_item_discount, per_total_discount, shipping_discount, free_shipping, percentage_discount

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Promotions

The store’s promotions: automatic discounts and those its coupon codes unlock.

Lecture

Promotions

The store’s promotions: automatic discounts and those its coupon codes unlock.

Route: GET /promotions

Formule Excel: =LF.bigcommerce.promotions("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`id`	id	No	Read exactly this promotion. Answers one row, or none when the id is unknown.
`name`	string	No	-
`code`	string	No	Only the promotion this code unlocks.
`status`	enum	No	Values: ENABLED, DISABLED, INVALID
`redemption_type`	enum	No	Values: AUTOMATIC, COUPON
`per_page`	number	No	Rows per page (max 250) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`name` default	string	—	-
`redemption_type` default	string	—	-
`status` default	string	—	-
`current_uses` default	number	—	-
`max_uses`	number	—	-
`start_date`	date	—	-
`end_date`	date	—	-
`stop`	boolean	—	-
`can_be_used_with_other_promotions`	boolean	—	-
`currency_code`	string	—	-
`rules`	string	—	-

Sales

Order Coupons

The coupons applied to an order, and what each took off.

Lecture

Order Coupons

The coupons applied to an order, and what each took off.

Route: GET /orderCoupons

Formule Excel: =LF.bigcommerce.orderCoupons("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`order_id`	id	Yes	Parent order
`per_page`	number	No	Rows per page (max 250) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`order_id` default	id	→ orders	-
`coupon_id`	id	→ coupons	-
`code` default	string	—	-
`amount`	number	—	-
`type`	number	—	-
`discount` default	number	—	-

Order Products

The line items of an order: each product sold, its quantity and its price.

Lecture

Order Products

The line items of an order: each product sold, its quantity and its price.

Route: GET /orderProducts

Formule Excel: =LF.bigcommerce.orderProducts("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`order_id`	id	Yes	Parent order
`per_page`	number	No	Rows per page (max 250) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`order_id` default	id	→ orders	-
`name` default	string	—	-
`sku` default	string	—	-
`quantity` default	number	—	-
`price_inc_tax` default	number	—	-
`total_inc_tax` default	number	—	-

Order Shipments

The shipments of an order: what left, to which address, with which tracking number.

Lecture

Order Shipments

The shipments of an order: what left, to which address, with which tracking number.

Route: GET /orderShipments

Formule Excel: =LF.bigcommerce.orderShipments("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`order_id`	id	Yes	Parent order
`per_page`	number	No	Rows per page (max 250) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`order_id` default	id	→ orders	-
`date_created` default	string	—	-
`tracking_number` default	string	—	-
`shipping_provider` default	string	—	-
`tracking_carrier`	string	—	-
`tracking_link`	string	—	-
`shipping_method`	string	—	-
`order_address_id`	id	—	-
`comments`	string	—	-
`items`	string	—	-

Creation

Create Shipment

Route: POST /mutation/orderShipments

Entrees configurables

Name	Type	Required	Description
`comments`	string	No	-
`items`	string	Yes	-
`order_address_id`	id	Yes	-
`order_id`	id	Yes	-
`shipping_provider`	string	No	-
`tracking_carrier`	string	No	-
`tracking_number`	string	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Order Shipping Addresses

Where each part of an order ships, and how.

Lecture

Order Shipping Addresses

Where each part of an order ships, and how.

Route: GET /orderShippingAddresses

Formule Excel: =LF.bigcommerce.orderShippingAddresses("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`order_id`	id	Yes	Parent order
`per_page`	number	No	Rows per page (max 250) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`order_id` default	id	→ orders	-
`first_name` default	string	—	-
`last_name` default	string	—	-
`street_1` default	string	—	-
`city` default	string	—	-
`country` default	string	—	-
`shipping_method` default	string	—	-

Order Statuses

The statuses an order can be in, with the labels the store gives them.

Utilise comme filtre par

Orders · status_id

Lecture

Order Statuses

The statuses an order can be in, with the labels the store gives them.

Route: GET /orderStatuses

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

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`name` default	string	—	-
`custom_label` default	string	—	-
`system_label`	string	—	-
`system_description`	string	—	-
`order`	number	—	-

Order Transactions

The payment transactions recorded on an order: each charge, capture, refund or void, with its gateway.

Lecture

Order Transactions

The payment transactions recorded on an order: each charge, capture, refund or void, with its gateway.

Route: GET /orderTransactions

Formule Excel: =LF.bigcommerce.orderTransactions("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`order_id`	id	Yes	Parent order
`per_page`	number	No	Rows per page (max 250) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`order_id` default	id	→ orders	-
`event` default	string	—	-
`method` default	string	—	-
`amount` default	number	—	-
`currency` default	string	—	-
`gateway` default	string	—	-
`status` default	string	—	-

Orders

Customer orders in your BigCommerce store.

Utilise comme filtre par

Order Coupons · order_id

Order Products · order_id

Order Shipments · order_id

Order Shipping Addresses · order_id

Order Transactions · order_id

Lecture

Orders

Customer orders in your BigCommerce store.

Route: GET /orders

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

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`min_id`	number	No	Only orders with this ID or a higher one; equal to To ID for exactly one order.
`max_id`	number	No	-
`status_id`	id	No	Only the orders in this status.
`customer_id`	id	No	-
`email`	string	No	Only the orders billed to this email.
`min_date_created`	string	No	A date, ISO 8601 (2026-01-31) or RFC 2822.
`max_date_created`	string	No	A date, ISO 8601 (2026-01-31) or RFC 2822.
`min_date_modified`	string	No	A date, ISO 8601 (2026-01-31) or RFC 2822.
`max_date_modified`	string	No	A date, ISO 8601 (2026-01-31) or RFC 2822.
`min_total`	number	No	-
`max_total`	number	No	-
`payment_method`	string	No	-
`channel_id`	id	No	-
`is_deleted`	boolean	No	The archived orders instead of the others.
`sort`	enum	No	Field and direction BigCommerce orders by Values: id:asc, id:desc, date_created:asc, date_created:desc, date_modified:asc
`per_page`	number	No	Rows per page (max 250) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`status` default	string	—	-
`date_created` default	string	—	-
`last_name` default	string	—	-
`email` default	string	—	-
`total_inc_tax` default	number	—	-
`currency_code` default	string	—	-
`payment_status` default	string	—	-

Creation

Create Order

Route: POST /mutation/orders

Entrees configurables

Name	Type	Required	Description
`billing_address.city`	string	Yes	-
`billing_address.company`	string	No	-
`billing_address.country`	string	Yes	-
`billing_address.country_iso2`	string	Yes	-
`billing_address.email`	string	Yes	-
`billing_address.first_name`	string	Yes	-
`billing_address.last_name`	string	Yes	-
`billing_address.phone`	string	No	-
`billing_address.state`	string	No	-
`billing_address.street_1`	string	Yes	-
`billing_address.street_2`	string	No	-
`billing_address.zip`	string	Yes	-
`customer_id`	id	No	-
`customer_message`	string	No	-
`external_id`	string	No	-
`payment_method`	string	No	-
`products`	string	Yes	-
`staff_notes`	string	No	-
`status_id`	id	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Update Order

Route: PATCH /mutation/orders

Entrees configurables

Name	Type	Required	Description
`billing_address.city`	string	Yes	-
`billing_address.company`	string	No	-
`billing_address.country`	string	Yes	-
`billing_address.country_iso2`	string	Yes	-
`billing_address.email`	string	Yes	-
`billing_address.first_name`	string	Yes	-
`billing_address.last_name`	string	Yes	-
`billing_address.phone`	string	No	-
`billing_address.state`	string	No	-
`billing_address.street_1`	string	Yes	-
`billing_address.street_2`	string	No	-
`billing_address.zip`	string	Yes	-
`customer_id`	id	No	-
`customer_message`	string	No	-
`external_id`	string	No	-
`payment_method`	string	No	-
`products`	string	Yes	-
`staff_notes`	string	No	-
`status_id`	id	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Archive Order

Route: DELETE /mutation/orders

Entrees configurables

Name	Type	Required	Description
`billing_address.city`	string	Yes	-
`billing_address.company`	string	No	-
`billing_address.country`	string	Yes	-
`billing_address.country_iso2`	string	Yes	-
`billing_address.email`	string	Yes	-
`billing_address.first_name`	string	Yes	-
`billing_address.last_name`	string	Yes	-
`billing_address.phone`	string	No	-
`billing_address.state`	string	No	-
`billing_address.street_1`	string	Yes	-
`billing_address.street_2`	string	No	-
`billing_address.zip`	string	Yes	-
`customer_id`	id	No	-
`customer_message`	string	No	-
`external_id`	string	No	-
`payment_method`	string	No	-
`products`	string	Yes	-
`staff_notes`	string	No	-
`status_id`	id	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Refunds

The refunds of the store’s orders: what was refunded, when, and why.

Lecture

Refunds

The refunds of the store’s orders: what was refunded, when, and why.

Route: GET /orderRefunds

Formule Excel: =LF.bigcommerce.orderRefunds("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`order_id_in`	string	No	Only the refunds of these order IDs, comma-separated.
`created_min`	string	No	An ISO 8601 date or date-time.
`created_max`	string	No	An ISO 8601 date or date-time.
`per_page`	number	No	Rows per page (max 250) Default: 100
`page`	number	No	Page number, starting at 1

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`order_id` default	id	→ orders	-
`user_id`	id	—	-
`created` default	date	—	-
`reason` default	string	—	-
`total_amount` default	number	—	-
`total_tax`	number	—	-
`uses_merchant_override_values`	boolean	—	-
`items`	string	—	-
`payments`	string	—	-

Store

Your BigCommerce store: its name, its domain, its currency, its units and its plan.

Lecture

Store

Your BigCommerce store: its name, its domain, its currency, its units and its plan.

Route: GET /store

Formule Excel: =LF.bigcommerce.store("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-

Donnees retournees dans Excel

Field	Type	Relations	Description
`id` default	id	—	-
`name` default	string	—	-
`domain` default	string	—	-
`status` default	string	—	-
`currency` default	string	—	-
`is_price_entered_with_tax` default	boolean	—	-
`plan_name` default	string	—	-

Name	Type	Required	Description
`link`	string	Yes	-
`category_id_in`	string	No	Only these category IDs, comma-separated.
`parent_id_in`	string	No	Only the children of these categories, comma-separated; 0 for the top level.
`tree_id_in`	string	No	Only the categories of these trees, comma-separated.
`name`	string	No	Exactly this name.
`name_like`	string	No	-
`keyword`	string	No	Search the name and the description.
`is_visible`	boolean	No	-
`per_page`	number	No	Rows per page (max 250) Default: 100
`page`	number	No	Page number, starting at 1

Connexion BigCommerce pour LinkyFlow

Workflows a ramener dans Excel

Catalog

Brands

Brands

Entrees configurables

Donnees retournees dans Excel

Create Brand

Entrees configurables

Donnees retournees dans Excel

Update Brand

Entrees configurables

Donnees retournees dans Excel

Delete Brand

Entrees configurables

Donnees retournees dans Excel

Categories

Categories

Entrees configurables

Donnees retournees dans Excel

Product Custom Fields

Product Custom Fields

Entrees configurables

Donnees retournees dans Excel

Add Custom Field

Entrees configurables

Donnees retournees dans Excel

Update Custom Field

Entrees configurables

Donnees retournees dans Excel

Delete Custom Field

Entrees configurables

Donnees retournees dans Excel

Product Images

Product Images

Entrees configurables

Donnees retournees dans Excel

Add Product Image

Entrees configurables

Donnees retournees dans Excel

Update Product Image

Entrees configurables

Donnees retournees dans Excel

Delete Product Image

Entrees configurables

Donnees retournees dans Excel

Product Modifiers

Product Modifiers

Entrees configurables

Donnees retournees dans Excel

Product Options

Product Options

Entrees configurables

Donnees retournees dans Excel

Product Reviews

Product Reviews

Entrees configurables

Donnees retournees dans Excel

Product Variants

Product Variants

Entrees configurables

Donnees retournees dans Excel

Create Variant

Entrees configurables

Donnees retournees dans Excel

Update Variant

Entrees configurables

Donnees retournees dans Excel

Delete Variant

Entrees configurables

Donnees retournees dans Excel

Products

Products

Entrees configurables

Donnees retournees dans Excel

Create Product

Entrees configurables

Donnees retournees dans Excel

Update Product

Entrees configurables