small classic ASP project - maintenance(repost)

This is a small project to fix some ASP code, probably can be done in a few hours or in? a day. The technologies involved are classic ASP and mySQL. The code involves accessing [url removed, login to view] Web Services (AWS).

## Deliverables

Attached is a script that needs to be fixed ([url removed, login to view]). It takes a group of product IDs? from local mySQL database, retrieves their lower price and sales rank from AWS, and updates the database with them. (ASIN, ISBN, and UPC are all product IDs used by amazon to identify merchandise.)

I removed my developer's token and amazon associate ID from the code for privacy reasons. You probably will be able to get your own from Amazon. If for any reasons you can't, I'll give you mine. They are declared in the attached program as strDevToken and strAssocId.

This is the link to Amazon API developer guide -

<[url removed, login to view]>

There are two things that need to be fixed:

1. The requests to AWS no longer work because Amazon changed the way they are validated a few months ago. All requests now have to be signed. This needs to be fixed. I believe the relevant documentation is here -

<[url removed, login to view]>

(The error you'll get when you try to run the attached code is caused by this new requirement to sign requests, before that the program worked fine)

2. The program retrieves the lowest-priced item. We need to modify it to exclude items listed by myself, if any. I am a seller on I know that API provides a method to identify the seller of the item.

This is the link to amazon's API -

<[url removed, login to view]>

Let me know if any questions.


1. The code - [url removed, login to view] and refreshAmazon.asp. [url removed, login to view] is just the interface, you don't need to make any changes to it

2. [url removed, login to view] - CREATE TABLE statement to re-create the mySQL database, for test purposes.

3. [url removed, login to view] - a tab-delimited file with some sample data that you can insert into the database with LoAD DATA command, for test purposes

* * *This broadcast message was sent to all bidders on Wednesday Dec 16, 2009 1:25:13 PM:

I was told that zip file couldn't be opened. I updated it and it's fine now.

Habilidades: Amazon Web Services, ASP, Engenharia, MySQL, PHP, Arquitetura de software, Teste de Software

Veja mais: web developer test questions, web developer price table, the method of web developer, sql create table price, php mysql developer statement, php developer test questions, html 5 documentation, html 5 command, get token developer, developer in php code insert, command group, classic asp web developer, asp classic developer, api developer price, amazon web services developer, amazon seller services, amazon aws database, we told two, fix two small, dg, classic asp, broadcast project, aws database, amazonwebservices, amazon rank

Acerca do Empregador:
( 38 comentários ) Greeneville, United States

ID do Projeto: #3033233

Concedido a:


See private message.

$72.25 USD em 4 dias
(90 Comentários)

4 freelancers estão ofertando em média $79 para esse trabalho


See private message.

$85 USD in 4 dias
(281 Comentários)

See private message.

$72.25 USD in 4 dias
(13 Comentários)

See private message.

$85 USD in 4 dias
(13 Comentários)