Stock Order Database

CLOSED
Bids
23
Avg Bid (USD)
$609
Project Budget (USD)
$250 - $750

Project Description:
I need a database with control panel building to manage stock ordering.

The fields in the Database are to be:

SKU (alphanumeric and hypens)
Alt SKU (alphanumeric and hypens)
Supplier (text)
Daily (true or false)
Sales (numeric)
Stock (numeric)
Low Stock Trigger (numeric)


The SKU will possibly have up to 4 alternative SKU's for example:

SKU: 7399-black may also be known as 7399-blk-os or 7399-blk-nw or black-7399



1) Create new Records (via .xls file)

This file will contain all data

If SKU already exists then do nothing BUT report error.



2) Update Sales (via .xls file)

This file will contain a SKU and a "sales" and the "sales" will replace the existing entry for sales. It will not overwrite the other fields. This file will contain multiple records for one SKU or Alternative SKU. For example data sample could be:

7399-black 12
7399-blk-os 54
7399-blk-nw 63
black-7399 3

So for the main sku 7399-black the sales value will be 132. I assume it would be best to automatically reset all existing sales values to 0 upon successful upload of this file and then increment until next update of sales??

If SKU or Alternative SKU does not exist report error


3) Update Stock (via .xls file)

This file will contain a "SKU", "stock", "low stock trigger" values. The stock and low stock trigger values will replace the existing entry for stock. It will not overwrite the other fields

If SKU does not exist report error

NB: Sometimes the stock value may be negative



4) Run Order Reports

I need to be able to run the following report and have it display with the option of saving as a text file:

Display SKU, Supplier, and a Stock Required value. This value = "Low Stock Trigger" minus "Stock"

So if Low Stock Trigger = 12 and Stock = 8 then the "Stock Required" = 4

Only show where stock required is greater than or equal to 1

NB: Sometimes the stock value may be negative


5) Control Panel will also be able to display all data from a search. A result will be a part match.

Skills required:
Database Administration, HTML, MySQL, PHP
Hire jamsy
Project posted by:
jamsy United Kingdom
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 1200
in 45 days
$ 700
in 10 days
$ 750
in 10 days
Hire AlinGhinoiu
$ 600
in 12 days
Hire leoe
$ 350
in 2 days
$ 325
in 5 days
Hire faizan101010
$ 600
in 15 days
Hire shihan033010
$ 500
in 15 days
$ 500
in 25 days
$ 300
in 5 days