All oDesk Jobs » Search Results » Job Facts
 oDesk Verified
Payment Method
Flag as inappropriate
Product Visibility XML, PHP
Open
Date Posted:September 3, 2009
Planned Start Date:September 3, 2009
Estimated Delivery Date:September 4, 2009
Type:Fixed-Price
Main Category:Web Development
Sub Category:Web Programming
Skills: PHP
XML
MySQL
more
Estimated Budget:$1,000
Last Buyer Activity:September 4, 2009
Candidates: 25 - average $1,030.31
Interviews: none
 
In Progress
Start Date:September 4, 2009
Agreed Amount:$1,111.11
Hired Provider: Dan O.
Payments: $1,055.56 (2)
Refunds: none
Completed
End Date: 
Feedback to Provider: 
Feedback to Buyer: 
Amount Paid: 
Payout Ratio: 
 
Preferred Qualifications
English skill:above 3
 
Buyer Facts
Member Since:December 9, 2008
Country:United States (GMT-06)
City:Brentwood
Jobs Posted:4
Jobs Filled:2
Jobs Not Yet Filled:1
Current Team size:1
Hours billed, last 30 days:0
Total oDesk Hours:0.00
Feedback Score: -
 

We have data from multiple vendors which I am bringing in to SQL to export in a more standard format.  I am also scraping a site to check pricing and it will be exported in XML.  So the vendor data as well as the pricing data can be in xml.  I would like to have the XML “displayed” on a page (like a spreadsheet) that would contain the following data:

SKU, Manufacturer, Name, UPC, Vendor, Condition, Availability, Cost, Price, Qty, Profit, Profit %, Vendor1Price, Vendor1Condition, Vendor2Price, Vendor2Condition, Vendor3Price, Vendor3Condition, Vendor4Price, Vendor4Condition

Profit and Profit % will have to be calculated, I’m not certain just yet how many Vendors Pricing and condition I need to see but four should be enough.  Other data for the most part will be available, some fields may be left empty due to incomplete data such as UPC.

Also Vendor#Price and Vendor#Condition, should be replaced by the actual vendors name from whom we are pulling the price.

Qty and Price should be able to be modified, I would also like some visual cues for pricing when our price is lowest, matching lowest, or higher than the lowest compared to displayed vendors.  Like Green when we’re the lowest, yellow when matching, red when higher.

I would also like check boxes or some way to select parts to export as well as a quick way to select all.  This way we can export this list into CSV, Tab Txt, XML, or (if not a big deal) XLS.  Being able to modify data and select parts to export will enable us to manage pricing and inventory for the various channels in a much more efficient way.

We should be able to sort on every field and authentication will be necessary.  We should also be able to limit who can see which fields as well as possibly display different costs or pricing based on the user logged in (although displaying different costs and pricing isn’t a necessity if it complicates things too much)

I currently have some vendor data in SQL 2005 and vendor pricing data in XML, our web server is Apache with mySQL.  I could bring the pricing data into SQL as well and see if I could get everything into one table if that will make things easier.  

I need to get this project done as soon as possible so please let me know when you could start, how much it will cost, and how long you expect the project to take to complete.

Buyer's Assignment History
Provider From/To Job Title Billed Feedback
267952 09/2009 - Present Product Visibility XML, PHP $1,173 (fixed-price)

Candidate List
Title Name Initiated By Date
project manager/php/drupal/jumla/javascript Ravinder Lala Provider September 3, 2009
programer/Designer Ranjana Srivastava Provider September 3, 2009
php/javascript/dreamwiver/wordpress Shankar Gauri Provider September 3, 2009
lamp developer/javascript/html/dhtml/xml/wordpress/dreamwiver Sharmila Gupta Provider September 3, 2009
PHP,Joomla,Drupal,Phpmydirectory,Wordpress web developing Jyoti Thakur Provider September 3, 2009
PHP/MySQL/DHTML/Ajax/Oscommerce/Wordpress/XHTML/HTML Daniel M. Provider September 3, 2009
5+ Exp. Web Developer:Asp.net/C#/VB.net/sqlserver,php/mysql,xhtml,css Purnendu B. Provider September 3, 2009
Quality Of Work Assured || Customer Satisfaction||PHP/MySQL Developer Vivek P. Provider September 3, 2009
PHP, CSS, Java Script, AJAX, Drupal, OsCommerce, Word Press, MY SQL Web Expert Provider September 3, 2009
Senior Web Developer From California,USA - PHP, MySql, Asp, SQL Server Yonatan Ogbaslassie Provider September 3, 2009
.Net PHP Joomla JQuery/AJAX CakePHP FaceBook Apps Expert 3+ Yrs of Exp Raj Gupta Provider September 3, 2009
PHP 5 Zend Certified Engineer Bogdan Gersak Provider September 3, 2009
♠♠♠ Web Guru (PHP/ASP/JSP/Coldfusion/Magento/Joomla/Smarty/Zend) ♠♠♠ Jongguk Jo Provider September 3, 2009
5 years exp in Web development, PHP, RoR, Adobe, J2EE, MySQL, DB2 Ruchi Jain Provider September 4, 2009
★★★★★ PHP/MYSQL/XHTML/AJAX/JAVASCRIPT/JQUERY/Flash GURU ★★★★★ Phila P Provider September 4, 2009
Project Manager PHP 5 & 4 ,F MVC framework, CakePHP , AJAX, FaceBook Harish B. Provider September 4, 2009
Accomplished PHP/Python Programmer/Designer Ed Rahn Provider September 4, 2009
PHP/JOOMLA/WordPress/Oracle/MySql/MsSql Mamta P. Provider September 4, 2009
PHP/Mysql/LAMP, Javascript,Ajax,Ecommerce Drupal.Wordpress @ Matrix Omkar Y. Provider September 4, 2009
JAVA |.NET | PHP | MY SQL l Designing l Scrapping lJoomla lYahoo Store Pratik Machchar Provider September 4, 2009
♠♠♠♠♠ Web Developer - Romania ™ Pula D. Provider September 4, 2009
Give Life To Imagination Raheel Siddiqui Provider September 4, 2009
Dev Expert-10 years exp - XML, XSL, XSL-FO, MySQL, Java, PHP, Magento Dan O. Provider September 4, 2009
>1000 hrs on Odesk PHP MYSQL ASP.NET AJAX DEVELOPER Ajay P. Provider September 4, 2009
Expert CakePHP JQuery Drupal Joomla X-Cart ASP/C#.Net Developer Dinesh K. Provider September 4, 2009

Related Trends
PHP Developers
MySQL Administrators
CSS Designers