Stock Order Database


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: Database Administration, HTML, MySQL, PHP

See more: greater building, data entry alphanumeric, alphanumeric data entry, stock update, Stock Control, nw, database building 2, mysql stock control database, update stock, create report database php, php upload xls file database, stock report, mysql update values, php create stock control database, update values mysql, order upload, php text xls, mysql multiple replace, stock data mysql, multiple replace mysql, create daily report mysql, create report php sample, daily report php mysql, php create daily report mysql, php stock control database example

Project ID: #4022475

22 freelancers are bidding on average $605 for this job


Greetings! Just giving a quote on your project does not guarantee a project worth excellence. So, we need to talk more, share the project details, and me taking the lead to create the project write-up and proposal for More

$1200 USD in 45 days
(196 Reviews)

Dear Sir, We would love to get this opportunity of working with you. We can assure you that we will provide you with a very nice Stock and Order maintenance system. Regards NetzPro

$700 USD in 10 days
(349 Reviews)

Interested to work for you .Experienced with similar jobs

$750 USD in 10 days
(174 Reviews)

Hello ! I would like to work with you on developing a Stock Order Database. Please have a look at your private message board. Thank you!

$600 USD in 12 days
(120 Reviews)

Hello James, Can you provide a sample of the xls files?, if so, I will start working on a demo for you. Best Regards. Leo.-

$350 USD in 2 days
(108 Reviews)

We are interested to develop this control panel in php and mysql.

$325 USD in 5 days
(87 Reviews)

Hi Please check ur pm.

$600 USD in 15 days
(9 Reviews)

Hi please check inbox.

$500 USD in 15 days
(232 Reviews)

Dear Sir, Expertise in Open Source/CRM/ERP/POS/Custom Solutions/Web designing. We do customization as per your requirements. ! With a good Profile in Freelancer and experience of over seven years in the Software Aren More

$500 USD in 25 days
(24 Reviews)

Ready to start this projectt

$300 USD in 5 days
(75 Reviews)

Hi, I am a web developer with 1+ year of experience. I am ready to work on this project for you Please contact me if you are interested Thanks,

$1500 USD in 15 days
(83 Reviews)

Hi, I have experience with this project, I happily if work with you in this project. Regards

$450 USD in 30 days
(16 Reviews)

Hi, We are Expert programmers with 6+ years great industry experience .. Attaching more details with PM . Please check

$550 USD in 25 days
(3 Reviews)

I have read your requirement ready to start, i have over 6+ years of experience in php, mysql, css etc. i have experience with inventory, orders management etc, for details read my message

$300 USD in 20 days
(7 Reviews)

Hello, I can do the work, please check out PM for more details.

$300 USD in 5 days
(1 Review)

Hi, we have gone through with the requirements. We can easily do it with our expertise.we will provide you regular updates during progress. We are available for you all the time. Let's work together. Regards Meena

$699 USD in 15 days
(5 Reviews)

We can do it for you as we have good working exp. of working on these type of projects.

$375 USD in 15 days
(2 Reviews)

I'm interested.

$750 USD in 14 days
(0 Reviews)

i can do batter this task.

$500 USD in 30 days
(0 Reviews)

We are freelance software developers. If you contact me I can give a quote for your project and we can discuss the details. <b><i>Removed by Admin</i></b>

$500 USD in 1 day
(0 Reviews)