ADO.NET Provider for BigCommerce

Build 23.0.8770

ProductBulkPricingRules

Returns bulk pricing rules applied to a product.

Table Specific Information

Select

The 本製品 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 本製品.

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

SELECT * FROM ProductBulkPricingRules WHERE Id = 1 

SELECT * FROM ProductBulkPricingRules WHERE ProductId = 2 

Columns

Name Type References 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) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8770