Export PrestaShop products to Google Shopping with Google Spreadsheets
Rating 3.00 stars - 2 votes

PrestaShop Product Feed Generator

As an online merchant, you have plenty of options to extend your online presence and promote products beyond the PrestaShop web store. Amazon, eBay, Google Merchant are just a few to name.

The good news is that most online platforms allow submitting your products in bulk via file upload or feed. Though, each platform has different requirements for the structure of the import file and field names. So, what you need is a tool that would let you export your store listing in a format compatible with a specific target website. This tool is PrestaShop Feed Generator.


PrestaShop Feed Generator

What is PrestaShop Data Feed Generator Tool and How to Use It for Product Export

Data Feed Generator exports PrestaShop catalog data into a file compatible with the selected marketplace or digital platform. The tool has a built-in list of feed templates. By choosing one, you can create a product feed for Google Merchant, as well as add, update product details and prices on Amazon.

When you select a template the tool pulls out the data from certain fields in your PrestaShop store and assigns it to the matching fields in the template. As a result, you have your store data exported to a CSV file on your computer or FTP, or Google Docs.


Steps to generate PrestaShop product feeds

  1. Download Store Manager for PrestaShop and connect the application to your store (if you don’t use Store Manager yet).
  2. Run the Feed Generator tool and select a feed template from the list.
  3. Export the file following the prompts in the Feed Generator Wizard.
  4. Submit the feed to the target website and promote your products!
If you haven’t installed Store Manager yet, download the free trial and connect the application to your store database using the wizard inside. Read about other Store Manager tools to simplify and speed up PrestaShop store management

Let’s review in detail how to generate feeds with the Store Manager for PrestaShop.


1. Download Store Manager for PrestaShop and Connect to Your Store

Download the trial version of Store Manager for PrestaShop and install it on your computer. Open the application and connect Store Manager to your store database following the instructions in the quick start guide.


2. Run the Feed Generator Tool and Select Feed Template From the List

Open Store Manager, go to the Tools tab, and click the Feed Generator icon on the toolbar:


Feed Generator with Store Manager for PrestaShop

Currently, Feed Generator allows you to:

  • Update Inventory and Price for simple products listed on Amazon
  • Update Inventory for simple products listed on Amazon US
  • Publish Raw Materials product type on Amazon US
  • Add Google Merchant feed

New platforms will be added shortly. Stay tuned!


3. Export the File Following the Prompts in the Feed Generator Wizard

So in the open window, you will see available feed templates:


PrestaShop Feed Templates with Store Manager

You can use these default XML files as they are or customize them according to your needs.


Let’s create a feed for Google Merchant. Select the default feed, clone it, and enter the feed name.


Note: We recommend cloning the default feed because if you alter some settings, the original XML file will be overwritten.

PrestaShop Rename Feed with Store Manager

When you create a new feed it automatically becomes active. So press “Next” to launch the Wizard:


Launch PrestaShop Feed Generator Wizard with Store Manager

The first step in the Wizard is to select an export target file. You can specify the path to the existing document (that is convenient when you want to update the feed) or create a new one.


We’ll be exporting our feed to Google Spreadsheets. So we switch to this option, add our Google Account, and browse Google Drive for a file.

Authenticate new account via browser and grant eMagicOne Store Manager Export/Import Permissions:

    Authenticate New Account via Browser Store Manager Notification Message

    Authenticate New Account via Browser


    Sign in with Google in Browser

    Sign in with Google


    Grant eMagicOne Store Manager Export Import Permission 1 Step

    Grant eMagicOne Store Manager Export/Import Permission 1 Step


    Grant eMagicOne Store Manager Export Import Permission 2 Step

    Grant eMagicOne Store Manager Export/Import Permission 2 Step


    Grant eMagicOne Store Manager Export Import Permission 3 Step

    Grant eMagicOne Store Manager Export/Import Permission 3 Step


    Confirm Granted Permissions for Store Manager Export Import

    Confirm Granted Permissions


    Authentication Successful Confirmation in Browser

    Authentication Successful Confirmation



If you want to create a new file press ”+” and name the document. Then click OK to return to the Wizard.


PrestaShop Export Feed to Google Sheets with Store Manager

In the next step, you should select which products you want to export. The Wizard will display your category tree so you can find a necessary subcategory by expanding it:


PrestaShop Feed Select Products to Export by Category with Store Manager

Now you can select a relevant category on Google Shopping. If you don’t select a category Google will assign it automatically. Though, there is a risk that automatically selected categories will be irrelevant. So it’s better to specify it manually.


PrestaShop Google Merchant Feed Category Mapping with Store Manager

Now it’s time to map the fields from your store to the ones required by the target website. Required fields are marked with an asterisk and mapped automatically. You can select another field from your store by clicking on the field value in the right column. Also, you can specify the values for additional fields like “sale_price” clicking on the empty row:


PrestaShop Feed Fields Mapping with Store Manager

On the last step, there are several options to select. Specify whether variations should be exported or skipped.


Important for product variations!

Feed Generator wizard supports the export of variations for Google Merchant Feed as is.

Export of product variations into Amazon feed is performed by our support engineers individually. Contact us at [email protected] for assistance.


Also, check if the currency and dimensions are correct:


PrestaShop Feed Options with Store Manager

And finally, review the details and view the result file:
PrestaShop Feed Open File with Store Manager

You can now check the exported data in Google Docs:


PrestaShop for Google Merchant Feed Exported with Store Manager

4. Submit the Feed to the Target Website and Promote Your Products!

Now when you have your Google Spreadsheet file ready let’s add it to the Google Merchant Center.


Log in to your Google Merchant Account and go to Products > Feeds. Then press “+”:


Adding Primary Feed in Google Merchant Center Generated with Store Manager

You will be offered to add a feed in three steps. Follow the instructions and on the last step tick the button “Select existing Google Spreadsheet”:


Selecting Google Spread Sheet File Generated by Store Manager to Create Feed in Google Shopping

Press “Create feed” to finish the process. Now you have your feed added to the Google Merchant Center and can start attracting new customers there.


Use PrestaShop Feed Generator free within Store Manager for PrestaShop!

Download FREE Trial

Related Articles:

Card image
How to Upload PrestaShop Feed to Facebook Marketplace

Steps to Generate PrestaShop Feed and Feature Products on Facebook MarketplaceRead More…

Card image
PrestaShop – Export Categories

Get a detailed algorithm of exporting the categories with products or exclusively category structure using export wizard. Read More…

Card image
Export PrestaShop Products From Specific Categories

Discover all possible ways of exporting PrestaShop selected product information from specific categories. Read More…

Card image
Import Products to PrestaShop using Store Manager

Get insight into main PrestaShop import options including import method, handling products not included in imported file, category options etc. Read More…


COMMENTS
Be the first to comment.