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

Sync WooCommerce Coupons, Refunds, Reviews and Categories to Google Sheets

Available in: Pro · Requires: WooCommerce

Besides orders, products, customers and subscriptions, Pro has four more WooCommerce data types.

Coupons

  • Fields: Coupon ID, Coupon Code, Description, Status, Discount Type, Coupon Amount, Free Shipping, Individual Use Only, Exclude Sale Items, Minimum and Maximum Spend, allowed and excluded products and categories, Email Restrictions, usage limits, Usage Count, Expiry Date, Date Created and Date Modified.
  • Filters: discount type and status.
  • Real-time: created, updated or deleted.
  • Import: create or update coupons, matched by Coupon ID or Coupon Code, with a default discount type and status, and optional deletion of coupons whose rows are removed.

Refunds

  • Fields: Refund ID, Order ID, Order Number, Refund Date, Reason, Refund Amount, Currency, Refunded Items, Refunded Quantity, Customer Name, Customer Email, Refunded By and Payment Refunded.
  • Filters: date range.
  • Real-time: when a refund is issued. Refunds are export only.

Product reviews

  • Fields: Review ID, Product ID, Product Name, Product SKU, Rating, Review Content, Status, Reviewer Name, Reviewer Email, Verified Purchase and Review Date.
  • Filters: rating and status.
  • Real-time: submitted, updated or deleted.
  • Import: create or update reviews, matched by Review ID, with a default review status and optional deletion.

Product categories and tags

  • Fields: Term ID, Name, Slug, Type, Description, Parent ID, Parent Name, Display Type, Menu Order, Image URL and Product Count.
  • Filters: type (categories or tags) and hiding empty terms.
  • Real-time: created, updated or deleted.
  • Import: create or update terms, matched by Term ID, name or slug, with optional deletion.

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