Getting eBay inventory quantities from an active listings report

Sellercloud automatically requests active listings reports from eBay, and you can use that report to see the inventory currently listed there. The report is in XML format, making it easy for the computer to read, but if you want to view it in Excel, follow these steps:
  1. Download the report from your Sellercloud account by going to Settings > Company Settings > Company Name > eBay Settings > Large Merchant Service Jobs.
  2. Click “Request New Report” and select Active Inventory.
  3. When job is completed, click the response link from the grid.
  4. Open the XML file directly in Excel, but if there are variation listings, it won’t open easily. Instead you will need to convert the XML file to CSV. This can be done by downloading an executable from http://xmltocsv.codeplex.com/.
  5. The single XML translates to a group of CSV files. The files Variation.csv and SKUDetails.csv contain the SKU and Quantity values.

Was this article helpful?

Related Articles