tr Skip to content

Connect WooCommerce and Airtable

WooCommerce runs the shop, and Airtable is where many teams plan stock, fulfilment and product launches. FlowMattic moves data both ways: orders and customers become Airtable records, and new records in Airtable can create WooCommerce products or orders. It suits stores whose operations team works in Airtable bases rather than the WordPress admin.

44 triggers 64 actions 8 example workflows 2 ready-made templates Unlimited runs

Try a pairing

When this happens in WooCommerce43 triggers

Do this in Airtable7 actions

1. TriggerNew Order Created
2. ActionCreate Record

When WooCommerce fires New Order Created, FlowMattic runs Create Record in Airtable with the data from that event.

You build this in the FlowMattic workflow builder on your own site. See the setup steps

WooCommerce and Airtable workflows you can build

Each one uses only triggers and actions the two integrations ship today, plus FlowMattic's own tools. Where the library has a ready-made template, import it instead of building from scratch.

WooCommerce app icon Airtable app icon

Add every new WooCommerce order as an Airtable record

Each order lands in an Orders table with the customer, items, total and status, so fulfilment can use Airtable views, filters and kanban boards on live store data.

New Order CreatedCreate Record

WooCommerce app icon Airtable app icon

Keep the Airtable record ID on the WooCommerce order

After the record is created, Add/Update Custom Fields saves its ID on the order. Later workflows then know exactly which record to update, since Airtable has no search action here.

New Order CreatedCreate RecordAdd/Update Custom Fields

WooCommerce app icon Airtable app icon

Update the Airtable record when an order is completed

Using the record ID saved on the order, Update Record changes the status field to Completed, so the fulfilment board moves the card without anyone dragging it.

Order Status Set to CompletedUpdate Record

WooCommerce app icon Airtable app icon

Publish products drafted in Airtable to the store

Merchandisers fill in name, price, description and SKU in a Products table. Each new record creates the WooCommerce product, so catalogue work happens where the team plans it.

New RecordCreate New Product

WooCommerce app icon Airtable app icon

Turn phone and wholesale orders logged in Airtable into store orders

Sales staff record offline orders in Airtable. Create New Order puts each one into WooCommerce, so stock levels, reports and invoices include sales that never went through checkout.

New RecordFilterCreate New Order

WooCommerce app icon Airtable app icon

Log out-of-stock products in a restock table

When a product sells out, a record with its name, SKU and the date goes into a Restock table, giving the buyer a running list of what to reorder.

Product Goes Out of StockCreate Record

WooCommerce app icon Airtable app icon

Store a weekly sales snapshot in Airtable

Every Monday the workflow pulls the WooCommerce sales report for the past week and saves totals, refunds and order count as one record, which builds a history you can chart.

ScheduleRetrieve Sales ReportCreate Record

WooCommerce app icon Airtable app icon

Collect product reviews with an AI sentiment label

Each new review is read by an AI Agent that labels it positive, mixed or negative and notes the main point, then saved to a Feedback table the product team sorts by label.

Product ReviewedAI AgentCreate Record

Set up: new orders as Airtable records

At the end, every new WooCommerce order is added to your Airtable Orders table as one record.

  1. Build the table

    In Airtable, create an Orders table with fields such as Order number, Customer, Email, Total, Status and Items.

  2. Connect Airtable

    In FlowMattic, open Connects and add an Airtable connection that can reach the base with that table.

  3. Trigger on New Order Created

    Create a workflow, pick WooCommerce and New Order Created, then place a test order so FlowMattic captures the order fields.

  4. Create the record

    Add Airtable with Create Record, select the base and table, map each order field to its Airtable field, test the step and switch the workflow on.

Add every new WooCommerce order as an Airtable record
  1. WooCommerce app icon 1. Trigger in WooCommerce New Order Created
  2. Airtable app icon 2. Action in Airtable Create Record

    Fields mapped from the earlier steps (a typical setup)

    From WooCommerceTo Airtable
    Order numberOrder number
    Billing first and last nameCustomer
    Billing emailEmail
    Order totalTotal
    Order statusStatus
    Line item namesItems
Built on the FlowMattic canvas. Test each step with real data, then switch the workflow on.

Triggers and actions in this pair

A trigger starts a workflow. An action is something FlowMattic does in the app as a step.

Good to know

  • Airtable's actions here are create, update, get and delete. There is no search action, so save the record ID on the order if later workflows need to update that record.
  • Airtable has one trigger, New Record. Editing an existing record does not start a workflow, so changes made in Airtable do not flow back to WooCommerce.
  • Field names and types come from your own base, so the mapping above is an example. Check that number and date fields receive values in a format Airtable accepts.
WooCommerce app icon

WooCommerce

Integration page

Triggers (43)

  • New Product CreatedWhen a new product is created
  • Product UpdatedWhen a product is updated
  • Product DeletedWhen a product is moved to trash
  • Restore ProductWhen a product is restored from trash
  • New Order CreatedWhen a new order is created
  • Order UpdatedWhen an order is updated
  • Order DeletedWhen an order is moved to trash
  • Restore OrderWhen an order is restored from trash
  • New Coupon CreatedWhen a new coupon is created
  • New Customer CreatedWhen a new customer profile is created
  • Product Added to CartWhen user adds product in cart
  • Product Removed from CartWhen a product is removed from cart
  • Order Status Set to PendingTriggers when an order status is set to pending
  • Order Status Set to FailedTriggers when an order status is set to failed
  • Order Status Set to On-holdTriggers when an order status is set to on-hold
  • Order Status Set to ProcessingTriggers when an order status is set to processing
  • Order Status Set to CompletedTriggers when an order status is set to completed
  • Order Status Set to RefundedTriggers when an order status is set to refunded
  • Order Status Set to CancelledTriggers when an order status is set to cancelled
  • WooCommerce Subscription CreatedTriggers when a subscription is created after a customer purchases a subscription product or products
  • WooCommerce Subscription Status UpdatedTriggers immediately after a subscription's status has been changed
  • Product ViewedTriggers when a product is viewed on frontend
  • Order Note AddedTriggers when a note is added to an order
  • Customer Order Count ThresholdTriggers when customer reaches specified completed order count
  • Customer Total Spend ThresholdTriggers when customer reaches specified spending amount
  • Product Category PurchasedTriggers when a product from specific category is purchased
  • Product PurchasedTriggers when a specific product is purchased
  • Variable Product PurchasedTriggers when a variable product is purchased
  • Variable Subscription PurchasedTriggers when a variable subscription product is purchased
  • Order PaidTriggers when an order payment is completed
  • Product ReviewedTriggers when a product review is submitted
  • Product RefundedTriggers when a product refund is created
  • Coupon UpdatedTriggers when a coupon is updated
  • Coupon DeletedTriggers when a coupon is deleted
  • Coupon RestoredTriggers when a coupon is restored from trash
  • Customer UpdatedTriggers when a customer profile is updated
  • Customer DeletedTriggers when a customer is deleted
  • Product Goes Out of StockTriggers when a product goes out of stock
  • Product Back in StockTriggers when a product comes back in stock
  • Product Low StockTriggers when a product reaches low stock threshold
  • Product Variation Goes Out of StockTriggers when a product variation goes out of stock
  • Product Variation Back in StockTriggers when a product variation comes back in stock
  • New Cart AbandonmentTriggers when a customer abandons their cart without completing checkout

Actions (57)

  • Create New ProductCreate a new product in WooCommerce
  • Create Variable ProductCreate a new variable product in WooCommerce
  • Create Product VariationCreate a new product variation in WooCommerce
  • Update ProductUpdate existing product in WooCommerce
  • Create New OrderCreate a new order in WooCommerce
  • Create CouponCreate a new coupon
  • Apply CouponApply a coupon to the cart
  • Add Email(s) to CouponAdd one or more emails to a coupon
  • Add Product to CartAdd products to the cart
  • Remove Product from CartRemoves the given product from the cart
  • Create a CustomerCreate a new customer profile
  • Get Customer by IDGet a customer's profile by their ID
  • Get Customer by EmailGet a customer's profile by their email
  • Get Order by IDGet an order's details by its ID
  • Get Orders by EmailGet all orders by email
  • Create AttributeCreate a custom product attribute
  • Add Attribute TermsAdd terms to the product attribute taxonomy
  • Add Product AttributesAdd attributes to the existing product
  • Update Product AttributesUpdate product attributes with new values and remove previous values
  • Get Product Sales CountGet number of sales for the product by ID
  • Add Order NoteAdd a note to the order
  • Get Product by IDGet product details by ID
  • Get Product by SKUGet product details by SKU
  • Get Orders of UserList all completed orders of a user by email or ID
  • Change Order StatusChange the status of an order
  • Get Customer Total SpentGet total amount spent by a customer
  • Get Customer Order CountGet total number of orders placed by a customer
  • Get Customer Last OrderGet the last order placed by a customer
  • Delete CouponDeletes an existing coupon
  • Retrieve Sales ReportGet total sales, refunds, net sales, and order count for a selected date range
  • Retrieve Top Sellers ReportGet list of top selling products with quantity sold
  • Retrieve Reviews TotalsGet review totals by rating
  • Retrieve Products TotalsGet product totals by type
  • Retrieve Customers TotalsGet customer totals report
  • Retrieve Coupons TotalsGet coupon totals by discount type
  • Retrieve Orders TotalsGet order totals by status
  • Retrieve a List of RefundsGet list of refunds for an order
  • Fetch Coupon DetailsRetrieves coupon details by coupon code or ID
  • Add/Update Custom FieldsAdds or update custom fields on specific order
  • Create Product ReviewCreate a new product review
  • Create Product TagCreate a new product tag
  • Create Product CategoryCreate a new product category
  • Delete CustomerDelete a customer account
  • Delete Product TagDelete a product tag
  • List All OrdersRetrieve a list of all orders
  • Retrieve Product by Name/SlugGet product details by product name or slug
  • Update CouponUpdate an existing coupon
  • Update CustomerUpdate customer details
  • Get All CustomersRetrieve a list of all customers
  • Get All ProductsRetrieve a list of all products
  • Get Product VariationGet variation details by product and variation ID
  • List All Order NotesRetrieve all notes for a specific order
  • Update Product VariationUpdate an existing product variation
  • Send Abandoned Cart EmailSend a recovery email to customers with abandoned carts
  • Check Cart StatusCheck if a cart is abandoned, recovered, or active
  • Update Product PriceManage the regular price or sale price of an existing Product or Variation by SKU or ID
  • Update Product Stock QuantityManage the stock quantity and stock status of an existing Product or Variation by SKU or ID

Triggers (1)

  • New RecordTriggers when a new record is created

Actions (7)

  • Create RecordCreates a new record
  • Update RecordUpdates an existing record
  • Get RecordGet the detail of an existing record
  • Get All RecordsGet all records from a table
  • Search RecordSearch for records using a filter formula
  • Search Record by ViewSearch for records filtered by a specific view
  • Delete RecordDelete an existing record

Why run this pair with FlowMattic

WooCommerce and Airtable connect through FlowMattic on your own site, with no separate automation account in the middle and no charge per run.

Store data passes through your server

Orders go from WooCommerce to Airtable through FlowMattic on your own WordPress site, so customer details are not held in a separate automation account.

Every order counts the same

Runs are unlimited on every plan, so a store with thousands of orders a month can send each one to Airtable without watching a task allowance.

WooCommerce depth on both sides

Reports, stock triggers, custom fields and product creation are all available, so the link goes well past copying orders into a table.

Common questions

How do I set up a WooCommerce Airtable integration without code?

In FlowMattic, connect Airtable, start a workflow from a WooCommerce trigger such as New Order Created, and add Airtable's Create Record with your order fields mapped to the table's fields. Test it with a real order, then switch it on.

Can Airtable changes update WooCommerce orders?

Only new Airtable records start a workflow here, so an edit to a record does not reach WooCommerce. New records can create products or orders in WooCommerce with Create New Product and Create New Order.

Can I send line items to a linked Airtable table?

Yes. Loop over the order's line items with Iterator and run Create Record for each item in an Order Items table, putting the order's record ID in the link field.

Can I move my existing orders into Airtable?

The triggers see new events only. For past orders, run a workflow once from Schedule with List All Orders, loop over them with Iterator and create a record for each.

What happens if a field name in Airtable changes?

The mapping points at the field you picked. If you rename or delete it in Airtable, open the Create Record step again, refresh the fields and remap before the next order arrives.

Did not find your answer? You can browse the help center or ask us directly.

Start automating WooCommerce and Airtable

Install FlowMattic, connect both accounts and import a template. Every run stays on your own server.

30-day money-back guarantee Unlimited workflows and runs Self-hosted

Reviewed 23 Oct 2026. The example workflows are written with AI from the real triggers and actions of both integrations and checked against them. WooCommerce integration 2.2.2, Airtable integration 1.1.0.