PHP Web Application for organizing Product Availability

CLOSED
Bids
26
Avg Bid (USD)
$1443
Project Budget (USD)
$750 - $1500

Project Description:
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.

Resources:

http://help.yahoo.com/l/us/yahoo/smallbusiness/store/api/docs/

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 required:
Database Administration, HTML, MySQL, PHP, Website Testing
About the employer:
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.


$ 1907
in 14 days
$ 1546
in 30 days
$ 1427
in 22 days
Hire rajeshsonisl
$ 2577
in 12 days
$ 1855
in 14 days
$ 1421
in 14 days
$ 1786
in 30 days
$ 1494
in 14 days
$ 1494
in 7 days
Hire phpXpertbd
$ 1578
in 14 days