Cmdlets for BigCommerce

Build 20.0.7654

ProductSkus

Returns Stock Keeping Unit identifiers associated with products or product options.

Table Specific Information

Select

The {i will use the BigCommerce API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the {i.

  • Id supports the '=, >=, >, <=, <' comparison.
  • ProductId supports the '=' comparison.
  • Sku supports the '=' comparison.
  • Upc supports the '=' comparison.
  • InventoryLevel supports the '=' comparison.
  • InventoryWarningLevel supports the '=' comparison.
  • BinPickingNumber supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM ProductSkus

SELECT * FROM ProductSkus WHERE Id = 1 

SELECT * FROM ProductSkus WHERE Id >= 1 AND Id <= 4

SELECT * FROM ProductSkus WHERE ProductId = 2

SELECT * FROM ProductSkus WHERE InventoryLevel = "test"

Columns

Name Type Description
Id [KEY] Integer ID of this sku.
ProductId [KEY] Integer ID of the associated product.
Sku String The unique SKU (stock keeping unit).
Price Decimal This SKUs base price on the storefront.
AdjustedPrice Decimal The SKUs price on the storefront, after the products base price is inherited, or any option set or any product rules are applied.
CostPrice Decimal The products cost price.
UPC String
InventoryLevel Integer The inventory level for the product.
InventoryWarningLevel Integer The inventory warning level for the product .
BinPickingNumber String The BIN picking number.
Weight Decimal This SKUs base weight on the storefront.
AdjustedWeight Decimal This SKUs weight on the storefront, after the products base weight is inherited, or any option set or any product rules are applied.
IsPurchasingDisabled Boolean If true, this prohibits purchasing of the SKU.
PurchasingDisabledMessage String The message to display if purchasing is disabled on this SKU.
ImageFile String The image that will be displayed when this SKU is selected on the storefront. When updating a SKU image, send the publicly accessible URL. Supported image formats are JPEG, PNG, and GIF.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654