
I need a website with database being built
- or -
Post a project like this1396
£330(approx. $443)
- Posted:
- Proposals: 12
- Remote
- #3523567
- OPPORTUNITY
- Awarded
Top Cert WordPress|Shopify|Wix|PHP|React JS|Full Stack| Developer|177 (5stars) and only single (4stars)

Web & Mobile App Developers | Admin Panels, APIs, Real-time Apps | 100+ 5★ Reviews

Full Stack Developer : PHP| React | Angular | Node.js | IONIC | React Native | Mobile App Development

91342931981326098901693616650415914207665560285241904433247448889339540006277066
Description
Experience Level: Expert
Estimated project duration: less than 1 week
At the moment I am using a very large excel spreadsheet with various tabs on it, all linked to one sheet which I then import into a database.
Those separate sheets all have differing calculations on, but then link to the same format on the end sheet.
What I envisage for this would be:-
Log on page – sign in with email address and password (I have hosting and domain already - would prefer this being built in laravel to manage it easier in the future).
Main Page – shows how many entries there are, along with a download button where I can download the latest updates in csv format.
Search button to find out details on a particular record, with a delete button which would remove it from the downloadable database, but keep a record of it.
Search would show all previous records along with the live version.
Dealer Page – Where I can Add and select “dealers” with information ie. Dealer Name, dealer contact details, VAT or no VAT, % or £ uplift on their prices. Option to “ceiling” their prices to the nearest 99p ie £1199.99 instead of £1200.
Option to increase uplift at certain levels ie if less than £100 then the uplift is £50, if between £101 and £250 the uplift is £100, if over £250.01 the uplift if £150 etc.
Would also show the last date of upload for that “dealer”
Upload Page – I select the “dealer” and upload the file that has been sent to me for that dealer. It would then use the information that I have put in via the dealer page to update the data for that dealer in the database, but keep a record of the old data for searchable purposes.
It would also send me a CSV file where information has been duplicated, and would import the “lowest price” version into the database.
When uploading it would show the date of upload.
Any questions just ask!
Those separate sheets all have differing calculations on, but then link to the same format on the end sheet.
What I envisage for this would be:-
Log on page – sign in with email address and password (I have hosting and domain already - would prefer this being built in laravel to manage it easier in the future).
Main Page – shows how many entries there are, along with a download button where I can download the latest updates in csv format.
Search button to find out details on a particular record, with a delete button which would remove it from the downloadable database, but keep a record of it.
Search would show all previous records along with the live version.
Dealer Page – Where I can Add and select “dealers” with information ie. Dealer Name, dealer contact details, VAT or no VAT, % or £ uplift on their prices. Option to “ceiling” their prices to the nearest 99p ie £1199.99 instead of £1200.
Option to increase uplift at certain levels ie if less than £100 then the uplift is £50, if between £101 and £250 the uplift is £100, if over £250.01 the uplift if £150 etc.
Would also show the last date of upload for that “dealer”
Upload Page – I select the “dealer” and upload the file that has been sent to me for that dealer. It would then use the information that I have put in via the dealer page to update the data for that dealer in the database, but keep a record of the old data for searchable purposes.
It would also send me a CSV file where information has been duplicated, and would import the “lowest price” version into the database.
When uploading it would show the date of upload.
Any questions just ask!
Peter J.
100% (54)Projects Completed
39
Freelancers worked with
30
Projects awarded
29%
Last project
3 May 2022
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-

Hey Peter, are you comfortable with a solution in excel only using Macro coding? because I think it is achievable using macro
-
How many time will you give me for this project???
10135491013548
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies