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

Create, edit, manage, and sync WooCommerce orders with Google Sheets for easy order handling and updates.

== Description ==

**MANAGE YOUR WOOCOMMERCE ORDERS FROM GOOGLE SHEETS - IN REAL TIME 🔄**

[Demo](https://lnk.wppool.dev/dc3jlsv) | [User Guide](https://wppool.dev/docs-category/order-sync-with-google-sheets-docs/) | [YouTube Video Tutorials](https://www.youtube.com/playlist?list=PLd6WEu38CQSzvajuy-cHLJRWbTGeboGd2) | [Get Support](https://wppool.dev/contact/) | [Get Ultimate](https://lnk.wppool.dev/qjkrdk1)

Managing WooCommerce orders directly from the dashboard often becomes time-consuming and repetitive - especially when handling large batches of orders, updating customer details, or tracking order progress during busy sales periods. Manual updates not only slow down your workflow but also increase the risk of data errors and make order management less efficient.

**FlexOrder** solves these common **WooCommerce order management** challenges by automatically syncing your store’s orders with Google Sheets. With **real-time,** **two-way synchronization,** all WooCommerce orders are exported to your connected spreadsheet, and any updates you make in Sheets - such as changing order statuses or editing billing and shipping details - are instantly reflected in your WooCommerce store.

https://youtu.be/i44dHegWvLY

== With FlexOrder, you can:== 

* **Bulk update WooCommerce order statuses** directly from Google Sheets.
* **Edit billing and shipping information** in a familiar spreadsheet environment.
* **Automatically sync order data** between WooCommerce and Google Sheets in real time.
* **Sort, filter, and organize orders** for better visibility and tracking.
* **Reduce manual work** and streamline your daily order management process.
* **Handle large order volumes** efficiently without slowing down your WooCommerce store.

FlexOrder empowers store owners, fulfillment teams, and support staff to manage WooCommerce orders faster and more accurately using the simplicity of Google Sheets. It improves order accuracy, accelerates fulfillment, and eliminates repetitive manual tasks - without requiring any coding or technical setup.

== 🚀 Quick & Easy WooCommerce Order Management FOR WOOCOMMERCE ==

FlexOrder provides a simple and efficient way to manage WooCommerce orders using Google Sheets.

* **Manage and sync orders** directly from a connected spreadsheet.
* **Bulk edit order statuses** quickly, with changes reflected instantly in WooCommerce.
* **No coding or technical knowledge** required, with a straightforward setup process.
* **Streamline your workflow** and reduce repetitive manual tasks.

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

== 😃 FlexOrder Free Features ==

* **2-way order sync between WooCommerce and Google Sheets:** Sync orders with Google Sheets. Once you connect your store with a spreadsheet, the order status will change bidirectionally and automatically. You can sync as many orders as you wish, and it is now easier than ever.

* **Edit Shipping & Billing Info from Google Sheets:** Update shipping and billing addresses directly from the connected sheets. All changes sync instantly, letting you fix or modify order details without logging into the WC dashboard.

* **Bulk editing WooCommerce orders:** Bulk edit orders from Sheets, without having to update each order manually. For instance, if you want to change the status of a whole batch of orders from "Pending" to "Processing", you can now do this in bulk from the connected spreadsheet. The changes will be applied instantly to the orders in your store.

* **Unlimited automatic order details export from WooCommerce:** Automatically export your order details (Order ID, Product Name, Order Status, Total Item, Total Price, Shipping Address & Billing Address) to the connected spreadsheet with our expertly crafted formatting.

* **Order sorting:** Sort your orders in Sheets in an ascending or descending manner for better organization. Easily find and manage orders based on your preferred sorting criteria for efficient order management.

* **Customizable Column Order:** Rearrange Sheet columns with a simple drag-and-drop! No more fixed layouts! Move the Price, Order Status, or any column to match your workflow.

* **1-click manual order sync on Sheets:** Using the “Fetch from WooCommerce” option on Sheets, you can manually import order details with a single click.

* **Manual order sync on WooCommerce from Sheets:** Use the “Sync on WooCommerce” option from Sheets to manually sync order status with your store.

* **Order details (name, ID, quantity, price) sync:** Sync order details (product name, ID, quantity, price, payment method) from WC to Sheets.

* **Billing details sync:** Keeping track of customer billing information is essential for order management and record-keeping. Billing details such as the customer’s **first name, last name, address, city, postcode, and country** will automatically sync into Sheets. By default, all billing details will be stored in a single column. However, if you prefer a more detailed view, you can enable the Separate Column View feature to display each piece of billing information in its own column. This makes it easier to verify payment details, manage invoices, and maintain accurate customer records without switching between platforms.

* **Shipping details sync:** Accurate shipping details are crucial for smooth order fulfilment. Shipping details such as the customers' **first name, last name, shipping address, city, postcode, and country** will automatically sync to your connected Sheet. By default, all shipping details will be combined in a single column. If you’d rather have them displayed separately, you can enable the Separate Column View feature to arrange each shipping detail into its respective column. This ensures you have all necessary delivery details in one place, making it easier to process shipments, avoid delivery errors, and track orders efficiently.

* **Imported order sync:** Whether you use any third-party plugin to import or export your order details or the default WordPress import/export tool, our order sync plugin will make sure none of your data gets lost. Once you import your data into WooCommerce and click on “Sync orders on Google Sheets”, your orders will be synced immediately.

* **Empty order sync:** Empty orders can be a hassle if not maintained properly. When you import bulk orders with third-party plugins/default WordPress tools, you often lose a few product details. In those instances, your empty orders will be synced as “No Products” in Sheets. It gives you the flexibility to either remove or edit the empty orders.

* **Easy setup wizard:** Get started easily with our intuitive guided tour for the plugin setup.

👁️ [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.

* **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. 

* **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.

* **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.

* **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.

* **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.

* **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 Sheets. Simplify your workflow and get greater flexibility and precision in managing your orders.

* **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.

* **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.** 

* **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 Sheets.

👁️ [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 Sheets 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 do I securely connect FlexOrder to my GSheets? =
Connecting Flex Order is designed to be straightforward. You'll typically need to generate a Google Service Account key from your Google Cloud Console and share your specific spreadsheet with that service account's email address. This method ensures secure, direct communication between your store and your designated spreadsheet without requiring your personal Google login details. Our detailed setup guide walks you through each step, including generating the necessary credentials and setting the correct sheet permissions.

= How many orders can I sync to the spreadsheets? =
You can sync all the orders of your stores to the connected sheet and change as many order statuses as you want

= How can I be assured that my orders and GSheets data stay consistently synced? =
Our plugin primarily acts as a bridge for your order data. When new orders are placed in your store, they are automatically pushed to your connected sheet. You can then make updates to specific fields directly within the Sheet (such as order status, tracking numbers, or notes), and FlexOrder will push these changes back to your store. 

= Can I manage custom order statuses directly from the Sheets? =
Yes, absolutely! FlexOrder allows you to update any valid store order status from your spreadsheet, including standard statuses like "Processing" or "Completed," as well as any custom order statuses you've created for your unique workflow (e.g., "Awaiting Pickup," "Shipped," "On Hold"). This flexibility means you can tailor your order management process entirely within your familiar spreadsheet environment.

= What specific order details can I view and manage within GSheets using the plugin? =
On the free version, You can sync essential order information such as product name, product ID, quantity, and price for each item in an order. This is perfect for basic order tracking and inventory overview. On the paid version you can additionally Unlock advanced details including payment method, discount amount, shipping details (address, method, cost), order URL, customer notes, refund status, and more.

= Can I delete or archive orders from my connected Sheets? =
The plugin does not support deleting orders from your store via the spreadsheet. This is a safety measure to prevent accidental data loss on your live store.

= Is any coding or technical expertise required to set up and use the plugin? =
Absolutely not! Our plugin is designed with simplicity in mind for all store owners and managers, regardless of their technical background. There is no coding or programming knowledge required to install, set up, or use the plugin.

== 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.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. 

= 1.17.2 - 15 October 2025 =
* **Fix:** Resolved duplicate order issue occurring during new order creation.

= 1.17.1 - 01 Sep 2025 =
* **Fix:** Fixed column mismatch issue caused by rearranging columns in the Sheets

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.