MSSQL Data Extraction to PHP site or similar

In Progress

Hello Freelancers.

We need to build a custom feature for our existing warehousing system InFlow Inventory.

What we need done is a system/script which every day at a certain time calculates how much space our customers use in our warehouse.

How can this be done?

Every product in our warehouse is entered in our warehouse system and stored in a MSSQL 2005 database.

The product is stored with length, height and width and m3 per. product.

Customers should pay per m3 (cubicmeter) they use in our warehouse.

Every customer has their own assigned "Location" in our warehouse system, so what we need is a system/script that every day calculates the total m3 usage of every location.

System/script should "list" all items in a location of the MSSQL database, take the m3 usage of every item in the database and multiply it with the amount of the item in stock.

All stock should then be put together and the total m3 usage of this specific (customer) location should be outputted into a list for every date of the year.

It is very important that the system/script is able to automatically search and check for new locations added to the MSSQL database BEFORE the list for the day is generated.

Please see attached example for an idea of how the output should look like. Output could be a .php page or similar.

We are able to provide a test enviroment with a copy of the actualy database.

Our warehouse software is InFlow Inventory ([url removed, login to view])

Looking forward to hearing from freelancers who can do this project.

Martin Brandt

Brandt Logistics

Skills: HTML, MySQL, PHP, SQL

See more: sql inventory system, site freelancers com, logistics freelancers, how to use freelancers com, how to search for freelancers, height and length, freelancers output, freelancers customer page, example of inventory database, a site for freelancers, Warehousing, how to take a test, freelancers site list, warehouse system, warehouse inventory, sql freelancers, mssql, m3, database extraction, data warehousing, c# MSSQL, mssql stored, similar stock, much similar, inventory mssql

About the Employer:
( 4 reviews ) Copenhagen, Denmark

Project ID: #4230700

Awarded to:

milenhristov

Hi Martin, I'm interested in this project. I can start working on this project on 14 of February. Best Regards, Milen

$400 USD in 5 days
(16 Reviews)
4.9

8 freelancers are bidding on average $492 for this job

hits

This is a placeholder bid. I need to see the following: "We are able to provide a test enviroment with a copy of the actual database." to be able to assess scope of work and revise or confirm my bid. We are a te More

$750 USD in 7 days
(793 Reviews)
8.7
SigmaVisual

I can help in your project, please check PMB and our ratings/reviews to get idea of our experience. Please let me know if you have any queries.

$399 USD in 10 days
(228 Reviews)
7.7
buraqtech

Check your PMB for details!!!

$585 USD in 12 days
(60 Reviews)
7.5
alifinteractive

Hi, We have a dedicated team with 7 years of experience on PHP/MySQL, Ajax, Jquery, HTML, CSS, Javascript, Java/J2EE. Also having much experience on framework and CMS like 1) CakePHP 2) CodeIgniter 3) Zendfram More

$750 USD in 20 days
(22 Reviews)
5.8
biddyweb

I can do this quickly using c#. Kindly contact me and lets discuss more.

$300 USD in 5 days
(8 Reviews)
5.7
debasishw3t

Sir i need to work please give this work

$300 USD in 60 days
(1 Review)
0.0
piyushasahu

Hi I am ready to start now. Thanks

$450 USD in 15 days
(0 Reviews)
0.0