In the event that you are upgrading a website from a previous version of BirdDog, you will need to run the below query immediately after all software has been updated to 9.8.7. Custom reports and queries that look at ship complete will need to be adjusted since the location has changed.
update BDOrderSupport
set ShipComplete=1
from OEORDHDR_SQL h (nolock)
join BDOrderSupport ohs (nolock) on h.ord_type=ohs.Ord_Type and h.ord_no=ohs.ord_no
where h.user_def_fld_5='y'
and isnull(ohs.ShipComplete,0)=0