This should be a simple project for anyone familiar with Restful API and excel. I need to be able to import products that I have access to through a rest API (with authorization). Basically, I need these products and all the detail in a CSV file so I can mass edit them then import them to Magento.
It is a basic Restful API using JSON OR XML. I will need all the product information fields to populate into the CSV file; I will edit the ones I do not need in excel. I would also like the option to import by specific parameters. For example, if I want all products under $1. There are close to 1,000,000 products, so I would need some way to filter them for import.
All fields for the product detail need to be import into the CSV file. Its important that all available data is populated. One of the import details is the quantity. These products have different prices for difference quantities (Example, 200 @ $1.50, 250 @$1.20, 300 @$1.10). The data needs to be a readable format in excel. Example output data from the API will added as a file
My budget is $150 on this project. Please let me know if you have any questions. I will give you access to the API after accepting the project. Any coding that is written for my server or otherwise will need to come with detailed instructions.
For those who are interested, please look at the file I uploaded before contacting me. The file shows the data I am retrieving and what needs to be parsed out into the CSV file. As you can see from the file, there are some product attributes like color, prices, price per quantity, etc that needs to retrieved. Thanks!
20 freelancers are bidding on average $154 for this job
I can do it in Python as either a simple script or web application, if you want. I am very familiar with REST APIs and have done similar projects in the past. You can have your data in csv or also xls.
HI, I have the complete xml to csv and reverse feed solution ready. Only need to customize a bit. I have already done exactly same for 3 customers and it is proven and big free as based on open standards,