Export PrestaShop products to Google Shopping with Google Spreadsheets
Rating 5.00 stars - 1 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.


When exporting feed to Google there are 2 options available at the moment:

In case you choose to export file to Google Drive using offline folder, please select export target as “Local file” and specify the local path to the Google offline folder. See here for detailed instructions.

In case you choose to request your own API and connect to your Google SpreadSheets, select Google SpreadSheets – Add account and specify your API key and proceed to login. See here for detailed instructions.


    Authenticate New Account via Browser Store Manager Notification Message

    Once you are authorized, you will see your Google SpreadSheets. 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 Drive (Offline folder or Google SpreadSheets, depnding on the option that was chosen):


    PrestaShop for Google Merchant Feed Exported with Store Manager

    4. The next step is to submit the Feed to the Target Website and Promote Your Products!

    Now when you have your .tsv file on Google Drive or Google Spreadsheet file, it is ready to be uploaded to your Google Merchant Center (Next).



    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.