IBM WCS Shipping by Weight

Research Shipping

1. http://publib.boulder.ibm.com/infocenter/wchelp/v7r0m0/topic/com.ibm.commerce.user.doc/tasks/tpnschunit.htm

how to change SKU and find out its weight

2. select * from CATENTSHIP where catentry_id=11729;

3. Select * from catentry where catentry_id=11729;

4.   Marker -

5. Select * from POLICY where storeent_id = (Select Store_id from Store where directory =

5.

6. 'MarkerStorefrontAssetStore') ;

7.

8. select * from policycmd where policy_id in ( Select policy_id from POLICY where storeent_id =

9. (Select Store_id from Store where directory = 'MarkerStorefrontAssetStore'));

10.

11.select CALSCALE_ID,CODE from CALSCALE with ur; 12204 'us_ground_na '

12.

13.select * from CALRANGE;

14.update CALRANGE set CALMETHOD_ID=-33 where CALSCALE_ID=12204 with ur;

15.

16.sHIPPING-

17.select * from calmethod;

18.SELECT * FROM CALRULE;

19.select * from calscale;

20.select * from calrange;

21.select * from CALUSAGE; // TAX , SHIPPING , SHIPPINGDISCOUNT ETC

22.select * from crulescale;

23.

24.

25.select * from SHiPMODE;

26.select * from SHPMODCLCD;

27.

28.//select * from calrange where calscale_id=13701 ;

29.

30.// WEIGHT ,HEIGHT ETC DETAILS

31.CATENTSHIP