You can reprocess Google Shopping content API by using a supplement feed.
- Go to Google Merchant Center
- Products
- All Products
- Click on the download icon
- 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 > Products > Feeds > click on add supplement feed
- Add your feed name (can be anything) and select Google Sheets, then continue.
- Click on Select an existing Google spreadsheet
- Locate your file and save, now choose your content api and continue.
- Now that you have created the connection, click on the supplement feed you just created, and click on “fetch now”.
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.