6

I need to create a PHP script that retrieve and update my inventory from and to Amazon into my personal web page. Can this be done with MWS or any WS? And also need to show in the front of my site all the products I have in Amazon and show a link for users to buy this items trough Amazon.

Any help?

Cheers and many thanks in advance

hakre
  • 193,403
  • 52
  • 435
  • 836
ReynierPM
  • 17,594
  • 53
  • 193
  • 363

3 Answers3

8

yes.

use the amazon mws api, specifically the Reports section here

You should request (via RequestReport) an "Open Listings Report". Amazon will give you some minutes later a CSV with all your listings with SKU, ASIN, quantity and price.

When you want to display those listings, you need to display them for yourself. you could link to the ASINs with some pictures, so maybe you need to get those pictures and titles for yourself (maybe with another ReportType).

You can play around with that API in the Amazon MWS Scratchpad.

Stefan
  • 2,028
  • 2
  • 36
  • 53
  • Ok, I've play with Scratchpad but my question is when or where is the results submited? I get Response (200) so seems to be OK but I can't see any downloable file or so. – ReynierPM May 08 '12 at 18:20
  • 1
    as you can see in the api reference (https://images-na.ssl-images-amazon.com/images/G/01/mwsportal/doc/en_US/bde/MWSReportsApiReference._V148508614_.pdf) you need to first `RequestReport`, then check the status with `GetReportRequestList` (look out for the RequestID), and if finished get the result with `GetReport` (look out for the ReportID returned by the request list) – Stefan May 09 '12 at 10:15
  • Ok I get the report now but it's in flat and not in CSV as you said before also only sku, asin, price, quantity is showed. How can I get images, titles and so on for those products? – ReynierPM May 09 '12 at 21:31
  • refer to the `ReportType` in the above stated api reference :) the flat file is a CSV file (if you downloaded it, you'd name it `*.csv`) - it is tab separated. – Stefan May 10 '12 at 09:48
  • Sure, you're right now what about get images and title and other data based on ASIN? I assume that ASIN is like a unique identifier I haven't experience with MWS or any Amazon WS – ReynierPM May 10 '12 at 12:22
  • you must request another `ReportType` which contains the picture url. if there's no picture url, you need to scrape the product pages. – Stefan May 10 '12 at 14:15
  • Hmmm and where I found that ReportType? I was looking at Scratchpad and none reports sound like return picture URL and titles – ReynierPM May 10 '12 at 14:24
  • read that: https://images-na.ssl-images-amazon.com/images/G/01/mwsportal/doc/en_US/bde/MWSReportsApiReference._V148508614_.pdf - if no `ReportType` (page 51) returns a picture url, you need to scrape the picture urls from the amazon web page (https://en.wikipedia.org/wiki/Web_scraping) – Stefan May 10 '12 at 15:03
  • Ok, I think must do it using Web_scraping but for titles? I need to get at least titles how? – ReynierPM May 10 '12 at 15:14
  • uuh ... i need a lot of patience for you :D use `ReportType` = `_GET_MERCHANT_LISTINGS_DATA_` for the title. – Stefan May 10 '12 at 15:46
  • Hey... @steve i have test with _GET_MERCHANT_LISTINGS_DATA_ type but thid dose not provice image-url... although it has it has a column for it... – Ravi Soni Jan 08 '13 at 05:59
  • @ravisoni you're right. that bugs me too. i worked around that by calling the (deprecated) product advertising api. i think the MWS Product API would be better suited for that. https://developer.amazonservices.com/gp/mws/api.html?section=products&group=products&version=latest – Stefan Jan 08 '13 at 08:31
  • @steve thanks for yoru comment ... Can i use product API for inventory Download... actually i have no previous experience with MWS or other API so please suggest what is right to do i just want to export the full inventory in any format with all possible data.. thanks – Ravi Soni Jan 08 '13 at 10:11
  • no, product API is for retrieving information about products, i.e. title, pictures, product codes, etc. this has nothing to do with your stock. retrieve it via the reports API, like you said with GET_MERCHANT_LISTINGS_DATA for example. – Stefan Jan 08 '13 at 12:39
1

For anyone using Amazon FBA; use the Fulfillment Inventory API: http://docs.developer.amazonservices.com/en_US/fba_inventory/

(at least; to retrieve your current inventory; maybe not 100% what questioner was asking for, but I arrived at this page few years later looking for the same thing but with FBA)

Arthur
  • 584
  • 6
  • 14
0

Amazon MWS is only for creating new products and syncing it to your amazon seller central or changing price automatic from your website or to get reports or order processing. I dont think you can display an amazon shop on your website using.

Keyur Padalia
  • 1,118
  • 2
  • 12
  • 18
  • And did you know any way to do this? Anyway MWS allows me to update and retrieve invetory or no? – ReynierPM Apr 20 '12 at 23:36
  • yes it does allow to retrieve quantity and to update quantity For This you will need Amazon Premium Seller Account and need to register for Amazon MWS API Keys. And you will need to learn FEEDs API, Reporting API to do this. The Below Given Links may help you. and they are for PHP Only. – Keyur Padalia Apr 21 '12 at 12:54
  • - https://developer.amazonservices.co.uk/doc/bde/feeds/v20090901/php.html - https://developer.amazonservices.co.uk/gp/mws/docs.html - http://www.amazonsellercommunity.com/forums/forum.jspa?forumID=43 – Keyur Padalia Apr 21 '12 at 12:56
  • Hmm this content seems to be outdated or maybe I didn't realize how to do that. Is there any pay support from Amazon? – ReynierPM Apr 23 '12 at 15:04