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.