eBay Data to Google Sheets to Create AppSheet Inventory Management App

[squareapp_28]

Hi,

Is it possible to connect an eBay account's active listings to Google Sheets?

I want to send active listing/live stock data to a Google Sheet and then create an inventory management app via AppSheet. I currently have this set up but the inventory on the Google Sheet is dependent upon manual updates every time an item sells on eBay.

I know I could manually update the stock levels via the AppSheet app every time a sale occurs. However, I'm not using the app as a pick/pack order inventory app so this isn't really an option. I'm currently only using the app for stock-taking purposes and utilizing the Scandit Barcode AppSheet capabilities to scan SKU labels with product data.

I'm of the understanding an eBay API will be required to pull the account data. I think CData has an ODBC driver that looks to do what I'm after but I'm not exactly sure if it's the right fit.

Does anyone have any ideas on how to link live eBay data to Google Sheets and then create an AppSheet Inventory management app for stock taking purposes?

Thanks in advance for any advice provided, it is greatly appreciated

[developer_support@ebay]

Hi @squareapp_28 

To download price and quantity information for all or a subset of your active listings, use the the createInventoryTask method with the feed type LMS_ACTIVE_INVENTORY_REPORT, along with the getResultFile method. The SKU details include ItemID and/or SKU, Price, Quantity, and SiteID.

For more information, please see "Overview of active inventory report flow" here.