ProductBulkPricingRules
Returns bulk pricing rules applied to a product.
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.
The rest of the filter is executed client-side within the add-in.
For example, the following queries are processed server-side:
SELECT * FROM ProductBulkPricingRules WHERE ProductId = 77 SELECT * FROM ProductBulkPricingRules WHERE ProductId = 77 AND Id = 1
Columns
| Name | Type | References | Description |
| Id [KEY] | Integer | 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 |