WooSheets Manage WooCommerce Orders with Google Spreadsheet

Description

WooSheets V4.3 Update

– Add New Sheet Headers, Edit Sheet Headers and Re-order Sheet Headers

– Add All Orders Sheets

– Clear Spreadsheet Option

– 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 Data to manage your all the orders.

With WooSheets, you get professional 24/7 support and extensive Documentation.

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

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

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 – [email protected] 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 Sheets & Google Drive API must be Enable

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

Please visit link Click Here.

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

Yes, You can add/edit/re-order the sheet headers columns as per your requirements.

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.3 (9 July 2020)
------------------------------------------------------------------------------------
- Edit Sheet Headers

- Clear Spreadsheet Option

- Optimize the code

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