ProductSkus
Returns Stock Keeping Unit identifiers associated with products or product options.
Table Specific Information
Select
The add-in 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 add-in.
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. |