How to Import Data to Shopware 6 from Google Sheets

Today, we explore a very important topic – Shopware 6 Google Sheets integration. It is a groundbreaking improvement to the default Shopware import that dramatically extends the basic data transfer opportunities of your e-commerce website. By default, you can only upload files to Shopware 6 manually. It means that if your update is stored somewhere else, for instance, a remote server, you cannot import it to your e-commerce website, not to mention such third-party services as Google Sheets or Google Drive. If you choose the default Shopware tools, you will have to take your update from the external storage and move it to Shopware 6 manually. If the update is stored in a Google Sheets file, you will have to export it as CSV and then import this file to your e-commerce website. However, there is a way to run the Shopware 6 Google Sheets import much faster. Meet the Improved Import, Export, and Mass Actions app that completely revamps the standard Shopware 6 import, providing the ability to connect to the popular online sheet editor. The following tutorial explains how to import data to Shopware 6 from Google Sheets. Also, check our guide to Shopware 6 Google Sheets integration, and don’t forget to go over our Shopware Cookbook for other helpful hints.

What is Google Sheets

Google Sheets is a popular spreadsheet application developed by Google. It is free, intuitive, web-based, and available as a mobile app for Android and iOS, and as a desktop application on Google’s ChromeOS. 

Another good thing is that Google Sheets is compatible with Microsoft Excel file formats. It means that you can upload any Excel file to your Google Drive and convert it into a Google Sheets table in a couple of clicks.

If an update for Shopware 6 is stored in a Google Sheets file, you no longer need to download and re-import it manually. You can establish a direct connection between the two systems. Below, you will learn how to import data from Google Sheets to Shopware 6.

How to import Google Sheets files to Shopware 6

First of all, install the Improved Import, Export & Mass Actions application to enable the Shopware 6 Google Sheets import. You can find the installation guide here: App Installation.

Next, you will need to get a link to your Google Sheets file.

Finally, you will be able to import data from Google Sheets to Shopware 6. 

Get a link to your Google Sheets file

You can get a link to your Google Sheets file as follows: 

1. Open your Google Sheets file and go to File -> Share -> Share with others;
   
2. In the General Access dropdown, choose Anyone with the link. It doesn’t matter whether you select Viewer, Commenter, or Editor;
   
3. Next, click Copy Link and Done.

Now, you can use this link to import data from your Google Sheets table to Shopware 6

Configure a new import profile

Now, you need to create a new import profile. Go to Extensions -> Improved Import, Export & Mass Actions -> Product Import and click the New Profile button.

The Select file screen displays. Follow these steps to configure your Shopeare 6 Google Sheets import: 

1. Specify your profile’s name; 
2. Select an entity you want to import (e.g., products or customers);
3. Create a schedule of updates if applicable;
4. Configure email notifications if necessary;
5. Select your file format – google-sheets (the app also works with CSV, XML, and XLSX files);
6. Choose Google Sheets as your import source and paste a link to your sheet (also, file, URL, FTP, and Google Drive are under your disposal);
7. Specify separators if your update includes unusual separators;
8. Configure advanced settings:  URL rewrite behavior, media replacement behavior, and stock increment strategy. 

Click Continue to proceed to the mapping tab. If the provided link is unsupported, the app will inform you about that. Get a proper link and repeat your attempt. 

On the mapping screen, specify which columns from the imported file should match the properties of the products from your Shopware 6 store. If your Google Sheets update is not prepared for Shopware 6 requirements, you can easily replace unsupported column names with suitable ones right now.

Click Continue to proceed. The app displays a product preview. 

Next, click the Save button to save your Google Sheets import profile. When you click the Import button at the bottom of the Preview result page, the app launches the update transferring your data file from Google Sheets to Shopware 6.

You can read more about the enhanced Shopware 6 import in our Improved Import, Export & Mass Actions Manual. 

Other Features

With the Improved Import, Export, and Mass Actions app you can not only import data from Google Sheets but also address numerous issues associated with the standard Shopware data transfers. For instance, the application provides the ability to work with numerous file types and sources, automate data transfers with update schedules, and map external attributes to local properties to make any third-party file suitable for Shopware 6 import. The following features are at your service:

• Full product import and export including custom properties (attributes);
• Customer import and export including addresses;
• Orders export;
• Full support for product variants with a full set of attributes;
• Product properties mapping and mapping presets;
• Import and export schedules;
• Support for CSV, XLSX, and XLSX file types;
• Direct file uploads;
• FTP/FTPS uploads.

You can find more information about the product here: 

• Improved Import, Export & Mass Actions application for Shopware 6 
• Improved Import, Export & Mass Actions Manual 
• Or contact us.