Power BI Connector for BigCommerce

Build 21.0.7930


Returns bulk pricing rules applied to a product.

Table Specific Information


The {i 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 {i.

  • 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 


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) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930