Example: Configuring fixed amount shipping charges
When configuring shipping charges based on weight ranges in WebSphere Commerce, the weight for that item will be multiplied by the shipping charge for the range that the weight falls under. This is because the default setup in WebSphere Commerce Accelerator is to use a per unit amount calculation range as opposed to a fixed amount calculation range.
For example:
For 0-9 kg, the shipping charge is $10. For 10-19 kg, the shipping charge is $20. For an item that weighs 5 kg, the shipping charge will be calculated as $50 (5 kg * $10/kg).
However, you prefer to have a fixed amount of $10 as the shipping charge.
To incorporate this, do the following:
Update the CALRANGE.CALMETHOD_ID from -34, which is the PerUnitAmountCalculationRangeCmdImpl, to -33, which is the FixedAmountCalculationRangeCmdImpl. This change allows you to charge a fixed amount for a specific range of weights.
For example:
- Determine the CALSCALE_ID that needs to be updated based on the CALSCALE.CODE. The name of the shipping charge you defined must match the CALSCALE.CODE in the database:
db2 select CALSCALE_ID,CODE from CALSCALE
- Update the CALRANGE.CALMETHOD_ID for the CALSCALE_ID from the preceding step:
db2 update CALRANGE set CALMETHOD_ID=-33 where CALSCALE_ID= CALSCALE_ID
- Refresh the registry in the Administration Console for the changes to take effect.