WooSheets – Manage WooCommerce Orders with Google Spreadsheet

woosheets-manage-woocommerce-orders-with-google-spreadsheet.png

WooSheets V4.2
Update

– Add All Orders Status and Order Status Field (All Orders
in one sheet with order status field)

– Update process of Google Sheets API Token

– Add New Sheet Headers (Subscription Next Payment Date and
Subscription End Date) within WooCommerce Subscriptions

– Compatibility with WooCommerce Product Add-Ons Ultimate
by PluginRepublic

– Add 3 New Languages Support (French, German and
Chinese)

WooSheets
Overview

Meet
WooSheets, one of the best plugin to manage your
WooCommerce Orders within one single Google
Spreadsheet
. It can easily manage your all the orders in
single spreadsheets with 7 different order status. Each status will
create separate sheets and automatically orders based on the order
id.

It will be automatically changed the google sheet location once
we are going to change the order status from admin side. We can
also
synchronize all the existing WooCommerce
orders
within the Google Sheet. There are 2 different
options called
Order Wise and Product Wise Row Datato manage your
all the orders.

With WooSheets, you get professional and extensive .

The plugin has compliant with
PHP 7.x,
WordPress 5.3.xand
WooCommerce 3.8.x.

UPDATES are regularly made on this plugin based on your
requests. Check the to read more.

Export Orders

Products
Name as Sheet Headers

Add Custom
Static Headers

WooSheets New
Designs

Compatibility with WooCommerce Third Party Plugins

1 –
Compatibility with WooCommerce Product Add-Ons Ultimate by
PluginRepublic
– V4.0

2 –
Compatibility with WooCommerce Xero
CRM
– V3.9.8

3 –
Compatibility with WooCommerce Stripe Payment
Gateway
– V3.9.8

4 –
Compatibility with WooCommerce
Bookings
– V3.9

5 –
WooCommerce Checkout Manager – By
QuadLayers
– V3.5

6 –
Product Addons for Woocommerce – By
Acowebs
– V3.3

7 –
Product Options and Price Calculation Formulas
– Uni CPO (Premium)
–
V2.9

8 –
WooCommerce TM Extra Product Options –
By ThemeComplete
– V2.8

9 –
WooCommerce Checkout Field Editor – By
WooCommerce
– V2.7

10 –
WooCommerce Checkout Field Editor Pro –
By ThemeHigh
– V2.7

11 –
Compatibility with WooCommerce
Subscriptions
– V2.6

12 –
Compatibility with WooCommerce Default Product
Attributes
– V2.5

13 –
Compatibility for WooCommerce Order Delivery
Date
– V2.4

14 –
Compatibility for WooCommerce Product
Add-Ons
– V2.3

15 –
YITH WooCommerce Product Add-Ons &
Premium
– V2.3

16 –
WooCommerce Sequential Order Numbers &
Pro
– V2.2

17 –
Custom Order Numbers for
WooCommerce
– V2.2

18 –
YITH WoCommerce Sequential Order
Number
– V2.2

19 –
WooCommerce Order Status
Manager
– V2.0

20 –
Custom Order Status for
WooCommerce
– V2.0

21 –
YITH WooCommerce Custom Order
Status
– V2.0

22 –
WooCommerce Order Status & Actions
Manager
– V2.0

23 –
WooCommerce Advance Order
Status
– V2.0

Don’t you find your plugin in above list?
Don’t worry, Please send me an email
– with zip file and link of the plugin
author.

WooSheets
Features

FAQ

1- Can I sync existing
WooCommerce orders to Google Spreadsheet?

Yes, You can synchronize the existing WooCommerce orders by
clicking

“Click to Sync†button at
WooSheets settings page.

2- What should I do,
error: The site is experiencing technical difficulties. Please
check your site admin email inbox for instructions?

There are following ways to resolved this error:

  • Revoke token at Google API Settings Page.
  • Check the Google Drive API must be Enable

3- What should I do,
Google Sheets API limit reached?

Please visit link .

4- Can I
reorder/add/edit the sheets header columns in Google
Spreadsheets?

No, We can’t reorder/add/edit the sheet
header columns because it will be miss match the orders data.

5- What If I See a
Screen Saying “This app isn’t
verified�

Google might display a screen that says “This
app isn’t verified. This app
hasn’t been verified by Google yet. Only proceed
if you know and trust the developer.â€
There’s no need to worry, though
— the message is only referring to the app that
you just created in your own Google account (so you are actually
the developer in this case).

To bypass this message, you’ll need click
Advanced and then Proceed.

Change log

Version 4.2 (12 June 2020)
------------------------------------------------------------------------------------
- Optimize the code

Version 4.1 (6 June 2020)
------------------------------------------------------------------------------------
- Add All Orders Status and Order Status Field (All Orders in one
sheet with order status field)

- Optimize the code

Version 4.0 (18 May 2020)
------------------------------------------------------------------------------------
- Update process of Google Sheets API Token

- Add New Sheet Headers (Subscription Next Payment Date and
Subscription End Date) within WooCommerce Subscriptions

- Compatibility with WooCommerce Product Add-Ons Ultimate by
PluginRepublic

Version 3.9.9 (4 March 2020)
------------------------------------------------------------------------------------
- Add Order Fee to deducted the fees from total

- Get full name of Country and State from there codes

- Optimize the code

Version 3.9.8 (20 February 2020)
------------------------------------------------------------------------------------
- Compatibility with WooCommerce Xero CRM (Sheet Headers Name -
Xero Invoice ID)

- Compatibility with WooCommerce Stripe Payment Gateway (Sheet
Headers Name - Stripe Fee, Stripe Net, Stripe Charge Captured, Net
Revenue From Stripe and Stripe Transaction Id)

- New Sheet Headers Name - Order Note, Order Paid Date, Order
Discount Tax and Tax Total

Version 3.9.7 (18 February 2020)
------------------------------------------------------------------------------------
- Export all orders of specific product categories within new
spreadsheet

- Optimize Code

Version 3.9.6 (7 February 2020)
------------------------------------------------------------------------------------
- Export with all orders or specific date range orders within new
spreadsheet

- Optimize Code

Version 3.9.5 (25 January 2020)
------------------------------------------------------------------------------------
- Products Name as Sheet Headers

- Add New Sheet Headers (Billing Company Name and Shipping Company
Name)

Version 3.9.4 (21 January 2020)
------------------------------------------------------------------------------------
- Add 3 New Languages Support (French, German and Chinese)

- Optimize Code

- Add 2 New Sheet Headers (Billing Address (All in one) and
Shipping Address (All in one))

Version 3.9.3 (7 January 2020)
------------------------------------------------------------------------------------
- Optimize Code

- Product Wise - Allow to Copy Same Columns checkbox

Version 3.9.2 (31 December 2019)
------------------------------------------------------------------------------------
- Optimize Code

Version 3.9.1 (25 December 2019)
------------------------------------------------------------------------------------
- Optimize Code

Version 3.9 (21 December 2019)
------------------------------------------------------------------------------------
- Compatibility with WooCommerce Bookings

- WooCommerce Bookings Sheet Headers (Booking Start Date, Booking
End Date, Booking Resource, Booking Cost, Booking Status, Booking
Persons)

- Add Sheet Headers Shipping Total

Version 3.8 (19 December 2019)
------------------------------------------------------------------------------------
- Add Custom Static Headers

Version 3.7 (14 December 2019)
------------------------------------------------------------------------------------
- Resolved Product Wise Row Data issues

- Add Order Id and Order Number for all rows in Product Wise option

- Add Filter option for headers

Version 3.6 (11 December 2019)
------------------------------------------------------------------------------------
- Add Product image sheet header option with thumbnail in
spreadsheet

- Google Sheets API Update

- Optimize Code for settings page

Version 3.5 (5 December 2019)
------------------------------------------------------------------------------------
- Plugin Compatibility with WooCommerce Checkout Manager - By
QuadLayers

Version 3.4 (3 December 2019)
------------------------------------------------------------------------------------
- New Designs integration

- One Page Integration

- Sorting with Sheet Headers

- Add auto update plugin code with Envato Market API settings

- Add Support Tab

Version 3.3 (18 November 2019)
------------------------------------------------------------------------------------
- Plugin Compatibility with Product Addons for Woocommerce - By
Acowebs

- Optimize Code for WooCommerce TM Extra Product Options - By
ThemeComplete

- Optimize Code for Token Generate

Version 3.2 (09 November 2019)
------------------------------------------------------------------------------------
- Optimize Code

Version 3.1 (07 November 2019)
------------------------------------------------------------------------------------
- Optimize Code WooCommerce Checkout Field Editor Pro
– By ThemeHigh

- Click to Sync All function have unique orders

- Optimize new order formatting code in spreadsheet

Version 3.0 (23 October 2019)
------------------------------------------------------------------------------------
- Optimize code, < WooSheets 2.9 have 8.9 MB Zip and WooSheets
3.0 have 1.18 MB

- Add Variation Name with product wise option

Version 2.9 (19 October 2019)
------------------------------------------------------------------------------------
- Compatibility with Product Options and Price Calculation Formulas
for WooCommerce – Uni CPO (Premium)

Version 2.8 (7 October 2019)
------------------------------------------------------------------------------------
- Compatibility with WooCommerce Product Option - By ThemeComplete

- Optimized the code

Version 2.7 (1 October 2019)
------------------------------------------------------------------------------------
- Compatibility with WooCommerce Checkout Field Editor - By
WooCommerce

- Compatibility with WooCommerce Checkout Field Editor Pro - By
ThemeHigh

Version 2.6 (20 September 2019)
------------------------------------------------------------------------------------
- Compatibility with WooCommerce Subscriptions latest version

- WooCommerce Subscriptions Headers (Subscription Price,
Subscription Sign Up Fee, Subscription Period, Subscription Period
Interval, Subscription Length, Subscription Trial Period,
Subscription Trial Length, Subscription Limit, Subscription One
Time Shipping, Subscription Payment Sync Date)

Version 2.5 (9 September 2019)
------------------------------------------------------------------------------------
- Compatibility with WooCommerce Default Product Attributes as
Sheet Header Columns

Version 2.4 (7 September 2019)
------------------------------------------------------------------------------------
- Compatibility with Order Delivery Date for WooCommerce

Version 2.3 (5 September 2019)
------------------------------------------------------------------------------------
- Compatibility with WooCommerce Product Add-Ons Plugin

- Compatibility with YITH WooCommerce Product Add-Ons Plugin

Version 2.2 (14 August 2019)
------------------------------------------------------------------------------------
- Compatibility with WooCommerce Sequential Order Numbers Plugins 

- Add Trash Orders Status

- Add Order Number headers with Product and Order Wise option

- Add SKU in Product Wise option

Version 2.1 (1 August 2019)
------------------------------------------------------------------------------------
- Update Product SKU 

- Add Product Meta headers in Product Wise Option

Version 2.0 (7 June 2019)
------------------------------------------------------------------------------------
- Compatibility with Custom WooCommerce Order Status Plugins

Version 1.3 (28 May 2019)
------------------------------------------------------------------------------------
- Update process of Google Sheet API Token

- Add New Additional Headers (Transaction ID, Customer Note,
Customer ID, Shipping Method Title (Optional), Tax Total
(Optional), Coupons Codes (Optional), Order URL (Optional), Prices
Include Tax (Optional))

Version 1.2 (7 May 2019)
------------------------------------------------------------------------------------
- Compatible With PHP, WordPress and WooCommerce latest version

- Manage Row Data (Order Wise and Product Wise Row Data)

- Auto Ordering

- Add SKU

- Freeze Headers

- Add New Headers for Product Wise and Order Wise Row Data

Version 1.1 (31 January 2019)
------------------------------------------------------------------------------------
- Compatible With WordPress and WooCommerce latest version

- WooCommerce Admin Edit order updates with Google Spreadsheet Data
i.e. Billing Details, Shipping Details, Products, Item Total, Order
Total etc. as per the header set.

Version 1.0 (6 October 2018)
------------------------------------------------------------------------------------
- Initial Version


Download