Retrieve inventory with php and MWS

About

Asked 19/4, 2012 at 19:56 Answered 28/9, 2015 at 22:41

Solved php amazon-web-services inventory amazon-mws

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

Sacellum answered 19/4, 2012 at 19:56 Comment(0)

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.

Olszewski answered 8/5, 2012 at 13:43 Comment(14)

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. – Sacellum 8/5, 2012 at 18:20

as you can see in the api reference (images-na.ssl-images-amazon.com/images/G/01/mwsportal/doc/en_US/…) 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) – Olszewski 9/5, 2012 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? – Sacellum 9/5, 2012 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. – Olszewski 10/5, 2012 at 9: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 – Sacellum 10/5, 2012 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. – Olszewski 10/5, 2012 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 – Sacellum 10/5, 2012 at 14:24

read that: images-na.ssl-images-amazon.com/images/G/01/mwsportal/doc/en_US/… - if no ReportType (page 51) returns a picture url, you need to scrape the picture urls from the amazon web page (en.wikipedia.org/wiki/Web_scraping) – Olszewski 10/5, 2012 at 15:3

Ok, I think must do it using Web_scraping but for titles? I need to get at least titles how? – Sacellum 10/5, 2012 at 15:14

uuh ... i need a lot of patience for you :D use ReportType = _GET_MERCHANT_LISTINGS_DATA_ for the title. – Olszewski 10/5, 2012 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... – Blistery 8/1, 2013 at 5: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. developer.amazonservices.com/gp/mws/… – Olszewski 8/1, 2013 at 8: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 – Blistery 8/1, 2013 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. – Olszewski 8/1, 2013 at 12:39

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)

Kwangchow answered 28/9, 2015 at 22:41 Comment(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.

Midget answered 20/4, 2012 at 20:0 Comment(4)

And did you know any way to do this? Anyway MWS allows me to update and retrieve invetory or no? – Sacellum 20/4, 2012 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. – Midget 21/4, 2012 at 12:54

- developer.amazonservices.co.uk/doc/bde/feeds/v20090901/php.html - developer.amazonservices.co.uk/gp/mws/docs.html - amazonsellercommunity.com/forums/forum.jspa?forumID=43 – Midget 21/4, 2012 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? – Sacellum 23/4, 2012 at 15:4

Hot tags

Godot Unity Godot Help Programming Godot 4.X GUI GDScript 3D 2D Physics CSharp Godot 3.X VR XR Projects C++

Recommended topics

Hot tags