Google Sheets Product Sync — Two-Way Sync Between PrestaShop and Google Sheets
Sync your entire PrestaShop catalog with a Google Sheet — two-way. Your team edits prices, stock, references, descriptions, categories, manufacturers, features and combinations directly in a spreadsheet, and the shop updates automatically. Changes made in PrestaShop push back to the sheet. No CSV import tool to learn. No developer to call. Just a spreadsheet your team already knows how to use.
What Does This Module Do?
Two-way sync — edit in Sheets to update the shop, or push shop edits back to the sheet
Service-account authentication — upload your Google credentials once, no OAuth consent screen, no token expiry
Multi-language fields — one column per language: name FR, name EN, description FR, description EN, meta title, meta description, URL
Features as dedicated columns — one column per feature (feature_material, feature_color) with auto-created values
Combinations in rows — one row per variant, standard Shopify CSV layout, works for 3 or 400 combinations
Categories by name — type Summer Sale, the module matches or creates it automatically
Manufacturers and suppliers by name — no ID hunting, just type the name
Default category per product — set it inline, resolved by name
Tags per language — comma-separated, synced per store language
Stock sync — quantity, out-of-stock behaviour, per product and per combination
Full-rewrite push — every push rebuilds the sheet from scratch, no drift, no duplicate rows
Auto-create on pull — new manufacturers, categories and feature values are created on the fly
Hidden system columns — _id, _row_type, _updated_at, _hash, _error, managed by the module
Per-row error reporting — the _error column tells you exactly what failed, per row
Batched Google API calls — 40 rows pulled in 3 seconds, no per-row round trips
Cron URL for automation — one URL, pinged by any scheduler, with a regenerable token
Hook-driven push trigger — product changes in the shop are queued for the next push
Full activity log — read, written, skipped, failed counts per run, with per-row detail
Automatic log pruning — configurable retention, no database bloat
Conflict resolution — last-write-wins, shop-wins, or sheet-wins, your choice
Multistore-aware — every write is scoped to the current shop
No core file changes — hooks and controllers only, upgrade-safe
PrestaShop 8 and 9 compatible — full Symfony + Twig architecture, PHP 8.0+
Compatible with PrestaShop 8.x and 9.x — Full Symfony + Twig architecture. Works via hooks only, upgrade-safe, PHP 8.0+.
🔄
Two-Way Sync
Edit in Sheets to update the shop, or push shop edits back to the sheet
🔐
Service-Account Auth
Upload your Google credentials once — no OAuth screen, no token expiry
🌍
Multi-Language Columns
One column per language — name FR, name EN, description, meta tags, URL
⭐
Features as Dedicated Columns
One column per feature (feature_material, feature_color) with auto-created values
🧬
Combinations in Rows
One row per variant — works for 3 or 400 combinations, standard Shopify layout
🏷️
Categories by Name
Type a category name — the module matches or creates it automatically
🏭
Manufacturers and Suppliers
Reference them by name — no numeric IDs, auto-created if missing
🎯
Default Category per Product
Set the default category inline, resolved by name in real time
#️⃣
Tags per Language
Comma-separated tags synced separately for each store language
📦
Stock Sync
Quantity and out-of-stock behaviour, per product and per combination
♻️
Full-Rewrite Push
Every push rebuilds the sheet from scratch — no drift, no duplicate rows
➕
Auto-Create on Pull
New manufacturers, categories and feature values created on the fly
🕶️
Hidden System Columns
_id, _row_type, _updated_at, _hash, _error — managed by the module
⚠️
Per-Row Error Reporting
The _error column tells you exactly what failed, on which row
⚡
Batched Google API Calls
40 rows pulled in seconds — no per-row round trips, no quota burn
⏰
Cron URL
One URL for any scheduler, with a regenerable security token
🪝
Hook-Driven Push Trigger
Shop-side product changes are queued automatically for the next push
📊
Full Activity Log
Read, written, skipped, failed counts per run, with per-row detail
🧹
Automatic Log Pruning
Configurable retention window — no database bloat over time
⚖️
Conflict Resolution
Last-write-wins, shop-wins, or sheet-wins — you choose the rule
🏬
Multistore-Aware
Every read and write is scoped to the current shop context
🧩
No Core File Changes
Hooks and controllers only — safe through every PrestaShop upgrade
Pro tip:Combine the Cron URL with the hook-driven push to get the best of both worlds — the sheet stays fresh whenever the shop changes, and the nightly cron catches any edits made outside PrestaShop.
Version History
Current version: v1.0.0
Version
Date
PrestaShop
Changes
v1.0.0
2026-09
8.0 - 9.x
Initial release: two-way Google Sheets sync, service-account authentication, multi-language columns, features as dedicated columns, combinations in rows, categories/manufacturers/suppliers by name, default category per product, tags per language, stock sync (product + combination), full-rewrite push, auto-create on pull, hidden system columns, per-row error reporting, batched Google API calls, cron URL with regenerable token, hook-driven push trigger, full activity log, automatic log pruning, conflict resolution modes, multistore-aware
PS 9.x
Google Sheets Product Sync for PrestaShop 8-9 | Two-Way Catalog Sync | OpenPresta
Two-way PrestaShop ↔ Google Sheets sync. Edit your catalog in a spreadsheet — prices, stock, multilingual text, categories, manufacturers, features, combinations. One sheet, one click, always up...
Covers updates, security patches, and premium support.
PrestaShop Compatibility:PS 9.x
verified 100% Satisfaction Guarantee
lock Secure Payment autorenew Easy Refund Policy support_agent Instant Support
Add-ons & Extensions Compatible
--20%
B2B Registration for...
€79.99
€99.99
--15%
Quick Edit for...
€67.99
€79.99
--15%
Shipping Rules -...
€101.99
€119.99
Two-way PrestaShop ↔ Google Sheets sync. Edit your catalog in a spreadsheet — prices, stock, multilingual text, categories, manufacturers, features, combinations. One sheet, one click, always up to date. No core file changes.
OpenPresta Google Sheets Product Sync — Two-Way Sync Between PrestaShop and Google Sheets
Sync your entire PrestaShop catalog with a Google Sheet — two-way. Your team edits prices, stock, references, descriptions, categories, manufacturers, features and combinations directly in a spreadsheet, and the shop updates automatically. Changes made in PrestaShop push back to the sheet. No CSV import tool to learn. No developer to call. Just a spreadsheet your team already knows how to use.
Two-way sync - edit in Sheets → update shop, or edit in shop → update Sheets
Service-account auth - upload your Google credentials once, no OAuth consent screen, no token expiry
Multi-language fields - one column per language: name FR, name EN, description FR, description EN, meta title, meta description, URL
Features as dedicated columns - one column per feature (feature_material, feature_color…) with auto-created values
Combinations in rows - one row per variant, standard Shopify CSV layout, works for 3 or 400 combinations
Categories by name - type "Summer Sale", the module matches or creates it automatically
Manufacturers & suppliers by name - no ID hunting, just type the name
Default category per product - set it inline, resolved by name
Tags per language - comma-separated, synced per store language
Stock sync - quantity, out-of-stock behaviour, per product and per combination
Full-rewrite push - every push rebuilds the sheet from scratch, no drift, no duplicate rows
Auto-create on pull - new manufacturers, categories and feature values are created on the fly
Hidden system columns - _id, _row_type, _updated_at, _hash, _error, managed by the module
Per-row error reporting - the _error column tells you exactly what failed, per row
Batched Google API calls - 40 rows pulled in 3 seconds, no per-row round trips
Cron URL for automation - one URL, pinged by any scheduler, with a regenerable token
Hook-driven push trigger - product changes in the shop are queued for the next push
Full activity log - read, written, skipped, failed counts per run, with per-row detail
Automatic log pruning - configurable retention, no database bloat
Conflict resolution - last-write-wins, shop-wins, or sheet-wins, your choice
Multistore-aware - every write is scoped to the current shop
No core file changes - hooks and controllers only, upgrade-safe
