Abstract: The present disclosure extends to maintaining an item inventory status at an inventory cache management system. The inventory cache may be refreshed regularly by a threshold-based triggering mechanism. In embodiments, as item inventory breaches certain thresholds, the inventory cache may be refreshed with increased frequency to mitigate overselling or underselling scenarios and reduce overall network traffic for items having relatively high inventory levels.

Abstract: A store computer system is provided. The computer system includes a sharded store transactional database such as an order or inventory database. The database may include a first database shard which stores a first group of order or inventory data and a second database shard which stores a second group of order or inventory data which is different than the first group of data. The computer system may include a store order management computer system that implements a shard determination module which is programmed to receive a query regarding an order or item associated with the store, identify a database shard associated with the order or item from data in the query, and communicate data regarding the order or item to or from the identified database shard.

Abstract: A method for sharding a store inventory database is provided. The method may include separating a store inventory database into a first inventory database shard in a first inventory database server which has inventory data for a first group of items sold by a store and into a second inventory database shard in a second inventory database server which has inventory data for a second group of items sold by the store which are different than the first group of items. The method may also include associating a router with the sharded store inventory database, the router housing resident shard determination logic which comprises information which, for an item sold by the store, identifies an inventory database shard on which inventory data for the item is stored.

Abstract: A method for sharding a store order database is provided. The method may include a store order management server operating an order management system application layer to facilitate online order management. The store order management server may receive, from a customer computer, a query regarding an order to purchase items from the store. The store order management server may transmit the customer query regarding the order to a router which may use resident shard determination logic to identify a database shard which pertains to the order. The database shard may be part of a store order database having a plurality of database shards. The router may transmit information regarding the order to a database server which implements the identified database shard and the database server may process the information and transmit information regarding the order to the customer computer.

Abstract: A method for sharding a store order database and order management application is provided. The method may include a computer router associated with a store receiving, from a customer computer, a query regarding an order. The router may use resident shard determination logic to identify a database shard which pertains to the order and which is part of a store order database having multiple database shards. The router may transmit information regarding the order to a database server which implements the identified database shard and which implements an order management system application layer. The database server may process information regarding the order and transmit information regarding the order to the customer computer.

Abstract: The present disclosure extends to maintaining an item inventory status at an inventory cache management system. The inventory cache may be refreshed regularly by a threshold-based triggering mechanism. In embodiments, as item inventory breaches certain thresholds, the inventory cache may be refreshed with increased frequency to mitigate overselling or underselling scenarios and reduce overall network traffic for items having relatively high inventory levels.

Abstract: 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.

Abstract: The present invention is generally directed to methods, systems, and computer program products for routing order lookups. Order data from order management system database is synchronized to an order cache. When an order lookup is received, a business layer determines if the cache can appropriately service the order lookup. If so, the business layer routes the order lookup to the cache. Otherwise, the business layer routes the order lookup to the order management system database. In some embodiments, order lookups configured to impact state of the order management system database (e.g., that write or change order data) are routed to the order management system database. In these same embodiments, order lookups configured to not impact state of the order management system database (e.g., that read order data) are routed to the cache.

Abstract: The present invention is generally directed to methods, systems, and computer program products for synchronizing database data to a database cache. Embodiments of the invention facilitate synchronizing order data from an order management system database to an order cache. When order data is synchronized, more efficient order lookups of the order data can occur. In some embodiments, the order management system database feeds the order cache with the latest updates as relevant state for orders is modified. A trigger within the order management system database can indicate when order state is modified. The trigger is monitored. When the trigger indicates modified order state, a caching interface (e.g., a caching API) can be called to publish the modified order state to the order cache.

Abstract: The present disclosure extends to maintaining an item inventory status at an inventory cache management system. The inventory cache may be refreshed regularly by a threshold-based triggering mechanism. In embodiments, as item inventory breaches certain thresholds, the inventory cache may be refreshed with increased frequency to mitigate overselling or underselling scenarios and reduce overall network traffic for items having relatively high inventory levels.

Abstract: The present disclosure extends to maintaining an item inventory status at an inventory cache management system. The inventory cache may be refreshed regularly by a threshold-based triggering mechanism. In embodiments, as item inventory breaches certain thresholds, the inventory cache may be refreshed with increased frequency to mitigate overselling or underselling scenarios and reduce overall network traffic for items having relatively high inventory levels.

Abstract: The present disclosure extends to maintaining an item inventory status at an inventory cache management system. The inventory cache may be refreshed regularly by a threshold-based triggering mechanism. In embodiments, as item inventory breaches certain thresholds, the inventory cache may be refreshed with increased frequency to mitigate overselling or underselling scenarios and reduce overall network traffic for items having relatively high inventory levels.

Abstract: The present disclosure extends to maintaining an item inventory status at an inventory cache management system. The inventory cache may be refreshed regularly by a threshold-based triggering mechanism. In embodiments, as item inventory breaches certain thresholds, the inventory cache may be refreshed with increased frequency to mitigate overselling or underselling scenarios and reduce overall network traffic for items having relatively high inventory levels.

Abstract: The present disclosure extends to maintaining an item inventory status at an inventory cache management system. The inventory cache may be refreshed regularly by a threshold-based triggering mechanism. In embodiments, as item inventory breaches certain thresholds, the inventory cache may be refreshed with increased frequency to mitigate overselling or underselling scenarios and reduce overall network traffic for items having relatively high inventory levels.

Abstract: Example mobile payment systems and methods are described. In one implementation, a mobile device creates an order with an online marketplace. The mobile deice captures an image of a negotiable instrument and communicates the image to the online marketplace along with a request to pay for the order using the negotiable instrument. The negotiable instrument is validated by the online marketplace. The mobile device receives a notification from the online marketplace indicating whether the request to pay for the order using the negotiable instrument was accepted.

Abstract: Example payment validation systems and methods are described. In one implementation, a request is received from a user to pay for an online order using an image of a negotiable instrument. Information associated with the negotiable instrument is identified from the image of the negotiable instrument. The identified information is communicated to a validation service. An indication is received from the validation service regarding whether the negotiable instrument is valid. If the negotiable instrument is valid, payment for the online order is processed using the image of the negotiable instrument.