Find Jobs
Hire Freelancers

Aggregating Amazon AWS Catalog Data - Excel VBA plug-in

$500-5000 USD

Cerrado
Publicado hace alrededor de 16 años

$500-5000 USD

Pagado a la entrega
Create an Excel spreadsheet with built-in macros and forms. The spreadsheet needs to call Amazon Web Services to retrieve catalog data from amazon through the REST interface (XMLs imported from the internet), based on simple input form another spreadsheet. The results (product data and search results) must be aggregated and displayed in a userform. ## Deliverables Workflow: A. When main macro is run, a userform appears to ask the user what workbook the macro should work on and which 2 columns include the values Title, UPC, Platform. The target spreadsheet has multiple lines, each line represents a product, and each product has a field for Title, UPC and Platform. B. The macro reads the data from the columns C. The macro: c1. Calls AWS ECS service and retrieves 50 search results (ItemSearch command) for every line in the spreadsheet (keywords = Title + Platform) for Amazon US and Amazon CANADA (the search is on the whole website, and it is not restricted to Videogames) c2. Aggregates all search results across CA and US for each product based on the identifier "ASIN". If the same ASIN shows up in multiple results for the same product in CANADA and US, it is counted only once. c3. For each ASIN, call, AWS ECS service to retrieve product information (ItemLookup command), including the URL of largest product image available if any D. Display in the user form all results in this way: Like an Access form, the UserForm displays results for one product (line in the target workbook) at a time. Buttons allow to move to the next or previous product. Let's say we are on product A. The user form displays the aggregated list of the top 12 search results gathered from Amazon US and Canada. The aggregated list has no duplicate ASINs in it, and the rank is based on the sum of the individual rankings in Canada and US. For each result displayed, what is displayed is the following information: - the image of the ASIN - the ASIN - the ASIN title, platform, product group, brand, manufacturer, format, GTIN or UPC, part number - if the UPC of the ASIN matches the UPC specified in the workbook for that product, there is a red box outline around the ASIN. E. The user can then select one of the ASINs and click on button "Select duplicate" E1. When this happens for the first time, the macro checks if the target workbook has a column which header (row 1) ="ASIN". if not, it creates one as Column A. E2. After that, the ASIN of what the user has selected is copied in the cell (column A, the row depends on which product is being analyzed). F. User closes the User Form More detailed information in the attachment * * *This broadcast message was sent to all bidders on Saturday Feb 2, 2008 8:52:02 PM: hi, Comprehensive specs have been added to the bid. See the zip attachment in the specs section. Thank you AM
ID del proyecto: 3670946

Información sobre el proyecto

4 propuestas
Proyecto remoto
Activo hace 16 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
4 freelancers están ofertando un promedio de $903 USD por este trabajo
Avatar del usuario
See private message.
$467,50 USD en 14 días
5,0 (404 comentarios)
6,4
6,4
Avatar del usuario
See private message.
$1.020 USD en 14 días
5,0 (11 comentarios)
4,0
4,0
Avatar del usuario
See private message.
$425 USD en 14 días
0,0 (3 comentarios)
0,0
0,0
Avatar del usuario
See private message.
$1.700 USD en 14 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
United States
0,0
0
Miembro desde ene 28, 2008

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.