WP connect

staurand

Orders Sync to Airtable for WooCommerce is a free plugin that allows you to synchronize automatically your WooCommerce store’s orders to your Airtable base with ease.
Whether you want to manage your order data, automate your reports, or centralize your store activity in Airtable, this plugin helps you streamline the process without manual data entry.
You can use our predefined Airtable template or connect to your own Airtable base for maximum flexibility.
Looking to sync products, inventory, and more from Airtable to WooCommerce? Check out our full-featured plugin <a href="https://wpconnect.co/woocommerce-airtable-integration/" rel="nofollow ugc">Air WP Sync for WooCommerce</a>. It also includes <a href="https://wpconnect.co/air-wp-sync-plugin/" rel="nofollow ugc">Air WP Sync Pro+</a> which allows you to sync posts, pages, users, and taxonomy terms.
<h3>Features</h3>
<h4>Sync your WooCommerce orders to Airtable</h4>
<ul>
<li>Send new orders from your WooCommerce store directly to Airtable.</li>
<li>Map key data like:
<ul>
<li>Order ID, status, date, total</li>
<li>Billing and shipping details</li>
<li>Customer information</li>
</ul>
</li>
</ul>
<h4>Flexible synchronization triggers</h4>
<ul>
<li>Sync orders manually at any time.</li>
<li>Or enable automatic syncing when the order status changes.</li>
<li>Syncs are queued and processed in a short time interval (~5 minutes), depending on your server’s cron and API limits.</li>
</ul>
<h4>Use a template or your own Airtable base</h4>
<ul>
<li>Use our ready-made Airtable template for a quick start.</li>
<li>Or connect to your own Airtable structure with custom mappings.</li>
</ul>
<h4>Built for simplicity</h4>
<ul>
<li>Minimal setup required.</li>
<li>No code or complex configurations.</li>
</ul>
<h4>Want more power? Sync your full store</h4>
To sync your products, inventory, custom fields, and SEO data, upgrade to <a href="https://wpconnect.co/woocommerce-airtable-integration/" rel="nofollow ugc">Air WP Sync for WooCommerce</a>. With it, you can: 
* Import products from Airtable to WooCommerce, including variable and downloadable products. 
* Keep inventory automatically in sync. 
* Sync WooCommerce custom fields and meta. 
* Manage orders from Airtable. 
* Get full support for ACF and major SEO plugins. 
* Gain access to Air WP Sync Pro+, which includes synchronization of: 
 – Pages 
 – Posts & Custom Posts Type 
 – Users 
 – Taxonomy terms
<h3>How to Use Orders Sync to Airtable for WooCommerce</h3>
<ol>
<li>Go to the Orders Sync to Airtable for WooCommerce page in your WordPress dashboard.</li>
<li>Click Get Started.</li>
<li>Enter your Airtable Access Token (<a href="https://airtable.com/create/tokens" rel="nofollow ugc">get it here</a>).</li>
<li>Select the target table for syncing your WooCommerce orders.</li>
<li>Map WooCommerce fields to Airtable columns.</li>
<li>Choose your synchronization trigger: manual or automatic on order status change.</li>
<li>Save the connection and start syncing.</li>
</ol>
<h3>Support</h3>
If you need assistance, please open a ticket at our <a href="https://wordpress.org/support/plugin/orders-sync-to-airtable-for-woocommerce/" rel="ugc">Support Center</a> or check our <a href="https://wpconnect.co/orders-sync-to-airtable-for-woocommerce-documentation/" rel="nofollow ugc">documentation</a>.
<h3>Troubleshooting</h3>
<ul>
<li>Make sure your Airtable table structure is properly set up.</li>
<li>Fields must match the expected order data columns.</li>
<li>Logs can be found in: <code>/wp-content/uploads/orders-sync-to-airtable-for-woocommerce-logs</code></li>
</ul>
<h3>Source</h3>
All source code is hosted on <a href="https://github.com/wpconnect-co/orders-sync-to-airtable-for-woocommerce" rel="nofollow ugc">github.com</a> (JavaScript source files, development tools…)
<h3>External Services</h3>
This plugin connects to the Airtable API to sync WooCommerce orders into an external Airtable base.
Data sent includes: 
– Customer name and email 
– Order total and order status 
– Product information 
– Stock quantity 
– Shipping and billing addresses (if configured)
Data is sent to Airtable every time a new WooCommerce order is created or updated. It can be synced manually as well.
The Airtable API service is provided by Airtable Inc. You can find their terms and policies here:
<ul>
<li><a href="https://www.airtable.com/company/tos" rel="nofollow ugc">Terms of Service</a></li>
<li><a href="https://www.airtable.com/company/privacy" rel="nofollow ugc">Privacy Policy</a></li>
</ul>

Orders Sync to Airtable for WooCommerce

Sync WooCommerce orders to Airtable easily and efficiently.

Aeropage Tools

<h3>Security Notice</h3>
In our latest release (version 3.3.0), we addressed security vulnerabilities reported by Cheng Liu. We strongly recommend updating to the latest version to protect your site.

A powerful, easy to use combination of tools that allow you to automatically (or manually) generate WordPress posts with custom metadata.
Create WordPress posts from your Airtable data.

Install the WordPress Plugin
The WordPress Connector has two parts, a WordPress plugin that pulls your Airtable data into wordpress, and an API tool to connect with airtable <a href="https://tools.aeropage.io/api-connector/dashboard" rel="nofollow ugc">here</a>.
To connect to wordpress, use the <a href="https://wordpress.org/plugins/aeropage-sync-for-airtable/" rel="ugc">Aeropage Sync for Airtable</a> plugin. You can find it in the WordPress directory by searching for “Aeropage“.

Add a Custom Post Type
Once the plugin is installed, just open it from the sidebar and “Add Post”.

After clicking “Add a Post” you will be shown a form.

Title
The title of the custom post type will usually be the same name as the table you”re importing data from in Airtable.
Dynamic URL 
The dynamic url can be “SEO” friendly by using the name eg “shure-headphones” or it can be easier to manage potential duplicate names by using the unique id of each record.
API Token
Continue to the next steps to create a token to use with the api connector.
Auto Sync
A cron job that is executed in an hourly interval which is based on WordPress Cron implementation. WordPress Cron is WordPress’s task scheduler that runs on site visits to handle tasks like publishing posts and checking for updates. 
WordPress Cron, and to an extent auto sync, relies on site traffic, so on low-traffic sites, tasks may not run on time.
If you have an access to the hosting server settings, you can update it like so:
Disable WordPress Cron in wp-config.php:
<pre><code>define('DISABLE_WP_CRON', true);
</code></pre>
Set up a server cron job to run wp_cron.php every hour:
<pre><code>*/5 * * * * curl http://example.com/wp-cron.php?doing_wp_cron
</code></pre>
When submitted this will create a custom post type and automatically add a new post for every record in your connected Airtable
To complete the form you will need an API token (below)…
Create API Connector & Token
The api connector stores your connection info and prepares the data in the response to be used in WordPress.
<h3>Connect to Airtable</h3>
After clicking new and creating your project, copy and paste the url to the airtable data you want to connect. To find out more details on this step, click on the instructions button.

Post Data & Fields (MetaData)
you can create dynamic values for your posts when they appear in “loops” on your WordPress archive pages, query and loop templates
Post Title
If you want to make a custom title, instead of using the default name of the records.
Post Image
The image will be automatically downloaded to your wordpress media library.
Post Excerpt
A short description of the post content.
Fields (Metadata)
By default, every field in your airtable record will be created as post metadata. If you want to prevent some data from being synced, click the field settings and toggle off the ones you want to exclude.
Attachment Proxy
Replaces temporary links in your attachment fields with permanent urls.
ðŸ’¡ After making changes, you need to refresh the data to see the result.

Posts Preview
You can see a preview of how your posts would look in a WordPress loop by click on the “posts” view. This can be used to confirm the Post Title, Image and Excerpt are correct before you syncronize with WordPress.

Syncronizing with Airtable
Once your data is setup in Aeropageâ€¦
<ul>
<li>Open the settings.</li>
<li>Click on the “token” field to copy it.</li>
<li>Go back to Wordrpress plugin, “create post” page.</li>
<li>Paste your token into the API Token field.</li>
</ul>
ðŸ’¡ Auto sync can be toggled on to check for new and changed data.

After a few seconds, you should see your data appear in the right – and a Success message.
You are now ready to save the post, which will syncronize you posts for the first time. After syncronizing your custom post will appear in the WordPress menu, and a post will have been added for each record in your Airtable data.
ðŸ’¡ The first time you sync it can take longer as it”s downloading your featured images.
You should also see the featured images for each post in your media library.

Finished
You can now use your custom post to make queries and templates â†’ also use custom post meta data, for any of the fields in your Airtable data when making Single Post templates. The custom posts and metadata should work with all your favorite builders. 

Gutenberg
<ul>
<li>Create loops using the “Query Loop” Block</li>
<li>Make templates for your single posts.</li>
</ul>
Elementor
<ul>
<li>Create loops using the “Loop Template” widget.</li>
<li>Make templates for your single posts.</li>
</ul>
Divi
<ul>
<li>Refer to documentation for how to make loops with custom posts and metadata.</li>
</ul>
<h3>Update your Data</h3>
To manually resync your data, make changes or delete – just click the icons below.

Make changes to the configuration

Resyncronize your data manually.
If you have auto sync toggled on, your posts will be updated automatically after running the cron job.

Orders Sync to Airtable for WooCommerce vs Aeropage Sync for Airtable