Available in: Free and Pro (imports need Pro)
Every sync job has a direction and a behavior.
Directions
WordPress → Sheet (export)
Export reads WordPress data and writes it to a spreadsheet tab. It is available in the free plugin and Pro. Use it to:
- Report on orders, form entries or content in Google Sheets.
- Share data with people who don’t use WordPress.
- Keep a copy of your data in a spreadsheet.
Sheet → WordPress (import, Pro)
Import reads a tab and creates or updates records in WordPress. The free plugin shows this option as “coming soon”. Pro can import into:
- WordPress posts, pages and custom post types.
- Users, including role, password handling and welcome emails.
- WooCommerce products, including prices, stock and categories.
- WooCommerce orders: update the status, customer note, tracking details and add a private note. Imports don’t create orders.
- WooCommerce coupons, product reviews and product categories and tags.
- A custom database table.
Most import destinations can also delete, trash or remove records whose rows were deleted from the sheet, if you turn that setting on.
Behaviors
- Create only: adds new items and skips existing ones.
- Update only: changes existing items and ignores new ones.
- Create and update: does both. This is the default.
Unique keys
A unique key tells PushRow whether an item already exists. For exports, it matches rows already in the sheet. For imports, it matches records in WordPress. Examples:
- Posts: Post ID, slug or title.
- Users: User ID, email or username.
- WooCommerce products: Product ID, SKU or product name.
- WooCommerce orders: Order ID or order number.
Set a unique key whenever you use update only or create and update, so re-runs don’t add duplicate rows.