Ecommerce · USE CASE

Find Google Shopping products whose stock or price doesn’t match Shopify.

Compare what Google Merchant Center holds for each product with the variant in your Shopify store. See which products Google lists as out of stock while you have units, which still look available on Google after selling out, and whose Google price differs from your store, ranked by the clicks each product gets.

Data sources
Assistant
Destination
Try it with your data Free with up to 3 data sources · No credit card
A WORKED EXAMPLE

Which Google Shopping products show a different stock level or price than our Shopify store?

ProductGoogleShopifyClicks, 28 days
Trail Bottle 750 mlOut of stock46 in stock412
Rain Shell$149.00$129.00301
Camp MugIn stockSold out236

Clicks Oct 19–Nov 15, 2026 · Product status, stock and prices read Nov 16, 19:00 UTC

6 products in the Merchant Center account need a look, and together they had 1,151 of its 2,033 product clicks from Oct 19–Nov 15. Google lists the Trail Bottle 750 ml as out of stock while Shopify has 46 units. The Rain Shell is $149.00 on Google but $129.00 in the store, and the Camp Mug and the black Trail Pack 22L still show as in stock on Google after selling out. Two more need attention in Merchant Center, and the Camp Chair is active in Shopify but not in Merchant Center at all.

WHERE THE RESULT GOES

Google Sheets

Export each data source report to Google Sheets, then add your analysis or checklist to the review Sheet.

Example use case

Ask. Follow up.
Take the next step.

✦ AI assistantSample use case
Merchant CenterShopify
YOU

  1. 01
    412 clicks in 28 days · Click potential high · Shopify variant updated Nov 12Check the product sync first

    Next

  2. 02
    301 clicks in 28 days · Approval status eligible limited · 1 item issueFix the price Google has

    Next

  3. 03
    333 clicks in 28 days · Both tracked at 0 units · Approval status eligibleRestock or update availability

    Next

Clicks Oct 19–Nov 15, 2026 · Product status, stock and prices read Nov 16, 19:00 UTC

01 · CONNECT YOUR DATA

Your tools. One place to ask.

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

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 the data sources

    Choose the accounts for this use case. 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.

  • Merchant Center: Sign in with Google and choose the Merchant Center account whose products you want to review. Datapipe reads product status and performance without changing anything. Setup guide ↗
  • 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

Find the datasets and check how products are identified

Read the full prompt
Use only this Datapipe project’s authorized data. Discover the connected accounts, datasets and compatible fields first. Confirm dates, timezones, currencies and data coverage. Keep missing or unmatched rows visible; never substitute sample data. Compare the sources explicitly and explain every match. Do not change source records or send messages.

From the connected Merchant Center account, show me the datasets and fields available, then read Product status with Product ID, Product title, Price, Currency, Availability, Approval status, Item issues and Click potential. From the connected Shopify store, read Product variants (GraphQL) with Shopify ID, Legacy ID, Product ID, Product title, Variant title, SKU, Price (store currency), Compare-at price (store currency), Store currency, Inventory quantity, Inventory item ID and Updated at. Show me ten Merchant Center Product IDs and tell me whether they look like shopify_<country>_<product ID>_<variant ID>, match Shopify SKUs, or follow another pattern. Do not match on product titles. If the IDs follow a pattern you can’t match exactly, stop and ask me how our feed builds them.
02

Read stock, tracking, status and clicks

Read the full prompt
Now read Shopify Inventory items with Shopify ID, SKU and Inventory tracked, and Products (GraphQL) with Legacy ID, Product title and Status. From Merchant Center, read Product performance for the last 28 complete days with Product ID, Product title, Clicks and Impressions; its dates follow the Merchant Center account’s time zone. Join each variant to its inventory item by Inventory item ID and to its product by Product ID. Tell me how many Merchant Center products match a Shopify variant, how many don’t, how many active Shopify variants have no Merchant Center product, and whether any Product ID appears more than once. Treat in_stock, in stock and IN_STOCK as the same value. Product status and Shopify stock are current; say so next to the click dates.
03

Prepare the product review list for this week

Read the full prompt
Build one list of products to review, sorted by 28-day clicks. Include: Merchant Center products whose Availability is out of stock while Shopify has tracked units or doesn’t track stock; products that are in stock in Merchant Center while Shopify tracks 0 or fewer units; products whose Merchant Center Price differs from Price (store currency) when the Currency equals Store currency and Compare-at price is empty; products whose Approval status is NOT_ELIGIBLE_OR_DISAPPROVED, with their Item issues count; Merchant Center products with no matching Shopify variant; and active Shopify variants with no Merchant Center product. For each, show both values side by side, the clicks and Click potential, and a suggested owner. List products in another currency and products with a compare-at price separately rather than calling them mismatches. Show how many clicks the listed products had out of the account total. Draft this in our conversation; do not change anything in Shopify or Merchant Center.

03 · USE WHAT YOU FIND

Match each product, compare stock and price, and review the gaps by clicks.

  1. 01

    Read what Google holds for each product in Merchant Center.

  2. 02

    Read the matching variants, inventory tracking and product status from Shopify.

  3. 03

    Match each product, compare stock and price, and review the gaps by clicks.

Check the result at your next review.

After the fixes, read Merchant Center Product status again the next day and check that the Trail Bottle 750 ml shows in stock, the Rain Shell shows $129.00 without the item issue, and the Camp Mug and black Trail Pack 22L show out of stock unless they were restocked. Then compare clicks for the Trail Bottle 750 ml over the next 14 days with its recent run, and repeat the full check every week so new gaps are caught early.

Implementation tips for this use case

Look at a few Merchant Center Product IDs first. Stores that use Shopify’s Google & YouTube sales channel usually see IDs like shopify_US_8101_4501, ending in the Shopify product ID and variant Legacy ID; other feeds often use the SKU. Match on whichever your account uses and list anything that doesn’t match. Then compare availability with tracked stock, and price with the store price when the currency is the same and there is no compare-at price. List products that Google says are not eligible, products in Merchant Center with no Shopify variant, and active Shopify variants missing from Merchant Center. Sort by clicks and take the list to the weekly ecommerce review, where the store team and whoever manages Merchant Center agree who fixes each item.

WHEN YOU NEED MORE CONTEXT

Go a little deeper.

The method and reporting checks
behind this example.

How to match Merchant Center products to Shopify variants and review stock and price gaps
  1. Read what Google holds for each product in Merchant Center.

    Add the Merchant Center account and the Shopify store to one project. From Merchant Center, read Product status with Product ID, Product title, Price, Currency, Availability, Approval status, Item issues and Click potential. It is the current state of each product, and report dates don’t apply. Then read Product performance for the last 28 complete days with Product ID, Product title, Clicks and Impressions. Its dates follow the Merchant Center account’s time zone, and its clicks combine free listings and Shopping ads. Item issues is a count; the issue text stays in Merchant Center.

  2. Read the matching variants, inventory tracking and product status from Shopify.

    From Shopify, read Product variants (GraphQL) with Shopify ID, Legacy ID, Product ID, Product title, Variant title, SKU, Price (store currency), Compare-at price (store currency), Store currency, Inventory quantity, Inventory item ID and Updated at. Read Inventory items with Shopify ID, SKU and Inventory tracked, and Products (GraphQL) with Legacy ID, Product title and Status. All three are the store’s current records. Inventory quantity is the variant’s total across locations, and it only means sold out when stock is tracked.

  3. Match each product, compare stock and price, and review the gaps by clicks.

    Look at a few Merchant Center Product IDs first. Stores that use Shopify’s Google & YouTube sales channel usually see IDs like shopify_US_8101_4501, ending in the Shopify product ID and variant Legacy ID; other feeds often use the SKU. Match on whichever your account uses and list anything that doesn’t match. Then compare availability with tracked stock, and price with the store price when the currency is the same and there is no compare-at price. List products that Google says are not eligible, products in Merchant Center with no Shopify variant, and active Shopify variants missing from Merchant Center. Sort by clicks and take the list to the weekly ecommerce review, where the store team and whoever manages Merchant Center agree who fixes each item.

See the complete example report
EXAMPLE REPORT

Which Google Shopping products show a different stock level or price than our Shopify store?

Clicks Oct 19–Nov 15, 2026 · Product status, stock and prices read Nov 16, 19:00 UTC

Which Google Shopping products show a different stock level or price than our Shopify store?
ProductGoogleShopifyClicks, 28 days
Trail Bottle 750 mlOut of stock46 in stock412
Rain Shell$149.00$129.00301
Camp MugIn stockSold out236
WHAT TO LOOK AT6 products in the Merchant Center account need a look, and together they had 1,151 of its 2,033 product clicks from Oct 19–Nov 15. Google lists the Trail Bottle 750 ml as out of stock while Shopify has 46 units. The Rain Shell is $149.00 on Google but $129.00 in the store, and the Camp Mug and the black Trail Pack 22L still show as in stock on Google after selling out. Two more need attention in Merchant Center, and the Camp Chair is active in Shopify but not in Merchant Center at all.

Match each product, compare stock and price, and review the gaps by clicks.

This was the account’s second most clicked product over the 28 days, with 412 clicks. Merchant Center now holds its availability as out of stock, but the matching Shopify variant (SKU TB-750) has 46 tracked units and was last updated on Nov 12. The read shows the gap, not its cause. Google may not have processed the latest store data yet, or the update may not have reached Merchant Center. The US product in Merchant Center has a price of $149.00, while the Shopify variant (SKU SHELL-01) is $129.00 with no compare-at price, so this is not a sale price. The Shopify variant was last updated on Nov 10. Google already reports 1 item issue and limited eligibility for this product. Google requires the price to match the product page, and a mismatch can lead to disapproval. The Canadian listing (189.00 CAD) is listed separately because the store price is in USD. Google still lists both products as in stock, but Shopify tracks 0 units for SKU MUG-12 and SKU PACK-22-BLK. Together they had 333 clicks over the 28 days, so shoppers may be reaching product pages they cannot buy from. Shopify’s variant read does not include whether a product keeps selling when out of stock, so check that setting before treating these as errors. The Trail Map Poster also shows 0 units, but its stock isn’t tracked because it is printed to order, so it is not on the list.

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

Add the Merchant Center account and the Shopify store to one project. From Merchant Center, read Product status with Product ID, Product title, Price, Currency, Availability, Approval status, Item issues and Click potential. It is the current state of each product, and report dates don’t apply. Then read Product performance for the last 28 complete days with Product ID, Product title, Clicks and Impressions. Its dates follow the Merchant Center account’s time zone, and its clicks combine free listings and Shopping ads. Item issues is a count; the issue text stays in Merchant Center. From Shopify, read Product variants (GraphQL) with Shopify ID, Legacy ID, Product ID, Product title, Variant title, SKU, Price (store currency), Compare-at price (store currency), Store currency, Inventory quantity, Inventory item ID and Updated at. Read Inventory items with Shopify ID, SKU and Inventory tracked, and Products (GraphQL) with Legacy ID, Product title and Status. All three are the store’s current records. Inventory quantity is the variant’s total across locations, and it only means sold out when stock is tracked. Look at a few Merchant Center Product IDs first. Stores that use Shopify’s Google & YouTube sales channel usually see IDs like shopify_US_8101_4501, ending in the Shopify product ID and variant Legacy ID; other feeds often use the SKU. Match on whichever your account uses and list anything that doesn’t match. Then compare availability with tracked stock, and price with the store price when the currency is the same and there is no compare-at price. List products that Google says are not eligible, products in Merchant Center with no Shopify variant, and active Shopify variants missing from Merchant Center. Sort by clicks and take the list to the weekly ecommerce review, where the store team and whoever manages Merchant Center agree who fixes each item.

Merchant Center products are matched to Shopify variants by product and variant ID or by SKU, never by title, and unmatched products stay on the list. A product counts as sold out only when Shopify tracks its stock and the quantity is 0 or less. Prices are compared only in the store currency and only when the variant has no compare-at price. Product status and stock are current; clicks cover the 28 complete days before the read in the Merchant Center account’s time zone.

  • Merchant Center products are matched to Shopify variants by product and variant ID or by SKU, never by title, and unmatched products stay on the list.
  • A product counts as sold out only when Shopify tracks its stock and the quantity is 0 or less.
  • Prices are compared only in the store currency and only when the variant has no compare-at price.
  • Product status and stock are current; clicks cover the 28 complete days before the read in the Merchant Center account’s time zone.
  • Access to the intended Merchant Center account or property.
  • Access to the intended Shopify account or property.
  • Merchant Center products are matched to Shopify variants by product and variant ID or by SKU, never by title, and unmatched products stay on the list.

For blended reports, align dates, normalized URLs, and reporting grain. Query-level search rows must not duplicate page-level sessions.

A FEW USEFUL ANSWERS

Before you start.

Why do I need both Merchant Center and Shopify?

Merchant Center shows what Google has for each product: availability, price, approval status and clicks. Shopify shows what the store actually has. A mismatch only appears when you put the two side by side, and the clicks from Merchant Center tell you which ones to fix first.

How are products matched?

By ID, never by title. Stores that use Shopify’s Google & YouTube sales channel usually have Merchant Center product IDs that end in the Shopify product ID and variant ID. Other feeds often use the SKU. The first prompt checks which pattern your account uses before anything is compared.

Does a sale price count as a price mismatch?

Not automatically. Google expects the regular price in the price attribute and the sale price separately. When a Shopify variant has a compare-at price, the product is listed separately so someone can check both prices in Merchant Center.

Why isn’t a product with 0 units always flagged?

If Shopify doesn’t track stock for a variant, its quantity stays at 0 even though it can be sold, as with a made-to-order poster. The review only treats a tracked quantity of 0 or less as sold out. Products set to keep selling when out of stock also need a manual check, because that setting isn’t in the variant read.

Can it tell me why Google disapproved a product?

It shows the approval status and how many item issues Google reports. The text of each issue is in Merchant Center, so open the product there to see what Google asks you to fix.

Does the assistant fix the feed or change prices?

No. It reads both sources and prepares the review list in your conversation. Your store team changes products in Shopify, and whoever manages Merchant Center handles resubmissions and issues.

YOUR NEXT STEP

Try it with your own data.

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

Start free →