WooCommerce Orders → Sheets
For a small school-photography business, I built a Chrome extension that sends WooCommerce orders to per-school spreadsheets, with preview, deduplication and native Sheets matching.
- My contribution
- I built a Chrome extension connecting WooCommerce orders to Google Drive and Sheets.
- Who it serves
- The team at a small school-photography business.
- Scope
- Per-school exports with preview, deduplication and spreadsheet matching.
Case overview
An operational solution for a school photography SMB that turns WooCommerce orders into Drive working sheets through an on-demand Chrome extension.
- Source
- WordPress/WooCommerce
- Interface
- Chrome MV3
- Destination
- Drive + Sheets
- Mode
- On demand
WooCommerce to Drive for SMBs
Chrome extension that turns ecommerce orders into operating spreadsheets by institution. The operator selects the school, validates the destination, previews new orders and writes only the contracted columns; Sheets handles matching and controls with native formulas.
- Woo fields
- 17
- Destination modes
- 3
- CONFIG cells
- 4
- Sheets anchors
- 13
Extension
The popup brings together school selection, automatic or manual destination, new-order count and loading into the selected spreadsheet.
| Step | Screen | Action | Output |
|---|---|---|---|
| 01 | School | Autocompletes known names, aliases and local exceptions. | Canonical school |
| 02 | Destination | Resolves EXPORT 2026 by folder, Drive browsing or pasted link. | Validated spreadsheet |
| 03 | Mapping | Allows Woo field changes without writing outside A:Q. | Protected contract |
| 04 | Run | Counts new orders, skips duplicates and writes ranges by batch. | Loaded rows |
Load Preview
The preview shows new orders before writing and separates states that require exclusion or review.
| Order | School | Class | Student | Status | Write |
|---|---|---|---|---|---|
| #10421 | North School | 3A morning | M. Alvarez | processing | A:Q |
| #10422 | North School | K5 afternoon | L. Campos | completed | A:Q |
| #10423 | North School | 6B morning | R. Diaz | pending | excluded |
| #10424 | North School | 2C afternoon | T. Molina | processing | duplicate skipped |
Operating Architecture
The solution keeps the ecommerce backend untouched and moves daily load into an on-demand tool with Drive as the working system.
- WooCommerce
- Orders REST API, 100-item pagination, date-from and status filter.
- Drive
- School folder and EXPORT 2026 discovery, with pasted-link fallback.
- Sheets
- Batch update through mapped ranges and duplicate validation before write.
- Templates
- EXPORT and LISTADO connected through CONFIG and authorized IMPORTRANGE.
Case decisions
Problem
A small-store operation needs to move web orders into working sheets without hand-copying data. The extension concentrates school selection, destination, preview and writing, while Sheets keeps the match with internal lists.
Architecture
The popup reads orders through API, resolves the EXPORT 2026 file in Drive, validates mapping and writes only PEDIDOS!A:Q. Column R remains manual and S:AH keeps formulas and helpers.
Control
The extension skips previously loaded orders, separates pending or cancelled states and lets LISTADO receive administrative data only when the exact key matches.
Facets
Tools
- WooCommerce API
- paginated reading of orders, statuses and checkout metadata
- Chrome MV3
- operating popup with school, destination, mapping, preview and execution
- Google Drive API
- folder and EXPORT 2026 spreadsheet discovery by institution
- Google Sheets API
- batch update into PEDIDOS!A:Q and deduplication by order ID
- Google Sheets formulas
- exact match between EXPORT and LISTADO with helpers and CONFIG cells