product-sync-master-sheet
Last commit date
admin
2 weeks ago
app
2 weeks ago
assets
2 weeks ago
framework
3 weeks ago
languages
3 weeks ago
autoloader.php
3 weeks ago
product-sync-master-sheet.php
2 weeks ago
readme.txt
2 weeks ago
readme.txt
272 lines
| 1 | === Sync Master Sheet - Product Sync with Google Sheet for WooCommerce === |
| 2 | Contributors: codersaiful |
| 3 | Donate link: https://donate.stripe.com/4gw2bB2Pzdjd8mYfYZ |
| 4 | Tags: stock management, bulk editor, woocommerce stock sync, woocommerce stock management, woocommerce inventory management |
| 5 | Requires at least: 4.0.0 |
| 6 | Tested up to: 7.0 |
| 7 | Stable tag: 2.0.2 |
| 8 | Requires PHP: 6.4 |
| 9 | License: GPLv2 or later |
| 10 | License URI: https://www.gnu.org/licenses/gpl-2.0.html |
| 11 | |
| 12 | Help you to connect your WooCommerce website with Google Sheet as well as Manage your Stock easy from one menu with Advance Filter |
| 13 | |
| 14 | == Description == |
| 15 | |
| 16 | [Features](https://codeastrology.com/sync-master-sheet/) | [Get Premium](https://codeastrology.com/sync-master-sheet/pricing/) | [Documentation](https://codeastrology.com/docs/plugin/product-sync-master-sheet/) |
| 17 | |
| 18 | Easily manage and synchronize your WooCommerce product stock with the power of Google Sheets using our plugin - Product Stock Sync with Google Sheet for WooCommerce. This intuitive solution empowers you to streamline your inventory management effortlessly. |
| 19 | |
| 20 | https://www.youtube.com/watch?v=IVW_UseTK8k |
| 21 | |
| 22 | **Features:** |
| 23 | * � |
| 24 | **Two-Way Product Synchronize** with **Google Sheets** |
| 25 | * � |
| 26 | **Edit Product Details** directly from Google Sheets, including Name/Title, Price, Regular Price, SKU, and Custom Fields |
| 27 | * � |
| 28 | **Add Unlimited New Products** from Google Sheets |
| 29 | * � |
| 30 | **Bulk Edit Products** using Google Sheets |
| 31 | * � |
| 32 | **Manage WooCommerce Custom Fields** (Meta Data) with seamless sync |
| 33 | * � |
| 34 | **Integration with Secure Custom Fields** Columns (previously known as ACF Plugin) |
| 35 | * � |
| 36 | **Update Product Status** easily via Google Sheets |
| 37 | * � |
| 38 | **Quick Edit Options** available directly in the plugin settings (including Table Title) |
| 39 | * � |
| 40 | **Show/Hide Columns** in Google Sheets for a customized view |
| 41 | * � |
| 42 | **Export Unlimited Products** to Google Sheets |
| 43 | * � |
| 44 | **Full Support for Variable Products** in Google Sheets |
| 45 | * � |
| 46 | **Filter by Category** (multiple filters supported) in Google Sheets |
| 47 | * � |
| 48 | **Column Sorting** for better data management in Google Sheets |
| 49 | * � |
| 50 | **Display Product** URLs in Google Sheets |
| 51 | * � |
| 52 | **View Product Edit Links** directly from Google Sheets |
| 53 | * � |
| 54 | **Auto Content Wrap** support for better readability |
| 55 | * � |
| 56 | **Short Description** support for quick product overview |
| 57 | * � |
| 58 | **Full Description** support for detailed product information |
| 59 | * � |
| 60 | **Show Product Images** support for better visual identification |
| 61 | * 🔥🔥🔥 **Stock Synchronize for Multiple Sites** from a single Google Sheet using SKU |
| 62 | * and Many more features available. |
| 63 | |
| 64 | **Key Features:** |
| 65 | |
| 66 | * **Google Sheet Integration:** Seamlessly connect your WooCommerce store with Google Sheets via the Google Sheets API. |
| 67 | * **Effortless Updates:** Update product stock levels directly from your Google Sheet, ensuring accurate and real-time inventory information on your WooCommerce store. |
| 68 | * **Simplified Stock Management:** Take control of your stock effortlessly within the familiar and user-friendly Google Sheets interface. |
| 69 | * **Automation:** Say goodbye to manual updates! Our plugin automates the synchronization process, saving you time and reducing the risk of errors. |
| 70 | |
| 71 | **How It Works:** |
| 72 | |
| 73 | * **Connect:** Establish a secure connection between your WooCommerce store and Google Sheets using the Google Sheets API. |
| 74 | * **Update:** Effortlessly update product stock levels, prices, and other details directly from your Google Sheet. |
| 75 | * **Real-time Sync:** Enjoy real-time synchronization between your WooCommerce store and Google Sheets, ensuring your inventory is always up-to-date. |
| 76 | |
| 77 | **Why Choose Product Stock Sync** |
| 78 | |
| 79 | * **Time-Saving:** Streamline your workflow with automated stock updates, freeing up time for more strategic business activities. |
| 80 | * **Accuracy:** Eliminate discrepancies and maintain accurate stock levels across your WooCommerce store and Google Sheets. |
| 81 | * **User-Friendly:** No technical expertise required! Our plugin is designed for easy setup and hassle-free stock management. |
| 82 | |
| 83 | **Getting Started: Setting Up Google Sheet API Connection** |
| 84 | |
| 85 | Ensure a smooth setup process by following these steps to connect your WooCommerce store with Google Sheets using our plugin. |
| 86 | Please follow, following steps: |
| 87 | |
| 88 | * [Tutorial - Setup Guideline](https://codeastrology.com/how-to-setup-product-sync-master-plugin/) - Checkout and follow step by step guideline. How to configure with Google Sheet - explained here. |
| 89 | * [Link Google Sheet](https://docs.google.com/spreadsheets/) - Create new spreadsheet or use existing. In the plugin settings, find the section to link your Google Sheet. Provide the required Google Sheet URL and configure additional settings as needed. |
| 90 | * [Create Google Project](https://console.cloud.google.com/projectcreate?previousPage=/apis/credentials) - Navigate to the "APIs & Services" and select "Dashboard". Click on "+ CREATE PROJECT" and fill in the necessary details. |
| 91 | * [Credentials to make a Service JSON](https://console.cloud.google.com/apis/credentials) - Still in the "APIs & Services" section, navigate to "Credentials". Click on "Create Credentials" and choose "Service Account Key". Create a new service account, download the JSON key file, and keep it secure. |
| 92 | * [Enable Sheet API](https://console.cloud.google.com/apis/library/sheets.googleapis.com) - In your project dashboard, go to "APIs & Services" > "Library". Search for "Google Sheets API" and enable it for your project. |
| 93 | * [Check Enable Sheet API](https://console.cloud.google.com/apis/api/sheets.googleapis.com/metrics) - Checkout existing API which enabled or not. |
| 94 | * **Authentication** - For generate access tocken, we have sent request to https://oauth2.googleapis.com/token. |
| 95 | * **WooCommerce required** - Ensure that, [WooCommerce](https://wordpress.org/plugins/woocommerce/) is already installed. Then install this plugin. |
| 96 | |
| 97 | Take control of your WooCommerce inventory like never before with *Product Stock Sync with Google Sheet for WooCommerce*. Experience seamless integration and efficient stock management today! |
| 98 | |
| 99 | **Credits** |
| 100 | |
| 101 | We believe in giving credit where it's due. Our plugin utilizes the following third-party resources to enhance its functionality: |
| 102 | |
| 103 | * Fontello Icons: We express our gratitude to [Fontello](https://github.com/fontello/fontello#developers-api) for providing the icon font used in our plugin's user interface. Beautiful and customizable icons make the user experience more visually appealing. |
| 104 | * Google Sheet API: A big thank you to the [Google Sheets API](https://developers.google.com/sheets/api/reference/rest) for enabling seamless integration between our plugin and Google Sheets. This API plays a pivotal role in automating the synchronization of product data. |
| 105 | * WooCommerce: Our plugin is built upon the robust foundation of [WooCommerce](https://wordpress.org/plugins/woocommerce/), empowering online businesses with a feature-rich and flexible e-commerce solution for WordPress. |
| 106 | * [WordPress](https://wordpress.org/): We are indebted to the WordPress platform for providing the framework that powers our plugin. Its open-source nature and extensive community support make it an ideal environment for creating powerful and customizable solutions. |
| 107 | |
| 108 | These entities have significantly contributed to the functionality, aesthetics, and overall success of our plugin. We are proud to acknowledge and appreciate their role in making our plugin a reality. |
| 109 | |
| 110 | **Important Links** |
| 111 | |
| 112 | * [Tutorial for Sheet Details](https://codeastrology.com/how-to-setup-product-sync-master-plugin/#sheet-details-here) |
| 113 | * [How to create JSON file and API key](https://codeastrology.com/how-to-setup-product-sync-master-plugin/#service-key-api-help-section) |
| 114 | * [Google Sheets API Connector Overview](https://cloud.google.com/workflows/docs/reference/googleapis/sheets/Overview) |
| 115 | * [Sheet API Method: values.batchUpdate](https://cloud.google.com/workflows/docs/reference/googleapis/sheets/v4/spreadsheets.values/batchUpdate) |
| 116 | * [Sheet API Method: spreadsheets.values.clear](https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/clear) |
| 117 | |
| 118 | **Used Request in Code** |
| 119 | |
| 120 | * Token Gen: `$token_url = 'https://oauth2.googleapis.com/token';` |
| 121 | * Scope: `['scope' => 'https://www.googleapis.com/auth/spreadsheets']` |
| 122 | * Insert Data in Sheet: `$api_url = "https://sheets.googleapis.com/v4/spreadsheets/$spreadsheet_id/values/$sheet_name!$range?valueInputOption=RAW&key=$API_KEY";` |
| 123 | * Update Sheet: `$api_url = "https://sheets.googleapis.com/v4/spreadsheets/$spreadsheet_id/values:batchUpdate?valueInputOption=RAW&key=$API_KEY"` |
| 124 | * Clear Sheet: `$api_url = "https://sheets.googleapis.com/v4/spreadsheets/$spreadsheet_id/values/$sheet_name:clear?key=$API_KEY"` |
| 125 | |
| 126 | == Installation == |
| 127 | |
| 128 | 1. Upload 'product-sync-master-sheet' to the '/wp-content/plugins/' directory |
| 129 | 2. Activate the plugin through the 'Plugins' menu in WordPress |
| 130 | 3. Connect with Google Sheet by API Key and service json file |
| 131 | |
| 132 | == Frequently Asked Questions == |
| 133 | |
| 134 | = Menu Location = |
| 135 | |
| 136 | � |
| 137 | Dashboard -> Product Sync with Google Sheet |
| 138 | |
| 139 | = Where is Bulk edit of Product? = |
| 140 | |
| 141 | � |
| 142 | Dashboard -> Product Sync with Google Sheet -> Product Quick Edit |
| 143 | |
| 144 | = What type of product's stock will sync with Google Sheet? = |
| 145 | |
| 146 | � |
| 147 | It's will sync with all type product with google sheet. Such: simple, variable, variation,grouped etc |
| 148 | |
| 149 | == Screenshots == |
| 150 | |
| 151 | 1. Setting |
| 152 | 2. Connection of Google Sheet |
| 153 | |
| 154 | == Changelog == |
| 155 | |
| 156 | = 2.0.2 = |
| 157 | * Added: Sheet Style/color/formatting options for better visualization for Google Sheets using batchUpdate API. |
| 158 | * Added: batchUpdate API method for better performance. |
| 159 | * Added: Different color formatting options for better visualization for Google Sheets using batchUpdate API. |
| 160 | * Added: Clear Sheet API method for better performance. |
| 161 | * Added: No of Sales column added in Google Sheet for better understanding of sales performance. |
| 162 | * Fixed: Google Sheets column letter range issue. |
| 163 | * Tested with latest WordPress 6.9 |
| 164 | * Tested with WooCommerce latest |
| 165 | * Code more optimized |
| 166 | * Bug Fixed |
| 167 | |
| 168 | = 2.0.1 = |
| 169 | * Tested with latest WordPress 6.9 |
| 170 | * Tested with WooCommerce latest |
| 171 | * Added: Save and Synchronize button added in settings page for quick sync with Google Sheet after change settings. |
| 172 | * Added: Reset settings button added in settings page to reset all settings to default. |
| 173 | * Added: Schedule Sync with Google Sheet |
| 174 | * Added: Thumbnail image support for synced products. |
| 175 | * Added: Short description field to synced product. |
| 176 | * Added: Full description field for synced products. |
| 177 | * Added: Content wrapping support |
| 178 | * Updated: AppsScript code updated for better performance and new features. |
| 179 | * Code more optimized |
| 180 | * Bug Fixed |
| 181 | |
| 182 | = 2.0.0 = |
| 183 | * Added: New feature - Sync Master Sheet for Multiple Sites from a single Google Sheet using SKU |
| 184 | * New: Tested with WooCommerce latest |
| 185 | * Tested with latest WordPress 6.9 |
| 186 | * Code more optimized |
| 187 | * Vendor removed. |
| 188 | * Bug Fixed |
| 189 | |
| 190 | = 1.1.4 = |
| 191 | * Added: Security improvement in AppsScript code. |
| 192 | * Added: AppsScript code copy button added in security page. |
| 193 | * Added: AppsScript code updated for better performance. |
| 194 | * Added: API Log page added for debug purpose. |
| 195 | * Added: New action hook(pssg_api_log) added. |
| 196 | * New: Tested with WooCommerce 7.9 |
| 197 | * Tested with latest WordPress 6.9 |
| 198 | * Code more optimized |
| 199 | * Bug Fixed |
| 200 | |
| 201 | = 1.1.3 = |
| 202 | * Code more optimized |
| 203 | * Bug Fixed |
| 204 | |
| 205 | = 1.1.2 = |
| 206 | * Tested with latest WordPress 6.8 |
| 207 | * Code more optimized |
| 208 | * Bug Fixed |
| 209 | |
| 210 | = 1.1.1 = |
| 211 | * Code more optimized |
| 212 | * Bug Fixed |
| 213 | |
| 214 | = 1.1.0 = |
| 215 | * Prie update issue from Quick Edit and Google Sheet has been fixed. |
| 216 | * Code more optimized |
| 217 | * Bug Fixed |
| 218 | |
| 219 | = 1.0.9 = |
| 220 | * Checked at latest version of WooCommerce |
| 221 | * Checked at latest version of WordPress |
| 222 | * Faster Sync time |
| 223 | * Code more optimized |
| 224 | * Bug Fixed |
| 225 | |
| 226 | = 1.0.8 = |
| 227 | * Faster load time |
| 228 | * Faster Sync time |
| 229 | * Added: Added Post URL, Edit URL, Post Status in premium version |
| 230 | * Fixed: Speed optimized for Sync with Google |
| 231 | * Fixed: Quick Table issue fixed. |
| 232 | * Fixed: edit from Quick Table issue fixed. |
| 233 | * Code more optimized |
| 234 | * Bug Fixed |
| 235 | |
| 236 | = 1.0.7 = |
| 237 | * Added: new action hook(pssg_loaded) added. |
| 238 | * Optimization of code |
| 239 | * Bug Fixed |
| 240 | |
| 241 | = 1.0.6 = |
| 242 | * Bug Fixed: AppsScript code copy issue fixed. |
| 243 | * Optimization of code |
| 244 | * Bug Fixed |
| 245 | |
| 246 | = 1.0.5 = |
| 247 | * Bug Fixed: Variation name issue when 3 or more variation - not showing issue fixed. |
| 248 | * Bug Fixed: preg_replace issue fixed from Quick/Bulk edit table |
| 249 | * Bug Fixed |
| 250 | |
| 251 | = 1.0.4 = |
| 252 | * Compatibility with Latest Google Sheet URL policy |
| 253 | * Bug Fixed |
| 254 | |
| 255 | = 1.0.3 = |
| 256 | * Compatibility with Latest WordPress |
| 257 | * Compatibility with latest WooCommerce |
| 258 | * Compatibility with Google Sheets API v4 |
| 259 | * Speed optimize |
| 260 | * Bug Fixed |
| 261 | |
| 262 | = 1.0.2 = |
| 263 | * Setup wizard added, where user will able to setup the plugin with Google sheet. |
| 264 | * Speed optimize |
| 265 | * Bug Fixed |
| 266 | |
| 267 | = 1.0.1 = |
| 268 | * Column setting issue saving issue has been solved. |
| 269 | * Code Optimization done. |
| 270 | |
| 271 | = 1.0.0 = |
| 272 | * Primary released. |