WooStockExport — Google Sheets + Apps Script for WooCommerce
Javascript and Typescript
Developed an automation tool based on Google Sheets and Apps Script for quick export and import of prices and stock levels in WooCommerce without using plugins.
What has been implemented:
Export of WooCommerce products → Google Sheets
With one click, a complete list of products is exported: SKU, name, regular price, sale price, stock quantity, product type, ID.
Data is structured and placed on the "Products" sheet for convenient editing.
Import of updated data back into WooCommerce
After editing prices or stock directly in Google Sheets — one click updates the selected products via the WooCommerce REST API.
Synchronization occurs without plugins and monthly service fees.
Technical implementation:
Export and import scripts written in Google Apps Script.
Custom menu implemented in Google Sheets for running operations.
doGet endpoint added for remote process execution.
Code is clean, commented, and ready for production.
User documentation:
A PDF guide has been prepared with step-by-step setup and screenshots.
Instructions for activating WooCommerce API keys (Consumer Key + Secret).
Troubleshooting tips and notes on automation via Cron.
Suitable for: WooCommerce store owners, managers who update stock daily, sellers working with supplier price lists, and freelancers who support client stores.
The result is a lightweight, standalone tool that provides full control over updating prices and stock levels without reliance on paid plugins or subscriptions.
#GoogleAppsScript #WooCommerce #GoogleSheets #API #Automation #Ecommerce #JavaScript #Integration #StockAccounting #WebDev
What has been implemented:
Export of WooCommerce products → Google Sheets
With one click, a complete list of products is exported: SKU, name, regular price, sale price, stock quantity, product type, ID.
Data is structured and placed on the "Products" sheet for convenient editing.
Import of updated data back into WooCommerce
After editing prices or stock directly in Google Sheets — one click updates the selected products via the WooCommerce REST API.
Synchronization occurs without plugins and monthly service fees.
Technical implementation:
Export and import scripts written in Google Apps Script.
Custom menu implemented in Google Sheets for running operations.
doGet endpoint added for remote process execution.
Code is clean, commented, and ready for production.
User documentation:
A PDF guide has been prepared with step-by-step setup and screenshots.
Instructions for activating WooCommerce API keys (Consumer Key + Secret).
Troubleshooting tips and notes on automation via Cron.
Suitable for: WooCommerce store owners, managers who update stock daily, sellers working with supplier price lists, and freelancers who support client stores.
The result is a lightweight, standalone tool that provides full control over updating prices and stock levels without reliance on paid plugins or subscriptions.
#GoogleAppsScript #WooCommerce #GoogleSheets #API #Automation #Ecommerce #JavaScript #Integration #StockAccounting #WebDev