fix VIP boolean migration
add external id to sales