Originally this was for iOS, but got switched to Android - hence the re-posting.
I have a client who is a wholesale telephone distributor. They send fields reps to stores and supply phones to these stores on a consignment basis (supply merchandise now, receive payment on sale). They need to track the phones they leave at a store and then when they come back, perform an inventory of what has sold and bill for those units. Client wants a scrolling list of available phones to check off. Then wants to bluetooth print a receipt of the sales order when delivering phones, as well as a printed bill when they return and perform a physical count of merchandise. They are currently doing this via cumbersome excel spreadsheets. They want to be able to do this on a motorola xoom and have that android device store the data to be synced once it is brought back into the office with a main tracking application.
The customer has a set of spreadsheets to track inventory and sales. We want to convert these into a database that can be accessed via an android application and then at the end of the day synced to the main database.
Original thought is to use an existing web-based shopping cart database on mysql and then have the Android App create the inventory lists, sales orders and invoices and store them on the device to then be synced to the main database once a network connection is established.
For your bids, please provide our thoughts on how this app may be better built as well as examples of related coding projects.