Ask ChatGPT Which Shopify Products Are Low on Stock

Q: Can ChatGPT change my inventory with this workflow?

No. This workflow only reads variant stock counts. ChatGPT can see what it returns, but it has no tool here that adjusts inventory or edits products.

Q: Does the threshold count stock at every location?

Yes. The inventory quantity filter uses each variant's total available stock across your locations. To check one location, change the query to read inventory levels at that location instead.

Q: Do I have to set up ChatGPT again for each new MCP workflow?

No. You add your MESA MCP server to ChatGPT once. Every MCP workflow you turn on after that shows up as another tool ChatGPT can call.

2 min setup

No coding required

Runs automatically

Checking stock means opening the Shopify inventory page and sorting by quantity every time someone asks what needs reordering. This workflow gives ChatGPT one MCP tool: when you ask about low stock in a chat, ChatGPT passes a quantity threshold to MESA, MESA looks up every Shopify variant at or below it, and ChatGPT answers with the products, SKUs and counts that need attention.

Use this template → Related article

AI Skill triggered (Trigger)

Shopify GraphQL Query

How it works

2 steps to ask ChatGPT what's running low in your Shopify store and get answers from live inventory

App connector: AI • Time to complete: 1 minute

Name the workflow 'List Low Stock Shopify Variants' and describe it as returning Shopify product variants whose total available inventory is at or below a threshold. Add parameters: threshold (a whole number, required, described as the highest stock count to include) and limit (optional whole number, described as the most variants to return, default 50).

App connector: Shopify • Time to complete: 1 minute

Run a productVariants query with the search filter inventory_quantity:<= set from the threshold parameter and first set from limit, sorted by inventory quantity ascending. Return only each variant's product title, variant title, SKU, and inventoryQuantity, so a large catalog doesn't overflow the response.

Trusted by 1,000+ merchants

Ready to ask ChatGPT what's running low in your Shopify store and get answers from live inventory

Get setup in 2 minutes.

Use this template →

FAQs

Can ChatGPT change my inventory with this workflow?

No. This workflow only reads variant stock counts. ChatGPT can see what it returns, but it has no tool here that adjusts inventory or edits products.

Does the threshold count stock at every location?

Yes. The inventory quantity filter uses each variant's total available stock across your locations. To check one location, change the query to read inventory levels at that location instead.

Do I have to set up ChatGPT again for each new MCP workflow?

No. You add your MESA MCP server to ChatGPT once. Every MCP workflow you turn on after that shows up as another tool ChatGPT can call.

Personalize this template

Customize this workflow even further:

Filter by vendor or product type

Add a vendor or product_type parameter and include it in the search filter so ChatGPT can check stock for one supplier before you place an order with them.

Include the reorder cost

Return each variant's unit cost from its inventory item so ChatGPT can estimate what a restock will cost.

"MESA has been a game changer for us. And, if you ever get stuck, their support team is always super helpful."

PetFriendly

"It's like Zapier but exactly designed for Shopify. I have been able to complete all the workflows that I've needed."

Zailys

"The MESA team has been amazing at helping us set up our automations. We would highly recommend this app!"

Rothy's

ask ChatGPT what's running low in your Shopify store and get answers from live inventory

2 min setup • Fully supported if you need help