We have 3 versions of shipping method/shipping preferences/carrier code
- orders from magento: it's called shipping preference. eg. ups_twodayair, ups_ground
- orders in BBOP-SHIPMENTS: it's also called shipping method(mapped with shipping preference). eg. 02, 03C
- CSH from warehoue: it's called carrier_code
For order 130342984
- magento order with shipping_preference
ups_ground
- BBOP translates it to shipping_method
03C
exported to warehouse - warehouse returned carrier_code
03C
in CSH
For order 130265936
- magento order with shipping_preference
ups_onedayair
- BBOP translates it to shipping_method
13
exported to warehouse - warehouse returned carrier_code
03C
in CSH
For order 130380344
- magento order with shipping_preference
ups_twodayair
- BBOP translates it to shipping_method
02
exported to warehouse - warehouse returned carrier_code
03C
in CSH (I also see warehouse returned 02 such as 130377941)
So CSH contains shipping code which reflects how warehouse ships things in real world
947 = ADJ
944 = RC