Today, we delve into a critical subject – the integration of Google Sheets with BigCommerce, representing a revolutionary enhancement to the default BigCommerce data import functionality. By default, BigCommerce only supports manual file uploads. This means that if your updates are located elsewhere, such as on a remote server, you are unable to seamlessly import them into your e-commerce website. This limitation extends to third-party services like Google Sheets or Google Drive as well.
Opting for the default BigCommerce tools necessitates the manual transfer of updates from external storage to your BigCommerce platform. In the case of updates stored in a Google Sheets file, you would need to export it as a CSV file before importing it into your e-commerce website.
Fortunately, there exists a more efficient method to execute BigCommerce Google Sheets imports. Allow us to introduce you to the Improved Import & Export Tool for BigCommerce, which completely overhauls the standard BigCommerce import process. It grants you the capability to seamlessly connect with the widely-used online spreadsheet editor.
In the following tutorial, we will elucidate the process of importing data from Google Sheets into your BigCommerce store. Additionally, we recommend consulting our comprehensive guide on BigCommerce Google Sheets integration, and be sure to explore our BigCommerce Cookbook for additional valuable insights.
Table of contents
What is Google Sheets
Google Sheets stands out as a widely-used spreadsheet application developed by Google. This versatile tool boasts several advantages—it’s not only free but also user-friendly, accessible via the web, and available as a mobile app for both Android and iOS platforms. Moreover, it can be employed as a desktop application on Google’s ChromeOS.
One particularly advantageous feature is Google Sheets’ compatibility with Microsoft Excel file formats. This means that you can effortlessly upload any Excel file to your Google Drive and swiftly convert it into a Google Sheets table with just a few clicks.
When it comes to updating your BigCommerce platform with data stored in a Google Sheets file, the process has become more streamlined. You no longer need to go through the manual steps of downloading and re-importing the data. Instead, you can establish a direct connection between the two systems. In the subsequent section, we will guide you through the process of seamlessly importing data from Google Sheets into your BigCommerce environment.
How to import Google Sheets files to BigCommerce
To initiate the BigCommerce Google Sheets import process, follow these sequential steps:
- Install the Improved Import & Export Tool: Your initial action is to install the Improved Import & Export Tool. This tool is essential to enable seamless data transfer between Google Sheets and your BigCommerce platform.
- Retrieve a Link to Your Google Sheets File: Subsequently, acquire a shareable link to your Google Sheets file. This link will serve as the bridge between your spreadsheet data and BigCommerce, facilitating the import process.
- Import Data from Google Sheets to BigCommerce: With the Improved Import & Export Tool installed and the shareable link in hand, you will then have the capability to import data directly from Google Sheets into your BigCommerce environment.
These steps will enable you to efficiently integrate and import data from Google Sheets into your BigCommerce store.
Retrieve a Link to Your Google Sheets File
Here are the steps for obtaining a link to your Google Sheets file and importing data from Google Sheets to BigCommerce:
Obtaining a Shareable Link:
- Open your Google Sheets file and navigate to File -> Share -> Share with Others.
- In the General Access dropdown, select “Anyone with the link.” You can choose from Viewer, Commenter, or Editor, as per your requirements.
- Click on “Copy Link” and then click “Done.”
Now, you can utilize this link to facilitate the import of data from your Google Sheets table to BigCommerce.
Import Data from Google Sheets to BigCommerce
Now, you need to create a new import profile:
- Proceed to create a new import profile by going to Apps -> My Apps -> Firebear Import & Export Tool -> Import, and click the “New Profile” button.
- The “Select File” screen will appear. Follow these steps to configure your Google Sheets import for Shopware 6:
- Specify a name for your profile.
- Choose the entity you wish to import (e.g., products).
- Set up a schedule for updates if needed.
- Configure email notifications if necessary.
- Select your file format as “google-sheets” (the app also supports CSV, XML, and XLSX files).
- Opt for Google Sheets as your import source and paste the link to your sheet.
- Specify separators if your update contains unusual separators.
- Configure advanced settings such as stock increment strategy.
- Click “Continue” to proceed to the mapping screen. If the provided link is unsupported, the app will notify you. In such cases, ensure you have the correct link before proceeding.
- On the mapping screen, indicate which columns from the imported file should match the properties of the products in your BigCommerce store. If your Google Sheets update doesn’t align with BigCommerce requirements, you can easily replace unsupported column names with suitable ones.
- Click “Continue” to proceed. The app will display a product preview.
- Finally, click the “Save” button to save your Google Sheets import profile. When you’re ready to import, click the “Import” button on the Preview result page. The app will initiate the data transfer from Google Sheets to your BigCommerce platform.
For more detailed information on enhancing your BigCommerce import, refer to our “Improved Import & Export Tool Manual.”
This comprehensive guide ensures a seamless and efficient process for integrating Google Sheets data into your BigCommerce store.
BigCommerce business owners have the valuable opportunity to address a multitude of import and export challenges effectively through the utilization of the Firebear Import & Export Tool. Unlike the default data transfer tool, this software solution offers a range of features, including support for various file formats and sources, scheduling options, and notifications. Its key components, which are currently available or will be introduced in the near future, encompass:
- Full product import and export capabilities, encompassing custom properties (attributes).
- Import and export functionality for customers, including address details.
- Export functionality for orders.
- Comprehensive product properties mapping and mapping presets.
- Flexible import and export scheduling.
- Compatibility with file formats such as CSV, XLSX, and XLSX.
- Seamless integration with Google Sheets for both import and export operations.
- Direct file uploads for added convenience.
- Support for FTP/FTPS uploads for secure data transfer.
- Integration with Google Drive for hassle-free uploads.
For further information about this product, please visit:
- Firebear Import & Export Tool for BigCommerce
- Firebear Import & Export Tool Manual
- Contact us
The Firebear Import & Export Tool empowers BigCommerce business owners to enhance their data management capabilities, streamlining import and export processes for increased efficiency and productivity.