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

Solved
YC2D2
New Member
7 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

Accepted Solution (1)

Accepted Solutions
LakesideDigital
New Member
2 1 1

This is an accepted solution.

Just wanted to let you know I had this same issue but just found a fix that worked for me.

When I made my Google Sheet for my supplement feed, I copied my product IDs into the "id" column, and they came through like this: 

shopify_us_4330371383341_35851101536420


However, when you look at the live product feed you'll notice the country code in the id is upper case.

shopify_US_4330371383341_35851101536420

 

Turns out the id attribute is case sensitive, which is why my ids did not match up, and why I also got the error "Offer Does Not Exist".

I did a find and replace in my Google sheet, changing all lower case country codes to upper case, then fetched the feed once more and it worked perfectly.

Hope this helps someone else struggling!

View solution in original post

Replies 18 (18)
EmmanuelFlossie
Shopify Partner
1544 91 370

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 and a Google Product Expert Education Award winner, a Google Ads Diamond Product Expert, and also a Google Partner.
Need Data Feed or Google Shopping support? Get in touch.
YC2D2
New Member
7 0 0

Hi Emmanuel,

 

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

YC2D2_0-1602916828992.png

 

EmmanuelFlossie
Shopify Partner
1544 91 370

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 and a Google Product Expert Education Award winner, a Google Ads Diamond Product Expert, and also a Google Partner.
Need Data Feed or Google Shopping support? Get in touch.
YC2D2
New Member
7 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? 

 

 

 

EmmanuelFlossie
Shopify Partner
1544 91 370

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 and a Google Product Expert Education Award winner, a Google Ads Diamond Product Expert, and also a Google Partner.
Need Data Feed or Google Shopping support? Get in touch.
YC2D2
New Member
7 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.

 

ferllamazares
New Member
5 0 0

Hello!

Sorry for answering almost one year after the opening of the thread

I am having the same issue and I am going crazy trying to fix it. Did you manage to solve it?

Thank you in advance

 

 

EmmanuelFlossie
Shopify Partner
1544 91 370

Setting a local inventory feed is very hard, because there are lots of moving parts. If you can not resolve it, contact Google directly.

To help you along below is the official guide:

 

  1. Set up your accounts
  2. Enable local inventory ads
  3. Verify your About page (European countries only)
  4. Create a local products feed
  5. Create a local product inventory feed
  6. Register and submit local feeds
  7. Request inventory verification
  8. Enable local in your Shopping campaigns
I'm a Google Shopping Specialist and a Google Product Expert Education Award winner, a Google Ads Diamond Product Expert, and also a Google Partner.
Need Data Feed or Google Shopping support? Get in touch.
ferllamazares
New Member
5 0 0

Thank you again. 

 

I have tried to contact Google. They bounce me from one department to another. At the end, they have suggested me to open threads in help forums, like this one. 

 

I will try to check again all the steps. 

YC2D2
New Member
7 0 0

Hello ferllamazares,

It has been over a year and I haven't found any solution to this. I've repeated this process every quarter or so, hoping that Google has updated their system to support shopify local feed but I still get the same rejection notice.

 

The only solution I can think of is to specify SKU for your products and use the SKU instead of item id as the id for your local feed. Alternatively you can purchase the app to sync it automatically for you.

From what I can understand, by changing the SKU as id, it will refresh and reload the whole google ad process again so I do not wish to take the risk.

 

Hope you can find a solution and do share them when you can 🙂 Good luck.

EmmanuelFlossie
Shopify Partner
1544 91 370

Understood, please note it takes me nearly 1 to 2 months to complete this task. I have done it several times, I get roughly 1 or 2 clients per month that need help setting it up. And it just takes a long time, even for someone who knows what they are doing 🙂

I'm a Google Shopping Specialist and a Google Product Expert Education Award winner, a Google Ads Diamond Product Expert, and also a Google Partner.
Need Data Feed or Google Shopping support? Get in touch.
ferllamazares
New Member
5 0 0

Thank you for your update, YC2D2.

I hope we can finaly find the way to make it. 

I will keep trying

Have a nice day!

 

LakesideDigital
New Member
2 1 1

This is an accepted solution.

Just wanted to let you know I had this same issue but just found a fix that worked for me.

When I made my Google Sheet for my supplement feed, I copied my product IDs into the "id" column, and they came through like this: 

shopify_us_4330371383341_35851101536420


However, when you look at the live product feed you'll notice the country code in the id is upper case.

shopify_US_4330371383341_35851101536420

 

Turns out the id attribute is case sensitive, which is why my ids did not match up, and why I also got the error "Offer Does Not Exist".

I did a find and replace in my Google sheet, changing all lower case country codes to upper case, then fetched the feed once more and it worked perfectly.

Hope this helps someone else struggling!

YC2D2
New Member
7 0 0

You are a genius and thank you for sharing your solution. It works. 

 

I hope others will benefit from this too!

ferllamazares
New Member
5 0 0

Thank you for your answer!

 

Unluckily, it doesn't work for me. I have made the same steps you mentioned, but I still receive the same error. 

 

In my case, I upload the products with the upper case country codes. For example, I send "shopify_ES_6757719113917_39963592229053". 

 

It is a little bit demotivating. However, I will keep trying to solve this. 

 

Thank you so much again. 

LakesideDigital
New Member
2 1 1

Here's a snapshot of what my feed setup looks like along with what my Google Sheets looks like.

Feed:

shopify feed structure.png

Google Sheet for Supplemental Feed:

LakesideDigital_0-1635901562324.png

Hope that helps!

Cheers,

YC2D2
New Member
7 0 0

Hi ferllamazares

 

Try changing the uppercase ES to lowercase es. "shopify_ES_6757719113917_39963592229053" to "shopify_es_6757719113917_39963592229053"

 

That should work

ferllamazares
New Member
5 0 0

Thank you so much for your help! I will try with the Google Sheets. I was submitting a CSV or TSV file.