WebSphere Commerce - Shipping Modes and Calculations

Troubleshooting Shipping Modes and charges:

It happens that sometimes we set up Shipping modes and charges properly for a Store but we are not able see those values on our shipping billing page or where ever we display Shipping mode types or shipping charges does not get reflected whenever you change the shipping modes.

If you are sure that your set up is correct and still you are not able to see charges, please validate your data in tables with below queries:

SELECT * FROM CALCODE WHERE CODE = 'ShippingCODE';

SELECT * FROM CALRULE WHERE CALCODE_ID = (SELECT CALCODE_ID FROM CALCODE WHERE CODE = 'ShippingCODE');

SELECT * FROM CALSCALE WHERE CODE = 'ShippingScale like FedEx Overnight';

SELECT * FROM CALRANGE WHERE CALSCALE_ID = (SELECT CALsCALe_ID FROM CALSCALE WHERE CODE = 'ShippingScale like FedEx Overnight');

SELECT * FROM CALRLOOKUP WHERE CALRANGE_ID in (SELECT CALRANGE_ID FROM CALRANGE WHERE CALSCALE_ID = 
(SELECT CALSCALE_ID FROM CALSCALE WHERE CODE = 'ShippingScale like FedEx Overnight'));
SELECT * FROM CRULESCALE WHERE CALSCALE_ID = (SELECT CALSCALE_ID FROM CALSCALE WHERE CODE = 'ShippingScale like FedEx Overnight');

SELECT * FROM CRULESCALE WHERE CALrule_ID in (SELECT CALRULE_ID FROM CALRULE WHERE CALCODE_ID = 
(SELECT CALCODE_ID FROM CALCODE WHERE CODE = 'ShippingCODE'));
SELECT * FROM CATENCALCD WHERE CALCODE_ID = (SELECT CALCODE_ID FROM CALCODE WHERE CODE = 'ShippingCODE');

SELECT * FROM SHPJCRULE WHERE CALrule_ID in (SELECT CALrule_ID FROM CALRULE WHERE CALCODE_ID = (SELECT CALCODE_ID FROM CALCODE WHERE CODE = 'ShippingCODE'));
SELECT * FROM FFMCENTER f , STOREENT s WHERE s.MEMBER_ID = f.MEMBER_ID AND s.IDENTIFIER ='StoreIdentifier';