ADO.NET Provider for BigCommerce

Build 23.0.8770

ProductSkus

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

Table Specific Information

Select

The 本製品 uses the BigCommerce API to process WHERE clause conditions built with the following columns and operators:

  • 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.

The rest of the filter is executed client-side within the 本製品.

For example, the following queries are processed server-side:

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 References 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) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8770