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.

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

Launch Import Export Wizard with Store Manager

Now hit the “Export” button.

Export Products to Google Sheets with Store Manager

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.

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

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.
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.
Follow these steps to allow access to your account and complete verification:

С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”:

Finally, you receive a message that authentication was successful

Authentication Successful Confirmation Message

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

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

Select File On Google Drive to Export Products with Store Manager

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.

Google Sheets Export File Options with Store Manager

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.

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

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.

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

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

Be the first to comment.

PrestaShop Product Export To Google Spreadsheets

PrestaShop Product Export To Google Spreadsheets Steps

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

Related Articles:

PrestaShop Google Drive Integration in Store Manager

Integrate PrestaShop with Google Sheets: Spreadsheet Import

How to Upload PrestaShop Feed to Facebook Marketplace

Export PrestaShop Products From Specific Categories