JDBC Driver for BigCommerce

Build 22.0.8462

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

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462