ProductBulkPricingRules

Returns bulk pricing rules applied to a product, including quantity thresholds and discount details.

Table-Specific Information

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

Id supports the = operator.
ProductId supports the =, IN, NOT IN, >, <, >=, and <= operators.

The rest of the filter is executed client-side within the connector.

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

SELECT * FROM ProductBulkPricingRules WHERE ProductId = 77

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

To insert a bulk pricing rule, specify at least the following columns: ProductId, Min, Max, Type, and TypeValue.

INSERT INTO ProductBulkPricingRules (ProductId, TypeValue, Type, Max, Min) VALUES (111, 50.02000, 'fixed', 4, 1)

The following is an example of how to update the ProductBulkPricingRules table:

UPDATE ProductBulkPricingRules SET TypeValue = 62.56, Type = 'price' WHERE ProductId = 111 AND Id = 222

The following is an example of how to delete from the ProductBulkPricingRules table:

DELETE FROM ProductBulkPricingRules WHERE ProductId = 81 AND Id = 71


Name	Type	ReadOnly	Description
Id [KEY]	Integer	True	The Id of the bulk discount rule.
ProductId [KEY]	Integer	False	The Id of the product associated with this bulk discount rule.
Min	Integer	False	The minimum inclusive quantity of a product to satisfy this rule. Must be greater than or equal to zero.
Max	Integer	False	The maximum inclusive quantity of a product to satisfy this rule.
Type	String	False	The type of the discount.
TypeValue	Decimal	False	The value of the discount.