You can reprocess Google Shopping content API by using a supplement feed.
- Open the zip file
- Change the .tsv file to .csv
- Open the file using your favorite spreadsheet editor and copy the ID column (it can also be called item_id, if so change the header from item_id to id).
- Go to Google Sheets
- Paste the ID column contents
- Go back to Google Merchant Center > Settings > Data Sources > Supplemental sources > click on add supplemental product data
- If you can not see supplemental sources, have a look at our guide.
- Add your feed name (can be anything) and select Google Sheets.
- Click on Choose an existing spreadsheet to upload your items
- Now that you have created the connection, click on the supplement feed you just created, and click on “update”.
I just tried this but the interface changed completely on this feature.. would you be so kind to make a new video/update the screenshots? We are utterly lost here.. Thanks so much <3
Hello Kim, thank you for your interest, I will look into this.
I did this last month and suddenly, the expiring items appeared again. I checked the supplemental feed schedule and it still says Daily. Do I repeat the same procedure above and create a new supplemental feed?
Usually, it should not cause this to happen again. However, please note that this fix is just temporary and should not be relied on as a permanent solution. You must check why the primary feed does not update the product details as this should happen daily.
Will this work for already expired items that are still showing in my local product section? So when I download all products they are still there but just not showing in my content API
Yes it will.
I tried doing that, but it still did not update all. It claims some are not matched but not too sure what to do about those
Strange, I tried it but I was also getting an error for 70,000 that offer does not exist when I just downloaded and then copy and pasted
Without seeing everything, I will not know what your issues are. If you need personal support, I do offer services, feel free to reach out at [email protected]
Hi,
I did the steps as mentioned in above steps and your youtube video. After uploading google sheets, I am getting error
Offer does not exist
13,108
All
The update could not be matched to an offer. Please make sure to use the identifier of an existing offer and check that the country of sale of the feed is correct.
Learn more
Below are some example items that are affected by this issue.
Could you please guide to resolve it
That means, the product id’s don’t match. Not sure what step gave you this issue. Consider trying again, or if you need assistance, feel free to email me at [email protected]
Thank you for this!
It worked!
Pleasure
Wow!! I watched your YouTube video and then followed the steps above, and the issues were just removed from my GMC Diagnostics. Thank you for your assistance.
Pleasure.
Thank you for these guides, however i am getting ‘invalid or missing required attribute: id‘ on the feed even when i have followed the instructions to a T
If the column header shows ID, then this is correct. You may have a column called item_id, if so change it to id. If you continue to have issues, feel free to email me at [email protected]
This actually worked. Thank you for this solution
Pleasure.
Hi Emmanuel,
Thank you for the great information, I followed method 3 but it didn’t work. When you say column ID, can you share a screenshot. When you turn the document to CSV there is no column ID.
When you download content from Google Merchant Center the column will be named item_id. Simply check the column info and see if you recognize the values. And if it matches the ID’s submitted in Google Merchant Center > Products > All Products
Thank you for the great information. I have been having problems with expiring items.
As you posted a message on the Content API, you need to contact the support team of the app you are using. Or use the method in this article.
A long time ago, some Content API apps had issues, and the way to resolve the problem was to disable automatic updates in Google Merchant Center. You could try this. But the best solution would be to ask for help from the data feed solution support team.