Closed

Stock Order Database

This project received 23 bids from talented freelancers with an average bid price of $609 USD.

Get free quotes for a project like this
Employer working
Project Budget
$250 - $750 USD
Total Bids
23
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.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online