Skip to content
Documentation Menu

Focus on the Orders Table

Key points

  • During synchronization, only products are imported from Airtable to WooCommerce. If orders exist in the database, they will be ignored. Similarly, if orders exist in WooCommerce, they will not be transferred to the Airtable base.
  • When an order is placed from your e-commerce store, a new record is added to the Orders table with the following default fields: order ID, date and time, status, total amount, customer email (if they are logged into their account), payment method, billing and shipping addresses, transaction ID, and any notes added by the customer.
  • Any changes to the order (such as product additions or removals, shipping or billing address updates, etc.) will be reflected in the Orders table only when the order status changes (for example, when the order status changes from “on hold” to “pending payment”). In other words, the update of a record in the Orders table in Airtable occurs only when the order status changes in WooCommerce.
  • The frequency of updates to the Orders table depends on the configuration of cron tasks on the site. See the article How to set up WP-Cron as a cron job in WordPress? for managing cron tasks.