Android Application featuring synch up with central database

Overall solution is composed of a central database (mysql) on a server and a local database on Android tablet. Android tablet is highly mobile and should offer spome replication capability whenever it is connecting back to the server or on demand of the user. Android database is a subset of the central database. User will select whatever he needs from central database, will deconnect and go offline. Users will be able to synchup: - In both direction between central database and android database to replicate customers, orders (past one month) with related ordered products data that has changed. - In one direction from central database to android database and replicate products and their images (stored in a separate folder with some subfolders eventually) that have changed. User should be able through some forms to search for a specific customer via name, address, or order. User should be able to edit customer details, enter one or multiple orders. User should be able to udpate ordered products by product number or flipping the product images and then selecting related product. All updates are recorded in the database. Once user is back online, the synch up between the two databases will occur as described above.