Produce a web based supplier database & reporting system.
- or -
Post a project like this1336
£1.0k(approx. $1.2k)
- Posted:
- Proposals: 31
- Remote
- #2955185
- OPPORTUNITY
- Awarded
Full Stack Lead Developer - PHP - Javascript - Laravel - Vue.js - MySQL - TailwindCSS +_+
London
104338931998312099349210186122883842559125274499728889524180411410996539772804371691
Description
Experience Level: Expert
Estimated project duration: 1 - 2 weeks
Create a web based database through which individual suppliers can log in and enter quantities of their products that have been delivered to specific outlets. This is to replace handwritten supplier delivery notes.
User Accounts
There will be 2 types of users
• Supplier
• Admin
The login system will determine which set of functionalities the person logging in accesses. There will need to be a forgotten password reset facility.
Supplier Interface
This interface to have the following options
• Product Lookup
• Delivery Note
• Delivery Reports
Product Lookup
This feature maybe required (depending on size of product range) to allow the supplier to select of one of the available products. This will show him the details of the product and the authorised Barcodes to be used for that product.
Delivery Note
This section allows the supplier to submit a delivery note. The screen shows a list of all the products and the approved delivery locations. The supplier simply chooses the barcode used and the quantities supplied to each location.
They will also need to enter the date supplied.
Once completed the supplier clicks an acknowledgement that details provided are correct and submits the delivery note.
Delivery Report
This screen allows the supplier to review previously submitted delivery notes.
Admin Interface
This interface has the following options
• Suppliers
• Delivery Reports
• Data Export
Suppliers
This section lists all the suppliers. Clicking a supplier shows their details and the list of products that that supplier providers. It will also show the list of locations that the supplier is authorised to deliver to.
Within this section the admin will be able to
• Add/Edit Suppliers
• Reset a Suppliers login
• Add/Edit the products for a supplier
• Add/Edit the Authorised Delivery Locations
The list of products for a given supplier is unique to that supplier and has their own specific agreed cost price and stock codes.
Delivery Reports
This section lists all the supplied delivery notes and allows for them to be individually viewed.
Data Export
This section allows you to set a date range and export data in one of 2 csv formats, these are
• Goods in Totals
• Store Supplies
The Goods in Total list all the products supplied in the given date range and list them along with the total quantities supplied. The Store Supplies report shows the quantities of each product supplied to each store for the given date range.
Hosting
This database will need to be hosted on a suitable application server and requires a data backup solution.
Example file attached of the product data and the maximum number of delivery locations.
User Accounts
There will be 2 types of users
• Supplier
• Admin
The login system will determine which set of functionalities the person logging in accesses. There will need to be a forgotten password reset facility.
Supplier Interface
This interface to have the following options
• Product Lookup
• Delivery Note
• Delivery Reports
Product Lookup
This feature maybe required (depending on size of product range) to allow the supplier to select of one of the available products. This will show him the details of the product and the authorised Barcodes to be used for that product.
Delivery Note
This section allows the supplier to submit a delivery note. The screen shows a list of all the products and the approved delivery locations. The supplier simply chooses the barcode used and the quantities supplied to each location.
They will also need to enter the date supplied.
Once completed the supplier clicks an acknowledgement that details provided are correct and submits the delivery note.
Delivery Report
This screen allows the supplier to review previously submitted delivery notes.
Admin Interface
This interface has the following options
• Suppliers
• Delivery Reports
• Data Export
Suppliers
This section lists all the suppliers. Clicking a supplier shows their details and the list of products that that supplier providers. It will also show the list of locations that the supplier is authorised to deliver to.
Within this section the admin will be able to
• Add/Edit Suppliers
• Reset a Suppliers login
• Add/Edit the products for a supplier
• Add/Edit the Authorised Delivery Locations
The list of products for a given supplier is unique to that supplier and has their own specific agreed cost price and stock codes.
Delivery Reports
This section lists all the supplied delivery notes and allows for them to be individually viewed.
Data Export
This section allows you to set a date range and export data in one of 2 csv formats, these are
• Goods in Totals
• Store Supplies
The Goods in Total list all the products supplied in the given date range and list them along with the total quantities supplied. The Store Supplies report shows the quantities of each product supplied to each store for the given date range.
Hosting
This database will need to be hosted on a suitable application server and requires a data backup solution.
Example file attached of the product data and the maximum number of delivery locations.
Mark H.
100% (15)Projects Completed
13
Freelancers worked with
10
Projects awarded
69%
Last project
18 Jan 2024
Isle of Man
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Mark,
Do you have designs?
938388
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