Google Merchant Centre - Local Product Inventory - "Offer Does Not Exist"

YC2D2
New Member
4 0 0

Hi all,

My google shopping feed is currently active and available on Shopping and Google Surface via Google API which is great.

Problem persists when I try to upload my own tab delimited feed for Local Product Feed. I've checked the storecode, itemid, availability, price and everything makes sense.

I received the error "offer does not exist".

I've tried using the shopify ID in GMC (EG: shopify_AU_4677150179427_32917051670627) as itemid, the variant_id (4677150179427) as itemid; they both don't work.

Anyone has any luck uploading a scheduled feed for local product inventory & listings without needing to use a paid app?

GMC Screengrab:

Capture.PNG

 

Product Feed Screengrab:

Capture1.PNG

0 Likes
EmmanuelFlossie
Shopify Partner
709 23 154

The column itemid is not a valid attribute name. It should be id.

You can learn more: https://support.google.com/merchants/answer/3061342?hl=en

I'm a Google Shopping Specialist & a Google Ads Platinum Product Expert (Only a hand full of Platinum experts in the world!)
Need Premium Data Feed Management Support? Get in touch.
0 Likes
YC2D2
New Member
4 0 0

Hi Emmanuel,

 

I've used the id (variant_id) and still the problem persists:

YC2D2_0-1602916828992.png

 

0 Likes
EmmanuelFlossie
Shopify Partner
709 23 154

In your inventory spreadsheet, the column header (the attribute) has to be ID, not itemid.

Itemid is not a valid attribute name.

I'm a Google Shopping Specialist & a Google Ads Platinum Product Expert (Only a hand full of Platinum experts in the world!)
Need Premium Data Feed Management Support? Get in touch.
0 Likes
YC2D2
New Member
4 0 0

Hi Emmanuel,

 

Thank you for replying and helping out.

 

The header in my inventory feed is ID, and I am using tab delimited. I've tried using both product ID and variant ID as the ID.

YC2D2_0-1602929373493.png

I've double checked the product ID in my client's shopify - basically searched for the id on the product page and it matches the product. So it is safe to say that I am using the right ID. Currently, the client did not specify any SKU.

 

What would you recommend in order for this to work? Set SKUs for all the products and create a new inventory feed with SKU ids instead of variant id? 

 

 

 

0 Likes
EmmanuelFlossie
Shopify Partner
709 23 154

This requires careful examination of the feed itself.

From the screenshots it looks to me the id's don't match.

You can go to Google Merchant Center > products > all products > and download your products from the main feed.

Then rebuilt your supplement inventory feed.

If that still fails, contact Google directly for support.

I'm a Google Shopping Specialist & a Google Ads Platinum Product Expert (Only a hand full of Platinum experts in the world!)
Need Premium Data Feed Management Support? Get in touch.
0 Likes
YC2D2
New Member
4 0 0

That was exactly what I did, Emmanuel but I still get the error message.

I thank you for your time and for trying to help. Wish you the very best.

 

0 Likes