BigCommerce connection for LinkyFlow

LinkyFlow brings BigCommerce ecommerce data into Excel so teams can browse, edit, validate, and publish from the spreadsheet.

Resources

Read requests

Write actions

Documented fields

372

Workflows you can move into Excel

Each resource below maps to a practical spreadsheet workflow. Read actions bring useful columns into Excel; create and edit actions show what can be reviewed in rows before sending changes.

Catalog

Brands

The brands of your catalogue.

Used as filter by

Products · brand_id

Read

Brands

The brands of your catalogue.

Route: GET /brands

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

Inputs you can set

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

Data returned in 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	—	-

Create

Create Brand

Route: POST /mutation/brands

Inputs you can set

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

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Brand

Route: PATCH /mutation/brands

Inputs you can set

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

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Delete Brand

Route: DELETE /mutation/brands

Inputs you can set

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

Data returned in Excel

This action returns a confirmation rather than a selectable table.

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

Data returned in Excel

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

Create

Add Custom Field

Route: POST /mutation/productCustomFields

Inputs you can set

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

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Custom Field

Route: PATCH /mutation/productCustomFields

Inputs you can set

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

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Delete Custom Field

Route: DELETE /mutation/productCustomFields

Inputs you can set

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

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Product Images

The images of a product, its thumbnail among them.

Read

Product Images

The images of a product, its thumbnail among them.

Route: GET /productImages

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

Inputs you can set

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

Data returned in 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	—	-

Create

Add Product Image

Route: POST /mutation/productImages

Inputs you can set

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

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Product Image

Route: PATCH /mutation/productImages

Inputs you can set

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

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Delete Product Image

Route: DELETE /mutation/productImages

Inputs you can set

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

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Product Modifiers

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

Read

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

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

Inputs you can set

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

Data returned in 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.

Read

Product Options

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

Route: GET /productOptions

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

Inputs you can set

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

Data returned in 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.

Read

Product Reviews

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

Route: GET /productReviews

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

Inputs you can set

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

Data returned in 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.

Read

Product Variants

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

Route: GET /productVariants

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

Inputs you can set

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

Data returned in 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	—	-

Create

Create Variant

Route: POST /mutation/productVariants

Inputs you can set

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	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Variant

Route: PATCH /mutation/productVariants

Inputs you can set

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	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Delete Variant

Route: DELETE /mutation/productVariants

Inputs you can set

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	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Products

Products in your BigCommerce catalogue.

Used as filter by

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

Read

Products

Products in your BigCommerce catalogue.

Route: GET /products

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

Inputs you can set

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

Data returned in 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	—	-

Create

Create Product

Route: POST /mutation/products

Inputs you can set

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	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Product

Route: PATCH /mutation/products

Inputs you can set

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	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Delete Product

Route: DELETE /mutation/products

Inputs you can set

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	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Variants

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

Read

Variants

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

Route: GET /variants

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

Inputs you can set

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

Data returned in 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.

Read

Customer Addresses

The addresses your customers ship and bill to.

Route: GET /customerAddresses

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

Inputs you can set

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

Data returned in 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	—	-

Create

Add Customer Address

Route: POST /mutation/customerAddresses

Inputs you can set

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	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Customer Address

Route: PATCH /mutation/customerAddresses

Inputs you can set

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	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Delete Customer Address

Route: DELETE /mutation/customerAddresses

Inputs you can set

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	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Customer Groups

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

Read

Customer Groups

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

Route: GET /customerGroups

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

Inputs you can set

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

Data returned in 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	—	-

Create

Create Customer Group

Route: POST /mutation/customerGroups

Inputs you can set

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	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Customer Group

Route: PATCH /mutation/customerGroups

Inputs you can set

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	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Delete Customer Group

Route: DELETE /mutation/customerGroups

Inputs you can set

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	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Customers

The customers of your BigCommerce store.

Used as filter by

Orders · customer_id

Read

Customers

The customers of your BigCommerce store.

Route: GET /customers

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

Inputs you can set

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

Data returned in 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	—	-

Create

Create Customer

Route: POST /mutation/customers

Inputs you can set

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	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Customer

Route: PATCH /mutation/customers

Inputs you can set

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	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Delete Customer

Route: DELETE /mutation/customers

Inputs you can set

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	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Inventory

Inventory Levels

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

Read

Inventory Levels

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

Route: GET /inventoryItems

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

Inputs you can set

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

Data returned in 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.

Used as filter by

Inventory Levels · location_id

Read

Inventory Locations

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

Route: GET /inventoryLocations

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

Inputs you can set

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

Data returned in 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.

Create

Set Stock Level

Route: POST /mutation/inventoryAdjustments

Inputs you can set

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	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Marketing

Coupons

The coupon codes your customers enter at checkout.

Read

Coupons

The coupon codes your customers enter at checkout.

Route: GET /coupons

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

Inputs you can set

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

Data returned in 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	—	-

Create

Create Coupon

Route: POST /mutation/coupons

Inputs you can set

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

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Coupon

Route: PATCH /mutation/coupons

Inputs you can set

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

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Delete Coupon

Route: DELETE /mutation/coupons

Inputs you can set

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

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Promotions

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

Read

Promotions

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

Route: GET /promotions

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

Inputs you can set

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

Data returned in 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.

Read

Order Coupons

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

Route: GET /orderCoupons

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

Inputs you can set

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

Data returned in 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.

Read

Order Products

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

Route: GET /orderProducts

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

Inputs you can set

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

Data returned in 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.

Read

Order Shipments

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

Route: GET /orderShipments

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

Inputs you can set

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

Data returned in 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	—	-

Create

Create Shipment

Route: POST /mutation/orderShipments

Inputs you can set

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	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Order Shipping Addresses

Where each part of an order ships, and how.

Read

Order Shipping Addresses

Where each part of an order ships, and how.

Route: GET /orderShippingAddresses

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

Inputs you can set

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

Data returned in 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.

Used as filter by

Orders · status_id

Read

Order Statuses

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

Route: GET /orderStatuses

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

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-

Data returned in 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.

Read

Order Transactions

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

Route: GET /orderTransactions

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

Inputs you can set

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

Data returned in 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.

Used as filter by

Order Coupons · order_id

Order Products · order_id

Order Shipments · order_id

Order Shipping Addresses · order_id

Order Transactions · order_id

Read

Orders

Customer orders in your BigCommerce store.

Route: GET /orders

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

Inputs you can set

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

Data returned in 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	—	-

Create

Create Order

Route: POST /mutation/orders

Inputs you can set

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	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Order

Route: PATCH /mutation/orders

Inputs you can set

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	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Archive Order

Route: DELETE /mutation/orders

Inputs you can set

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	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Refunds

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

Read

Refunds

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

Route: GET /orderRefunds

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

Inputs you can set

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

Data returned in 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.

Read

Store

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

Route: GET /store

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

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-

Data returned in 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

BigCommerce connection for LinkyFlow

Workflows you can move into Excel

Catalog

Brands

Brands

Inputs you can set

Data returned in Excel

Create Brand

Inputs you can set

Data returned in Excel

Update Brand

Inputs you can set

Data returned in Excel

Delete Brand

Inputs you can set

Data returned in Excel

Categories

Categories

Inputs you can set

Data returned in Excel

Product Custom Fields

Product Custom Fields

Inputs you can set

Data returned in Excel

Add Custom Field

Inputs you can set

Data returned in Excel

Update Custom Field

Inputs you can set

Data returned in Excel

Delete Custom Field

Inputs you can set

Data returned in Excel

Product Images

Product Images

Inputs you can set

Data returned in Excel

Add Product Image

Inputs you can set

Data returned in Excel

Update Product Image

Inputs you can set

Data returned in Excel

Delete Product Image

Inputs you can set

Data returned in Excel

Product Modifiers

Product Modifiers

Inputs you can set

Data returned in Excel

Product Options

Product Options

Inputs you can set

Data returned in Excel

Product Reviews

Product Reviews

Inputs you can set

Data returned in Excel

Product Variants

Product Variants

Inputs you can set

Data returned in Excel

Create Variant

Inputs you can set

Data returned in Excel

Update Variant

Inputs you can set

Data returned in Excel

Delete Variant

Inputs you can set

Data returned in Excel

Products

Products

Inputs you can set

Data returned in Excel

Create Product

Inputs you can set

Data returned in Excel

Update Product

Inputs you can set