Export from Amazon MWS to CSV
Hi All, my company purchased Celigo primarily to integrate Amazon with NetSuite. However, I'm wondering if I can use Celigo to pull more comprehensive exports for Amazon inventory data into a CSV rather than directly to NetSuite for a Amazon clean-up project I'm working on. Amazon Seller Central doesn't include all item details when exporting reports, and I'm hoping to automate it rather than have to get all of the data manually. I set up the connector to Amazon MWS, but all I'm seeing is Resource: Orders: OrderRetrieval and nothing inventory related. I also was able to point the destination as an FTP/CSV file, so that seems workable. Does anyone know if this is the sort of thing Celigo can be used for? And how I might get additional Amazon MWS "Resource" options?
Comments
Hi Adam,
The Amazon MWS "Form View" has limited resources as you said but you can switch the "Form View" to HTTP to pull any Amazon report. Is there a specific report for Inventory you are looking to pull?
Thanks for responding! The Amazon inventory reports don’t seem to have full inventory details (bullet points, weights, dimensions, keywords, etc) and was curious if that could be pulled using Celigo and the API. The fact the “resources” section of the export is limited to orders seems to point to no, but I figure it was worth asking!
If the Amazon API allows, you can definitely pull the information.
Here's a suggestion on how you can approach this:
Please sign in to leave a comment.