How to Export/Import Products, Customers, Orders or Any Other Data from PrestaShop into the File on Google Drive

You might use Google Drive for multiple business tasks, including exporting and importing PrestaShop products, customers, orders data. Whether it is a one-time task or scheduled synchronization is required, you can use Store Manager for PrestaShop to perform this task.

Depending on your needs, you can either:

• export data to native Google Sheets. Follow this guide to save data into a Google Sheets native file on Google Drive;
• export product feed data to Google Drive to sync with Google Shopping. Follow this guide to upload a file into Google Shopping and update it on a schedule automatically;
• or export products, customers, and orders as a CSV, XML, Excel, or any other file into Google Drive. We’ll review this method in this article.

All of the above options allow you to export data one time or on a schedule, share the file or folder with required services or people or achieve any other goals. If you need assistance with choosing which option works the best for you, contact us for assistance.

In this article, we’ll review how to export/import products, customers, orders or any other data from PrestaShop into the file on Google Drive (CSV, XML, Excel, etc) with Store Manager software. Follow a few steps to proceed.

First things first, install Google Drive app on your desktop. You can download it here https://www.google.com/drive/download/.

Follow the on-screen prompts to install the app. Go to the “Downloads” folder and open GoogleDriveSetup.exe on your PC. Based on your preference, choose whether to add shortcuts and proceed with the “Install” option.

After the app is installed, press “Launch” and then “Get started”.

At the next step, you’ll be offered to sign in with the Google Account you would like to work with further.

After selecting the account, complete the login.

Following a few “next” steps, choose which folders to sync from your computer to Google Drive or skip it if you’d like to get back to it later.

Once installation is complete, press “Open Drive” option, the “Google Drive” folder will be streamed on your computer, creating a virtual disc.

You can update your preferences and choose to mirror or stream My Drive after installation.

Store Manager’s export and import functionality further works with the local virtual disc, which is synchronized to Google Drive based on your settings.

Now, let’s get down to the PrestaShop to Google Drive import and export itself.

1. Open or install the Store Manager software, and connect it to your PrestaShop store. You can download a free trial to test the functionality free for 2 weeks. Free assistance is available for installation and connection configuration.


2. Run the Export/Import Wizard from the toolbar or context menu, and hit “Export” or “Import”.




3. At the step of “Select export target”, choose the “Local file” radio button.



In case of import, choose the file located in Google Drive offline folder.

4. Specify the file name on the Google Drive where products will be exported to, or imported from and hit “Next” to proceed.




5. Proceed with the export or import configuration as usual.



You can check detailed instructions on export configurations here: PrestaShop Product Export.

You can check detailed instructions on import configurations here: PrestaShop Product Import.

6. Hit “Import” or “Export” to complete the task.

A .csv file will be saved to your Google Drive if you perform an export procedure, you can check Google Drive once it has synchronized. Or the import procedure is complete if you have performed the import procedure from the file on Google Drive.

To convert the file into Google Sheets format, use this guide https://developers.google.com/apps-script/samples/automations/import-csv-sheets/.

Disclaimer

Since Google updated its API verification process in 2024, all software developers must undergo an annual security assessment, validated by a CASA authorized lab, which involves a significant cost. This includes local client applications and Google Workspace addons.

Since the Store Manager to Google Sheets Integration requires Level 3 access, we must complete this costly security assessment annually. Unfortunately, this requirement conflicts with our pricing model, which is a one-time payment for lifetime usage.

Related Articles:

PrestaShop Google Drive Integration in Store Manager

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

Integrate PrestaShop with Google Sheets: Spreadsheet Import

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

How to Upload PrestaShop Feed to Facebook Marketplace

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

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.