Order status not sync between OMS and WMS

Creation date: 07/02/2022 11:45    Updated: 07/02/2022 11:45
Question:

Hi CSO Team.


Please check attached excel file, there are around 150k order status that not sync between OMS and WMS (these are orders that created start from december 2021). 

Please do investigate why the order status not sync. 


Answer:

Investigation:

Initially it is because of OMS expiration. After renewal, this issue still persist.
Upon further checking, there is no WMS warehouse id passed into OMS and causing duplication and no sync.
After correcting this, there is an activity that will write back to the sendFlag which is causing it to be ‘W’ instead of ‘N’ or ‘Y’. Stopped this write back as W.
After that, OMS did not take in the WHID sent by DATAHUB.
Fixed OMS and deploy for observation.

After observation, this no longer an issue.
Files