The present invention is generally directed to methods, systems, and computer program products for routing order lookups from retail systems. Order data from order management system database is synchronized to an order cache. When an order lookup is received (e.g., from a retail kiosk or POS terminal), a business layer determines if the cache can appropriately service the order lookup. If so (e.g., if the order lookup does not change order state), the business layer routes the order lookup to the cache. Otherwise (e.g., if the order lookup does change order state), the business layer routes the order lookup to the order management system database. In-store retail systems can be used to lookup orders previously submitted through other channels, such as, a website or mobile application. Knowing order details for other orders can assist the customer with in-store purchasing decisions.