Create Customer Group Discounted Prices

Create Customer Group Discounted Prices β€” Functional Description

Standalone FS Admin screen that maintains per–customer-group profit-share percentages in pd_dealer_discounts and, on Update Prices, rebuilds OpenCart oc_product_discount rows for every active product. Quantity-1 rows are created for each configured customer group; case and half-case quantity tiers apply to customer group 3 (Dealer). This script is a prerequisite for inventory/setProductRewardPoints.php, which reads quantity-1 discounts to calculate reward points.

Application rule

  • The price will be applied to the product if the product has a cost >0 and a price >0 and the product is enabled.
Discounta for purchase of a single quantity
% of retail profit
% of retail profit
% of retail profit
% of retail profit
% of retail profit
% of retail profit
% of retail profit
% of retail profit
% of retail profit
% of retail profit
Discounta for purchase of case quantities
% of retail profit
% of retail profit