Documentation Menu
Focus on the Orders Table
The Orders table allows you to quickly manage orders directly from Airtable, as it gathers all orders placed on your e-commerce site along with their status.
Key points
Here are the key points to remember about this table:
- Once a connection is established between your Airtable base and WooCommerce via our Air WP Sync for WooCommerce plugin, any changes regarding orders in WooCommerce will be reflected in the Orders table automatically, with no action required from you.
📌 Data transfer occurs only from WooCommerce to Airtable, so it is unless to make changes to the Orders table from Airtable as they will not be reflected in WooCommerce.
- 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.
Air WP Sync for WooCommerce thus provides seamless order management while eliminating the need for manual updates.