Note: Google Merchant Center also supports reading from an existing Google Sheets spreadsheet.  Since EZ Exporter also has a direct Google Sheets integration, this is an alternative option as well and will be much simpler to set up. Click here to learn more about how to set up the Google Sheets integration in EZ Exporter.

Google Merchant Center supports automatically fetching product feeds from an SFTP or FTP server.

EZ Exporter also supports automated exports of Shopify product data to an SFTP or FTP server, so you can automate this process using the app.

This guide goes over how you can set this up via the SFTP method.

Google Merchant Center Configuration

1. In Google Merchant Center, click the settings icon and choose the SFTP / FTP / GCS option.

2. On the next page, under SFTP Settings, click the "Generate" link to create a password for the SFTP server and make sure to save this information. From this page, also make a note of the Server, Port, and Username information. You will need to enter these in EZ Exporter later.

3. Go to the Products > Feed page in Google Merchant Center and create a feed.

4. Enter the required information on the next page and click "Continue".  On the following page, choose the option called Upload and click "Continue".

5. On the next page, enter the name of the feed file (e.g. google_shopping_feed.txt). Make a note of this as you will need to enter this same name in EZ Exporter later. Click "Create feed".

That's it on the Google Merchant Center side. Now let's configure EZ Exporter.

EZ Exporter Configuration

1. In EZ Exporter, go to the Templates page.  Under the "Platforms and Marketplaces" tab, use the template called "Google Shopping Feed".  Please note that this is just a starter template and you may need to modify the field mappings depending on how you organize the data in your Shopify store.

2. Edit the Export Profile named "Google Shopping Feed".

3. In File Options, under Filename pattern, enter the name of the feed file that you entered in Google Merchant Center (case-sensitive).

4. Scroll down to Destination and set Type to "SFTP (SSH)".

5. Enter the following information.

• Host: partnerupload.google.com:19321
• Folder path: /

For the Username and Password, enter the username and password that were provided to you by Google Merchant Center.

6. Under Schedule, tick the "Enable schedule" checkbox and select the desired schedule frequency.  You can also manually Run this export.

7. Save the Export Profile settings and do an initial "Run" of this export profile via the app's main page.

At this point, Google Merchant Center will automatically fetch the file and the products should automatically show up in Google Merchant Center. This could take some time; give it at least 30 minutes.