Integrate PrestaShop with Google Sheets: Import From Spreadsheet
2019-07-18 2019-06-13
Rating 5 stars - 1 votes

Integrate PrestaShop with Google Sheets: Spreadsheet Import

PrestaShop integration with Google Sheets is a great way to keep and modify files with data. Though, PrestaShop admin does not offer such a possibility yet.

From version 2.55.2199 Store Manager introduces the ability to export and import data to PrestaShop from Google Sheets. You can use this article as a guide to upload product data to PrestaShop as a Google spreadsheet.

How to Import Products to PrestaShop from a Google Sheet?

Launch Import Wizard

  1. Launch Export/Import Wizard from the toolbar of Store Manager.


  2. Select ‘Import’ action.


  3. Select Google Spreadsheets as the import source.
Add your Google account

  1. Press the ‘Add Account’ button to integrate Store Manager with your Google Drive. Enter the name of cloud storage.


  2. Sign in to start the integration.


  3. Allow Store Manager to see, edit, create and delete all of your files on Google Drive.


  4. Allow Store Manager to view and manage Google Drive files that you have opened or created with this app.


  5. Allow Store Manager to see, edit, create and delete your spreadsheets on Google Drive.


  6. Confirm granting all of the above permissions.


  7. Now you can find your cloud storage added to Store Manager.


  8. Select the cloud file from your Google Drive.


  9. Select sheet to import and preview sheet data.



Configure import settings

  1. Set up the delimiters to separate fields data.


  2. In case your file contains date values and numbers, set up base formats and separators.


  3. You can check the ‘Encode scientific values for EAN13 codes’ box, if your EAN codes are in scientific format.

  4. Assign file columns to database fields using the CSV column dropdowns. Or you can assign them automatically by pressing Auto Fill button.


  5. Preview the import file. In case you find some incorrect data, go back to previous steps and check what is missed.


  6. It is possible to start the upload from any CSV line you want. Just check the ‘Start import from line’ box and select the line number from the dropdown.

  7. Configure the import options:
  • Select the import method
  • Specify how to handle products that are not listed in the CSV.


  • In case the import file contains products with no category specified, you can indicate a category path that will be assigned to such products. If unnecessary, check the ‘Ignore category path…’ box

  • Select the store views to import the products to.
  • Check the ‘Create Import log file’, if necessary.

To start running the import, press the ‘Import’ button.


Advantages:

  • Google Spreadsheets format is considered to be the most convenient for storing and editing data.
  • Store Manager supports both spreadsheet export and import and this way simplifies the update procedure.
  • You can integrate multiple Google Drive accounts with Store Manager and easily switch between them.
  • It is possible to schedule spreadsheet import if you equip the application with Automated Import addon.


Import products to PrestaShop from Google spreadsheets for 14 days FREE – Try Now





Related Articles:


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…

Card image
PrestaShop Product Export To Google Spreadsheets

Expand PrestaShop export possibilities by extracting products to Google Spreadsheets file. Read More…

Card image
PrestaShop Combination Update Wizard Tutorial

Find out how to update PrestaShop combinations massively via Store manager Combinations Updator. Read More…

Card image
Handling Products Not Listed in CSV by Suppliers

Check out what actions can be performed with the merchandise not listed in the import file in the process of upload. Read More…


COMMENTS
Be the first to comment.