ProductBulkPricingRules

Returns bulk pricing rules applied to a product.

Table Specific Information

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

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

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

SELECT * FROM ProductBulkPricingRules WHERE ProductId = 77

SELECT * FROM ProductBulkPricingRules WHERE ProductId = 77 AND Id = 1


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