Datapipe
Start free

Ecommerce · USE CASE

Know what needs a stock check.

Find Shopify products below your chosen threshold before planning the next promotion.

Shopify
Try it with your data Free with up to 3 data sources · No credit card
A WORKED EXAMPLE
Products to check today
Everyday toteCheck stock8 → Below 10
Desk organizerCheck stock3 → Below 10
Canvas pouchAbove threshold42 → Below 10
Current inventory · illustrative capture Nov 8, 2026

Two products fall below the example threshold of 10.

EXAMPLE CONVERSATION

Your question.
A useful answer.

✦ AI assistant
Shopify
YOU

  1. 01
    Shopify · Current product inventoryReview first

    Next

  2. 02
    Shopify · Current product inventoryCheck before promotion

    Next

Current inventory · Example review

01 · CONNECT YOUR DATA

Your tools. One place to ask.

1 of 3 Free data sources
No credit card · Daily refresh

Shopify
DatapipeYour project
Your AI assistantor a report in Sheets / Data Studio
  1. Create your free workspace

    Sign up with your company email. Your first project opens on Data sources.

  2. Add your data source

    Choose the accounts for this workflow. Authorize access and select the property or site.

  3. Bring your question

    Connect your project to a supported AI assistant, or build your source reports.

Create a free account →
Setup steps & what you need

Email/password signups confirm their email first. Use Google signup with a company account if you prefer.

  • Shopify: Enter your shop, authorize it, and add that store to the project. Setup guide ↗

Free includes 3 data sources across the workspace. One account/property added to one project counts as one. Extra properties or the same account in another project use another slot.

02 · ASK A USEFUL QUESTION

Start with a prompt.
Follow the evidence.

Copy these in order into your connected assistant.
Each builds on the answer before it.

01

Build today’s low-stock list

Read the full prompt
Use only this Datapipe project’s authorized data sources. Discover the connected accounts, datasets, and fields first. If the right account or required data is missing, ask me rather than substituting sample data. Show the actual dates, filters, coverage, and any partial results.

From this project’s connected Shopify store, list current products with total inventory below 10. Return product ID, title, status, and total inventory, plus the capture time. Ten is my chosen review threshold, not a demand forecast. Do not reconstruct historical stock from current values.
02

Check the inventory context

Read the full prompt
For the shortlisted products, inspect available variant and location datasets. Ask for a specific location if the dataset requires it. Keep product totals distinct from location-level availability and flag missing stock context.
03

Prepare a promotion stock check

Read the full prompt
Create a review list for the shortlisted products: observed stock, variants/locations to check, and missing demand or fulfillment information. Do not infer sales velocity from a single snapshot or place orders or change inventory.
Need to connect your assistant?Claude guide ↗ChatGPT guide ↗

03 · USE WHAT YOU FIND

Check availability before planning the next promotion.

  1. 01

    Read current product inventory from the connected store.

  2. 02

    Apply the threshold that makes sense for your business.

  3. 03

    Check the relevant locations and variants before taking action.

Check the result at your next review.

Repeat the current-state review at a useful cadence. Historical stock movement or demand forecasts need appropriate historical and sales data; a single current snapshot cannot supply them.

Implementation tips for this use case

Choose a threshold suited to the business and check the relevant locations, variants, and fulfillment rules. Use the list in your promotion or replenishment review rather than treating it as an automatic purchase order.

WHEN YOU NEED MORE CONTEXT

Go a little deeper.

The method and reporting checks
behind this example.

How to find products below your stock threshold

  1. Read the connected store’s current products.

    Choose the Shopify current-products dataset, product identity, and native total inventory. The current state is not a historical stock record.

  2. Apply your business threshold.

    Choose a threshold such as fewer than 10 units. Keep this a user-selected operational filter rather than a predicted stockout date.

  3. Check variants and locations before acting.

    Use the relevant location/variant reporting where needed. Review availability and demand separately before ordering stock or changing a promotion.

See the complete example report
EXAMPLE REPORTFictional sample data

Products to check today

Current inventory · illustrative capture Nov 8, 2026

Products to check today · fictional sample data
ProductInventoryYour thresholdCheck
Everyday tote8Below 10Check stock
Desk organizer3Below 10Check stock
Canvas pouch42Below 10Above threshold
WHAT TO LOOK ATTwo products are below the example threshold of 10.

Check availability before planning the next promotion.

Illustrative report output · no live query or source change

The tote and desk organizer are below the threshold you chose. Inspect variants and location-level availability before making replenishment or promotion decisions.

Try the example with sample CSVs

Fictional rows matching the example above. Attach these files to your assistant for a sample analysis.

Data method, reporting checks & sources

Use the Shopify current-products dataset and native total inventory. This is a current-state check, not historical stock reconstruction or a demand forecast.

Inventory is not sales velocity or a promise of fulfillment availability. Product totals and location-level availability have different grains. No purchase order or stock adjustment is created.

  • Stock values are current and timestamped.
  • The threshold is explicit and appropriate for this business.
  • Location and variant checks are separate from product-level totals.
  • An authorized Shopify store with inventory read access.
  • Your own stock threshold and a separate location/variant check where needed.

For blended reports, align dates, normalized URLs, and reporting grain. Query-level search rows must not duplicate page-level sessions. This is an illustrative workflow; live accounts and destinations need their own setup.

Report starting points ↗

A FEW USEFUL ANSWERS

Before you start.

Is total product inventory the same as what is available at one location?

No. Product totals, variant stock, and location-level availability have different contexts. Check the dataset relevant to fulfillment before making a decision.

Can this predict when I will run out?

Not from this sample. A forecast needs demand, sales velocity, lead times, and suitable historical data. This use case is a current threshold check.

YOUR NEXT STEP

Try it with your own data.

Start free with up to 3 data sources. No credit card.

Start free →

What else are you working on?

Browse all use cases →
SEO & content · 3 data sources

Which pages work on Google but struggle on Bing?

Compare Search Console and Bing page performance, then use WordPress content to choose the next investigation.

Search ConsoleBing WebmasterWordPress
See the example SEO & content · 3 data sources

Should we refresh a page or write something new?

Combine Search Console, current WordPress content and a Google Sheet of DataForSEO research to decide what deserves a brief.

Search ConsoleWordPressGoogle Sheets
See the example