Plugin
Updated
WPSyncSheets For WooCommerce
WPSyncSheets For WooCommerce by Creative Werk Designs is a WordPress plugin that connects a WooCommerce store to Google Sheets. It imports and exports orders, products, customers, coupons and events, so store data lives in a spreadsheet you can sort, share and analyze.
- Version
- 9.2.0
- Released
- Nov 18, 2024
- Developer
- Creative Werk Designs
- Type
- WordPress plugin
- Requires
- WooCommerce and Wpsyncsheets WooCommerce
- Licence
- GPL
- Included in
- Every plan, or $6.39 a year on its own
What’s new in WPSyncSheets For WooCommerce 9.2.0
Version 9.2.0 · Nov 18, 2024
Latest
- NewIntroduced a date range filter to sync products based on sale periods
- NewAn option to include child categories when syncing products through product-category-specific sheets.
- NewSplit the “Product Image” header into two options like Product Image and Product Gallery Images where each holding relevant data.
- ImprovedNew Features: Improved overall code performance and efficiency.
- ImprovedFeatures: Enhanced overall design aesthetics and visual appeal.
What it does
Many store owners end up exporting CSV files from WooCommerce again and again just to build a report or check stock. This plugin replaces that routine by keeping store data in sync with Google Sheets. Orders, products, customers, coupons and events can move in both directions, so you can review data in a sheet or bring changes back into the store. Scheduled synchronization runs updates at intervals you choose, which cuts down on repeated manual exports.
It needs WooCommerce and works from a configuration panel inside WordPress. You can map which fields sync, so each sheet holds only the columns you care about. Product syncing has extra controls, such as a date range filter based on sale periods, the option to include child categories in category-specific sheets, and separate columns for the main product image and gallery images. Once data is in Google Sheets, you can use the spreadsheet's own tools to build reports and dashboards. It also handles multiple stores or sheets, which suits agencies.
Best for
- WooCommerce store owners who report in Google Sheets
- Agencies managing data for several WooCommerce stores
- Analysts and marketers who build dashboards from store data
Features
Two-way data sync
Import and export orders, products, customers, coupons and events between WooCommerce and Google Sheets, so the store and the spreadsheet hold matching records.
Scheduled synchronization
Set custom intervals for automatic updates, so your sheets refresh with store data on a schedule without you running exports by hand.
Custom field mapping
Choose which WooCommerce fields sync to Google Sheets, giving you tailored sheet layouts that include only the data your team uses.
Sale period date filter
Sync products based on a date range tied to their sale periods, which helps when reviewing or editing items in a specific promotion.
Child category support
When using product-category-specific sheets, you can include child categories so products in subcategories land in the same sheet.
Separate image columns
Product images are split into two headers, Product Image and Product Gallery Images, so each column holds its own image data.
Multiple stores and sheets
Manage data from several WooCommerce stores or several Google Sheets at once, useful for agencies and merchants with more involved setups.
Questions about WPSyncSheets For WooCommerce
What kinds of store data can it sync with Google Sheets?
It handles orders, products, customers, coupons and events. Data can be imported and exported in both directions, so you can work on records in a sheet and keep them matched with your WooCommerce store.
Can it update my sheets automatically?
Yes. Scheduled synchronization lets you set custom intervals for updates, so your Google Sheets refresh with the latest store information without you exporting data manually each time.
Can I control which product data ends up in a sheet?
You can map which fields sync, filter products by a date range based on sale periods, and include child categories in category-specific sheets. Main product images and gallery images also get their own separate columns.
Does it work with more than one store?
Yes. It supports managing data from multiple WooCommerce stores or multiple Google Sheets at the same time, which helps agencies and merchants that run several shops or keep data across different sheets.
Is WPSyncSheets For WooCommerce free?
The code of WPSyncSheets For WooCommerce is licensed under the GPL, so anyone may use, change and share it. GPL Feast is a paid service: a plan or a single purchase gives you the download and automatic updates. The developer's own support, licence key and online services are not included.
Which version of WPSyncSheets For WooCommerce is this?
Version 9.2.0, released Nov 18, 2024. New versions appear here when the developer publishes them, and members get them as automatic updates.
How do I update WPSyncSheets For WooCommerce?
Install the free GPL Feast Updater on your site and connect it with your API key. It installs new versions of WPSyncSheets For WooCommerce automatically and keeps a backup, so you can roll back.
What does WPSyncSheets For WooCommerce need?
WPSyncSheets For WooCommerce needs WooCommerce and Wpsyncsheets WooCommerce installed and active.
You might also like
