WPSyncSheets For Woocommerce

Documentation

WooCommerce Google Spreadsheet Addon

Change Logs

For guidance to Create Google API settings. Go through Video Tutorial

Version 9.2.0 (18 November 2024)

  1. Introduced a date range filter to sync products based on sale periods
  2. Added an option to include child categories when syncing products through product-category-specific sheets.
  3. Split the “Product Image” header into two options like Product Image and Product Gallery Images where each holding relevant data.
  4. Improved overall code performance and efficiency.
  5. Enhanced overall design aesthetics and visual appeal.

Version 9.1.1 (9 July 2024)

  1. Add dependency with lite version
  2. Add filter for sync products with product category wise sheet
  3. Add Order compatibility with WooCommerce Orders Tracking Premium Plugin
  4. Add Order compatibility with Tour & Travel Booking Manager PRO by MagePeople Team
  5. Optimize the Code

Version 9.1 (27 May 2024)

  1. Add Compatibility with HPOS WooCommerce
  2. Add Order compatibility with Order Delivery Date for WooCommerce by Tyche Softwares lite plugin
  3. Optimize the Code

Version 9.0.3 (27 March 2024)

  1. Added Product compatibility for Cost of Goods for WooCommerce by WPFactory
  2. Added Coupon usage count header in Coupon Settings
  3. Optimize the Code

Version 9.0.2 (9 November 2023)

  1. Product Compatibility with WooCommerce Subscriptions Plugin
  2. Optimize the Code

Version 9.0.1 (18 August 2023)

  1. Add New Order Setting Option – Exclude Order Status from Order Note
  2. Optimize the Code

Version 9.0.0 (27 July 2023)

  1. New UI Designs Change
  2. Optimize the Code

Version 8.1.1 (27 June 2023)

  1. Fixed issues with Inherit Styles option added in all settings
  2. Optimize the Code

Version 8.1 (27 June 2023)

  1. Add Inherit Styles option added in all settings
  2. Add Product compatibility with JetEngine by Crocoblock – View Lists
  3. Product and Order compatibility with SOFT79 Expiry dates for WooCommerce PRO by Soft79
  4. Fix issues with order compatibility of YITH WooCommerce Product Add-Ons
  5. Enhanced the functionality to update order item attributes during order import
  6. Optimize the Code

Version 8.0.1 (18 May 2023)

  1. Fixed issues with Import Products/Customer
  2. Row color option apply to selected sheets
  3. Optimize the Code

Version 8.0 (9 May 2023)

  1. Add Custom Static Headers Option for Products & Customers Settings
  2. Fixed issues for the import attributes & language products sync
  3. Fixed issues for Freeze Header & Background Color option
  4. Updated plugin compatibility for WooCommerce Checkout Manager – By QuadLayers
  5. Updated plugin compatibility for WooCommerce Booking
  6. Optimize the Code

Version 7.9 (27 April 2023)

  1. Schedule Auto Import/Export has options with 10 minutes
  2. Added Import Export Huge Amounts of Data
  3. Added Order Item ID as a new sheet header
  4. Added Product Menu Order and Product Variation Menu Order as new sheet headers
  5. Optimize the Code

Version 7.8 (7 April 2023)

  1. Product compatibility with ACF fields –View Lists
  2. Added Order ID with the hyperlink
  3. Added filter for Customer Settings custom headers options
  4. Fixed issues for Auto Schedule on UTC time to default website time
  5. Fixed issues for Export Orders and Products with huge numbers of data
  6. Optimize the Code

Version 7.7 (9 March 2023)

  1. Product compatibility with Product Notes for WooCommerce by Algoritmika Ltd plugin
  2. Auto import feature for Customers and Coupons
  3. Optimize the Code

Version 7.6 (7 January 2023)

  1. Product compatibility with WooCommerce Cost of Goods by SkyVerge plugin
  2. Product compatibility with WooCommerce Brands by WooCommerce plugin
  3. Optimize Code for Bulk Order Status change via admin
  4. The license key read-only issue resolved
  5. Resolved Cron issues settings
  6. Optimize the Code

Version 7.5 (31 October 2022)

  1. Order compatibility with Flexible Product Fields and Flexible Product Fields Pro by WP Desk plugin
  2. Products click to sync with WPML custom language
  3. Sync and Import Attributes in Product settings
  4. ‘Order Id with Link’ header added to Order settings

Version 7.4 (26 September 2022)

  1. Product compatibility with WPML Multilingual
  2. Product compatibility with ACF and ACF Pro plugin (Text and URL fields only)
  3. Order compatibility with Supplier Management for Woocommerce by P5Cure plugin
  4. Click To Sync with the custom date range
  5. Add a single product click to the sync button
  6. Schedule Auto Sync for all
  7. Added ‘Show Attributes at product page’, ‘Attributes to use for Variations’, ‘Attributes visible at product page’, ‘Product Category Ids’ sheet headers
  8. Detach an image from a product
  9. Optimized code

Version 7.3 (27 July 2022)

  1. ‘Product Catalog Visibility’ and ‘Is Featured Product’ sheet headers were added to product settings
  2. New Bulk insert products sheet option created

Version 7.2 (25 June 2022)

  1. Woocommerce Delivery & Pickup Date Time Pro by CodeRockz
  2. Checkout field editor and Manager for WooCommerce – Pro by Acowebs
  3. Product Names as sheets within a single Google Spreadsheet

Version 7.1 (14 June 2022)

  1. Bulk Insert Products Options
  2. Add User Role Capability
  3. Resolve Cron and Export Order Tab issues
  4. Optimize Code

Version 7.0 (4 June 2022)

  1. Yoast SEO plugin compatibility for products
  2. Add sheet header column for “Use Attributes for Variations”
  3. Events Settings order will be managed as per the event categories
  4. Optimize Click to Sync for Events
  5. Add New Filters – Go to Filters, Hooks & Snippets Documentation Page

Version 6.9 (10 May 2022)

  1. Add Schedule Auto Import Products

Version 6.8 (4 April 2022)
  1. Compatibility with EAN for WooCommerce
  2. Allow custom meta keys with prefix wpsyncsheets_
  3. WooCommerce Events data issues resolved
  4. Optimize Code

Version 6.7 (24 February 2022)
  1. Compatibility with YITH Cost of Goods for WooCommerce
  2. Compatibility with Food Store – Online Food Delivery & Pickup
  3. Add bypass plugin filter
  4. Import Orders with Insert/Update/Delete
  5. Optimize Code

Version 6.6 (31 December 2021)
  1. Optimize Code
  2. Rename Order Status with Sheet Name
  3. Compatibility with WooCommerce Gravity Forms Product Add-ons

Version 6.5 (19 November 2021)
  1. Optimize Code
  2. Compatibility with Advanced Product Fields (Product Addons) for WooCommerce

Version 6.4 (18 October 2021)
  1. Add License Key Code
  2. Add formula option to get values from the spreadsheet

Version 6.3 (29 September 2021)
  1. Optimize Code

Version 6.2 (20 September 2021)
  1. Import Orders Option
  2. Schedule Auto Sync

Version 6.1 (14 September 2021)
  1. Import Products Option

Version 6.0 (6 September 2021)
  1. Brand Name & Security Patch
  2. Coding Standards Improvement as per Envato guidelines

Version 5.9 (6 August 2021)
  1. Brand Name & Security Patch for next update

Version 5.8 (12 July 2021)
  1. Compatibility with WooCommerce PayPal Payments
  2. Add Click To Sync metabox
  3. Optimize Code

Version 5.7 (9 June 2021)
  1. Compatibility with Event Tickets Plus & The Events Calendar PRO By Modern Tribe, Inc.
  2. Add New Graph Sheets Functionality
  3. Optimize Code

Version 5.6 (21 May 2021)
  1. Add Product QTY Total Sheet Headers in Order Wise option
  2. Formatted price with Product Base Price and Order Base Price
  3. Add Client Role Sheet Header
  4. Optimize Code

Version 5.5 (7 May 2021)
  1. WooCommerce Coupons Sync with Google Spreadsheet
  2. Compatibility with WP Crowdfunding Products settings
  3. Custom headers with IP Address, User Agent, User Name, Site Name, Site Url

Version 5.4 (27 April 2021)
  1. WooCommerce Customers Sync with Google Spreadsheet
  2. Compatibility with WP Crowdfunding Plugin

Version 5.3 (9 April 2021)
  1. WooCommerce Products Sync with Google Spreadsheet
  2. Custom Static Headers values issues fixed
  3. Ascending or Descending with Order ID option
  4. Compatibility with Flexible checkout fields by WP Desk
  5. Compatibility with Acowebs Product Addon with Product Settings
  6. Optimize Code

Version 5.2 (20 March 2021)
  1. Click To Sync with custom date range and All Orders options
  2. Optimize the code

Version 5.1 (27 February 2021)
  1. Price Format
  2. Compatibility with WooCommerce Brands Plugin
  3. Optimize the code

Version 5.0 (7 December 2020)
  1. Officially Name Change WooSheets to WPSyncSheets For WooCommerce
  2. Row Input Format Option (RAW / USER_ENTERED)

Version 4.8 (1 December 2020)
  1. Optimize the code

Version 4.7 (31 October 2020)
  1. Change the Odd / Even Spreadsheet Rows Background Color
  2. Compatibility with YITH Woocommerce Delivery Date
  3. Compatibility with PRO Order delivery, Order pickup, Order date time, Pickup Location for WooCommerce
  4. Compatibility with WooCommerce Donation or Tip on Cart And Checkout

Version 4.6 (17 October 2020)
  1. Add category Filter Option
  2. Click to Sync with counting orders

Version 4.5 (18 August 2020)
  1. Ajax Products Listing
  2. Show Error Messages
  3. Optimize the code

Version 4.4 (27 July 2020)
  1. Download All Orders Spreadsheet as Excelsheet (.XLSX)
  2. Compatibility with WooCommerce Bookings And Appointments by PluginHive
  3. Compatibility with WooCommerce Delivery — Delivery Date & Time Slots by welunch

Version 4.3 (9 July 2020)
  1. Edit Sheet Headers
  2. Clear Spreadsheet Option
  3. Optimize the code

Version 4.2 (12 June 2020)
  1. Optimize the code

Version 4.1 (6 June 2020)
  1. Add All Orders Status and Order Status Field (All Orders in one sheet with order status field)
  2. Optimize the code

Version 4.0 (18 May 2020)
  1. Update process of Google Sheets API Token
  2. Add New Sheet Headers (Subscription Next Payment Date and Subscription End Date) within WooCommerce Subscriptions
  3. Compatibility with WooCommerce Product Add-Ons Ultimate by PluginRepublic

Version 3.9.9 (4 March 2020)
  1. Add Order Fee to deducted the fees from total
  2. Get full name of Country and State from there codes
  3. Optimize the code

Version 3.9.8 (20 February 2020)
  1. Compatibility with WooCommerce Xero CRM (Sheet Headers Name – Xero Invoice ID)
  2. Compatibility with WooCommerce Stripe Payment Gateway (Sheet Headers Name – Stripe Fee, Stripe Net, Stripe Charge Captured, Net Revenue From Stripe and Stripe Transaction Id)
  3. New Sheet Headers Name – Order Note, Order Paid Date, Order Discount Tax and Tax Total

Version 3.9.7 (18 February 2020)
  1. Export all orders of specific product categories within new spreadsheet
  2. Optimize Code

Version 3.9.6 (7 February 2020)
  1. Export with all orders or specific date range orders within new spreadsheet
  2. Optimize Code

Version 3.9.5 (23 January 2020)
  1. Products Name as Sheet Headers
  2. Add New Sheet Headers (Billing Company Name and Shipping Company Name)

Version 3.9.4 (21 January 2020)
  1. Add 3 New Languages Support (French, German and Chinese)
  2. Optimize Code
  3. Add 2 New Sheet Headers (Billing Address (All in one) and Shipping Address (All in one))

Version 3.9.3 (7 January 2020)
  1. Optimize Code
  2. Product Wise – Allow to Copy Same Columns checkbox

Version 3.9.2 (31 December 2019)
  1. Optimize Code

Version 3.9.1 (25 December 2019)
  1. Optimize Code

Version 3.9 (21 December 2019)
  1. Compatibility with WooCommerce Bookings
  2. WooCommerce Bookings Sheet Headers (Booking Start Date, Booking End Date, Booking Resource, Booking Cost, Booking Status, Booking Persons)
  3. Add Sheet Headers Shipping Total

Version 3.8 (19 December 2019)
  1. Add Custom Static Headers

Version 3.7 (14 December 2019)
  1. Resolved Product Wise Row Data issues
  2. Add Order Id and Order Number for all rows in Product Wise option
  3. Add Filter option for headers

Version 3.6 (11 December 2019)
  1. Add Product image sheet header option with thumbnail in spreadsheet
  2. Google Sheets API Update
  3. Optimize Code for settings page

Version 3.5 (5 December 2019)
  1. Plugin Compatibility with WooCommerce Checkout Manager – By QuadLayers

Version 3.4 (3 December 2019)
  1. New Designs integration
  2. One Page Integration
  3. Sorting with Sheet Headers
  4. Add auto update plugin code with Envato Market API settings
  5. Add Support Tab

Version 3.3 (18 November 2019)
  1. Plugin Compatibility with Product Addons for Woocommerce – By Acowebs
  2. Optimize Code for WooCommerce TM Extra Product Options – By ThemeComplete
  3. Optimize Code for Token Generate

Version 3.2 (09 November 2019)
  1. Optimize Code

Version 3.1 (07 November 2019)
  1. Optimize Code WooCommerce Checkout Field Editor Pro – By ThemeHigh
  2. Click to Sync All function have unique orders
  3. Optimize new order formatting code in spreadsheet

Version 3.0 (23 October 2019)
  1. Optimize code, < WooSheets 2.9 have 8.9 MB Zip and WooSheets 3.0 have 1.18 MB
  2. Add Variation Name with product wise option

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

Version 2.8 (7 October 2019)
  1. Compatibility with WooCommerce Product Option – By ThemeComplete
  2. Optimized the code

Version 2.7 (1 October 2019)
  1. Compatibility with WooCommerce Checkout Field Editor – By WooCommerce
  2. Compatibility with WooCommerce Checkout Field Editor Pro – By ThemeHigh

Version 2.6 (20 September 2019)
  1. Compatibility with WooCommerce Subscriptions latest version
  2. WooCommerce Subscriptions Headers
    1. Subscription Price
    2. Subscription Sign Up Fee
    3. Subscription Period
    4. Subscription Period Interval
    5. Subscription Length
    6. Subscription Trial Period
    7. Subscription Trial Length
    8. Subscription Limit
    9. Subscription One Time Shipping
    10. Subscription Payment Sync Date

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

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

Version 2.3 (5 September 2019)
  1. Compatibility with WooCommerce Product Add-Ons Plugin
  2. Compatibility with YITH WooCommerce Product Add-Ons Plugin

Version 2.2 (14 August 2019)
  1. Compatibility with WooCommerce Sequential Order Numbers Plugins
  2. Add Trash Orders Status
  3. Add Order Number headers with Product and Order Wise option
  4. Add SKU in Product Wise option

Version 2.1 (1 August 2019)
  1. Update Product SKU
  2. Add Product Meta headers in Product Wise Option

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

Version 1.3 (28 May 2019)
  1. Update process of Google Sheet API Token
  2. Add New Additional Headers
    1. Transaction ID
    2. Customer Note
    3. Customer ID
    4. Shipping Method Title
    5. Tax Total
    6. Coupons Codes
    7. Order URL
    8. Prices Include Tax

Version 1.2 (7 May 2019)
  1. Compatible With PHP, WordPress and WooCommerce latest version
  2. Manage Row Data (Order Wise and Product Wise Row Data)
  3. Auto Ordering
  4. Add SKU
  5. Freeze Headers
  6. Add New Headers for Product Wise and Order Wise Row Data

Version 1.1 (31 January 2019)
  1. Compatible With WordPress and WooCommerce latest version
  2. 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)
  1. Initial Version

Need help?

We're ready to help out & answer questions!