We need a desktop module that will interact with local and online mysql database and our accounting packages and spreadsheet. We would like to export products up to mysql from the various accounting packages and excel as well as import customer data, order, inventory information, etc from mysql to the various accounting packages. What we need is a program that will connect to the database, show us what we select such as customer - show all their data as in form that collects that data on website; orders- show all data as on invoice; inventory- show items in stock, quantity, price, description, etc. according to a guidelines we will provide. From the view, we should be able to select customer, orders, or items to be batch processed (downloaded), we should then be able to select which program format to export the data to - like iif for Quickbooks , tab delimited for MYOB, etc. If we process customer orders, the status should then automatically update to processing in the database. And to upload ofcourse. We should be able to conduct searches based on guidelines we provide like show all orders from June 1 to June 4. We will need an interface that is straightforward and easy to use as not all my family speak English. We should also have option for interface to be in other languages - I can provide all the information in each language we want used. So at setup the user can choose what language they will use during the interaction process. We would like it if we can create custom skins for the interface. We currently have programs or code that does each separate thing that we can provide for you if you wish to see.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.
php, mysql, Quickbooks, MYOB accounting, Peachtree, Excel.