Shopify Inventory Level at Location

SylvP

Hi everybody, I'm looking at a solution to retrieve the inventory levels of my products in Shopify.

Any idea on how to do it without using an external connector?

Thanks

MarkSnodgrass

Did you try the Shopify Quickstart App in the Domo App Store?

SylvP

Yes, but it's the available inventory cross-location.

smenten

seconded here - inventory by location by variant SKU is a need (cross-location//total inventory by product is pretty irrelevant in our case)

German_Rodriguez

Looking for the same

DMJerry

Did anyone find an answer to this minus going direct to the API and not the DOMO connector?

ArborRose

I'm not sure what you are looking for @DMJerry. I thought the responses gave insight into solutions.

Shopify has an API that can be called with Domo's API connectors, or through a custom connector.

• Create a Shopify Private App (or API credentials):
  • Go to your Shopify admin.
  • Navigate to Apps -> Develop apps.
  • Create a new app, and under Admin API Permissions, make sure to allow read access to Inventory and Products.
  • Once the app is created, you'll be given the API key and password (or access token for a public app).

• Use Shopify API to Retrieve Inventory Levels:
  • Shopify has an API endpoint to fetch inventory levels for products. The key endpoints you'll use are:
    • GET /admin/api/2023-01/products.json: To retrieve the list of products.
    • GET /admin/api/2023-01/inventory_levels.json: To get inventory levels for each product variant.
  • You can use tools like Postman to test the API and get familiar with the structure of the data you'll retrieve.

ArborRose

Note: I think Shopify has rate limits of something like 2 requests/second.