WPSyncSheets For WooCommerce Review: Import-Export Store Data (Tried & Tested)

WPSyncSheets For WooCommerce allows you to import and export data between your WooCommerce store and Google Sheets. 

I have been using WPSyncSheets for a couple of months, and it has been proven to be a powerful import-export plugin for the WooCommerce store while being very user-friendly. 

In the following review, I will cover the plugin’s offerings, pricing plans, and how to use it. 

Dive right in. 

WPSyncSheets For WooCommerce Overview

WPSyncSheets For WooCommerce comes from the house of WPSyncSheets – a plugin development company known for building migration plugins for WordPress and WooCommerce. 

WPSyncSheets For WooCommerce is their flagship product and one of the best WooCommerce migration plugins I’ve encountered. 

The WPSyncSheets For WooCommerce allows you to import-export the following data types from a WooCommerce store: orders, products, customers, and coupons. 

Using the plugin, you can export data from your store into Google Sheets and then utilize the same sheet to import data into your WooCommerce store. 

You can also update or delete data on the sheet, which will automatically be updated or removed from your store. 

In order words, the plugin connects your store with a Google Sheet, allowing the two platforms to sync data in real-time. 

This migration plugin is ideal for backing up store data off-site, collaborating with team members without giving them access to the store’s backend, and bulk updating store data within minutes. 

Its Impressive Set of Features

The plugin offers the following features: 

1. Comprehensive Data Export 

With WPSyncSheets, you can export all your WooCommerce data to Google Sheets, including complete order details, product information, customer data, and coupon details. 

You can export order IDs, items, quantities, totals, billing addresses, product names, types, images, and SKUs. 

Also, export customer data such as user roles, email addresses, names, coupon details, codes, expiry dates, applicable products, and event information, including event names, images, and dates.

2. Data Import Capabilities

The plugin lets you import data from Google Sheets directly into WooCommerce, making updating your store’s data easy. 

You can import orders with their associated items, totals, statuses, fees, notes, and product data, including images, SKUs, and pricing information. 

You can also import customer data, including first names, roles, billing addresses, coupon details like expiry dates, amounts, maximum spend limits, and event details, such as event names, images, dates, and attendee counts.

3. Automate Sync

WPSyncSheets allows your WooCommerce store and the Google Sheets you have been using to import and export data to sync in real-time. This means that if you add new data or update or delete data on any platform, the action is automatically replicated on the other platform — no manual intervention is required. Your data is always up to date on both platforms. 

4. Generate Data Graphs on Google Sheets

The data exported on your Google Sheets can be used to generate graphs on key store metrics, such as sales, order statistics, product performance, and customer counts. 

You can customize these graphs through the plugin’s settings interface.

5. Granular Control Over Import-Export 

WPSyncSheets provides various configuration options to control data migrations and manage spreadsheets. 

You can create new Google Spreadsheets or map to existing ones, control sheet headers, and choose between order-wise or product-wise organization. You can also freeze the first row, select from different input formats, customize price formats, and alternate row background colors.

6. Compatibilities 

WPSyncSheets For WooCommerce integrates with ACF Lite and Pro custom fields and supports multiple languages and multisite installations.

WPSyncSheets For WooCommerce: Pros & Cons

Pros

• Easily import and export WooCommerce data to Google Sheets
• Automate data sync between WooCommerce and Google Sheets
• Supports real-time data synchronization with Google Sheets
• Granular control over import and export settings
• Generate data graphs on Google Sheets for key store metrics
• Compatible with ACF Lite and Pro custom fields
• Supports multiple languages and multisite installations

Cons

• Free version only supports exports, not imports
• Does not import-export posts and pages 
• Businesses may become overly reliant on Google Sheets for data management needs
• Data migration from WooCommerce stores to Sheets can lead to data overload, which complicates data maintenance and analysis

Pricing Plans

There are free and paid versions of the plugin. 

The free version has some limitations. Using the free plugin, you can only export orders, products, customers, and coupons. 

To export events and ACF fields, you need the paid plugin. You need the paid plugin to import orders, products, customers, coupons, events, and ACF fields. 

The paid plugin has three-tiered pricing plans. The single website license costs $49, and five sites and twenty-five sites license costs $149 and $449 annually. 

The lifetime plans start at $249, $399, and $699 for one, five, and twenty-five sites, respectively.

You can make a combined purchase by buying the WPSyncSheets For WooCommerce with another WPSyncSheets plugin for a starting price of $79 for a single website license. 

Learn more about the pricing plans. 

How to Import-Export Data With WPSyncSheets For WooCommerce 

We are demonstrating how to import-export WooCommerce data using the paid WPSyncSheets For WooCommerce plugin. 

Step 1: Install & Active WPSyncSheet For WooCommerce

Download the plugin from your WPSyncSheets account or welcome email to your local computer. 

Next, upload and activate the plugin in your WooCommerce store. 

Then go to WPSyncSheets → For WooCommerce → License, and then add your unique license to activate the paid plugin. You will get the license from your WPSyncSheets account or the welcome email. 

Step 2: Connect Your GDrive With WooCommerce

To import export data between your store and Google Sheets, you need to connect the store with your GDrive account, where the Google Sheets will be generated. 

This connection can be made using Google API keys, which must be generated from Google Cloud Services. Here is a help doc to help you generate Google API keys. 

Once you have the keys, go to WPSyncSheets → For WooCommerce → API Integration and add the Client ID, Secret Key, and Token for the integration to begin. 

Step 3: Export Orders, Products, Customers, & Coupons

The process of exporting orders, products, customers, and coupons is similar. So, instead of repeating the same steps, I’d only demonstrate how to export orders. You can follow the same steps to export the others by visiting their individual settings pages. 

Now, to export orders, go to Order Settings and toggle on the Order Settings option. 

Immediately, numerous other options will populate the page. Let’s take a look at those options:

Google Spreadsheet Settings: Allows you to generate a new Google Sheet or to select an existing one to export your WooCommerce orders to. It has options to create, preview, or download the spreadsheet.

Default Order Status as Sheets: When enabled, this option creates separate sheets in your Google Sheet for each default WooCommerce order status, such as “Pending,” “Processing,” and “Completed.” For example, if you enable the “Completed Orders” option, you will see a new “Completed Orders” sheet listing all completed orders.

Custom Order Status as Sheets: Create sheets for custom order statuses defined by third-party plugins. For instance, if you have a custom status like “Awaiting Payment,” enabling this option will generate a separate sheet that organizes all orders with that status.

Product Names as Sheets: Generates a separate sheet for each product name, containing all orders that include that specific product. For example, if you sell “Blue T-Shirts,” there will be a dedicated sheet listing all orders that contain blue T-shirts.

Manage Row Data: Choose how data is organized in the sheet. Selecting “Order-wise” would display all details of an order in one row, while “Product-wise” would list each product of an order on a separate line.

Sheet Headers: Here, you can enable or disable specific headers in your Google Sheet corresponding to your WooCommerce order data. For instance, if your default headers include “Order ID,” “Customer Name,” and “Total Amount,” you can disable “Total Amount” if it’s not needed.

Custom Static Headers: Add personalized headers to your Google Sheet. For example, you could add a custom header called “Delivery Method” to include additional information about how the order was shipped.

Select Category: Filter orders in the Google Sheet to include only those from selected product categories. For example, if you select the category “Electronics,” only orders containing electronic products will be exported to the spreadsheet.

Product Name as Sheets Headers: Creates columns in the Google Sheet for selected product names, displaying their quantities. For instance, if you have products like “Laptop” and “Mouse,” columns for each product will show how many of each were ordered.

Append After: Specifies where the product name columns should be inserted in the Google Sheet. For example, if set to append after “Customer Name,” the product name columns will appear immediately after the customer information.

Spreadsheet Row Order: Determines how rows are organized based on order ID. For instance, if you set it to sort by order ID in ascending order, orders will be listed from the lowest ID number to the highest.

Inherit Styles: Controls whether new rows in the Google Sheet inherit styles from the row above. For example, if the row above has a specific font color and background shading, enabling this option would apply those styles to new rows added below it.

Exclude Order Status from Order Notes: Excludes notes regarding order status changes from appearing in the order notes section. So if an order status changes from “Pending” to “Completed,” this note will not be included in the exported data.

Import Orders: This allows you to import orders from Google Sheets into your WooCommerce store and provides settings to insert, update, or delete orders, with options to add new orders, modify existing ones, or remove orders entirely.

Sync Orders: It synchronizes orders from your WooCommerce store with the Google Sheet, adding new orders and leaving existing ones unchanged. This can be scheduled to run automatically.

Schedule Auto Sync: This option enables automatic synchronization of orders at specified intervals, allowing you to keep your Google Sheet up-to-date with your WooCommerce store’s order data.

I recommend that you take some time to modify these options according to your needs and then hit the Save button.

When you are done, let’s start exporting order data into Google Sheets. 

Go to Google Spreadsheet Settings → Create New Spreadsheet, add a name to the sheet, and hit enter. 

A Google Sheet with that name will be generated. 

Next, choose the Select Existing Spreadsheet option, select the Google Sheets you generated, and hit the eye button to open the Google Sheets in a new tab or hit the download button to download the spreadsheet to your local computer.

Here’s how exported orders look on Google Sheets:

IMPORTANT: To export products, customers and coupons, you must carry out the same steps in the relevant setting pages. 

Need more assistance with export? Check out these help docs.

Step 4: Import Orders, Products, Customers, & Coupons

By now, you should have four separate sheets with exported data on orders, products, customers, and coupons. 

You will use these sheets to import data into your WooCommerce store. 

Open the Settings page (Order Settings, Product Settings, Customers Settings, or Coupons Settings) and scroll down to the Import section. Enable it and then enable the Insert, Update, and Delete options. 

Next, go to the Sync section and hit the Click to Sync button. 

This will add new columns to the four Google Sheets you generated with exported data. You will use these columns to import new data into your store.

To add data to your store, fill in a row with the new data and then add “1” in the Insert column. 

Go to the Settings page and hit the Click to Sync button. This will import data into your WooCommerce store.

To update existing data, modify the data in the sheet and add “1” in the Update column. To delete data from the store, just add “1” in the adjacent Delete column. And don’t forget to hit the Click to Sync button to sync data between your store and the sheet.

You can also schedule sync so that you don’t have to initiate the sync process again and again manually. 

Need more assistance with import? Check out the following help docs:

• How to Import Orders 
• How to Import Products 
• How to Import Customers
• How to Import Coupons

Step 5: Configure General Settings

I recommend checking the General Settings page and making necessary modifications. 

You can customize and tailor the Google Sheets to meet your specific needs. For instance, freeze the header row to keep essential details visible while scrolling, automatically assign alternating row background colors to organize data, and define how input data should be interpreted. 

Additionally, you can customize the display format for price values and generate graph sheets based on the latest data, with the option to regenerate them at any time. 

Final Thoughts

WPSyncSheets For WooCommerce is a powerful and user-friendly plugin that enables seamless import and export of data between WooCommerce stores and Google Sheets. 

This user-friendly plugin not only facilitates the seamless import and export of critical store data—such as orders, products, customers, and coupons—but also automates real-time synchronization, ensuring that both platforms remain updated without manual intervention.

The ability to generate data graphs on Google Sheets and customize the display format for price values adds an extra layer of functionality, making it an essential tool for any WooCommerce store owner. 

While there are some limitations to the free version, the paid plans offer excellent value, with pricing starting at $49 for a single website license. 

Overall, WPSyncSheets For WooCommerce is a must-have plugin for anyone looking to streamline their data management and analysis processes, and I highly recommend giving it a try. 

Get WPSyncSheets For WooCommerce today!