WebToffee Logo
  • Home
  • Plugins
  • Blog
  • Documentation
  • Support
Login
0

  • Getting Started
    • Plugin setup
    • Import/Export Products
    • Import/Export Product Reviews
    • Import/Export Product Tags
    • Import/Export Product Categories
  • Import
    • Import products with attributes
    • Import google drive images
    • Import grouped products
    • Import products using URL
    • Importing downloadable products
    • Import subscription products
    • Import products using CSV
    • Import products with images
    • Updating evaluation fields on Import
    • Import products from MS Excel
    • Import products with categories
    • Import products from Google Spreadsheet
    • Import composite products
    • Import external/affiliate products
    • Import variable products from CSV
  • Export
    • Export products to CSV
    • Batch export products
    • Exporting products by category
    • Export definite number of products
    • Export product variations[v-3.8.5]
    • Export product lists[v-3.8.5]
    • Export products to MS Excel
    • Export product with categories
    • Export products with images
    • Export variable products
    • Export products with attributes
  • Meta Data
    • Import product metadata from CSV
  • Bulk Edit
    • Bulk update product category
    • Bulk upload variable products
    • Bulk upload products
    • Bulk update product price
  • FTP Cron Schedules
    • Cron Import products using multiple CSVs
    • Cron scheduled Import-export
    • Export products via SFTP
  • Code Snippet
    • Set email alert on cron import
    • Export without user restrictions
    • Export/Import bundled products
    • Export/Import product variation images
    • How to filter and export WooComm...
    • Alter product data
    • Compatibility with YITH Product Bundle
    • Export reviews with no ratings
    • Import images from multiple columns
    • Support for WebP images
  • Advanced Topics
    • Migrate from Shopify to WooCommerce
    • Update simple and variable products
    • Import/Export custom fields
    • Update inventory data
    • Import/Export products to Google Spreadsheets
    • Updating product stock
    • Plugin visibility on a multisite
    • WPML Compatibility
    • Thumbnail regeneration failure on product import
    • Import/Export product bundles
    • Set up cron when site activity is less
    • Export WPML multilingual products
    • Update product variations without SKU
    • Steps to import WPML products
    • Duplicate entry in the media library
    • Memory limitations on Import/Export
    • Import/Export product images in ZIP
  • Troubleshooting
    • Finding PHP Error Logs
    • Resolve “Call to undefined function mb_detect_encoding()”
    • Resolve post ID conflicts on import
    • Troubleshooting Guide-Products
    • Maximum file upload size
  • Third-Party Compatibility
    • Plugins
  • FAQ
    • Frequently asked questions
  • Changelog
    • Version 1.1.2

Documentation/Product Import Export Plugin for WooCommerce/How to Import WooCommerce Products Using Google Spreadsheet

How to Import WooCommerce Products Using Google Spreadsheet

Last updated on April 13, 2022

Importing WooCommerce products into your store can be done with ease using the plugin,  Product Import Export for WooCommerce. The plugin offers three different methods for importing:

  • import locally using a CSV/XML file from the system
  • via FTP 
  • using a URL

To begin with, you will have to create a google sheet with the required data in appropriate column headers.

For an uninterrupted import of products, the column headers must be specified in a pre-defined format. However, you can even enter custom headers at this stage and map later during the import process.
WooCommerce Product Export-Google spreadsheet
WooCommerce Product Export-Google spreadsheet
To use Google Spreadsheet URL for importing, ensure that the importing URL is publically accessible.

Publishing URL to the web

To publish your Google Spreadsheet URL to the web: 

  1. Open your Google Spreadsheet.
  2. Click File at the top left.
  3. Click Publish to the web.
  4. Publish your spreadsheet (If your spreadsheet is not yet published):
    • Click Publish.
      publish-to-web
    • Click OK in the pop-up window.
      publish-confirmation
    • Copy the URL displayed on the Link tab.
      get-link-of-spreadsheet

To use google spreadsheet URL in the required CSV format:

  • Choose the required sheet under the dropdown, Entire Document.
  • Specify the .csv extension under Webpage.

Importing steps

From the WordPress admin panel’s menu, click on WebToffee Import /Export (Pro) > Import.

  1. Select the required post type.
  2. Select either Quick or Advanced import method.
  3. Select URL under Import from and paste the Google Spreadsheet link in the field, Enter file URL.enter-file-url
  4. Click on Step3 to map the columns and move to step 4 to finish importing.

Follow the steps in How to import products for more detailed documentation.

  • Was this article helpful?
  • Yes, thanks!Not really
Get the plugin

On this page

  • Publishing URL to the web
  • Importing steps

This article posted in Documentation, Import, Knowledge Base, Product Import Export Plugin for WooCommerce

Written by

Vineetha

Vineetha is a technical content writer with a knack of simplifying complex information into readable content. She focuses on writing content in a conveyable and clear format.

Comments (9)

  1. isdine

    June 17, 2021

    Hello with the url connection, can we add products directly from googlesheets without having to go to wordpress?

    Reply
    • Alan

      Alan

      June 21, 2021

      Hi,

      If you are required to schedule the import from the Google sheet, you may please first generate the public downloadable URL of the sheet as in the below article and then schedule the import using the google sheet URL by specifying the import time. Later on, the import will run automatically in the background and import the data present in the file.
      https://www.webtoffee.com/how-to-import-woocommerce-products-using-google-spreadsheet/

      Reply
      • Snoop

        March 17, 2022

        Hi!. and is it possible to set up a cron job in order to do that regularly?

        Reply
        • Alan

          Alan

          March 17, 2022

          Hi,
          Yes, you can set up a cron job to update regularly.

          Reply
  2. Scott Rust

    Scott Rust

    May 7, 2021

    I am trying to import from a google sheet and having problems. I have made the cvs file publicly accessable. However, my link is slightly different than what is in the instructions. The instructions say – Replace the trailing edge of the URL from “edit?usp=sharing” to “export?format=csv”

    My link ends with “view?usp=sharing”. I have tried replacing this text with the “export?format=csv” and using the link as is. Neither work.

    What should I try next?

    Reply
  3. Manuel

    Manny

    September 30, 2020

    Can you import group products and how?

    Reply
    • Mark

      Mark

      December 16, 2020

      Hi,

      Yes, you can import grouped products. Please go through the below article
      https://www.webtoffee.com/importing-grouped-products-in-woocoomerce/

      Reply
  4. Luis Cardoso

    Luis Cardoso

    May 26, 2020

    I am following these steps but the Method 3: Enter the URL of the file is not working. I really needed that feature

    Reply
    • Alan

      Alan

      May 26, 2020

      Hi,

      Please make sure that the CSV file URL that you are trying to import is publically accessible and points directly to the CSV file. If the issue still persists please share with us your importing CSV file URL via support.

      Reply

Got any query? Please leave a comment or reach out to our support

Cancel reply

Your email address will not be published. Required fields are marked *

We develop awesome WordPress plugins & WooCommerce extensions to help build successful online businesses.

© 2021 WebToffee. All rights reserved.

Our plugins

  • GDPR Cookie Consent
  • PDF Invoices & Packings Slips
  • Product Import Export Plugin
  • User & Customer Import Export
  • Import Export Suite
  • Sequential Order Numbers
  • Smart Coupons for WooCommerce
  • URL Coupons for WooCommerce
  • PayPal Express Checkout
  • Stripe Payment Gateway
  • Subscriptions for Woocommerce
  • Product Catalog Sync for Facebook
  • PrintNode for PDF Invoices
  • Order, coupon, subscriptions for WooCommerce
  • WordPress Backup and Migration
View more +

Get Started

  • Plugins
  • Testimonials
  • Affiliates
  • We're hiring

Help & Support

  • Documentation
  • Documentation (Basic)
  • FAQ
  • Support

Company

  • Terms & Conditions
  • Privacy Policy
  • Refund policy
  • Support policy
  • License Activation

© 2021 WebToffee. All rights reserved.

We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies. However you may visit Cookie Settings to provide a controlled consent.
Cookie settingsACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of the basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website, to store user preferences and provide you with content and advertisements that are relevant. Such cookies will be stored on your browser but only upon procuring consent.

You will also have the option to opt-out of these cookies should you want to. But opting out of some of these cookies may have an effect on your browsing experience as per the descriptions elucidated against the respective categories below.

Necessary
Always Enabled

The cookies defines under this category are absolutely essential for the website to function. Hence they are loaded by default irrespective if user consent.

CookieDescription
PHPSESSIDThis cookie is native to PHP applications. The cookie is used to store and identify a users' unique session ID for the purpose of managing user sessions on the website. The cookie is a session cookie and is deleted when all the browser windows are closed.
viewed_cookie_policyThe cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not a user has consented to the use of cookies. It does not store any personal data.
Analytics

Analytics cookies help us understand how our visitors interact with the website. It helps us understand the number of visitors, where the visitors are coming from, and the pages they navigate. The cookies collect this data and are reported anonymously.

CookieDescription
_gaThis cookie is installed by Google Analytics. The cookie is used to calculate visitor, session, campaign data and keep track of site usage for the site's analytics report. The cookies store information anonymously and assigns a randomly generated number to identify unique visitors.
_gat_gtagIdentification code of website for tracking visits.
_gidThis cookie is installed by Google Analytics. The cookie is used to store information on how visitors use a website and helps in creating an analytics report of how the website is doing. The data collected including the number visitors, the source where they have come from, and the pages visited in an anonymous form.
_hjidHotjar cookie. This cookie is set when the customer first lands on a page with the Hotjar script. It is used to persist the random user ID, unique to that site on the browser. This ensures that behavior in subsequent visits to the same site will be attributed to the same user ID.
_hjIncludedInSampleThis cookie is set to let Hotjar know whether that visitor is included in the sample which is used to generate heatmaps, funnels, recordings, etc.
has_recent_activityThis cookie is used to signal to the code repository website if the user has browsed other website resources during the current session.
tk_aiGathers information for our own first-party analytics tool about how our services are used. A collection of internal metrics for user activity and is used to improve user experience.
tk_lrThis cookie is set by the JetPack plugin on sites using WooCommerce. This is a referral cookie used for analyzing referrer behavior for Jetpack.
tk_orThis cookie is set by the JetPack plugin on sites using WooCommerce. This is a referral cookie used for analyzing referrer behavior for Jetpack.
tk_qsGathers information for our own first-party analytics tool about how our services are used. A collection of internal metrics for user activity and is used to improve user experience.
tk_r3dThe cookie is installed by JetPack. Used for the internal metrics for user activities to improve user experience.
Advertisement

Advertisement cookies help us provide our visitors with relevant ads and marketing campaigns.

CookieDescription
_fbpThis cookie is set by Facebook to deliver advertisements when they are on Facebook or on a digital platform powered by Facebook advertising after visiting this website.
frThe cookie is set by Facebook to show relevant advertisements to the users and measure and improve the advertisements. The cookie also tracks the behavior of the user across the web on sites that have Facebook Pixel or Facebook social plugin.
Preferences

Preference cookies are used to store user preferences to provide them with content that is customized accordingly. This includes the language of the website or the location of the visitor.

CookieDescription
_gh_sessThis cookie is used to preserve users' states across page requests.
Save & Accept