Google API not working?

General ShopSite user discussion

Google API not working?

Postby gourmetdelights » Tue Aug 13, 2024 12:49 pm

Using ShopSite® Pro 14.0 sp3 r4, hosted by Lexiconn.com (they are a great host FYI)

In early July I tried to use Google to upload my products via the API

They are still not uploaded more than a month later. I hoped I caught it in the middle of the current upload, but it should have something for "last updated" if it was only doing a refresh. So I assume it has not yet uploaded anything.

Image


I'm not sure if this is a Google problem, a Shopsite problem, or a compatibility between the two problem. I am guessing a Google Problem as their rollout of this feature in the spring was, at best, clunky and prone to error ("hey use this feature to highlight your company. I click "OK" only to be stuck on the intro screen. That has been fixed, late June, but the uploads aren't working yet...)

Note back in say 2010+- Google allowed a very easy upload via spreadsheet, then that went away, and now they are offering an API upload, which sounds great, I simply need to keep my website products current and not keep a separate spreadsheet, but it is only great if it successfully uploads.

Any thoughts/help greatly appreciated.

Thank you.
http://gourmet-delights.com
Exceptional Foods at Realistic Prices
We ship worldwide
FREE shipping to all US States, Territories, AP/AE
gourmetdelights
 
Posts: 85
Joined: Thu May 19, 2011 4:59 pm

Re: Google API not working?

Postby loren_d_c » Thu Aug 15, 2024 2:58 pm

ShopSite does not use the 'API' method, it generates an XML file and uploads it to Google's FTP server. If you have registered the FTP upload file in your Google Merchant Center account, then they periodically (hourly or more often) check your FTP account for the filename that you registered, and if it finds it there, processes the products in the file.

The initial upload mechanism provided by Google was FTP, and this is the method that had been implemented in ShopSite many versions ago. At some point Google added an option to use SFTP (a more secure transfer method), and then in September '23 they made SFTP required and turned off regular FTP capability. ShopSite 14 sp3 r5 and newer use SFTP instead of FTP, so it sounds like you need to ask your host to upgrade you to at least one maintenance release newer than what you currently have to have this SFTP capability.

https://support.shopsite.com/KBase/questions/2600/

"* adds SFTP as a connection method for Google Shopping feeds. Google will end support for the previously used FTP method after September 15, 2023. Merchants must log in to their Google Merchant Center account and create an SFTP account there and enter the new SFTP credentials in ShopSite 14 sp3 r5 or newer to use this new connection method."

So as mentioned in the kbase, you ALSO need to create the SFTP account in your Google Merchant Center account (even if you previously had an FTP account set up with them). And if you haven't already registered the xml feed file in your Google Merchant Center account you will need to do that, too. The filename you specify in Google should be the same one you specific in your ShopSite's Google Shopping configuration (default is froogle-bulk.xml)

https://help.shopsite.com/help/14.0.3/en-US/sc/pro/froogle.configure.html

-Loren
loren_d_c
 
Posts: 2571
Joined: Fri Aug 04, 2006 12:02 pm
Location: Anywhere

Re: Google API not working?

Postby gourmetdelights » Wed Oct 30, 2024 12:10 pm

Thank you Loren, I'm now using ShopSite® 64-bit Pro 15.0 r3 and can upload products!
http://gourmet-delights.com
Exceptional Foods at Realistic Prices
We ship worldwide
FREE shipping to all US States, Territories, AP/AE
gourmetdelights
 
Posts: 85
Joined: Thu May 19, 2011 4:59 pm


Return to User Forum

Who is online

Users browsing this forum: Bing [Bot], Google [Bot] and 4 guests