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