PrestaShop Product Export To Google Spreadsheets
Rating 5 stars - 2 votes

PrestaShop Product Export To Google Spreadsheets


No need to tell why export functionality plays not the last role for e-merchant. Retrieving product data sheets for checking the details, sending the file to the supplier, using sheets for further import – all these tasks can be successfully done with the export tool. However, since PrestaShop default functionality has limited export that concerns not only fields but also sources, Store Manager will become a proficient tool to relieve the process. Among the existing file locations products can be carried to, the software offers Google Spreadsheets as well.

The possibility to perform PrestaShop product export to Google Spreadsheets has been implemented in Store Manager for PrestaShop v.2.55.0.2199. To get access to this functionality, make sure you are working with the mentioned version of the software or higher.
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

PrestaShop Product Export To Google Spreadsheets Steps


To carry out PrestaShop goods to Google spreadsheets, you have to go through several steps of Products Import/Export Wizard.

  1. Launch the Wizard available in the Import/Export section of Store Manager

  2. Launch Import Export Wizard with Store Manager

  3. Now hit the “Export” button.


  4. Export Products to Google Sheets with Store Manager
  5. At the “Select file” step, choose the “Google spreadsheets” radio button export target and you will be offered to add an account and specify its display name.

  6. Add Cloud Storage Display Name for Google Sheets Export with Store Manager

  7. You will be redirected to the Google authentication window that provides your Google account sign in to Google Drive Integration. Selecting the account, you need to grant the addon access to view, modify, create and delete all your files on Google Drive; view and manage your Google Drive files and folders that are open or created with this Integration; view, modify, create and delete your spreadsheets in Google Drive.
  8. At the next confirmation step, you can check what data Google Drive Integration will process, its terms of use, and Privacy Policy. You will also be notified via email about granting access to your account.
  9. Follow these steps to allow access to your account and complete verification:

    • Sign in with Google at Browser

    • Sign in with Google in Browser

    • Сonfirm that you grant Store Manager addon access to your account by clicking “Allow”:
    • Grant eMagicOne Store Manager Export/Import Permission 1 Step

    • Grant eMagicOne Store Manager Export Import Permission to Manage Files Step 1

    • Grant eMagicOne Store Manager Export/Import Permission 2 Step

    • Grant eMagicOne Store Manager Export Import Permission to Manage Files Step 2

    • Grant eMagicOne Store Manager Export/Import Permission 3 Step

    • Grant eMagicOne Store Manager Export Import Permission to Manage Files Step 3

    • Review your choices and click “Allow”:

    • Verify and Confirm Granted Permissions

    • Finally, you receive a message that authentication was successful

    • Authentication Successful Confirmation Message

  10. After you have finished with permissions, you can proceed with the export itself.

  11. Specify export file name or browse Drive Explorer to find the existing file or add a ew one right away.

  12. Select File On Google Drive to Export Products with Store Manager

  13. Select among the available options:

    • replace sheet values – products that already exist in the selected file sheet will be overwritten;

    • append to sheet – will add selected products for export to the existing ones;

    • insert new sheet – will create a new, separate spreadsheet in the chosen file.

  14. Google Sheets Export File Options with Store Manager

  15. For more convenient data arrangement, the step afterward offers to select all products, particular categories or use a product filter for merchandise export. Advanced Export Options are also included.

  16. Further, choose fields delimiter, quote character, images, downloadable files, and attachments (in case you are going to append these details) settings.

  17. Select the exact fields of PrestaShop products you are going to export to Google SpreadSheets. Store Manager allows opting for a group of fields or the needed ones as well as add expressions on the fly.

  18. Check the details of the process and select whether to copy the file URL to the clipboard or view the export file.

  19. After you finished the whole process, you may check the result file on your Google Drive.

In case you need to have product listings appended to Google Sheets on an hourly / daily / weekly basis, Automated Product Export addon already built-in Store Manager will be a suitable tool for this operation. Check the related article on how to create the configuration and add it to the scheduler.


Download trial version of Store Manager and try exporting goods with PrestaShop Google Drive Integration

Try Now


Related Articles:


Card image
PrestaShop Google Drive Integration in Store Manager

Discover PrestaShop Google Drive Integration for exporting and importing products to/from Google Sheets. Read More…

Card image
Integrate PrestaShop with Google Sheets: Spreadsheet Import

Perform PrestaShop product import from your Google cloud storage with eMagicOne Google Drive Integration. Read More…

Card image
PrestaShop Export Products

Export selected group of fields or choose separate ones, apply filters for convenient PrestaShop product export.Read More…

Card image
Export PrestaShop Products From Specific Categories

Select specific categories from the available ones to make PrestaShop product export more flexible. Read More…


COMMENTS
Be the first to comment.