Black Friday: 40% off every Pro planGet 40% off

Understanding Sync Directions and Behaviors

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.

Was this page helpful? If something is unclear or missing, tell the developer.