warehouse integration (rev. 3)