PHP Web Application for organizing Product Availability

Inventory Project Web Application Specifications for Ecommerce website

Currently we get inventory reports from our vendors via email ( through a gmail account ) and via FTP transmissions. Reports come in different formats and structures. The formats include .csv, .xls, .xlsx, .txt mostly. There are approximately 200 suppliers that will need to be mapped.

The application will gather this data from email attachments and FTP locations, then normalize this data in a central database. There will also be other databases involved, like our central product database and a vendor database.

The database will be used to transmit inventory to our multiple websites via the Yahoo Catalog Manager API. It will also be used to compare against our master product database to create various reports like “available to sell but not on the websites”, "on the websites but not in the database" and other reports. The normalized database will need to be able to be queried, so we can get vendor reports and other reports.

The data set itself is fairly simple. In will consist of only a few items. These being Manufacturer, Manufacturer part Number, in stock (yes / no), back order date, quantity in stock, discontinued (yes/no), there may be mapping logic surrounding this data. The Manufacturer Part number will be the KEY for the database.

We have a spreadsheet with most of the vendors organized with data delivery methods and some basic mapping.

The main interface will be a website that we can log into. As data and it's structure can change, we will need the ability to change mappings. So if a vendor shifts columns, we can re-map the data set.

We have a test environment setup and will provide hosting for a development environment.


[url removed, login to view]

If you have any additional questions regarding this project please let us know.

We need this project completed within 14 days of project start.

Skills: Database Administration, HTML, MySQL, PHP, Website Testing

See more: web application specifications, web application inventory, web account manager, vendor product, set data structures, sell reports, sell application development, resources need manager, questions data structures, product development manager, mapping websites, different data structures, data structures set, data structures questions, data set testing, create website like gmail, map data structure, basic data structures, application data structures, application data structure, application website development, yahoo web hosting, yahoo store manager, web product manager, mapping api

About the Employer:
( 2 reviews ) Melville, United States

Project ID: #4641219

23 freelancers are bidding on average $1467 for this job


Dear Sir, We would love to get this opportunity of working with you. We can guarantee complete satisfaction if you select us to execute this project. Regards NetzPro

$1907 USD in 14 days
(358 Reviews)

Please see PMB for more detailed message.

$1546 USD in 30 days
(35 Reviews)

Check your PMB for details!!!

$1427 USD in 22 days
(69 Reviews)

Quality work assured. Ready to get started. Thanks.

$2577 USD in 12 days
(422 Reviews)

Hi, we can help you to build this application. Let us have sample vendor's inventory reports. We will use CodeIgniter + Twitter Bootstrap Framework. We can discuss more via PMB/Chat. Thanks.

$1855 USD in 14 days
(93 Reviews)

Let me work for you. ok i got your requirement i will provide UI (user interface) which will grab all the files from ftp server and save into the centralize database from where you can access it. i have UI demo ready More

$1421 USD in 14 days
(54 Reviews)

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

$1786 USD in 30 days
(31 Reviews)

Hi, I have read all the requirements and I am very confident to do this project from start till end. I can guarantee complete satisfaction if you select me to execute this project. Please check your private message boa More

$1494 USD in 14 days
(28 Reviews)

Hi We are ready to deliver this to you on time. We have expertise on this domain. Please check your PMB. Regards ETS

$1494 USD in 7 days
(16 Reviews)

I can offer my high quality php programming services to you. phpXpertbd ready to start immediately. More details in PM. Thanks

$1578 USD in 14 days
(19 Reviews)

Hello, we will provide the winning edge to this project by leveraging our Business-to-IT Connect and deeply committed people. Kindly check your personal message box for more details.

$1519 USD in 20 days
(6 Reviews)

Hi, we are a team of programmers and designers with expertise and experience in PHP, Mysql, jQuery and Ajax. We have coded and designed websites for various types of businesses very successfully. We have developed many More

$773 USD in 15 days
(44 Reviews)

Hi, We can give you the best and quick output. We have a professional team in your required area, they work sincerely. You will get your desired output from us. We are very much concerned about quality and customer sa More

$1546 USD in 30 days
(5 Reviews)

8 year's experience for the Web Development, eCommerce Development,Php development

$1315 USD in 30 days
(6 Reviews)

php/mysql/html team

$1030 USD in 8 days
(6 Reviews)

We truly believe in Commitment, sincerity, reliability, long term relationship and Excellence. Willing to start your work right away. Please send me details in PMB. Thanks

$1666 USD in 30 days
(2 Reviews)

Hello , I will do my best please check Private Message. Thanks

$1500 USD in 14 days
(1 Review)

Hi Please check the PM thanks

$833 USD in 14 days
(13 Reviews)

i'm ready let's start

$750 USD in 0 days
(4 Reviews)

It's an easy task for [url removed, login to view] have gone through your requirements and we are ready to start the work immediately on your project. Please see the attached list of company's projects. Also please check the PMB.Thanks.

$1500 USD in 20 days
(0 Reviews)