ProductBulkPricingRules
Returns bulk pricing rules applied to a product.
Table Specific Information
Select
The driver 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 driver.
- Id supports the '=' comparison.
- ProductId supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM ProductBulkPricingRules SELECT * FROM ProductBulkPricingRules WHERE Id = 1 SELECT * FROM ProductBulkPricingRules WHERE ProductId = 2
Columns
| Name | Type | Description |
| Id [KEY] | String | The ID of the bulk discount rule. |
| ProductId [KEY] | Integer | The ID of the product associated with this bulk discount rule. |
| Min | Integer | The minimum inclusive quantity of a product to satisfy this rule. Must be greater than or equal to zero. |
| Max | Integer | The maximum inclusive quantity of a product to satisfy this rule. |
| Type | String | Type of the discount. |
| TypeValue | Decimal | The value of the discount |