WordPress.org
Get WordPress

Plugin Directory

Changeset 3331341


Ignore:
Timestamp:
07/21/2025 10:10:05 AM (8 months ago)
Author:
ordersyncplugin
Message:

Updating readme/assets from GitHub

Location:
order-sync-with-google-sheets-for-woocommerce
Files:
2 edited

Legend:

Unmodified
Added
Removed

  • order-sync-with-google-sheets-for-woocommerce/tags/1.15.2/readme.txt

    r3319391 r3331341  
    1 === Bulk Order Sync for WooCommerce with Google Sheets | Bulk Edit WooCommerce Orders, Manage Orders, Sync Order Details & More - FlexOrder ===
    2 Contributors: ordersyncplugin, devsabbirahmed 
     1=== FlexOrder - Manage & Sync Orders with Google Sheets for WooCommerce ===
     2Contributors: ordersyncplugin, devsabbirahmed, naeemkhan25
    33Tags: sync order, order management, inventory management, bulk edit, woocommerce orders
    44Requires at least: 5.4
    … …  
    99License URI: http://www.gnu.org/licenses/gpl-2.0.html
    1010
    11 Manage WooCommerce orders from Google Sheets. WooCommerce bulk order sync, bulk order management, and sales order management with Google Sheets.
     11Create, edit, manage, and sync WooCommerce orders with Google Sheets for easy order handling and updates.
    1212
    1313== Description ==
    1414
    15 🔥 Sync **WooCommerce orders with Google Sheets**. Perform WooCommerce order sync, bulk order management, and bulk editing with Google Sheets.
     15🔥 Seamlessly **connect WooCommerce with Google Sheets** to manage orders, update statuses in bulk, and simplify your workflow.
    1616
    1717**Let’s grow, connect, and thrive together!**
    1818
    19 * **🤝 Join Our [Facebook Community](https://cutt.ly/ceCQgvoT)**
    20 * **🌐 Follow Us on [X (Twitter)](https://x.com/wppool_)**
    21 * **🎥 Subscribe on [YouTube](https://www.youtube.com/@WPPOOL)**
    22 * **👍 Like Our [Facebook Page](https://www.facebook.com/wppool.dev)**
    23 
    24 Welcome to the next generation of WooCommerce order management. Automatically sync WooCommerce orders with Google Sheets. Our **WordPress Google Sheets integration** ensures you are always one step ahead with faster and more efficient sales order management.
    25 
     19* **🤝 Join Our [Facebook Community](https://lnk.wppool.dev/EIRJ9Uh)**
     20* **🌐 Follow Us on [X (Twitter)](https://lnk.wppool.dev/peklsBJ)**
     21* **🎥 Subscribe on [YouTube](https://lnk.wppool.dev/FwHDK1u)**
     22* **👍 Like Our [Facebook Page](https://lnk.wppool.dev/KOnE5Qh)**
     23
     24Experience smarter WooCommerce order management with automatic syncing to Google Sheets. Our **WordPress Google Sheets integration** helps streamline order processing with faster and more efficient sales order management.
    2625
    2726https://youtu.be/sCzwNJ1wkPo?rel=0
    2827
    29 Integrate once and enjoy unlimited bidirectional order sync between WooCommerce and Google Sheets. With FlexOrder, you can bulk edit WooCommerce orders from the connected spreadsheet instead of updating them one by one. It saves time, and you can focus more on other aspects of your business.
     28Set up once and enable two-way syncing between WooCommerce and Google Sheets. With FlexOrder, you can efficiently manage and bulk update orders directly from your spreadsheet, saving time and reducing manual tasks.
    3029
    3130=== 🚀 QUICK & EASY ORDER MANAGEMENT SYSTEM FOR WOOCOMMERCE ===
    3231
    33 * Performs e-commerce order management, sales order management, and WooCommerce order sync from a connected spreadsheet.
    34 * Saves time by bulk editing order status from Google Sheets. The status changes instantly on the connected WooCommerce store.
     32* Performs e-commerce order management, sales order management, and order sync from a connected spreadsheet.
     33* Saves time by bulk editing order status from Sheets. The status changes instantly on the connected eCommerce store.
    3534* Managing the plugin requires zero coding or technical knowledge. Super easy to use with quick setup steps.
    3635
    37 👁️ [View Demo](https://go.wppool.dev/kh8d) | 🚀 [Get ULTIMATE](https://go.wppool.dev/gaVU) | 🤝 [Join Our Facebook Community](https://cutt.ly/ceCQgvoT)
     36👁️ [View Demo](https://lnk.wppool.dev/dc3jlsv) | 🚀 [Get ULTIMATE](https://lnk.wppool.dev/qjkrdk1) | 🤝 [Join Our Facebook Community](https://lnk.wppool.dev/EIRJ9Uh)
    3837
    3938=== 😃 FlexOrder Features ===
    4039
    41 * **2-way order sync between WooCommerce and Google Sheets:** Sync WooCommerce 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. WooCommerce order sync is now easier than ever.
    42 
    43 * **Bulk editing WooCommerce orders:** Bulk edit WooCommerce orders from Google 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 WooCommerce.
    44 
    45 * **Unlimited automatic order details export from WooCommerce:** Automatically export your WooCommerce 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.
    46 
    47 * **Order sorting:** Sort your orders in Google Sheets in ascending or descending manner for better organization. Easily find and manage orders based on your preferred sorting criteria for efficient order management.
    48 
    49 * **Customizable Column Order:** Rearrange Google Sheet columns with a simple drag-and-drop! No more fixed layouts! Move the Price, Order Status, or any column to match your workflow.
    50 
    51 * **1-click manual order sync on Google Sheets:** Using the “Fetch from WooCommerce” option on Google Sheets, you can manually import WooCommerce order details with a single click.
    52 
    53 * **Manual order sync on WooCommerce from Google Sheets:** Use the “Sync on WooCommerce” option from Google Sheets to manually sync order status with WooCommerce.
    54 
    55 * **Order details (name, ID, quantity, price) sync:** Sync order details (product name, ID, quantity, price, payment method) from WooCommerce to Google Sheets.
    56 
    57 * **Billing details sync:** Keeping track of customer billing information is essential for order management and record-keeping. Now, billing details such as the customer’s **first name, last name, address, city, postcode, and country** will automatically sync into Google 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.
    58 
    59 * **Shipping details sync:** Accurate shipping details are crucial for smooth order fulfillment. Now, shipping details such as the customers' **first name, last name, shipping address, city, postcode, and country** will automatically sync to your connected Google 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.
    60 
    61 * **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 on WooCommerce and click on “Sync orders on Google Sheets”, your orders will be synced immediately.
    62 
    63 * **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 Google Sheets. It gives you the flexibility to either remove or edit the empty orders.
    64 
    65 * **Easy setup wizard:** Get started with your WooCommerce order sync journey with our guided tour.
    66 
    67 👁️ [View Demo](https://go.wppool.dev/kh8d) | 🚀 [Get ULTIMATE](https://go.wppool.dev/gaVU) | 🤝 [Join Our Facebook Community](https://cutt.ly/ceCQgvoT)
     40* **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.
     41
     42* **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.
     43
     44* **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.
     45
     46* **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.
     47
     48* **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.
     49
     50* **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.
     51
     52* **Manual order sync on WooCommerce from Sheets:** Use the “Sync on WooCommerce” option from Sheets to manually sync order status with your store.
     53
     54* **Order details (name, ID, quantity, price) sync:** Sync order details (product name, ID, quantity, price, payment method) from WC to Sheets.
     55
     56* **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.
     57
     58* **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.
     59
     60* **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.
     61
     62* **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.
     63
     64* **Easy setup wizard:** Get started easily with our intuitive guided tour for the plugin setup.
     65
     66👁️ [View Demo](https://lnk.wppool.dev/dc3jlsv) | 🚀 [Get ULTIMATE](https://lnk.wppool.dev/qjkrdk1) | 🤝 [Join Our Facebook Community](https://lnk.wppool.dev/EIRJ9Uh)
    6867
    6968=== 🔥 FlexOrder Ultimate Features ===
    7069
    71 * **All free features**
    72 
    73 * **✨ Create WooCommerce Orders from Google Sheets:** Create WooCommerce orders directly from Google 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.
    74 
    75 * **Payment method sync:** Sync customer’s payment method information with Google Sheets.
    76 
    77 * **Sync Transaction IDs:** Automatically link WooCommerce orders to their payment gateway Transaction IDs in Google Sheets for seamless reconciliation.
    78 
    79 * **Order date sync:** Keep your WooCommerce orders organized by syncing order dates directly to Google Sheets.
    80 
    81 * **Advanced order sorting:** Manage your orders by sorting them based on order date, price, and items in Google Sheets. You can sort orders in ascending or descending order by date, price, or item count, making it easier to track sales trends, prioritize processing, and organize orders.
    82 
    83 * **🔥 Create Multiple Rows for Different Products:** If an order has multiple products, enabling this feature will create multiple rows for each product in Google Sheets.
    84 
    85 * **Custom separators:** You can choose a custom separator for displaying multiple product information in Google Sheets. By default, information's are 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 (, | ;).
    86 
    87 * **Discount sync:** Sync discount information between WooCommerce and Google Sheets.
     70* **Access to all free features**
     71
     72* **✨ 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.
     73
     74* **Payment method sync:** Sync the customer’s payment method information with Sheets.
     75
     76* **Sync Transaction IDs:** Automatically link your store's orders to their payment gateway Transaction IDs in Sheets for seamless reconciliation.
     77
     78* **Order date sync:** Keep your store orders organized by syncing order dates directly to Sheets.
     79
     80* **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.
     81
     82* **🔥 Create Multiple Rows for Different Products:** If an order has multiple products, enabling this feature will create multiple rows for each product in Sheets.
     83
     84* **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: (, | ;).
     85
     86* **Discount sync:** Sync discount information between your store and Sheets.
    8887
    8988* **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.**
    … …  
    9190* **Order URL sync:** Sync the order URL and get an insight into where the transaction took place from the connected spreadsheet.
    9291
    93 * **Customer notes sync:**Sync customer notes that are provided during purchase with Google Sheets.
    94 
    95 * **Order notes sync:** WooCommerce 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.
    96 
    97 * **Order quantity sync:** Sync the quantity for each ordered product on Google Sheets.
    98 
    99 * **WooCommerce Product SKU Sync:** Sync product SKUs from WooCommerce dashboard to Google Sheets effortlessly. Ensure accurate product tracking and simplify order management.
    100 
    101 * **WooCommerce Custom order status sync:** Sync any custom order status created manually or using a third-party plugin with your Google Sheets. Simplify your workflow and get greater flexibility and precision in managing your orders.
    102 
    103 * **WooCommerce Custom Fields Sync:** WooCommerce custom fields or metadata lets you display additional product data (Special Instructions, Gift Messages, Delivery Date, etc.). With WooCommerce custom fields sync, you can sync the custom fields data that comes with orders on Google Sheets.
     92* **Customer notes sync:**Sync customer notes that are provided during purchase with Sheets.
     93
     94* **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.
     95
     96* **Order quantity sync:** Sync the quantity for each ordered product on Sheets.
     97
     98* **Product SKU Sync:** Sync product SKUs from your store's dashboard to Sheets effortlessly. Ensure accurate product tracking and simplify order management.
     99
     100* **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.
     101
     102* **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.
    104103
    105104* **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.**
    … …  
    107106* **Customer name sync:** The "order placed by" column ensures you have the details of the customer who placed the order.
    108107
    109 * **Order coupon sync (upcoming):** Learn about applied coupons from Google Sheets.
    110 
    111 👁️ [View Demo](https://go.wppool.dev/kh8d) | 🚀 [Get ULTIMATE](https://go.wppool.dev/gaVU) | 🤝 [Join Our Facebook Community](https://cutt.ly/ceCQgvoT)
     108* **Order coupon sync (upcoming):** Learn about applied coupons from Sheets.
     109
     110👁️ [View Demo](https://lnk.wppool.dev/dc3jlsv) | 🚀 [Get ULTIMATE](https://lnk.wppool.dev/qjkrdk1) | 🤝 [Join Our Facebook Community](https://lnk.wppool.dev/EIRJ9Uh)
    112111
    113112=== 🔥 More Awesome Plugins ===
    114 If you like FlexOrder, then consider checking out our other awesome projects:
     113If you like FlexOrder, then consider checking out our other awesome plugins for your site:
     114
     115* 📊 **[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.
    115116   
    116 * 🔄 **[FlexStock - Stock Sync with Google Sheet for WooCommerce](https://wordpress.org/plugins/stock-sync-with-google-sheet-for-woocommerce/)**  - Auto-sync WooCommerce products from Google Sheets. Flex Stock is an easy, powerful, and simple inventory management system to handle your WooCommerce products.
    117 
    118 * 🟢 **[FlexTable - Sheets To WP Table Live Sync](https://wordpress.org/plugins/sheets-to-wp-table-live-sync/)** - Google Sheets allows you to input data on your Google sheet and show the same data on WordPress as a table effortlessly. Try Flex Table now!
    119 
    120 * 🎁 **[EchoRewards](https://wordpress.org/plugins/echo-rewards/)** - With Echo Reward, you can refer a friend for WooCommerce to launch your customer referral program. Echo Rewards Referral Plugin is a WooCommerce referral plugin to boost your sales. Generate coupons, reward customers, and launch the ideal refer-a-friend program for your store.
    121 
    122 * 🌓 **[WP Dark Mode](https://wordpress.org/plugins/wp-dark-mode/)**  - Use WP Dark Mode plugin to create a stunning dark version for your WordPress website. WP Dark Mode works automatically without going into any complicated settings.
     117* 🔄 **[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.
     118
     119* 🎁 **[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.
     120
     121* 🟢 **[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.
    123122
    124123
    … …  
    1281272. Upload your credentials.json file from the Google Cloud Platform and connect your spreadsheet.
    1291283. Provide editor access to your service account and configure Apps Script.
    130 4. That’s it. Enjoy super-fast order sync between WooCommerce and Google Sheets.
     1294. That’s it. Enjoy super-fast order sync.
    131130
    132131You can also follow our step-by-step tutorial.
    … …  
    143142Learn more about how [Appsero collects and uses this data](https://appsero.com/privacy-policy/).
    144143
     144
     145=== Development and Build Instructions ===
     146
     147This 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.
     148
     149## Source Code Location
     150* The unminified source code is organized as follows:
     151* `/src/` - Main source directory
     152* `/src/lib/` - Library files 
     153* `/src/js/` - Unminified JavaScript source files
     154* `/src/scss/` - SCSS source files
     155* `appscript` - Google Sheets Apps Script files
     156* `tailwindcss` - CSS framework setup
     157* `webpack` - Webpack configuration files
     158* `package` - Package configuration files
     159
     160## Build Tools & Dependencies
     161The plugin uses the following build tools:
     162
     163* npm - Package manager
     164* webpack - JavaScript bundling
     165* tailwindcss - CSS framework
     166* alpinejs - Frontend framework
     167* Google Apps Script – Custom backend automation and Google Sheets integration
     168
     169## Build Setup
     170To build the project from source:
     171
     1721. Copy the appscript files from `/src/js/scripts/` to the plugin's root `/appsscript/ directory
     1732. Install dependencies: `npm install`
     1743. Run the build scripts:
     175   * Admin styles: `npm run webpack:watch`
     176   * Frontend styles: `npm run sass` and `npm run webpack`
     177   * Admin Appscript: `npm run appscript`
     178
     179**Output Directories**
     180
     181* `/public/css/` - Contains minified CSS output files
     182* `/public/fonts/` - Contains fonts files
     183* `/public/images/` - Contains images files
     184* `/public/js/` - Contains minified JavaScript output files
     185
     186=== External services ===
     187
     188## Select2 a jQuery-based replacement for select boxe
     189- **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.
     190- **Service Provider**: Developed and maintained by the open-source community [Select2 ](https://github.com/select2/select2/tree/master)
     191
     192## Google Apps Script – Google Sheet Integration 
     193- **Purpose**: Used to develop custom server-side logic and automation for our application, including data handling, API integrations, and real-time communication features. 
     194- **Service Provider**: Google LLC 
     195- **Developer**: This integration is developed and maintained by our in-house development team to ensure seamless functionality and secure handling of user data. [Google Apps Script](https://developers.google.com/apps-script) 
     196
     197
    145198== Frequently Asked Questions ==
    146199
    147 = How can I link my site with Google Sheets? =
    148 It’s pretty  simple and easy. You’ll have to insert a link to the spreadsheet and provide editor access to your service account.
    149 = How do I sync orders in WooCommerce? =
    150 Install FlexOrder (formerly **Order Sync for WooCommerce with Google Sheets**) and link with your Google Sheets spreadsheet. Now you can sync and manage your WooCommerce orders from a connected spreadsheet.
    151 = How many order status can I change from Google Sheets? =
    152 Unlimited! There is absolutely no limit when it comes to syncing order status between WooCommerce and Google Sheets.
    153 = Which product description can I sync with Google Sheets? =
    154 On the free version, you can sync the following order details - product name, ID, quantity, and price. On the paid version you can also sync payment method, discount amount, shipping details, order URL, and customer notes.
    155 = Can I remove any WooCommerce order from the Google Sheets? =
    156 No. You won’t be able to remove any order from Google Sheets.
    157 = Do I need to know any programming language for using Flex Order plugin? =
    158 No. No coding knowledge is required for using this plugin.
     200= How do I securely connect FlexOrder to my GSheets? =
     201Connecting 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.
     202
     203= How many orders can I sync to the spreadsheets? =
     204You can sync all the orders of your stores to the connected sheet and change as many order statuses as you want
     205
     206= How can I be assured that my orders and GSheets data stay consistently synced? =
     207Our 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.
     208
     209= Can I manage custom order statuses directly from the Sheets? =
     210Yes, 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.
     211
     212= What specific order details can I view and manage within GSheets using the plugin? =
     213On 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.
     214
     215= Can I delete or archive orders from my connected Sheets? =
     216The 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.
     217
     218= Is any coding or technical expertise required to set up and use the plugin? =
     219Absolutely 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.
    159220
    160221== Screenshots ==
    161 1. Bi-directional sync between WooCommerce and Google Sheet
     2221. Bi-directional sync between WooCommerce and Sheet
    1622232. Manage and update WooCommerce order status from Google Sheet
    163 3. Get additional syncing option on your Google Sheet
    164 4. Edit and update WooCommerce order status from Google Sheet
    165 5. One click instant orders sync on Google sheet from WooCommerce dashboard
     2243. Get additional syncing option on your spreadsheet
     2254. Edit and update WooCommerce order status from GSheet
     2265. One click instant orders sync on spreadsheet from WC dashboard
    1662276. Start syncing your orders with easy and fast setup
    167228
    … …  
    175236
    176237= 1.15.0 - 23 Jun 2025 =
    177 * **New (✨ Create WooCommerce Orders from Google Sheets):** Create WooCommerce orders directly from Google Sheets. Simply fill in the required fields in the spreadsheet to create new orders
     238* **New (✨ Create Orders from Sheets):** Create orders directly from Sheets. Simply fill in the required fields in the spreadsheet to create new orders
    178239* **Improved:** Improved overall performance and some minor UI adjustments
    179240* **Fix:** Resolved an issue of the Order ID and SKU not being synced to Google Sheet for the recent orders
    … …  
    222283
    223284= 1.11.0 - 18 Dec 2024 =
    224 * **New**: Added functionality to sync WooCommerce product SKUs directly to Google Sheets
     285* **New**: Added functionality to sync product SKUs directly to Google Sheets
    225286* **Fix**: Addressed an issue preventing order synchronization in Multisite environments
    226287* **Fix**: Fixed a bug that caused metadata display issues in Google Sheets
    … …  
    255316
    256317= 1.9.0 – 15 Jul 2024 =
    257 * **New (Sync order notes):** Users can now sync the order notes. Both private and public notes will be synced from WooCommerce to Google Sheets
     318* **New (Sync order notes):** Users can now sync the order notes. Both private and public notes will be synced to the Sheets
    258319
    259320= 1.8.0 – 3 Jun 2024 =
    260 * **New (Custom order status sync):** Users can now sync custom order statuses. Any update of the custom order status will be synced bidirectionally to WooCommerce and Google Sheets
    261 * **Improvement**: Enhanced the custom field sync feature functionality. All types of custom fields related to order can now be synced to the Google Sheet
    262 * **Improvement:** Users can now control the display sequence of the custom field columns on the Google Sheets
     321* **New (Custom order status sync):** Users can now sync custom order statuses to the sheet. Any update of the custom order status will be synced bidirectionally
     322* **Improvement**: Enhanced the custom field sync feature functionality. All types of custom fields related to order can now be synced to the spreadsheet
     323* **Improvement:** Users can now control the display sequence of the custom field columns on the GSheet
    263324* **Improvement:** Optimized the overall codebase for better performance & maintainability
    264 * **Fix:** Fixed the Google Sheets tab creation issue. Users can now use any tab of the Google Sheet to sync the orders. If the entered sheet tab doesn't exist on Google sheets, a new sheet tab will be automatically created
    265 * **Fix:** Fixed the breaking of the Google Sheets when more than ten custom fields are synced
     325* **Fix:** Fixed the Google Sheets tab creation issue. Users can now use any tab of the Sheet to sync the orders. If the entered sheet tab doesn't exist on Google sheets, a new sheet tab will be automatically created
     326* **Fix:** Fixed the breaking of the GSheets when more than ten custom fields are synced
    266327
    267328= 1.7.1 - 04 Apr 2024 =
    … …  
    281342
    282343= 1.6.0 – 13 Dec 2023 =
    283 * New: Custom fields of WooCommerce orders can now be synced to the Google Sheets
     344* New: Custom fields of orders can now be synced to the Sheets
    284345
    285346= 1.5.0 – 28 NOV 2023 =
    … …  
    345406
    346407= 1.1.1 =
    347 * [Fixed]: After enabling this WooCommerce in Multisite, it mentions that the WooCommerce plugin must be enabled.
     408* [Fixed]: After enabling this WooCommerce in Multisite, it mentions that the plugin must be enabled.
    348409* [Improved]: readme file
    349410* [Improved]: AppsScript file

  • order-sync-with-google-sheets-for-woocommerce/trunk/readme.txt

    r3319391 r3331341  
    1 === Bulk Order Sync for WooCommerce with Google Sheets | Bulk Edit WooCommerce Orders, Manage Orders, Sync Order Details & More - FlexOrder ===
    2 Contributors: ordersyncplugin, devsabbirahmed 
     1=== FlexOrder - Manage & Sync Orders with Google Sheets for WooCommerce ===
     2Contributors: ordersyncplugin, devsabbirahmed, naeemkhan25
    33Tags: sync order, order management, inventory management, bulk edit, woocommerce orders
    44Requires at least: 5.4
    … …  
    99License URI: http://www.gnu.org/licenses/gpl-2.0.html
    1010
    11 Manage WooCommerce orders from Google Sheets. WooCommerce bulk order sync, bulk order management, and sales order management with Google Sheets.
     11Create, edit, manage, and sync WooCommerce orders with Google Sheets for easy order handling and updates.
    1212
    1313== Description ==
    1414
    15 🔥 Sync **WooCommerce orders with Google Sheets**. Perform WooCommerce order sync, bulk order management, and bulk editing with Google Sheets.
     15🔥 Seamlessly **connect WooCommerce with Google Sheets** to manage orders, update statuses in bulk, and simplify your workflow.
    1616
    1717**Let’s grow, connect, and thrive together!**
    1818
    19 * **🤝 Join Our [Facebook Community](https://cutt.ly/ceCQgvoT)**
    20 * **🌐 Follow Us on [X (Twitter)](https://x.com/wppool_)**
    21 * **🎥 Subscribe on [YouTube](https://www.youtube.com/@WPPOOL)**
    22 * **👍 Like Our [Facebook Page](https://www.facebook.com/wppool.dev)**
    23 
    24 Welcome to the next generation of WooCommerce order management. Automatically sync WooCommerce orders with Google Sheets. Our **WordPress Google Sheets integration** ensures you are always one step ahead with faster and more efficient sales order management.
    25 
     19* **🤝 Join Our [Facebook Community](https://lnk.wppool.dev/EIRJ9Uh)**
     20* **🌐 Follow Us on [X (Twitter)](https://lnk.wppool.dev/peklsBJ)**
     21* **🎥 Subscribe on [YouTube](https://lnk.wppool.dev/FwHDK1u)**
     22* **👍 Like Our [Facebook Page](https://lnk.wppool.dev/KOnE5Qh)**
     23
     24Experience smarter WooCommerce order management with automatic syncing to Google Sheets. Our **WordPress Google Sheets integration** helps streamline order processing with faster and more efficient sales order management.
    2625
    2726https://youtu.be/sCzwNJ1wkPo?rel=0
    2827
    29 Integrate once and enjoy unlimited bidirectional order sync between WooCommerce and Google Sheets. With FlexOrder, you can bulk edit WooCommerce orders from the connected spreadsheet instead of updating them one by one. It saves time, and you can focus more on other aspects of your business.
     28Set up once and enable two-way syncing between WooCommerce and Google Sheets. With FlexOrder, you can efficiently manage and bulk update orders directly from your spreadsheet, saving time and reducing manual tasks.
    3029
    3130=== 🚀 QUICK & EASY ORDER MANAGEMENT SYSTEM FOR WOOCOMMERCE ===
    3231
    33 * Performs e-commerce order management, sales order management, and WooCommerce order sync from a connected spreadsheet.
    34 * Saves time by bulk editing order status from Google Sheets. The status changes instantly on the connected WooCommerce store.
     32* Performs e-commerce order management, sales order management, and order sync from a connected spreadsheet.
     33* Saves time by bulk editing order status from Sheets. The status changes instantly on the connected eCommerce store.
    3534* Managing the plugin requires zero coding or technical knowledge. Super easy to use with quick setup steps.
    3635
    37 👁️ [View Demo](https://go.wppool.dev/kh8d) | 🚀 [Get ULTIMATE](https://go.wppool.dev/gaVU) | 🤝 [Join Our Facebook Community](https://cutt.ly/ceCQgvoT)
     36👁️ [View Demo](https://lnk.wppool.dev/dc3jlsv) | 🚀 [Get ULTIMATE](https://lnk.wppool.dev/qjkrdk1) | 🤝 [Join Our Facebook Community](https://lnk.wppool.dev/EIRJ9Uh)
    3837
    3938=== 😃 FlexOrder Features ===
    4039
    41 * **2-way order sync between WooCommerce and Google Sheets:** Sync WooCommerce 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. WooCommerce order sync is now easier than ever.
    42 
    43 * **Bulk editing WooCommerce orders:** Bulk edit WooCommerce orders from Google 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 WooCommerce.
    44 
    45 * **Unlimited automatic order details export from WooCommerce:** Automatically export your WooCommerce 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.
    46 
    47 * **Order sorting:** Sort your orders in Google Sheets in ascending or descending manner for better organization. Easily find and manage orders based on your preferred sorting criteria for efficient order management.
    48 
    49 * **Customizable Column Order:** Rearrange Google Sheet columns with a simple drag-and-drop! No more fixed layouts! Move the Price, Order Status, or any column to match your workflow.
    50 
    51 * **1-click manual order sync on Google Sheets:** Using the “Fetch from WooCommerce” option on Google Sheets, you can manually import WooCommerce order details with a single click.
    52 
    53 * **Manual order sync on WooCommerce from Google Sheets:** Use the “Sync on WooCommerce” option from Google Sheets to manually sync order status with WooCommerce.
    54 
    55 * **Order details (name, ID, quantity, price) sync:** Sync order details (product name, ID, quantity, price, payment method) from WooCommerce to Google Sheets.
    56 
    57 * **Billing details sync:** Keeping track of customer billing information is essential for order management and record-keeping. Now, billing details such as the customer’s **first name, last name, address, city, postcode, and country** will automatically sync into Google 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.
    58 
    59 * **Shipping details sync:** Accurate shipping details are crucial for smooth order fulfillment. Now, shipping details such as the customers' **first name, last name, shipping address, city, postcode, and country** will automatically sync to your connected Google 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.
    60 
    61 * **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 on WooCommerce and click on “Sync orders on Google Sheets”, your orders will be synced immediately.
    62 
    63 * **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 Google Sheets. It gives you the flexibility to either remove or edit the empty orders.
    64 
    65 * **Easy setup wizard:** Get started with your WooCommerce order sync journey with our guided tour.
    66 
    67 👁️ [View Demo](https://go.wppool.dev/kh8d) | 🚀 [Get ULTIMATE](https://go.wppool.dev/gaVU) | 🤝 [Join Our Facebook Community](https://cutt.ly/ceCQgvoT)
     40* **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.
     41
     42* **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.
     43
     44* **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.
     45
     46* **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.
     47
     48* **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.
     49
     50* **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.
     51
     52* **Manual order sync on WooCommerce from Sheets:** Use the “Sync on WooCommerce” option from Sheets to manually sync order status with your store.
     53
     54* **Order details (name, ID, quantity, price) sync:** Sync order details (product name, ID, quantity, price, payment method) from WC to Sheets.
     55
     56* **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.
     57
     58* **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.
     59
     60* **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.
     61
     62* **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.
     63
     64* **Easy setup wizard:** Get started easily with our intuitive guided tour for the plugin setup.
     65
     66👁️ [View Demo](https://lnk.wppool.dev/dc3jlsv) | 🚀 [Get ULTIMATE](https://lnk.wppool.dev/qjkrdk1) | 🤝 [Join Our Facebook Community](https://lnk.wppool.dev/EIRJ9Uh)
    6867
    6968=== 🔥 FlexOrder Ultimate Features ===
    7069
    71 * **All free features**
    72 
    73 * **✨ Create WooCommerce Orders from Google Sheets:** Create WooCommerce orders directly from Google 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.
    74 
    75 * **Payment method sync:** Sync customer’s payment method information with Google Sheets.
    76 
    77 * **Sync Transaction IDs:** Automatically link WooCommerce orders to their payment gateway Transaction IDs in Google Sheets for seamless reconciliation.
    78 
    79 * **Order date sync:** Keep your WooCommerce orders organized by syncing order dates directly to Google Sheets.
    80 
    81 * **Advanced order sorting:** Manage your orders by sorting them based on order date, price, and items in Google Sheets. You can sort orders in ascending or descending order by date, price, or item count, making it easier to track sales trends, prioritize processing, and organize orders.
    82 
    83 * **🔥 Create Multiple Rows for Different Products:** If an order has multiple products, enabling this feature will create multiple rows for each product in Google Sheets.
    84 
    85 * **Custom separators:** You can choose a custom separator for displaying multiple product information in Google Sheets. By default, information's are 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 (, | ;).
    86 
    87 * **Discount sync:** Sync discount information between WooCommerce and Google Sheets.
     70* **Access to all free features**
     71
     72* **✨ 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.
     73
     74* **Payment method sync:** Sync the customer’s payment method information with Sheets.
     75
     76* **Sync Transaction IDs:** Automatically link your store's orders to their payment gateway Transaction IDs in Sheets for seamless reconciliation.
     77
     78* **Order date sync:** Keep your store orders organized by syncing order dates directly to Sheets.
     79
     80* **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.
     81
     82* **🔥 Create Multiple Rows for Different Products:** If an order has multiple products, enabling this feature will create multiple rows for each product in Sheets.
     83
     84* **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: (, | ;).
     85
     86* **Discount sync:** Sync discount information between your store and Sheets.
    8887
    8988* **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.**
    … …  
    9190* **Order URL sync:** Sync the order URL and get an insight into where the transaction took place from the connected spreadsheet.
    9291
    93 * **Customer notes sync:**Sync customer notes that are provided during purchase with Google Sheets.
    94 
    95 * **Order notes sync:** WooCommerce 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.
    96 
    97 * **Order quantity sync:** Sync the quantity for each ordered product on Google Sheets.
    98 
    99 * **WooCommerce Product SKU Sync:** Sync product SKUs from WooCommerce dashboard to Google Sheets effortlessly. Ensure accurate product tracking and simplify order management.
    100 
    101 * **WooCommerce Custom order status sync:** Sync any custom order status created manually or using a third-party plugin with your Google Sheets. Simplify your workflow and get greater flexibility and precision in managing your orders.
    102 
    103 * **WooCommerce Custom Fields Sync:** WooCommerce custom fields or metadata lets you display additional product data (Special Instructions, Gift Messages, Delivery Date, etc.). With WooCommerce custom fields sync, you can sync the custom fields data that comes with orders on Google Sheets.
     92* **Customer notes sync:**Sync customer notes that are provided during purchase with Sheets.
     93
     94* **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.
     95
     96* **Order quantity sync:** Sync the quantity for each ordered product on Sheets.
     97
     98* **Product SKU Sync:** Sync product SKUs from your store's dashboard to Sheets effortlessly. Ensure accurate product tracking and simplify order management.
     99
     100* **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.
     101
     102* **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.
    104103
    105104* **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.**
    … …  
    107106* **Customer name sync:** The "order placed by" column ensures you have the details of the customer who placed the order.
    108107
    109 * **Order coupon sync (upcoming):** Learn about applied coupons from Google Sheets.
    110 
    111 👁️ [View Demo](https://go.wppool.dev/kh8d) | 🚀 [Get ULTIMATE](https://go.wppool.dev/gaVU) | 🤝 [Join Our Facebook Community](https://cutt.ly/ceCQgvoT)
     108* **Order coupon sync (upcoming):** Learn about applied coupons from Sheets.
     109
     110👁️ [View Demo](https://lnk.wppool.dev/dc3jlsv) | 🚀 [Get ULTIMATE](https://lnk.wppool.dev/qjkrdk1) | 🤝 [Join Our Facebook Community](https://lnk.wppool.dev/EIRJ9Uh)
    112111
    113112=== 🔥 More Awesome Plugins ===
    114 If you like FlexOrder, then consider checking out our other awesome projects:
     113If you like FlexOrder, then consider checking out our other awesome plugins for your site:
     114
     115* 📊 **[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.
    115116   
    116 * 🔄 **[FlexStock - Stock Sync with Google Sheet for WooCommerce](https://wordpress.org/plugins/stock-sync-with-google-sheet-for-woocommerce/)**  - Auto-sync WooCommerce products from Google Sheets. Flex Stock is an easy, powerful, and simple inventory management system to handle your WooCommerce products.
    117 
    118 * 🟢 **[FlexTable - Sheets To WP Table Live Sync](https://wordpress.org/plugins/sheets-to-wp-table-live-sync/)** - Google Sheets allows you to input data on your Google sheet and show the same data on WordPress as a table effortlessly. Try Flex Table now!
    119 
    120 * 🎁 **[EchoRewards](https://wordpress.org/plugins/echo-rewards/)** - With Echo Reward, you can refer a friend for WooCommerce to launch your customer referral program. Echo Rewards Referral Plugin is a WooCommerce referral plugin to boost your sales. Generate coupons, reward customers, and launch the ideal refer-a-friend program for your store.
    121 
    122 * 🌓 **[WP Dark Mode](https://wordpress.org/plugins/wp-dark-mode/)**  - Use WP Dark Mode plugin to create a stunning dark version for your WordPress website. WP Dark Mode works automatically without going into any complicated settings.
     117* 🔄 **[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.
     118
     119* 🎁 **[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.
     120
     121* 🟢 **[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.
    123122
    124123
    … …  
    1281272. Upload your credentials.json file from the Google Cloud Platform and connect your spreadsheet.
    1291283. Provide editor access to your service account and configure Apps Script.
    130 4. That’s it. Enjoy super-fast order sync between WooCommerce and Google Sheets.
     1294. That’s it. Enjoy super-fast order sync.
    131130
    132131You can also follow our step-by-step tutorial.
    … …  
    143142Learn more about how [Appsero collects and uses this data](https://appsero.com/privacy-policy/).
    144143
     144
     145=== Development and Build Instructions ===
     146
     147This 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.
     148
     149## Source Code Location
     150* The unminified source code is organized as follows:
     151* `/src/` - Main source directory
     152* `/src/lib/` - Library files 
     153* `/src/js/` - Unminified JavaScript source files
     154* `/src/scss/` - SCSS source files
     155* `appscript` - Google Sheets Apps Script files
     156* `tailwindcss` - CSS framework setup
     157* `webpack` - Webpack configuration files
     158* `package` - Package configuration files
     159
     160## Build Tools & Dependencies
     161The plugin uses the following build tools:
     162
     163* npm - Package manager
     164* webpack - JavaScript bundling
     165* tailwindcss - CSS framework
     166* alpinejs - Frontend framework
     167* Google Apps Script – Custom backend automation and Google Sheets integration
     168
     169## Build Setup
     170To build the project from source:
     171
     1721. Copy the appscript files from `/src/js/scripts/` to the plugin's root `/appsscript/ directory
     1732. Install dependencies: `npm install`
     1743. Run the build scripts:
     175   * Admin styles: `npm run webpack:watch`
     176   * Frontend styles: `npm run sass` and `npm run webpack`
     177   * Admin Appscript: `npm run appscript`
     178
     179**Output Directories**
     180
     181* `/public/css/` - Contains minified CSS output files
     182* `/public/fonts/` - Contains fonts files
     183* `/public/images/` - Contains images files
     184* `/public/js/` - Contains minified JavaScript output files
     185
     186=== External services ===
     187
     188## Select2 a jQuery-based replacement for select boxe
     189- **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.
     190- **Service Provider**: Developed and maintained by the open-source community [Select2 ](https://github.com/select2/select2/tree/master)
     191
     192## Google Apps Script – Google Sheet Integration 
     193- **Purpose**: Used to develop custom server-side logic and automation for our application, including data handling, API integrations, and real-time communication features. 
     194- **Service Provider**: Google LLC 
     195- **Developer**: This integration is developed and maintained by our in-house development team to ensure seamless functionality and secure handling of user data. [Google Apps Script](https://developers.google.com/apps-script) 
     196
     197
    145198== Frequently Asked Questions ==
    146199
    147 = How can I link my site with Google Sheets? =
    148 It’s pretty  simple and easy. You’ll have to insert a link to the spreadsheet and provide editor access to your service account.
    149 = How do I sync orders in WooCommerce? =
    150 Install FlexOrder (formerly **Order Sync for WooCommerce with Google Sheets**) and link with your Google Sheets spreadsheet. Now you can sync and manage your WooCommerce orders from a connected spreadsheet.
    151 = How many order status can I change from Google Sheets? =
    152 Unlimited! There is absolutely no limit when it comes to syncing order status between WooCommerce and Google Sheets.
    153 = Which product description can I sync with Google Sheets? =
    154 On the free version, you can sync the following order details - product name, ID, quantity, and price. On the paid version you can also sync payment method, discount amount, shipping details, order URL, and customer notes.
    155 = Can I remove any WooCommerce order from the Google Sheets? =
    156 No. You won’t be able to remove any order from Google Sheets.
    157 = Do I need to know any programming language for using Flex Order plugin? =
    158 No. No coding knowledge is required for using this plugin.
     200= How do I securely connect FlexOrder to my GSheets? =
     201Connecting 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.
     202
     203= How many orders can I sync to the spreadsheets? =
     204You can sync all the orders of your stores to the connected sheet and change as many order statuses as you want
     205
     206= How can I be assured that my orders and GSheets data stay consistently synced? =
     207Our 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.
     208
     209= Can I manage custom order statuses directly from the Sheets? =
     210Yes, 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.
     211
     212= What specific order details can I view and manage within GSheets using the plugin? =
     213On 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.
     214
     215= Can I delete or archive orders from my connected Sheets? =
     216The 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.
     217
     218= Is any coding or technical expertise required to set up and use the plugin? =
     219Absolutely 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.
    159220
    160221== Screenshots ==
    161 1. Bi-directional sync between WooCommerce and Google Sheet
     2221. Bi-directional sync between WooCommerce and Sheet
    1622232. Manage and update WooCommerce order status from Google Sheet
    163 3. Get additional syncing option on your Google Sheet
    164 4. Edit and update WooCommerce order status from Google Sheet
    165 5. One click instant orders sync on Google sheet from WooCommerce dashboard
     2243. Get additional syncing option on your spreadsheet
     2254. Edit and update WooCommerce order status from GSheet
     2265. One click instant orders sync on spreadsheet from WC dashboard
    1662276. Start syncing your orders with easy and fast setup
    167228
    … …  
    175236
    176237= 1.15.0 - 23 Jun 2025 =
    177 * **New (✨ Create WooCommerce Orders from Google Sheets):** Create WooCommerce orders directly from Google Sheets. Simply fill in the required fields in the spreadsheet to create new orders
     238* **New (✨ Create Orders from Sheets):** Create orders directly from Sheets. Simply fill in the required fields in the spreadsheet to create new orders
    178239* **Improved:** Improved overall performance and some minor UI adjustments
    179240* **Fix:** Resolved an issue of the Order ID and SKU not being synced to Google Sheet for the recent orders
    … …  
    222283
    223284= 1.11.0 - 18 Dec 2024 =
    224 * **New**: Added functionality to sync WooCommerce product SKUs directly to Google Sheets
     285* **New**: Added functionality to sync product SKUs directly to Google Sheets
    225286* **Fix**: Addressed an issue preventing order synchronization in Multisite environments
    226287* **Fix**: Fixed a bug that caused metadata display issues in Google Sheets
    … …  
    255316
    256317= 1.9.0 – 15 Jul 2024 =
    257 * **New (Sync order notes):** Users can now sync the order notes. Both private and public notes will be synced from WooCommerce to Google Sheets
     318* **New (Sync order notes):** Users can now sync the order notes. Both private and public notes will be synced to the Sheets
    258319
    259320= 1.8.0 – 3 Jun 2024 =
    260 * **New (Custom order status sync):** Users can now sync custom order statuses. Any update of the custom order status will be synced bidirectionally to WooCommerce and Google Sheets
    261 * **Improvement**: Enhanced the custom field sync feature functionality. All types of custom fields related to order can now be synced to the Google Sheet
    262 * **Improvement:** Users can now control the display sequence of the custom field columns on the Google Sheets
     321* **New (Custom order status sync):** Users can now sync custom order statuses to the sheet. Any update of the custom order status will be synced bidirectionally
     322* **Improvement**: Enhanced the custom field sync feature functionality. All types of custom fields related to order can now be synced to the spreadsheet
     323* **Improvement:** Users can now control the display sequence of the custom field columns on the GSheet
    263324* **Improvement:** Optimized the overall codebase for better performance & maintainability
    264 * **Fix:** Fixed the Google Sheets tab creation issue. Users can now use any tab of the Google Sheet to sync the orders. If the entered sheet tab doesn't exist on Google sheets, a new sheet tab will be automatically created
    265 * **Fix:** Fixed the breaking of the Google Sheets when more than ten custom fields are synced
     325* **Fix:** Fixed the Google Sheets tab creation issue. Users can now use any tab of the Sheet to sync the orders. If the entered sheet tab doesn't exist on Google sheets, a new sheet tab will be automatically created
     326* **Fix:** Fixed the breaking of the GSheets when more than ten custom fields are synced
    266327
    267328= 1.7.1 - 04 Apr 2024 =
    … …  
    281342
    282343= 1.6.0 – 13 Dec 2023 =
    283 * New: Custom fields of WooCommerce orders can now be synced to the Google Sheets
     344* New: Custom fields of orders can now be synced to the Sheets
    284345
    285346= 1.5.0 – 28 NOV 2023 =
    … …  
    345406
    346407= 1.1.1 =
    347 * [Fixed]: After enabling this WooCommerce in Multisite, it mentions that the WooCommerce plugin must be enabled.
     408* [Fixed]: After enabling this WooCommerce in Multisite, it mentions that the plugin must be enabled.
    348409* [Improved]: readme file
    349410* [Improved]: AppsScript file
Note: See TracChangeset for help on using the changeset viewer.