Check the cause of error in triggering manual order sync, upon checking the cause is Data too long for column 'ext_shipping_method', this is now resolved by adjusting the max variable of column from 100 to 255. 