=== FlexOrder - WooCommerce Order Sync & Management with Google Sheets ===
Contributors: ordersyncplugin, devsabbirahmed, naeemkhan25
Tags: woocommerce orders, order management, bulk edit, sync order, woocommerce export 
Requires at least: 5.4
Tested up to: 7.0
Requires PHP: 5.6
Stable tag: 1.17.7
License: GPLv2 or later
License URI: http://www.gnu.org/licenses/gpl-2.0.html

Sync WooCommerce orders with Google Sheets. Bulk edit order statuses, export order data, and manage orders in real time, two ways.

== Description ==

**Sync, Manage, and Bulk Edit WooCommerce Orders from Google Sheets - In Real Time with Two-Way Sync 🔄**

**[FlexOrder](https://wcordersync.com/)** helps you sync WooCommerce orders with Google Sheet through **two-way, real-time synchronization**. **Bulk edit order statuses, export order data**, and **manage orders in real time**, two ways, directly from a **spreadsheet**.

Any order placed in your store appears **automatically** in your connected Sheet. Any status change you make in Sheets syncs instantly back to WooCommerce. Store owners, fulfillment teams, and support staff can **manage WooCommerce orders without touching the WordPress dashboard**.

**Recommended by Professionals!**👇

https://youtu.be/sCzwNJ1wkPo?si=_yN_ol7YumwvYrAx

👁️ [View Demo](https://lnk.wppool.dev/dc3jlsv) | 🚀 [Get ULTIMATE](https://lnk.wppool.dev/qjkrdk1) | 🤝 [Join Our Facebook Community](https://lnk.wppool.dev/EIRJ9Uh) 

== With FlexOrder - Order Management, you can:==  

* **Bulk edit WooCommerce order statuses** directly from Google Sheet
* **Export WooCommerce orders automatically** with every new order placed
* **Sync order changes from Sheets** back to WooCommerce in real time
* **Sort, filter, and organize orders** for faster fulfillment
* **Manage large order volumes** without slowing down your store
* **Give team members order access through Sheets** - no WordPress login needed

**Let’s grow, connect, and thrive together:**

* **🤝 Join Our [Facebook Community](https://lnk.wppool.dev/EIRJ9Uh)** 
* **🌐 Follow Us on [X (Twitter)](https://x.com/wppool_)**
* **🎥 Subscribe on [YouTube](https://www.youtube.com/@WPPOOL)**
* **👍 Like Our [Facebook Page](https://www.facebook.com/wppool.dev)**


== 😃 FlexOrder Free Features ==

* **Two-Way WooCommerce Order Sync:** Connect your store to a Google Sheet and WooCommerce orders sync automatically in both directions. Every new order exports to Sheets instantly. Every status change made in Sheets reflects back in your store with no manual intervention needed.
 
* **Bulk Edit WooCommerce Orders:** Update the status of multiple WooCommerce orders at once directly from Sheets. Change a full batch from "Pending" to "Processing" in one action with no order-by-order updates required. [Learn more about bulk editing.](https://wppool.dev/docs/bulk-edit-woocommerce-orders-using-google-sheets/)
 
* **Unlimited WooCommerce Order Export:** Automatically export WooCommerce orders data including Order ID, Product Name, Order Status, Item Count, and Total Price to your connected Sheet. No cap on how many orders sync.
 
* **Edit Shipping & Billing Info from Sheets:** Update shipping and billing addresses directly from the connected Sheet. Changes sync instantly back to WooCommerce without logging into the dashboard.
 
* **Order Details Sync:** Export product name, product ID, quantity, price, and payment method from WooCommerce to Sheets automatically with each order.
 
* **Billing Details Sync:** Billing information including first name, last name, address, city, postcode, and country syncs to a single column by default. Enable Separate Column View to display each billing field in its own column for easier invoice management and record-keeping.
 
* **Order Sorting:** Sort WooCommerce orders in Sheets in ascending or descending order. Find and manage orders faster based on your preferred criteria.

https://youtu.be/nmnWhody7Kw?si=YecjwhzCCJDGrc6Y
 
* **Manual Sync to WooCommerce from Sheets:** Use the "Sync on WooCommerce" option in Sheets to push status changes back to your store manually whenever needed.
 
* **Imported Order Sync:** Orders imported via any third-party plugin or the default WordPress import tool sync to Sheets immediately after running "Sync orders on Google Sheet." No order data is lost.
 
* **Empty Order Sync:** Orders with missing product data sync to Sheets as "No Products," giving you visibility to review, edit, or remove incomplete WooCommerce orders.

* **Easy Setup Wizard:** A guided setup walks you through connecting WooCommerce to Google Sheets step by step with no technical knowledge needed.

👁️ [View Demo](https://lnk.wppool.dev/dc3jlsv) | 🚀 [Get ULTIMATE](https://lnk.wppool.dev/qjkrdk1) | 🤝 [Join Our Facebook Community](https://lnk.wppool.dev/EIRJ9Uh)

== 🔥 FlexOrder Ultimate Features ==

* **Access to all free features**

* **✨ Create WooCommerce Orders from Google Sheets:** Create orders directly from Sheets. No need to log into WordPress or manually enter order data. Simply fill in the required fields in the spreadsheet, and orders will be created automatically with accurate billing, shipping, and product details.[Learn how this works.](https://wppool.dev/docs/how-to-create-woocommerce-orders-from-google-sheets/) 

* **Advanced order filtering:** Filter WC orders by status, days old, or a specific date range. Only the filtered orders will be synced to your connected Sheet, giving you more control over which data gets updated.

https://youtu.be/YHiTYYDC6so?si=lgkrYm-9SNkK9rah

* **Advanced order sorting:** Manage your orders by sorting them based on order date, price, and items in  Sheets. You can sort in ascending or descending order by date, price, or item count, making it easier to track sales trends, prioritize processing, and organize orders. 

* **Payment method sync:** Sync the customer’s payment method information with Sheets.

* **Sync Transaction IDs:** Automatically link your store's orders to their payment gateway Transaction IDs in Sheets for seamless reconciliation.

* **Order date sync:** Keep your store orders organized by syncing order dates directly to Sheets.

* **🔥 Create Multiple Rows for Different Products:** If an order has multiple products, enabling this feature will create multiple rows for each product in Sheets.

* **Order notes sync:** Custom order notes are the messages that admins can add to customer orders. With order notes sync, you can now get private and public order notes in a separate column in the spreadsheet.

https://youtu.be/9a0bR46LhHo?si=78ydNdmtkmG56z-_

* **Custom separators:** You can choose a custom separator for displaying multiple product information in Sheets. By default, information is separated by commas (e.g., item1, item2, item3). With this feature, you can replace the comma with a separator of your choice from the available options such as: (, | ;).

* **Discount sync:** Sync discount information between your store and Sheets.

* **Shipping details sync:** Sync all shipping details available in the free version, along with additional fields: **state/county, company name, address line 2, phone number, and email.** 

* **Order URL sync:** Sync the order URL and get an insight into where the transaction took place from the connected spreadsheet.

* **Customer notes sync:**Sync customer notes that are provided during purchase with Sheets. [Read the full guide.](https://wppool.dev/docs/how-to-sync-order-notes-from-google-sheets/) 

* **Custom Fields Sync:** Custom fields or metadata let you display additional product data (Special Instructions, Gift Messages, Delivery Date, etc.). With custom fields sync, you can sync the custom fields data that comes with orders on Sheets.

https://youtu.be/Gd2dD421mNA?si=zljMFknudniGP_Ya

* **Order quantity sync:** Sync the quantity for each ordered product on Sheets.

* **Product SKU Sync:** Sync product SKUs from your store's dashboard to Sheets effortlessly. Ensure accurate product tracking and simplify order management.

* **Custom order status sync:** Sync any custom order status created manually or using a third-party plugin with your spreadsheet. Simplify your workflow and get greater flexibility and precision in managing your orders.

* **Customer name sync:** The "order placed by" column ensures you have the details of the customer who placed the order.

* **Order coupon sync (upcoming):** Learn about applied coupons from Google Sheet.

* **Billing details sync:** Sync all billing details available in the free version, along with additional fields: **state/county, company name, address line 2, phone number, and email.** 

https://youtu.be/-8a9TMakWrw?si=_TpQ_gtjWYi4n1G5

👁️ [View Demo](https://lnk.wppool.dev/dc3jlsv) | 🚀 [Get ULTIMATE](https://lnk.wppool.dev/qjkrdk1) | 🤝 [Join Our Facebook Community](https://lnk.wppool.dev/EIRJ9Uh)

**🤔Why Choose FlexOrder?**

FlexOrder transforms Google Sheets into your WooCommerce order management hub helping store owners, accountants, and fulfillment teams save time, reduce errors, and simplify daily workflows. 

* **Save Hours Every Week:** Bulk update order statuses, billing, shipping, and more directly from Sheets. All changes sync instantly to WooCommerce.

* **Work Faster in a Tool You Already Know:** Use Google Sheets as your live, two-way order dashboard - no complex setup, no learning curve.

* **No Technical Skills Required:** Setup is quick. Anyone on your team can manage orders without logging into WordPress.

* **Fix Errors Instantly:** Correct shipping or billing info in the spreadsheet and watch it update automatically in WooCommerce.

* **Organize Large Stores Easily:** Sort, filter, rearrange columns, create multi-product rows, and sync custom fields for cleaner, structured data.

* **Perfect for Teams & VAs:** Give staff limited access via Sheets instead of exposing your WordPress admin.

* **Handles Complex Stores Smoothly:** Compatible with imports, custom statuses, advanced sorting, multi-product orders, and third-party plugins.

* **Scales Effortlessly:** Manage 50 or 5,000 orders with the same simplicity.

* **Advanced Tools for Power Users:** Create orders from Sheets and sync payment details, transaction IDs, SKUs, notes, discounts, and more.

* **Lightweight, Fast & Reliable:** Sync thousands of orders without slowing down your WooCommerce site.

**Missing-Anything?**

If we missed a feature or functionality you need, we’d love to hear from you. Share your ideas or suggestions so we can continue improving FlexOrder. Contact **[our support](https://wordpress.org/support/plugin/order-sync-with-google-sheets-for-woocommerce/)** to share your ideas. 

**Let’s grow, connect, and thrive together!**

🤝 Join Our [Facebook Community](https://lnk.wppool.dev/EIRJ9Uh)
🌐 Follow Us on [X (Twitter)](https://lnk.wppool.dev/peklsBJ)
🎥 Subscribe on [YouTube](https://lnk.wppool.dev/FwHDK1u)
👍 Like Our [Facebook Page](https://lnk.wppool.dev/KOnE5Qh)


== 🔥 More Awesome Plugins ==
If you like FlexOrder, then consider checking out our other awesome plugins for your site:

* 📊 **[ArchiveMaster](https://lnk.wppool.dev/3nutDhU)** - Use Archive Master plugin to archive your old WooCommerce orders. Archive your old orders for a decluttered, optimized and faster store. You can unarchive your orders anytime.
	
* 🔄 **[FlexStock](https://lnk.wppool.dev/zUZQxOU)** - Auto-sync WooCommerce products to Sheets. Flex Stock is an easy, powerful, and simple inventory management system to handle your store products.

* 🎁 **[EchoRewards](https://lnk.wppool.dev/0Sz5OzF)** - With Echo Reward, you can launch customer referral program to boost your sales. Generate referral coupons, reward customers, and launch the ideal refer-a-friend program for your store. 

* 🟢 **[FlexTable](https://lnk.wppool.dev/pvnikH3)** - Flex Table allows you to input data on your Sheets and show the same data on WordPress as a table effortlessly.


== Installation ==

1. Navigate to WordPress Dashboard>Plugins>Add New and search "FlexOrder" and Activate the plugin.
2. Upload your credentials.json file from the Google Cloud Platform and connect your spreadsheet.
3. Provide editor access to your service account and configure Apps Script.
4. That’s it. Enjoy super-fast order sync.

You can also follow our step-by-step tutorial.

https://youtu.be/NB4YW6S6bm0

== Privacy Policy ==
FlexOrder uses [Appsero](https://appsero.com) SDK to collect some telemetry data upon user's confirmation. This helps us to troubleshoot problems faster & make order improvements.

Appsero SDK **does not gather any data by default.** The SDK only starts gathering basic telemetry data **when a user allows it via the admin notice**. We collect the data to ensure a great user experience for all our users. 

Integrating Appsero SDK **DOES NOT IMMEDIATELY** start gathering data, **without confirmation from users in any case.**

Learn more about how [Appsero collects and uses this data](https://appsero.com/privacy-policy/).


== Development and Build Instructions ==

This plugin uses **npm**, **webpack**, **Tailwind CSS**, and **Alpine.js** for building production files. All source code for minified JavaScript and CSS files is included in the plugin's `/src` directory.

 **Source Code Location**
* The unminified source code is organized as follows:
* `/src/` - Main source directory
* `/src/lib/` - Library files  
* `/src/js/` - Unminified JavaScript source files
* `/src/scss/` - SCSS source files
* `appscript` - Google Sheets Apps Script files
* `tailwindcss` - CSS framework setup
* `webpack` - Webpack configuration files
* `package` - Package configuration files

**Build Tools & Dependencies**
The plugin uses the following build tools:

* npm - Package manager
* webpack - JavaScript bundling
* tailwindcss - CSS framework
* alpinejs - Frontend framework
* Google Apps Script – Custom backend automation and Google Sheets integration

**Build Setup**
To build the project from source:

1. Copy the appscript files from `/src/js/scripts/` to the plugin's root `/appsscript/ directory
2. Install dependencies: `npm install`
3. Run the build scripts:
   * Admin styles: `npm run webpack:watch`
   * Frontend styles: `npm run sass` and `npm run webpack`
   * Admin Appscript: `npm run appscript`

**Output Directories** 

* `/public/css/` - Contains minified CSS output files
* `/public/fonts/` - Contains fonts files
* `/public/images/` - Contains images files
* `/public/js/` - Contains minified JavaScript output files

== External services ==

**Select2 a jQuery-based replacement for select boxe**

* **Purpose**: Select2 enhances traditional HTML <select> elements by adding support for searching, and improved styling with full compatibility across modern browsers. It provides a richer, more user-friendly interface for dropdowns.
* **Service Provider**: Developed and maintained by the open-source community [Select2 ](https://github.com/select2/select2/tree/master)

**Google Apps Script – Google Sheet Integration**

* **Purpose**: Used to develop custom server-side logic and automation for our application, including data handling, API integrations, and real-time communication features.  
* **Service Provider**: Google LLC  [Google Apps Script](https://developers.google.com/apps-script) 

== Frequently Asked Questions ==

= How does FlexOrder connect to Google Sheets? =
You generate a Service Account key from Google Cloud Console, upload the credentials file in the plugin settings, and share your Sheet with the service account email. The setup wizard walks through every step. No coding required.
 
= How many WooCommerce orders can I sync? =
All of them. There is no limit on how many orders sync to your connected spreadsheet or how many status changes you can make.
 
= Does two-way sync work automatically? =
Yes. New WooCommerce orders export to Sheets automatically. Status changes made in Sheets sync back to WooCommerce automatically. You can also trigger a manual sync in either direction at any time.
 
= Can I bulk edit order statuses from Sheets? =
Yes. Select the orders you want to update, change the status column in Sheets, and the changes apply to your WooCommerce store. You can update an entire batch in one action.
 
= What order data is available in the free version? =
Free users can export Order ID, Product Name, Order Status, Item Count, Total Price, and Payment Method. Two-way status sync, bulk editing, manual sync, and column customization are all included at no cost.
 
= What additional data syncs in the Pro version? =
Pro adds Transaction IDs, Order Dates, Discounts, Order URLs, Customer Notes, Order Notes, Product SKUs, Custom Order Statuses, Custom Fields, Customer Name, and the ability to create new WooCommerce orders directly from Sheets.
 
= Can I manage custom order statuses from Sheets? =
Yes. Any valid WooCommerce order status syncs — including custom statuses created manually or through third-party plugins.
 
= Can I export orders that were imported via third-party plugins? =
Yes. Orders imported through any plugin or the default WordPress import tool sync to Sheets when you run "Sync orders on Google Sheets."
 
= Will FlexOrder slow down my WooCommerce store? =
No. The sync runs independently and does not affect store performance or page load times.
 
= Can I delete WooCommerce orders from Sheets? =
No. Order deletion from Sheets is intentionally not supported to prevent accidental data loss on your live store.

== Screenshots ==
1. Bi-directional sync between WooCommerce and Sheet
2. Manage and update WooCommerce order status from Google Sheet
3. Get additional syncing option on your spreadsheet
4. Edit and update WooCommerce order status from GSheet
5. One click instant orders sync on spreadsheet from WC dashboard
6. Start syncing your orders with easy and fast setup

== Upgrade Notice ==

= 1.16.0 =
This version introduces editing feature for shipping & billing addresses from the connected sheet

== Changelog ==

= 1.17.7 - 24 June 2026 =
* **Enhancement:** Popup module and SDK update.

= 1.17.6 - 04 June 2026 =
* **Improvement:** Added compatibility with WordPress 7.0

= 1.17.5 - 03 Mar 2026 =
* **Improvement:** Added built-in support for 16 languages, ready to use out of the box: **Bengali, Spanish (Spain), German, French, Portuguese (Brazil), Hindi, Arabic, Chinese (Simplified), Japanese, Italian, Russian, Indonesian, Turkish, Dutch,   Korean, and Polish.**

= 1.17.4 - 24 November 2025 =
* **Improvement:** Regular update & maintenance release. 

= 1.17.3 - 10 November 2025 =
* **Improvement:** Routine maintenance released. 

**For older changelog entries, please see the [additional changelog.txt file](https://plugins.svn.wordpress.org/order-sync-with-google-sheets-for-woocommerce/trunk/changelog.txt) delivered with the plugin.**
