Create MySQL Database And Interface To Replace Excel Reporting Summaries
$30-250 USD
Pago na entrega
This project involves creating a MySQL database that organizes sales data into several different summaries. I currently use an Excel worksheet (using data tables) for this operation. However, a true database is better suited for the project.
The input data is a txt file, which I parse into an Excel spreadsheet. Each data file has the same fields, but varies in number of records/rows. The data file contains information for three primary data types: sales orders, refunds and adjustments. Information for a single sales order or refund is contained in multiple records/rows and must the summarized into a single record.
The Excel spreadsheet I use, works fine for creating the various summaries for a given batch file. However, the spreadsheet does not have the capability to aggregate the data by date ranges. I need the ability to report by data batch and/or date range.
The various summaries/reports needed are:
1. Date, Transaction Type, Order, SKU
2. Date, Transaction Type, SKU
3. Transaction Type, SKU
4. Date, Transaction Type
5. Transaction Type
6. Reconciliation Summary
7. Shrinkage adjustments by SKU
Please see the attached Excel spreadsheet. It contains the data file (Raw Data tab) and the various summaries. Not all of the columns shown on the sheet need to be shown on the reports.
The database must have an interface where the batch number and/or date range can be entered and be able to select the various reports to be displayed. The interface does not need to be beautiful, simply operational.
Please let know your questions.
ID do Projeto: #9175233
Sobre o projeto
25 freelancers estão ofertando em média $174 nesse trabalho
Hi, I am a freelance web developer and have been in the business for over 4 years specializing PHP, SQL. Please consider my bid and message me for further info.
Hi I can create complete database with requested reports and interface in 8 days. Please contact me if you are interested. Regards, Mladen
Hi Dear, I am having 7+ yrs of exp in PHP/MYSQL. I have read the details of your project. I can do this with timely updates
I have +5.5 year experience in database development. I had working on different database technology oracle,sql server , my sql ,ms sql. Ready To Start Immediate.
Hello.. I am based out in Hong Kong and got right set of tools to complete this assignment efficiently. Feel free to discuss with me details over chat and I can start it asap
Hello dear, I am Computer Science graduate. I am basically working as web developer and web designer in a firm and often do freelancing as part time. I am willing to do your task. Let's come in chat for detail. Thank Mais
Hi, It is very easy to do that. That is why my bid is so low. And I need to make some jobs to get qualified in freelancer. Otherwise I would charge 100 to 150. I suggest: LAMP (linux, apache, mysql, php) to build t Mais
Based on your requirements, it will be easier to create an MS access database with a nice UI to load the data and also to generate the various reports. Have done databases of these types a lot of times
It would be a great opportunity to be of service to you. I am open to further discussion. Thank you in anticipation for your kind consderation