Amazon XLST and Excel Spreadsheet - Item Lookup

終了済み 投稿 May 1, 2008 着払い
終了済み 着払い

I am assuming this will be a fairly simple project to undertake for someone with experience with Amazon's ECS and XSLT.

I need an Excel macro that will create an Amazon ECS ItemLookup request for product data based on existing data in a spreadsheet, and display it in an Excel spreadsheet or HTML file using XSLT.

Assume that I have an Excel spreadsheet with UPC information, software titles and platforms. The macro should ask which fields hold the the title, platform, UPC, etc. It will then generate the appropriate ECS request to retrieve the Amazon catalog information (title, sales rank, number of sellers, lowest New price) and display it in an Excel spreadsheet.

Ideally, I would like the following options:

- Multiple lookup options

-- Category, UPC

-- Category, Keywords

-- Both UPC and Keywords in category

-- Restrict by Condition

The macro would allow the user to indicate where the UPC, Keywords, and/or Category are located in the spreadsheet, and specify the default Category and Condition when not available.

The program would most likely need to send multiple requests in order to comply with Amazon's 10 ItemID per request restrictions.

The programmer would also need to provide a xsl file to format the results.

We would also require instructions on how to modify the request and results (ex. add an additional result field, change the ECS format).

This should be based on the latest released version of Amazon's web services.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

XSL file will run on our person web server, Excel spreadsheet/macro must be compatible with Excel 2003 and Windows XP

PHP

プロジェクトID: #3906091

プロジェクトについて

2個の提案 リモートプロジェクト アクティブ May 18, 2008

2人のフリーランサーが、平均$149 で、この仕事に入札しています。

thechaoshacker

See private message.

$212.5 USD 14日以内
(10件のレビュー)
3.5
vapinfocis

See private message.

$85 USD 14日以内
(0件のレビュー)
0.0