Automated systems for inventory visibility and shelf management