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

CLOSED
Bids
9
Avg Bid (USD)
$433
Project Budget (USD)
$30 - $250

Project Description:
Dear Professionals,

I am building a new EC site.

I will retrieve products' data from amazon.co.jp.
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
https://developer.amazonservices.com/

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 amazon.co.jp.
Then, I would like to upload amazon item data to my website via Magmi.

I have attached a excel file with macro.
mwsusa.xlsm is a sample file for amazon.com which uses Amazon API.
mwsjapan.xlsm is file for amazon.co.jp.
mwssample.png 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 Amazon.com's same ASINs.

-----------------------------------------------------------------------------------------
I will send you some more files.
Please ask any question as many as you have.

Thank you
NOVITA
Kumagai

Skills required:
Amazon Web Services, Magento, MySQL, PHP, Software Architecture
Additional Files: mwsusa.xlsm mwsjapan.xlsm mwssample.png
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 206
in 5 days
$ 567
in 12 days
Hire iclicknetwork
$ 526
in 5 days
$ 329
in 10 days
$ 515
in 5 days
$ 421
in 8 days
$ 603
in 15 days
$ 315
in 5 days
$ 412
in 15 days