Closed

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
9
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
[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 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.
[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 amazon.co.jp.
[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
NOVITA
Kumagai

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