Broadleaf Commerce Discussion Forums

Hi guys,

I am wondering in the shipping options, how to set the logic like weight $10 per 10kg?

My answer is
INSERT INTO BLC_FULFILLMENT_WEIGHT_BAND (FULFILLMENT_WEIGHT_BAND_ID, MINIMUM_WEIGHT, WEIGHT_UNIT_OF_MEASURE, FULFILLMENT_OPTION_ID, RESULT_AMOUNT, RESULT_AMOUNT_TYPE) VALUES (1, 0.0, 'KILOGRAMS', 4, 10.00, 'RATE');
INSERT INTO BLC_FULFILLMENT_WEIGHT_BAND (FULFILLMENT_WEIGHT_BAND_ID, MINIMUM_WEIGHT, WEIGHT_UNIT_OF_MEASURE, FULFILLMENT_OPTION_ID, RESULT_AMOUNT, RESULT_AMOUNT_TYPE) VALUES (2, 10.0, 'KILOGRAMS', 4, 20.00, 'RATE');
INSERT INTO BLC_FULFILLMENT_WEIGHT_BAND (FULFILLMENT_WEIGHT_BAND_ID, MINIMUM_WEIGHT, WEIGHT_UNIT_OF_MEASURE, FULFILLMENT_OPTION_ID, RESULT_AMOUNT, RESULT_AMOUNT_TYPE) VALUES (3, 20.0, 'KILOGRAMS', 4, 30.00, 'RATE');
.....

Then what's the maxmum? Is it endless?

Regards,

Dan

The easiest is to implement your own FulfillmentPricingProvider

The bands are designed to be just that, a band. From what you've set up, you have these weight bands:

0->10
10->20
20->infinity

So yes, anything above 20kg will cost $30. This is why the property is a minimum weight.

The bands were not designed to operate in the way that you want. What you want is more dynamic. The bands are designed to be static and stop at a particular interval.

@RapidTransit has it right, you will need an implementation of a FulfillmentPricingProvider.

Cool, thanks, guys!