Application(Macro): Converting CSV file from Amazon MWS API format to Magento/Magmi format

This project received 9 bids from talented freelancers with an average bid price of $433 USD.

Get free quotes for a project like this
Employer working
Project Budget
$30 - $250 USD
Total Bids
Project Description

Dear Professionals,

I am building a new EC site.

I will retrieve products' data from

Then, I will upload the data by using Magmi, so I need to convert CSV file.

By using Macro/API, please convert CSV file from Amazon MWS API format to Magento/Magmi format automatically.

The CSV file will be updated everytime I upload the file.

The items include Configurable Products with Size/Color options and multiple images.

You may need to know Amazon MWS API to retrieve data from Amazon.

I am looking for a person who knows Amazon MWS API and Magmi format very well.

Amazon MWS

[url removed, login to view]

Required skill: API, Macro, Experience of Amazon Marketplace Web Service (Amazon MWS), Amazon API, Knowledge of Magento/Magmi


I will sell products which are sold at

Then, I would like to upload amazon item data to my website via Magmi.

I have attached a excel file with macro.

[url removed, login to view] is a sample file for [url removed, login to view] which uses Amazon API.

[url removed, login to view] is file for

[url removed, login to view] is a brief instruction of mwsjapan.

Please try to think how the item data can link with the Magmi CSV.

I prefer to convert my amazon data to a Magmi format automatically.

Please let me know how you can do it.

These are my requirements for this project.

You will make a macro(programming), and I will convert/upload a CSV by myself.

1. I will only provide ASIN. The file should output all required fields for Magmi without errors, if I enter ASIN.

2. It should calculate price automatically. (from Japanese yen to US dollars) the rate will be changed every week.

3. It should support Configurable Products (size/color options).

4. It should support multiple images/media_gallery.

5. Can I use Japanese characters in the Magmi field? If not, you can retrieve English data from [url removed, login to view]'s same ASINs.


I will send you some more files.

Please ask any question as many as you have.

Thank you



Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online